Version History of ELY Areas 2017 (1:4 500 000) Table

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

Click here for a data sample

The 'table__history' is a history table that contains the version history of its base table rows, sourced from 'Tilastokeskus' in Finland. The table is part of a larger dataset collection and each row in this table is uniquely identified by a combination of the start date and row number. The table captures the date when each row was extracted from the data source and 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. This table provides comprehensive data on ELY-areas in 2017 at a scale of 1:4 500 000, with each row representing an ELY area. The data includes geographic information which can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Some examples of how the data could be used in analytics include analyzing the changes in ELY areas over time, identifying trends or patterns in the geographic data, and conducting geospatial analysis to understand spatial relationships and patterns. The table also includes the names of the ELY areas in multiple languages, which can be useful for multilingual data analytics or for conducting comparative studies across different regions and languages.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date a row was extracted from the data source.
_end_datedateThis column contains the date when a newer version of the row was extracted. A null value indicates the most recent version.
_row_numberlongThis column contains the row number from the raw data extracted from the source. Together with '_start_date', it uniquely identifies each row in this version history table.
elystringThis column contains a string code representing a specific ELY Centre in Finland.
geom_geojsonstringThis column contains the geographical data of the ELY Centre in GeoJSON format.
geom_geotextstringThis column contains the geographical data of the ELY Centre in geotext format.
geom_typestringThis column indicates the type of geographical data stored, in this case, a type of polygon.
geom_centroidstringThis column contains the geographical point at the center of the ELY Centre.
geom_center_xdoubleThis column contains the x-coordinate of the geographical center of the ELY Centre.
geom_center_ydoubleThis column contains the y-coordinate of the geographical center of the ELY Centre.
gidlongThis column contains an integer identifier unique to each ELY Centre.
gml_idstringThis column contains a string identifier unique to each ELY Centre.
namestringThis column contains the English name of the ELY Centre.
namnstringThis column contains the name of the ELY Centre in Swedish.
nimistringThis column contains the name of the ELY Centre in Finnish.
vuosidoubleThis column contains a real number indicating the year of data reference.

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
Idb675edb5-c0ff-437d-a4bd-ef15ccc7a3dd
Package id1eec9fe4-c9ef-4a96-9772-83e8e7d2fdd6
Position1
Revision id79e366fa-160a-41b9-879a-a19fea9fba55
Stateactive
Tabletilastointialueet_ely4500k_2017__table__history