Version History of ELY Areas 2014 (1:1 000 000)
The 'table__history' is a meticulously organized history table that is part of the wider 'tilastointialueet_ely1000k_2014' dataset, which contains relevant data that has been structured into rows and columns. This particular table is a repository of the version history of its base table rows, tracing the changes in the data over time.
The table primarily holds data on the ELY-alueet 2014 (ELY areas 2014) at a scale of 1:1,000,000, which can be translated to a diverse range of geospatial analytics. The data is supplied by 'Tilastokeskus' (Statistics Finland) based in Finland.
Columns in this table are rich with geographic information, including a set of 'geom_' prefixed columns, which provide detailed geospatial data. This data, which is based on the WGS 84 coordinate reference system, can be utilized for detailed geospatial data analytics. For instance, the longitude and latitude are given in the 'geom_center_x' and 'geom_center_y' columns respectively.
Additionally, there are columns describing the ELY area in multiple languages, including Finnish and Swedish, which can be useful for multilingual data applications. It also includes a column for the year ('vuosi'), which is particularly relevant for time series analysis or historical comparisons.
The unique identifiers in this table are a combination of the '_start_date' and '_row_number' columns, which together create a unique identifier for each record. The '_start_date' is the date when the data row was extracted from the source, while the '_end_date' is the date when a fresh version of that row was extracted. If the '_end_date' is null, that signifies that the row is the most recent version.
In terms of data analytics, this table can be a valuable resource. For instance, the geographic data can be used for spatial analysis, such as identifying patterns or trends in the distribution of ELY areas. Similarly, the multilingual data can provide insights for language-based studies or applications. The version history could be used to track changes in the data over time, allowing for a deeper understanding of how these areas are evolving. Furthermore, the data can be used in creating interactive maps, or for integrating with other datasets for more comprehensive analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was first captured from the data source, indicating the start of that version of the row. |
| _end_date | date | The date when a new version of the row was captured from the data source, indicating the end of that version of the row. If this value is null, it signifies that this version of the row is the most recent. |
| _row_number | long | The row number in the raw data extracted from the data source. This, combined with '_start_date', forms a unique identifier for each row in this version history table. |
| ely | string | A string identifier representing different regions in Finland. |
| geom_geojson | string | Geospatial data in GeoJSON format, representing the geometrical shape of the region. |
| geom_geotext | string | Geospatial data in text format, representing the geometrical shape of the region. |
| geom_type | string | The type of the geometrical shape, in this case a 'ST_MULTIPOLYGON', which represents a complex shape with multiple boundaries. |
| geom_centroid | string | The central point of the geometrical shape. |
| geom_center_x | double | The X-coordinate of the center of the geometrical shape. |
| geom_center_y | double | The Y-coordinate of the center of the geometrical shape. |
| gml_id | string | A unique string identifier for each row, typically adhering to a specific naming convention. |
| name | string | The English name of the region. |
| namn | string | The Swedish name of the region. |
| nimi | string | The Finnish name of the region. |
| vuosi | long | The year the data was recorded, represented as an integer. |
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 | 230d3cde-0ad4-43c6-8522-028fc613a1ef |
| Package id | bc1301fc-df2a-40ff-b865-ad1543edd33c |
| Position | 1 |
| Revision id | 17adb698-f493-4a8e-a8d6-e64b4358b98b |
| State | active |
| Table | tilastointialueet_ely1000k_2014__table__history |