Version History of Major Areas 2013 (1:4 500 000) Table
The 'table__history' is a historical record table, which is a part of the 'tilastointialueet_suuralue4500k_2013' dataset. This table holds the version history of each row of its base table, which represents the Major Regions of Finland in 2013 at a scale of 1:4 500 000. The table allows tracking changes in the data across time, offering valuable insights for studies related to regional changes and development.
The table has a unique identifier for each row based on the combination of '_start_date' and '_row_number', representing when a particular row was extracted and its position in the raw data source respectively. If '_end_date' is null, it indicates that the version of the row is the most recent.
The table's geographic information, prefixed with 'geom_', is particularly valuable for geospatial data analytics. It includes geographic coordinates, presented using WGS 84 coordinate reference system with longitude first, followed by latitude. The data includes 'geom_type', specifying the nature of the geographic data, and 'geom_centroid', which represents center points of the geo areas.
The data also includes other essential information such as the Finnish and Swedish names of the regions, and the year the data was collected. A few examples of how this data could be used in analytics include tracking regional development over time, analyzing changes in geo boundaries, or studying the correlation between different areas and time.
The table is sourced from the 'Tilastokeskus' (Statistics Finland) website, based in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column marks the date when the row was extracted from the source data. It forms a unique identifier for each row in combination with the '_row_number' column. |
| _end_date | date | This column records the date when a new version of the row was extracted from the source data. If this column's value is null, it signifies that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the source. It is part of the unique identifier for each row when combined with the '_start_date' column. |
| geom_geojson | string | This column contains geometric data in the GeoJSON format, which describes the geographic features of the data. |
| geom_geotext | string | This column contains geometric data in text format. It can be used to visualize the geographic features of the data. |
| geom_type | string | This column specifies the type of geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. In this case, the geometry type is a multipolygon. |
| geom_centroid | string | This column holds the centroid of the geographic feature, which is the center point of the shape. |
| geom_center_x | double | This column contains the x-coordinate of the centroid of the geographic feature. |
| geom_center_y | double | This column contains the y-coordinate of the centroid of the geographic feature. |
| gml_id | string | This is a unique identifier for each row, provided by the source data. |
| name | string | This column holds the English names of the geographic features. |
| namn | string | This column contains the names of the geographic features in Swedish. |
| nimi | string | This column contains the names of the geographic features in Finnish. |
| suuralue | string | This column represents a category or grouping of the geographic features. |
| vuosi | long | This column represents the year related to the geographic data. |
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 | 018e2bc4-f6cb-4f64-989b-6c2c9b6c9b3c |
| Package id | 4bf8ab2c-30ec-4738-8e82-2f83ee27ad5e |
| Position | 1 |
| Revision id | 2adfe177-8826-46bd-88ef-a962733d7920 |
| State | active |
| Table | tilastointialueet_suuralue4500k_2013__table__history |