Version History of ELY Areas 2024 (Scale 1:4,500,000) Table
The 'table__history' is a version history table that forms part of the dataset collection 'tilastointialueet_ely4500k_2024'. It comprises of the historical versions of the base table rows, with each row representing a particular version of the data from the ELY-areas 2024 at a scale of 1:4,500,000.
The table includes a unique combination of '_start_date' and '_row_number' to identify each row. The '_start_date' column indicates the date when the row was extracted from the data source, while the '_row_number' column represents the row number in the raw data. The '_end_date' column contains the date when a new version of the row was extracted. If '_end_date' is null, it indicates that the row is the most recent version.
In addition to these, the table incorporates geographical information through columns starting with 'geom_'. This data, represented using the WGS 84 coordinate reference system, can be used for geospatial data analytics.
The table also contains information about the ELY-centres, including their names and IDs. The geographic and administrative data can be utilized in various ways. For instance, one could perform a temporal analysis of the changes in the geographic boundaries of the ELY-centres over time. Additionally, the data could be used to analyze the spatial distribution of various administrative regions in Finland.
The table's data is sourced from the 'Tilastokeskus' website, based in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | Contains the date when the row was extracted from the data source, enabling tracking of the version history of the table rows. |
| _end_date | date | Holds the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version. |
| _row_number | long | Represents the number of the row in the raw data extracted from the data source. Combined with '_start_date', it uniquely identifies each row in this version history table. |
| ely | string | String data type column, holding a unique identifier for each ELY (Centre for Economic Development, Transport and the Environment) in Finland. |
| geom_geojson | string | Stores geometric data in GeoJSON format, representing the geographical boundaries of each ELY. |
| geom_geotext | string | Holds the geometric boundaries of each ELY as text, providing a human-readable format for the geographic data. |
| geom_type | string | Specifies the type of geometric shape used to represent the ELY boundaries, such as polygon or multipolygon. |
| geom_centroid | string | Contains the central point (centroid) of the geometric shape representing the ELY boundaries. |
| geom_center_x | double | Represents the X-coordinate of the centroid of the geometric shape representing the ELY boundaries. |
| geom_center_y | double | Represents the Y-coordinate of the centroid of the geometric shape representing the ELY boundaries. |
| gml_id | string | A string type column that contains a unique identifier for each row, provided by the data source. |
| id | long | An integer type column, representing a unique identifier for each row in the table. |
| name | string | Holds the English name of each ELY. |
| namn | string | Contains the Swedish name of each ELY. |
| nimi | string | Stores the Finnish name of each ELY. |
| vuosi | long | An integer type column, representing the year for which the row's data is relevant. |
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 | 162ffb4d-bcd4-4181-a163-9d97e606b235 |
| Package id | 01da5ded-3128-4dd4-9f36-e54366380ec9 |
| Position | 1 |
| Revision id | 4fb1ce50-d73f-4b7d-9f70-2abb4bf63793 |
| State | active |
| Table | tilastointialueet_ely4500k_2024__table__history |