Version History of Regions (Scale 1:1 000 000)
The 'table__history' is a comprehensive history table that forms part of the 'tilastointialueet_maakunta1000k' dataset collection. This history table specializes in storing the version history of its base data rows, making it a valuable resource for tracing changes over time.
The table contains rich data about regions in Finland, as sourced from the 'Tilastokeskus' website. Each row represents a region at a particular point in time, with unique identifiers established by a combination of the '_start_date' and '_row_number' columns. These columns also help delineate the life cycle of each data row, with '_start_date' indicating when the row was extracted and '_end_date' denoting when a new version was extracted. If '_end_date' is null, it signifies that the current row is the latest version.
Geographic information is an integral part of this table. The 'geom_' prefixed columns provide detailed geospatial data, including the type of the geographical shape (polygon or multipolygon), text representation of the geographical shapes, geojson formatted geographical shapes, and centroid point of the shape. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order of longitude first, followed by latitude. This geospatial data can be utilized for geographic information system (GIS) applications and spatial data analytics.
The table also includes columns indicating the region's name in various languages, the year of the data, and a unique ID for each region. The 'gml_id' column contains unique identifiers that can be used for linking data between tables or datasets.
In terms of data analytics, this table could be used in a variety of ways. For instance, the version history could be analyzed to track changes in regional boundaries over time. Furthermore, the geospatial data could be used to visualize regional data on a map, allowing for a spatial interpretation of the data. The multi-language names could also be used in a multilingual application or website to display regional information in the user's preferred language.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier combination with '_row_number' for each row in this 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 of this column is null, it indicates that the row is the most recent version. |
| _row_number | long | This column contains the row number from the raw data extracted from the data source. It forms a unique identifier combination with '_start_date' for each row in this version history table. |
| geom_geojson | string | This column contains the geographical data of the region in GeoJSON format, which represents simple geographical features with their non-spatial attributes. |
| geom_geotext | string | This column contains the geographical data of the region as text, which represents simple geographical features with their non-spatial attributes. |
| geom_type | string | This column represents the type of the geographical feature, like whether it's a polygon or a multipolygon. |
| geom_centroid | string | This column contains the central point of the geographical feature, represented as a point. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical feature. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical feature. |
| gml_id | string | This column contains a unique identifier for each row in the base table, which is a string. |
| maakunta | string | This column contains a string that represents a region. |
| name | string | This column contains the name of the region in English. |
| namn | string | This column contains the name of the region in Swedish. |
| nimi | string | This column contains the name of the region in Finnish. |
| vuosi | long | This column contains the year the data was collected, 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 | c730feb6-89bf-4feb-af89-7b80ecc1a0ba |
| Package id | 480e5225-931b-4fde-bec7-d14dd5e48cbc |
| Position | 1 |
| Revision id | 8414e3a9-bf59-4604-8f7e-0a85f7fae5df |
| State | active |
| Table | tilastointialueet_maakunta1000k__table__history |