Version History of ELY Areas (Scale 1:4,500,000) - Historical Data Table
The 'table__history' is an extensive repository of version history for each row of its base table. The base table represents various ELY areas at a scale of 1:4,500,000, sourced from the 'Tilastokeskus' website in Finland. Each row in the table is uniquely identified by a combination of the '_start_date' and '_row_number'. The table includes additional columns, '_start_date' and '_end_date', which record when the data was extracted and when a new version was extracted respectively. If the '_end_date' column value is null, it signifies that this is the most recent version of the row.
The table also carries a wealth of geographic information in columns prefixed with 'geom_'. This data can be used for geospatial data analytics, with geographic coordinates presented using the WGS 84 coordinate reference system, longitude first, followed by latitude.
The data in this table can be harnessed in numerous ways for data analytics. For instance, one could track changes in the ELY areas over time by examining the '_start_date' and '_end_date' of each row. Additionally, the geographic information could be utilized to analyze spatial patterns or changes in the ELY areas. Furthermore, data analysts could also use the table to study the evolution of the ELY areas, as well as identify and understand trends and patterns in these regions.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique combination with '_row_number' to identify 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 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. It forms a unique combination with '_start_date' to identify each row in this version history table. |
| ely | string | This column stores a string that represents a particular ELY center. |
| geom_geojson | string | This column stores the geometric data of the ELY center in GeoJSON format. |
| geom_geotext | string | This column stores the geometric data of the ELY center in text format. |
| geom_type | string | This column indicates the type of the geometric data stored. |
| geom_centroid | string | This column stores the centroid of the geometric shape representing the ELY center. |
| geom_center_x | double | This column stores the x-coordinate of the geometric center of the ELY center. |
| geom_center_y | double | This column stores the y-coordinate of the geometric center of the ELY center. |
| gml_id | string | This column stores a unique identifier for each row in string format. |
| id | long | This column stores a unique integer identifier for each row. |
| name | string | This column stores the English name of the ELY center. |
| namn | string | This column stores the name of the ELY center in another language. |
| nimi | string | This column stores the Finnish name of the ELY center. |
| vuosi | long | This column stores an integer that represents the year. |
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 | 81efa15c-e61d-4789-afce-c2e0cde2f413 |
| Package id | 5ebf616a-3ff5-4c46-aa02-7a3fe9038928 |
| Position | 1 |
| Revision id | 3d74822e-1a00-47f7-a08f-6a8247929826 |
| State | active |
| Table | tilastointialueet_ely4500k__table__history |