Version History of ELY Areas 2014 (1:4 500 000) Dataset
The 'table__history' is a historical data table that originates from the 'Tilastokeskus' (Statistics Finland) website, based in Finland. It is a part of the 'tilastointialueet_ely4500k_2014' dataset collection. This historical data table provides a version history of its base table rows, documenting changes over time. The content of the base table can be described as 'ELY-areas 2014 (1:4 500 000)'.
The table contains multiple columns with different types of data. Each row of the table is uniquely identified by the combination of '_start_date' and '_row_number' columns. The column '_start_date' indicates when the data was extracted from the source, while the '_end_date' shows when a new version of the row was extracted. If the '_end_date' value is null, it suggests that the row is the most recent version.
Furthermore, the table contains geographical data columns, starting with 'geom_', which can be useful for geospatial analysis. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude (X coordinate) first, followed by latitude (Y coordinate).
The table also includes columns for 'ely', 'gml_id', 'name', 'namn', 'nimi', and 'vuosi'. These columns provide additional information related to the ELY areas, their identifiers, and their names in various languages, as well as the year of data collection.
This table can be utilized in various data analytics scenarios. For example, it could be used to track changes in the ELY areas over time, analyze patterns or trends, or even predict future changes. Additionally, the geospatial data could be used to visualize the ELY areas on a map, enabling more detailed regional analysis. The multilingual names could also be used to present the data in different languages, enhancing its usability for international users.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This represents the date a certain version of the row was extracted from the data source. This date, combined with '_row_number', uniquely identifies each row in the history table. |
| _end_date | date | This indicates the date when a newer version of the row was extracted from the data source. A null value in this column signifies that the row is the latest version. |
| _row_number | long | This contains the unique number of the row in the raw data, which in combination with '_start_date', allows for the identification of individual versions of rows in the history table. |
| ely | string | This is a string variable in the base table which possibly denotes a certain administrative or geospatial area within Finland. |
| geom_geojson | string | This contains geometric data in the GeoJSON format. It is likely linked to the geographical representation of the data in each row. |
| geom_geotext | string | This contains geometric data in text form. It is likely a different representation of the geographical data contained in 'geom_geojson'. |
| geom_type | string | This indicates the type of geometric data represented in the 'geom_geotext' and 'geom_geojson' columns. |
| geom_centroid | string | This contains the centroid of the geographic area represented by the 'geom_geojson' and 'geom_geotext' data. The centroid is the geometric center of a shape. |
| geom_center_x | double | This represents the x-coordinate of the geometric center or centroid of the shape represented by 'geom_geojson' and 'geom_geotext'. |
| geom_center_y | double | This indicates the y-coordinate of the geometric center or centroid of the shape represented by 'geom_geojson' and 'geom_geotext'. |
| gml_id | string | This is a string variable in the base table which possibly serves as a unique identifier for each row. |
| name | string | This column contains English names of entities represented in the data. This could be regions, administrative areas or other geospatial entities within Finland. |
| namn | string | This column contains the names of entities represented in the data in Swedish. This could be regions, administrative areas or other geospatial entities within Finland. |
| nimi | string | This column contains the names of entities in Finnish. This could be regions, administrative areas or other geospatial entities within Finland. |
| vuosi | long | This is an integer variable in the base table which likely represents the year associated with the data in 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 | 2b4151d3-ae30-40ee-9f2a-1c1831da26cf |
| Package id | 4983d0b6-d6e0-4d62-beec-6bf06b6a11b4 |
| Position | 1 |
| Revision id | 6ffca85b-3489-43d4-b950-2822e9be2789 |
| State | active |
| Table | tilastointialueet_ely4500k_2014__table__history |