ELY Areas 2018 Version History (1:1 000 000)
The 'table__history' is a comprehensive historical data repository that belongs to the 'tilastointialueet_ely1000k_2018' dataset collection. The primary purpose of this history table is to keep track of the version history of the base table rows, making it a valuable resource for tracking changes over time. The data included in the table is sourced from the 'Tilastokeskus' website, which is based in Finland.
The table records the detailed information of ELY-areas in 2018 (1:1 000 000 scale). Each row in the table is uniquely identified by a combination of '_start_date' and '_row_number', which denote the date the row was extracted from the data source and the number of the row in the raw data respectively. The table also registers the '_end_date', indicating when a new version of the row was extracted. If the '_end_date' is null, it means that the row is the most recent version.
The columns starting with 'geom_' capture geographic information which can be utilized for geospatial data analytics. This includes the geojson and geotext data, the type of the geometry, the centroid of the geometry, and the x and y coordinates of the center of the geometry. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
Other columns in the table contain identifiers, names in different languages, and the year the data was recorded. For instance, 'ely' represents different ELY areas coded with numbers, while 'name', 'namn', and 'nimi' give the names of these areas in English, Swedish, and Finnish respectively.
The 'table__history' provides a rich data source for several data analytics applications. For instance, the version history can be analyzed to track changes in the geographic boundaries of ELY areas over time. The geographic data can also be used to create detailed geo-visualizations of these areas. Moreover, the multilingual data can be utilized for research in regional language use trends. In addition, the data can be used to analyze the impact of regional policies over time by correlating with other time-series data such as economic indicators.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This is a special column that captures the date when a row was extracted from the data source. It forms a unique combination with '_row_number' to identify each row in the version history table. |
| _end_date | date | Another special column that records the date when a new version of a row was extracted from the data source. If the value is null, it signifies that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. It is used in conjunction with '_start_date' to uniquely identify each row in the history table. |
| ely | string | This column captures a coded string representation of the ELY Center, a regional administrative unit in Finland. |
| geom_geojson | string | This column contains the geographical data of the ELY Center in GeoJSON format, a widely used format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column holds the geographical data of the ELY Center as a text string, represented in a format known as Well-Known Text (WKT). |
| geom_type | string | This column specifies the type of the geographical data represented, e.g., MultiPolygon. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid (geometrical center) of the ELY Center region. |
| geom_center_x | double | This column records the X coordinate of the geographic center of the ELY Center region. |
| geom_center_y | double | This column records the Y coordinate of the geographic center of the ELY Center region. |
| gml_id | string | This column contains a unique identifier for each row in the table. |
| id | long | This column contains an integer value representing the ID of a row, as provided by the data source. |
| name | string | This column contains the English name of the ELY Center. |
| namn | string | This column contains the name of the ELY Center in Swedish. |
| nimi | string | This column contains the name of the ELY Center in Finnish. |
| vuosi | long | This column records the year of the data, represented as an integer. |
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 | 2d793b53-12e7-4e75-a203-e756ffcc6d98 |
| Package id | b2968b7b-c934-4a44-b66e-89604582f05d |
| Position | 1 |
| Revision id | 0d79b9c9-cfa8-4c3f-9cf1-b3a54b9da03a |
| State | active |
| Table | tilastointialueet_ely1000k_2018__table__history |