Version History of Large Areas 2014 (1:1 000 000)
The 'table__history' is a version history table that is part of a larger dataset collection. This table provides a historical record of data related to the 'Large Areas 2014 (1:1 000 000)' dataset, containing data on various large geographical areas. The table houses data on each row's unique extraction date, the date when a new version of the row was extracted, and the row number in the raw data from the source, which are identified by the special columns '_start_date', '_end_date', and '_row_number' respectively. A combination of '_start_date' and '_row_number' uniquely identifies each row in this table.
The table also contains a wealth of geographic information in columns starting with 'geom_', which can be utilized for geospatial data analytics. This includes data on the type of geographical feature, the geometric center of the feature, and the geographical coordinates of the center. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
In addition to geographic information, the table also contains the names of large areas in different languages, the year the data was captured, and unique identifiers for each area.
The 'table__history' could be utilized in a variety of data analytics scenarios. For instance, it can be used for studying changes in geographical features over time, analyzing the evolution of large areas, or for conducting geospatial analysis to identify trends or patterns in the data.
This table is sourced from the 'Statistics Finland (Tilastokeskus)' website in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column records the date when the row was extracted from the data source. It helps to keep track of the version history of the row. |
| _end_date | date | This column records the date when a newer version of the row was extracted from the data source. If the value is null, it indicates that the row is the most current version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the source. It is used in combination with the '_start_date' column to uniquely identify each row in this history table. |
| geom_geojson | string | This column stores the geographical data in GeoJSON format, which represents simple geographical features. |
| geom_geotext | string | This column stores the geographical data in geotext format, providing a readable representation of the geographical features. |
| geom_type | string | This column specifies the type of the geographical object, for instance, 'ST_MULTIPOLYGON' indicates the object is a multi-polygon. |
| geom_centroid | string | This column contains the centroid point of the geographical object, providing a central location of the geographical feature. |
| geom_center_x | double | This column records the X-coordinate of the center of the geographical object. |
| geom_center_y | double | This column records the Y-coordinate of the center of the geographical object. |
| gml_id | string | This column contains a unique identifier for each geographical object. |
| name | string | This column contains the English names of the regions in Finland. |
| namn | string | This column contains the Swedish names of the regions in Finland. |
| nimi | string | This column contains the Finnish names of the regions in Finland. |
| suuralue | string | This column contains numerical codes representing the large regions of Finland. |
| vuosi | long | This column records the year the data was collected. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | b91c44c2-3e10-486a-83dd-0795889f414e |
| Package id | 8a5fa44a-077b-4997-a005-d78f3f8e344d |
| Position | 1 |
| Revision id | 296e5ae4-f5d7-46e7-9555-a2c1897062fe |
| State | active |
| Table | tilastointialueet_suuralue1000k_2014__table__history |