Version History of ELY Areas 2017 (1:4 500 000) Table
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_date | date | This column contains the date a row was extracted from the data source. |
_end_date | date | This column contains the date when a newer version of the row was extracted. A null value indicates the most recent version. |
_row_number | long | This 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. |
ely | string | This column contains a string code representing a specific ELY Centre in Finland. |
geom_geojson | string | This column contains the geographical data of the ELY Centre in GeoJSON format. |
geom_geotext | string | This column contains the geographical data of the ELY Centre in geotext format. |
geom_type | string | This column indicates the type of geographical data stored, in this case, a type of polygon. |
geom_centroid | string | This column contains the geographical point at the center of the ELY Centre. |
geom_center_x | double | This column contains the x-coordinate of the geographical center of the ELY Centre. |
geom_center_y | double | This column contains the y-coordinate of the geographical center of the ELY Centre. |
gid | long | This column contains an integer identifier unique to each ELY Centre. |
gml_id | string | This column contains a string identifier unique to each ELY Centre. |
name | string | This column contains the English name of the ELY Centre. |
namn | string | This column contains the name of the ELY Centre in Swedish. |
nimi | string | This column contains the name of the ELY Centre in Finnish. |
vuosi | double | This column contains a real number indicating the year of data reference. |