Version History of ELY Areas 2019 (1:1 000 000)
The 'table__history' is a historical data table that stores the version history of its base table rows. It belongs to a dataset collection named 'tilastointialueet_ely1000k_2019'. It provides a comprehensive catalog of the ELY areas in Finland for the year 2019, at a scale of 1:1,000,000.
The table includes a unique identifier for each row in the raw data, which is a combination of the date when the data was extracted and the row number. It also includes the date when a new version of the row was extracted. This feature allows for easy tracking and analysis of changes to the base table over time.
The table contains geographic information, which can be used to perform geospatial data analytics. This includes the type of geographic feature, its geographic coordinates, its textual representation, and its center coordinates. The geographic coordinates use the WGS 84 coordinate reference system, with longitude first, followed by latitude.
The table also includes identifiers and names of ELY areas in multiple languages such as Finnish, Swedish, and English. This could be useful for multilingual data analytics and localization tasks.
One of the use cases for this table could be to analyze the changes in the geographic boundaries of ELY areas over time. Another use case could be to use the geospatial data to visualize the ELY areas on a map, which can then be used for spatial analysis.
The data for this table is sourced from the 'Tilastokeskus' (Statistics Finland) website.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It's part of a combination with '_row_number' that uniquely identifies 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 means 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. It's part of a combination with '_start_date' that uniquely identifies each row in this version history table. |
| ely | string | This column contains a string value representing a unique identifier for the ELY Centre, which is a regional centre for economic development, transport and the environment in Finland. |
| geom_geojson | string | This column contains a GeoJSON representation of the geometry of the ELY Centre region. |
| geom_geotext | string | This column contains a text representation of the geometry of the ELY Centre region. |
| geom_type | string | This column contains the type of the geometry, which in this case is 'ST_MULTIPOLYGON', indicating the region is represented by multiple polygons. |
| geom_centroid | string | This column contains the coordinates of the centroid of the geometry of the ELY Centre region. |
| geom_center_x | double | This column contains the x-coordinate (longitude) of the center of the geometry of the ELY Centre region. |
| geom_center_y | double | This column contains the y-coordinate (latitude) of the center of the geometry of the ELY Centre region. |
| gml_id | string | This column contains a string value representing the GML (Geography Markup Language) identifier for the data row. |
| id | long | This column contains an integer value representing a unique identifier for the data row. |
| name | string | This column contains a string value representing the English name of the ELY Centre. |
| namn | string | This column contains a string value representing the name of the ELY Centre in Swedish. |
| nimi | string | This column contains a string value representing the name of the ELY Centre in Finnish. |
| vuosi | long | This column contains an integer value representing the year the data row was recorded or updated. |
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 | 20ac8948-82ee-4d7a-886f-1f961122b8ff |
| Package id | 1ed301ad-8f0f-4052-b018-30371ca19450 |
| Position | 1 |
| Revision id | 79eb2884-fe12-46de-b47d-0d6f2eccf9d3 |
| State | active |
| Table | tilastointialueet_ely1000k_2019__table__history |