Provinces 2016 (1:4,500,000) - Historic Versioning

To download the data set, please sign up or log in

Click here for a data sample

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_datedateThis 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_datedateThis 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_numberlongThis 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_geojsonstringThis column contains the multi-polygon geographical data of the regions in GeoJSON format.
geom_geotextstringThis column contains the textual representation of the multi-polygon geographical data of the regions.
geom_typestringThis 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_centroidstringThis column contains the geographical coordinates of the centroid of the multi-polygon representing the regions.
geom_center_xdoubleThis column contains the X-coordinate of the centroid of the multi-polygon representing the regions.
geom_center_ydoubleThis column contains the Y-coordinate of the centroid of the multi-polygon representing the regions.
gml_idstringThis is a unique identifier for each row in the table. The id is a combination of the dataset collection name and the row number.
maakuntastringThis column contains numerical codes that represent different regions in Finland.
namestringThis column contains the English names of the regions.
namnstringThis column contains the regional names of the regions in Sweden.
nimistringThis column contains the regional names of the regions in Finland.
vuosidoubleThis 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
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Id8b56efab-9153-4fad-8bda-f4c7287b3673
Package id8fe60840-1096-4bbf-be7a-5e0e086f9ab5
Position1
Revision idae4e0d4b-b39e-4a50-b514-6d2acdfbd4c4
Stateactive
Tabletilastointialueet_maakunta4500k_2016__table__history