Historical Versioning of Regional Units 2024 (1:4 500 000)
The 'table__history' is an integral part of the 'tilastointialueet_seutukunta4500k_2024' dataset collection. As a history table, it maintains the version history of its base table rows, ensuring that every change in the data is recorded and preserved for future reference. The table houses a variety of data, including geographical and temporal information, all sourced from 'Tilastokeskus' in Finland.
The table comprises unique identifiers for each row, formed by a combination of the extraction date and the row number. This information, along with the table's history functionality, makes it an invaluable tool for tracking data evolution over time. If an '_end_date' is not present for a row, it signifies that the entry is the most recent version.
A significant portion of the table is dedicated to geographical data. These data, represented in the WGS 84 coordinate reference system, include geographic coordinates, polygons, centroids, and more, allowing for extensive geospatial data analytics. For example, the geographic information could be used to visualize the spatial distribution of the regions or to perform spatial analysis related to the regions.
Additionally, the table includes information on regions, such as their names in various languages and their codes. This information can be utilized to conduct region-based analysis or comparative studies among different regions.
The temporal information in the table, specifically the year ('vuosi'), enables users to perform temporal analysis, track changes over time, or predict future trends based on historical data.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column shows the date when the row was extracted from the data source. It forms a unique combination with '_row_number' to identify 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 source. It forms a unique combination with '_start_date' to identify each row in the version history table. |
| geom_geojson | string | This column contains the geometric representation of the area in GeoJSON format. The data is a polygon. |
| geom_geotext | string | This column contains the geometric representation of the area in text format. |
| geom_type | string | This column indicates the type of the geometric data. In this case, it is a polygon. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid of the area. |
| geom_center_x | double | This column contains the x-coordinate (longitude) of the centroid of the area. |
| geom_center_y | double | This column contains the y-coordinate (latitude) of the centroid of the area. |
| gml_id | string | This column contains a unique identifier for each row, which is a combination of the dataset name and the year. |
| name | string | This column contains the name of the area in English. |
| namn | string | This column contains the name of the area in Swedish. |
| nimi | string | This column contains the name of the area in Finnish. |
| seutukunta | string | This column contains a code representing a specific region. |
| vuosi | long | This column contains the year the data represents. All data in this table pertains to the year 2024. |
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 | 92c7a56f-3ac7-493c-87e7-29c66c0fe3ca |
| Package id | 92428bd4-2c64-44bd-b7bd-48f905840e9b |
| Position | 1 |
| Revision id | db5691d1-e3c1-4a4d-b97b-dbdddf3a9ea3 |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2024__table__history |