Regional Administrative Units 2023 Version History (1:4 500 000)
The 'table__history' is a comprehensive historical archive that forms part of a larger dataset known as 'tilastointialueet_maakunta4500k_2023'. This historical compilation serves as a version history for its base table rows, tracking changes and updates made over time. The information contained within this table provides insight into the regions of Finland as projected for the year 2023. This is denoted by the 'name' column which specifies the names of various regions such as 'Kanta-Häme', 'Central Finland', 'South Karelia', 'Satakunta', 'North Ostrobothnia' and more. The table also provides alternative names for these regions in the 'namn' and 'nimi' columns to cater for different languages and dialects.
In addition to regional information, the table also contains geographical data in the form of coordinates presented in the WGS 84 coordinate reference system. This is reflected in columns starting with 'geom_', which can be leveraged for geospatial data analytics to create detailed geographical visualizations or to conduct spatial analysis.
Specifically, the coordinates of the geographic center of each region are stored in the 'geom_center_x' and 'geom_center_y' columns, while the 'geom_type' column specifies the type of geographical shape that represents each region. Visual representations of these shapes are stored in 'geom_geojson' and 'geom_geotext' formats in the respective columns.
The table allows tracking of changes made to the data over time through the '_start_date' and '_end_date' columns. Each row in the table is uniquely identified by a combination of '_start_date' and '_row_number'. The '_start_date' indicates when the row was extracted from the data source, while the '_end_date' signifies when a new version of the row was extracted. If the '_end_date' is null, it indicates that the row is the most recent version.
The table was sourced from the Finnish statistical agency, 'Tilastokeskus' (Statistics Finland). The data in this table could be utilized in various ways in data analytics. For instance, it could be used in demographic studies to analyze regional growth over time by comparing changes in the table's rows. It could also be used in geospatial analytics to visualize regional boundaries and identify geographical trends or patterns. Furthermore, it could be used by government agencies for planning and policy-making purposes, based on the historical and geographical data provided.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the source. For example, a row may have been extracted on November 11, 2024. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the 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 as it was in the raw data extracted from the source. This number, in combination with the '_start_date', uniquely identifies each row in this version history table. |
| geom_geojson | string | This column contains the geographical data of the regions in GeoJSON format. The data could represent different types of geographical features, such as polygons or multipolygons. |
| geom_geotext | string | This column contains the geographical data of the regions in plain text format. The data could represent different types of geographical features, such as polygons or multipolygons. |
| geom_type | string | This column indicates the type of geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. The types could be 'Polygon' or 'MultiPolygon'. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid, or geometric center, of the region represented in the row. |
| geom_center_x | double | This column contains the X-coordinate (longitude) of the geometric center of the region. |
| geom_center_y | double | This column contains the Y-coordinate (latitude) of the geometric center of the region. |
| gml_id | string | This column contains a unique identifier for each row. For example, the ID 'maakunta4500k_2023.4' identifies one specific row. |
| maakunta | string | This column contains codes representing different regions or provinces in Finland. |
| name | string | This column contains the name of the region or province in English. |
| namn | string | This column contains the name of the region or province in Swedish. |
| nimi | string | This column contains the name of the region or province in Finnish. |
| vuosi | long | This column contains the year that the data represents, for example, the year 2023. |
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 | d7672e11-c1fb-4bd7-80d3-0bcdf826b7ad |
| Package id | f4628305-52e8-4ae7-b814-09013390ed15 |
| Position | 1 |
| Revision id | 942a3b73-e51a-4b7a-aeb9-8d6b4ffd5c88 |
| State | active |
| Table | tilastointialueet_maakunta4500k_2023__table__history |