Provinces 2016 (1:4,500,000) - Historic Versioning
The table titled 'table__history' is part of a dataset collection called 'tilastointialueet_maakunta4500k_2016'. This table is a history table that contains the version history of its base table rows. It provides a detailed historical record, tracking when each row was extracted from the data source and when a new version of the row was extracted. This feature is particularly useful for tracking changes over time and maintaining an accurate record of data alterations. The table is sourced from 'Tilastokeskus' (Statistics Finland) based in Finland.
The contents of the table are related to 'Maakunnat 2016 (1:4 500 000)', which can be translated to 'Regions 2016 (1:4 500 000)'. This gives an overview of different regions in Finland and their related data for the year 2016. Columns in the table provide geographic information, including geographic coordinates, which can be used for geospatial data analytics. The geographic coordinates are presented using WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
Several columns uniquely identify each row, such as the combination of '_start_date' and '_row_number'. This combination facilitates precise data tracking and maintains a clear version history. The '_end_date' indicates when a new version of the row was extracted. If the '_end_date' is null, this means that the row is the most recent version.
The data in this table could be utilized in various ways. For example, it could be used to track changes in regional data over time, providing a rich historical context for data analysis. Additionally, the geographical information could be used to create detailed maps or conduct geospatial analytics. This could be particularly valuable for regional planning or environmental studies.
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 part of a unique identifier 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 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 data source. Together with '_start_date', it forms a unique identifier for each row in this history table. |
geom_geojson | string | This column contains the multi-polygon geographical data of the regions in GeoJSON format. |
geom_geotext | string | This column contains the textual representation of the multi-polygon geographical data of the regions. |
geom_type | string | This column contains the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. In this table, it always contains the value 'ST_MULTIPOLYGON'. |
geom_centroid | string | This column contains the geographical coordinates of the centroid of the multi-polygon representing the regions. |
geom_center_x | double | This column contains the X-coordinate of the centroid of the multi-polygon representing the regions. |
geom_center_y | double | This column contains the Y-coordinate of the centroid of the multi-polygon representing the regions. |
gml_id | string | This is a unique identifier for each row in the table. The id is a combination of the dataset collection name and the row number. |
maakunta | string | This column contains numerical codes that represent different regions in Finland. |
name | string | This column contains the English names of the regions. |
namn | string | This column contains the regional names of the regions in Sweden. |
nimi | string | This column contains the regional names of the regions in Finland. |
vuosi | double | This column contains the year of the data. The data in this table is from the year 2016. |
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 | 8b56efab-9153-4fad-8bda-f4c7287b3673 |
Package id | 8fe60840-1096-4bbf-be7a-5e0e086f9ab5 |
Position | 1 |
Revision id | ae4e0d4b-b39e-4a50-b514-6d2acdfbd4c4 |
State | active |
Table | tilastointialueet_maakunta4500k_2016__table__history |