Version History of ELY Areas 2015 (1:4 500 000)
The 'table__history' is a history table that keeps track of the version history of its base rows. The table is a part of the dataset collection 'tilastointialueet_ely4500k_2015'. The base table contains data about the ELY-areas in 2015 at a scale of 1:4,500,000. This information is sourced from the 'Tilastokeskus' website, located in Finland.
The data in the table is organized into rows, with each row representing a specific version of the base row. Each row in this table is uniquely identified by a combination of the '_start_date' and '_row_number'. The '_start_date' indicates the date the row was extracted from the data source, while the '_row_number' represents the number of the row in the raw data extracted from the data source. The table also includes an '_end_date' column that indicates 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.
The table also contains geographic information, represented by columns beginning with 'geom_'. These geographic details can be used for geospatial data analytics. It is important to note that the geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The data within 'table__history' provides valuable insights and can be utilized in numerous ways. For example, by analyzing the '_start_date' and '_end_date', one can track the changes in the ELY-areas over time. Additionally, the geographical data can be used to map the ELY-areas and analyze spatial patterns and trends. Moreover, the version history information can be used to restore previous versions of the data, if necessary.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of the combination 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 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 also forms part of the combination that uniquely identifies each row in this version history table. |
| ely | string | This column contains string values representing different regions. |
| geom_geojson | string | This column contains geographic data in GeoJSON format. |
| geom_geotext | string | This column contains geographic data in text format. |
| geom_type | string | This column specifies the type of geometric data contained in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the centroid point of the geographic data. |
| geom_center_x | double | This column contains the X coordinate of the center point of the geometric data. |
| geom_center_y | double | This column contains the Y coordinate of the center point of the geometric data. |
| gid | long | This is an integer column, which is likely used as an identifier. |
| gml_id | string | This column contains string identifiers in GML format. |
| name | string | This column contains name of the region in English. |
| namn | string | This column contains name of the region in another language, possibly Swedish. |
| nimi | string | This column contains name of the region in another language, possibly Finnish. |
| shape_star | double | This column contains real number values which likely represent some aspect of the geometric shape of the corresponding geographic region. |
| shape_stle | double | This column contains real number values which likely represent some aspect of the geometric shape of the corresponding geographic region. |
| vuosi | double | This column contains real number values which likely represent the year associated with the corresponding row of data. |
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 | a3e98865-2fc5-4741-8801-78b588dd3e51 |
| Package id | 62305c15-b745-445d-8513-7d98f2a08866 |
| Position | 1 |
| Revision id | 03eec88e-c4a3-47cb-8931-ad09c3d3a2f1 |
| State | active |
| Table | tilastointialueet_ely4500k_2015__table__history |