Historical Version Records of Regional Units 2015 (1:4 500 000)
The 'table__history' is a comprehensive compilation of historical data, part of the dataset collection 'tilastointialueet_seutukunta4500k_2015'. This history table embodies the version history of its base table rows, capturing information such as the distinct row number, start and end dates of data extraction, and geographic details relevant for geospatial analysis. It does not merely present the raw data but gives it a temporal context, enabling tracking changes over time.
The table provides insights into regional data from 2015 with a focus on Finnish regions (Seutukunnat) at a scale of 1:4 500 000. The table lays out detailed geographic information, including types of geographic areas (like MultiPolygon), centroid points, and center coordinates. It is important to note that geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This makes the data interoperable and usable in varied geospatial analysis tools and applications.
The table also delineates the unique identification for each region, its name in multiple languages, and specific shape characteristics. A unique combination of row number and start date serves to identify each row of data, ensuring precise data management and retrieval. The start and end dates reflect the time frame of data extraction, with a null end date indicating the most recent version of the row.
This table, sourced from the Finnish Statistics Bureau ('Tilastokeskus'), can serve several analytical purposes. For example, it can be used in spatial data analytics to study regional variations in Finland, track changes over time, or even analyze spatial relationships and patterns. It can also be instrumental in creating time-series analysis to observe trends and patterns over a specified period. Moreover, with its multilingual support, the table can assist in cross-cultural and multilingual research, enhancing data accessibility and comprehension.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies each row in the version history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value of this column 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, in combination with '_start_date', uniquely identifies each row in the version history table. |
| geom_geojson | string | Geospatial data representing the area of interest in GeoJSON format. |
| geom_geotext | string | Geospatial data representing the area of interest in text format. |
| geom_type | string | The type of geometry used to represent the area of interest. |
| geom_centroid | string | The centre point of the area of interest represented as a geometric point. |
| geom_center_x | double | The x-coordinate of the centre point of the area of interest. |
| geom_center_y | double | The y-coordinate of the centre point of the area of interest. |
| gml_id | string | A unique identifier for each row in the table. |
| name | string | The English name of the region of interest. |
| namn | string | The regional name of the region of interest. |
| nimi | string | The local name of the region of interest. |
| seutukunta | string | A code representing the region of interest. |
| shape_star | double | A measure of the area size of the region of interest. |
| shape_stle | double | A measure of the perimeter of the region of interest. |
| vuosi | double | The year of the data entry. |
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 | 5b63f292-b0d3-4365-8f05-6552313d3515 |
| Package id | c1b1af70-624a-487b-94c4-e9f26399e720 |
| Position | 1 |
| Revision id | 2a97912a-6619-477e-99a5-9a99d4b9cf86 |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2015__table__history |