Version History of ELY Areas 2016 (1:4 500 000) Table
The table named 'table__history' is an integral part of the dataset collection 'tilastointialueet_ely4500k_2016'. This table serves as a historical record, keeping track of the version history of its base table rows. The table contains data pertaining to ELY-areas in 2016, at a scale of 1:4,500,000, sourced from 'Tilastokeskus' (the Finnish Statistics Bureau) located in Finland.
The table's columns hold a wide range of data types, including date timestamps, row numbers, geographic information, and text fields. A unique feature of this history table is its two additional columns, '_start_date' and '_end_date', which respectively denote the dates when a row was extracted from the source data and when a new version of the row was extracted. If the '_end_date' is null, it signifies that the row is the most recent version.
Among the various columns, those starting with 'geom_' are of special interest as they hold geospatial data. This geographic information, expressed using a WGS 84 coordinate reference system, is particularly useful for geospatial data analytics.
Potential uses of the data in this table could include tracking changes over time in the ELY-areas, performing trend analysis, and carrying out geospatial analytics. For instance, the data could be used to monitor the shifts in boundaries of the ELY-areas over time or to analyse the spatial distribution and concentration of specific attributes within these areas. Furthermore, the version history could be utilized to validate the data integrity and accuracy of the base table.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column records the date when the row was extracted from the data source. It forms a combination with the '_row_number' column 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 of this column is null, it indicates 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. Together with the '_start_date' column, it forms a unique identifier for each row in this version history table. |
| ely | string | This is a string type column in the dataset, although the sample values appear to be numerical. |
| geom_geojson | string | This column contains geojson data representing the geographical area related to the row. |
| geom_geotext | string | This column contains text-based geographical data. |
| geom_type | string | This column specifies the type of the geographical data present in the row. |
| geom_centroid | string | This column contains the geographical point that represents the centroid of the area related to the row. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical area related to the row. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical area related to the row. |
| gid | long | This column is of integer type and could be a unique identifier for the geographical area. |
| gml_id | string | This column is of string type and contains a unique identifier for the geographical data. |
| name | string | This column contains the English name of the entity related to the row, such as a government or administrative body. |
| namn | string | This column contains the name of the entity related to the row in another language. |
| nimi | string | This column contains the name of the entity related to the row in yet another language. |
| vuosi | double | This column, of real type, contains the year associated with the row. |
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 | a017255e-d984-46c6-afc9-2b103d76a241 |
| Package id | 5cd6b9d9-22bb-44ad-862a-b3f002422f39 |
| Position | 1 |
| Revision id | 089945bb-e86d-48a9-b46d-7c0eebe6f942 |
| State | active |
| Table | tilastointialueet_ely4500k_2016__table__history |