Version History of Regional Units 2018 (Scale 1:4 500 000)
The 'table__history' is a historical dataset that encapsulates the version history of its base data. This table is a part of the larger dataset collection, 'tilastointialueet_seutukunta4500k_2018'. It provides a meticulous record of how the data in the base table has evolved over time. This is particularly useful for keeping track of changes and spotting trends, which are crucial in data analytics.
The table includes columns that provide geographic information, which can be exploited for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
In addition to the base table columns, the history table includes two special columns: a start date and an end date. These columns document when a row was extracted from the data source and when a new version of that row was extracted. If the end date is null, this indicates that the row is the most recent version. The table also includes a column that uniquely identifies each row in the history table, formed by a combination of the start date and a row number.
The content of the base table is described as 'Seutukunnat 2018 (1:4 500 000)', which translates to 'Region 2018 (1:4 500 000)'. This suggests that the data could be used for regional analysis of Finland, such as tracking changes in regional boundaries or population shifts over time.
The data for this table is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. Thus, the data could also be used for studies related to Finnish demographics or geography, or for longitudinal studies that require historical data.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column holds the date when the row was extracted from the source. It is part of a combination with '_row_number' that uniquely identifies each row in the version history. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. A null value in this column indicates the row is the most recent version. |
| _row_number | long | This column represents the number of the row in the raw data extracted from the data source. It forms a unique pair with '_start_date' to identify each row in the version history. |
| geom_geojson | string | This column holds the geographical data in the GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geographical data represented as text, specifically in the form of multipolygons. |
| geom_type | string | This column specifies the type of the geometric data included in the row. For example, the type could be a multi-polygon. |
| geom_centroid | string | This column contains the central point of the geometric data, represented as a point. |
| geom_center_x | double | This column holds the X-coordinate of the geometric center of the data. |
| geom_center_y | double | This column holds the Y-coordinate of the geometric center of the data. |
| gml_id | string | This column contains a unique identifier for each row. |
| name | string | This column holds the name of the area, in English. |
| namn | string | This column contains the name of the area in a different language. |
| nimi | string | This column contains the name of the area in another language. |
| seutukunta | string | This column contains a code representing a specific region within Finland. |
| vuosi | long | This column contains the year related to the data in the row, represented as an integer. |
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 | edd15b76-e166-4453-a9c5-df3e0df95e1b |
| Package id | 09a16cd0-abc7-4071-a57e-4d04076de268 |
| Position | 1 |
| Revision id | f5c4d60b-fee0-442f-bc4a-298bbaba1975 |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2018__table__history |