Version History of Large Areas (1:4 500 000)

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

Click here for a data sample

The table 'table__history' is a historical data table that forms part of a larger dataset collection. This table captures the version history of its base table rows in a detailed and organized manner. It includes data on large areas (1:4 500 000) and has been sourced from 'Tilastokeskus' (Statistics Finland), a reputable data provider in Finland. The data contained in this table is distinguished by the dates of extraction and updates from the source, as well as the unique row numbers, ensuring each row in the version history table can be accurately identified and tracked. The table also contains geographic data, allowing for geospatial analytics. This geographic information is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. Furthermore, the table includes various types of geographic data such as geotext and geojson, which can be used to generate detailed and interactive maps. The table also provides regional names in different languages, which can be crucial in international studies or multilingual projects. The history table can be leveraged in data analytics in numerous ways. For instance, it can be used to track changes in geographic data over time, analyze trends in regional development, or serve as a reference for multilingual data mapping. It could also be used in combination with other data to provide comprehensive regional analysis. For example, it could be combined with demographic or economic data to analyze the relationship between geographical changes and socio-economic factors. The possibilities for data analytics using this table are extensive and can provide valuable insights for various research and analytics projects.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date when the row was extracted from the data source. It forms a unique identifier for each row in the version history table in combination with the '_row_number' column.
_end_datedateThis column contains the date when a new version of the row was extracted. 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 source. It forms a unique identifier for each row in the version history table in combination with the '_start_date' column.
geom_geojsonstringThis column contains the geometry of the area in GeoJSON format.
geom_geotextstringThis column contains the geometry of the area in text format.
geom_typestringThis column specifies the type of the geometry data.
geom_centroidstringThis column contains the centroid of the geographical area.
geom_center_xdoubleThis column contains the x-coordinate of the center of the geographical area.
geom_center_ydoubleThis column contains the y-coordinate of the center of the geographical area.
gml_idstringThis column contains an ID that is unique for each row.
namestringThis column contains the name of the area in English.
namnstringThis column contains the name of the area in Swedish.
nimistringThis column contains the name of the area in Finnish.
suuraluestringThis column contains an identifier for the major region the area belongs to.
vuosilongThis column contains the year of the data.

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
Id60729b06-276d-4c9e-be9e-a4769a526df6
Package idb2d6af9f-eb94-4459-86da-b8a5704b846c
Position1
Revision id3c1de46f-1d71-4c46-870f-8e8f0179bd67
Stateactive
Tabletilastointialueet_suuralue4500k__table__history