Historical Versioning of Finnish Regions 2020 (1:1 000 000)
The history table, part of a dataset collection, maintains a record of version history for its base table rows. It comprises a rich set of columns, including those related to geographic information which is particularly useful for geospatial analytics. This spatial data is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table contains data from the 'Regions 2020 (1:1 000 000)' base table, which gives information about various regions. For each region, data such as the region's name in different languages and geographic information in various formats are captured. The geospatial data, for instance, includes the region's shape represented in geojson and geotext formats, the type of the geographic shape, and the centroid of the shape with coordinates. These details can be useful in mapping exercises or analyzing spatial relationships between different regions.
The version history detail in the table is maintained via three special columns. The '_row_number' column holds the number of the row in the raw data extracted from the data source. Combined with the '_start_date', it forms a unique identifier for each row in this version history table. The '_start_date' gives the date of extraction from the data source, while the '_end_date' signifies when a new version was extracted. If the '_end_date' is null, it indicates the most recent version of the row. This feature enables tracking changes in the base data over time, which could be useful for time-series analysis or trend identification.
The table is sourced from 'Tilastokeskus' (Statistics Finland), a website based in Finland. This indicates that the data is reliable and could be used in a variety of data analytics tasks, such as studying demographic trends, performing spatial analysis, or visualizing the geographical distribution of various regional attributes.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is a key part of the combination that uniquely identifies each row in the version history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates 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 original data source. It forms part of the unique identifier for each row in this version history table. |
| geom_geojson | string | This column contains geographical data in the GeoJSON format, representing various geographical structures such as polygons and multipolygons. |
| geom_geotext | string | This column contains geographical data in a text format, representing various geographical structures such as polygons and multipolygons. |
| geom_type | string | This column specifies the type of geographical structure represented in the 'geom_geojson' and 'geom_geotext' columns, such as polygon or multipolygon. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid of the geographical structure represented in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical structure represented in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical structure represented in the 'geom_geojson' and 'geom_geotext' columns. |
| gml_id | string | This column contains a unique identifier for each row, provided by the data source. |
| maakunta | string | This column contains an identifier for the region, provided by the data source. |
| name | string | This column contains the English name of the region represented by the row. |
| namn | string | This column contains the Swedish name of the region represented by the row. |
| nimi | string | This column contains the Finnish name of the region represented by the row. |
| vuosi | long | This column contains the year of the data represented by the row. The values are in integer format. |
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 | b1d695f4-fdcf-491d-92e4-39e66dd10261 |
| Package id | 27a4c737-7c35-437e-8810-bf20d493d58d |
| Position | 1 |
| Revision id | 97dd9fef-a39e-4d39-bf40-2e953534ca39 |
| State | active |
| Table | tilastointialueet_maakunta1000k_2020__table__history |