Historical Records of ELY Areas 2018 (Scale 1:4,500,000)
The 'table__history' is a historical data repository that documents the evolution of its base table entries over time. This table is part of a dataset collection pertaining to statistical areas in Finland, specifically the ELY-areas in 2018 at a scale of 1:4,500,000. The information captured in this table is derived from the Finnish statistical agency, 'Tilastokeskus'.
The table's columns provide a wealth of information. Key among them are a pair of columns, '_start_date' and '_row_number', which together create a unique identifier for each row. The '_start_date' column records the date an entry was extracted from the source, while the '_end_date' column notes when a new row version was extracted. If the '_end_date' is null, it signifies that the row is the latest version.
This table is also rich in geographic data, with several columns beginning with 'geom_' storing geospatial information. This data is presented using the WGS 84 coordinate reference system, which orders the coordinates as longitude first, followed by latitude. This geospatial data, coupled with the historical record in this table, could be leveraged to conduct temporal studies and spatial analyses, including trend analysis over time or regional comparisons.
For example, analysts could trace the changes in specific statistical areas over time, or compare the development across different regions. Alternatively, with the geographic coordinates, GIS specialists could create detailed maps or conduct spatial analyses. The temporal data could also be used for predictive modeling, allowing researchers to forecast future trends based on historical patterns.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. This column, together with '_row_number', uniquely identifies each row in the history table. |
| _end_date | date | 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 | The number of the row in the raw data extracted from the data source. This column, together with '_start_date', uniquely identifies each row in the history table. |
| ely | string | A string indicating an identifier associated with the row. |
| geom_geojson | string | Contains geographical data in GeoJSON format. |
| geom_geotext | string | Contains geographical data in text format. |
| geom_type | string | The type of the geographical data. |
| geom_centroid | string | The central point of the geographical data. |
| geom_center_x | double | The X coordinate of the center of the geographical data. |
| geom_center_y | double | The Y coordinate of the center of the geographical data. |
| gml_id | string | A string identifier for the row. |
| id | long | An integer identifier for the row. |
| name | string | A string containing the name associated with the row. |
| namn | string | A string containing an alternate name associated with the row. |
| nimi | string | A string containing another alternate name associated with the row. |
| vuosi | long | An integer indicating 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 | afcf8ce5-fd1a-4f1d-8f10-200601875aa6 |
| Package id | 3a1655c1-36e3-47a3-a7f1-a68f2d75ff9c |
| Position | 1 |
| Revision id | 0c01c33c-fd17-4590-b41c-f40ae4fe3805 |
| State | active |
| Table | tilastointialueet_ely4500k_2018__table__history |