Version History of ELY Areas 2019 (Scale 1:4,500,000)
The 'table__history' is a rich data repository that captures the version history of its base table rows. It is part of the 'tilastointialueet_ely4500k_2019' dataset, which is sourced from the Finnish statistics agency, 'Tilastokeskus'. The information in this table is an invaluable resource for understanding the ELY Centres in Finland, as described by the data source. ELY Centres are responsible for the regional implementation and development of administrative sector tasks of the Finnish government.
The table is composed of various columns that provide comprehensive details about each row from the base table. It includes geographic information, which could be utilized for geospatial data analytics. This geographic data is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
For example, it has columns that provide multi polygon geometric details and centroids of regions, facilitating cartographic or spatial analysis of the ELY Centres. The table also includes columns that contain names and identifiers of the ELY Centres, offering possibilities for categorical or comparative analysis.
One of the key features of this table is the presence of version history specific columns. These include '_start_date', '_end_date', and '_row_number'. The '_start_date' and '_row_number' together form a unique identifier for each row in the table. The '_start_date' indicates the date when the row was extracted from the source, while the '_end_date' signifies when a new version of the row was extracted. If the '_end_date' is null, it implies that the row is the most recent version.
With this, the table provides a temporal dimension to the data, allowing for historical analysis or trend identification over time. For instance, one could trace the evolution of ELY Centres or analyze temporal patterns in the geographic distribution of these centres.
In summary, the 'table__history' is an extensive and dynamic data resource that offers a historical and geographic perspective on the ELY Centres in Finland, making it potentially useful for a range of data analytics applications.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column marks the date when the row was extracted from the data source. It helps in tracking the chronology of the data extracted. |
| _end_date | date | This column indicates the date when a new version of the row was extracted from the data source. If the value here is null, it signifies that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. It works in conjunction with '_start_date' to uniquely identify each row in this version history table. |
| ely | string | This refers to a unique identifier for different regions in Finland. |
| geom_geojson | string | This column contains the geometrical representation of the region in GeoJSON format. |
| geom_geotext | string | This column contains the geometrical representation of the region in text format. |
| geom_type | string | This column specifies the type of geometry used for the region, for example, 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column provides the centroid or the geometric center of the region. |
| geom_center_x | double | This column shows the x-coordinate of the geometric center of the region. |
| geom_center_y | double | This column shows the y-coordinate of the geometric center of the region. |
| gml_id | string | This is a unique identifier for each row in the table. |
| id | long | This is the numerical ID for each row in the table. |
| name | string | This column contains the English name of the region. |
| namn | string | This column contains the name of the region in Swedish. |
| nimi | string | This column contains the name of the region in Finnish. |
| vuosi | long | This column represents the year to which the data pertains. |
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 | 50eb0fca-3f71-4d65-980f-a8fc7cf28350 |
| Package id | 21240982-37a7-45b2-a2e6-fe9e3624083a |
| Position | 1 |
| Revision id | 6b99e6dc-8940-45c9-8fac-913284a362f6 |
| State | active |
| Table | tilastointialueet_ely4500k_2019__table__history |