Version History of ELY Areas 2017 (Scale 1:1 000 000)
The 'table__history' is a historical data table that captures the version history of its base table rows. It forms part of a broader dataset collection that encapsulates data on 'ELY-areas 2017' at a scale of 1:1 000 000, indicating it holds geographic data related to administrative regions in Finland. The data is sourced from 'Tilastokeskus' (Statistics Finland), a web portal from Finland.
The table includes a range of columns that provide rich data, including geographic, temporal, and categorical data. For instance, it carries columns that hold geographic data encoded in formats such as GeoJSON and GeoText. This geographic data, presented in the WGS 84 coordinate reference system, can be utilized for geospatial data analytics. For instance, it could be used to map the administrative regions and understand their spatial relationships.
In addition to the geographic data, the table also includes columns that provide the version history of the rows. The '_start_date' and '_end_date' columns capture the dates when the row was extracted from the data source and when a new version of the row was extracted, respectively. The '_row_number' column contains the row number in the raw data, and together with '_start_date', they form a unique identifier for each row in this version history table. This feature allows for tracing changes over time in the administrative boundaries or designations.
The table also contains columns with information about the administrative regions, including their names in different languages and an identification number ('ely'). These could be used in various data analytics applications, such as studying regional differences in various socio-economic indicators or tracking changes in regional policies over time.
The geographic coordinates in the table could be combined with external data sources to conduct spatial analyses. For instance, one could correlate regional socio-economic data with spatial factors, such as distance to urban centers or natural resources.
In summary, the table provides a rich historical dataset that can be used for a variety of data analytics purposes, particularly those involving geospatial analyses and regional studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This is the date when the row was extracted from the data source, adding a timestamp to each row in the 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 of this column 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, providing a unique identifier for each row in combination with the '_start_date' column. |
| ely | string | This column contains a string value representing a specific administrative region of Finland. |
| geom_geojson | string | This column stores the geographical data of the region in GeoJSON format, a popular open standard format for representing simple geographical features. |
| geom_geotext | string | This column contains the geographical data of the region in text format. |
| geom_type | string | This column indicates the type of the geographical data stored, in this case, a multipolygon. |
| geom_centroid | string | This column contains the centroid of the geographical data, representing the geometric center of the region. |
| geom_center_x | double | This column contains the x-coordinate of the geographical center of the region. |
| geom_center_y | double | This column contains the y-coordinate of the geographical center of the region. |
| gid | long | This is an integer column that may be used as a unique identifier for the regions. |
| gml_id | string | This column contains a unique identifier for each row in string format. |
| name | string | This column contains the English name of the region. |
| namn | string | This column contains the Swedish name of the region. |
| nimi | string | This column contains the Finnish name of the region. |
| vuosi | double | This column contains the year of the record, represented in real number format. |
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 | 7acd9ab2-06f3-41ae-bbc2-9247dd7cfc34 |
| Package id | 8ad3f748-85fc-4751-844c-012532e1d106 |
| Position | 1 |
| Revision id | a9bffbe5-2e9c-4645-8e0e-d5f1512cbab1 |
| State | active |
| Table | tilastointialueet_ely1000k_2017__table__history |