Version History of Regional Units 2021 (1:4 500 000) - History Table
The 'table__history' is a part of the dataset collection 'tilastointialueet_seutukunta4500k_2021'. This history table maintains the version history of its base table rows, providing a chronological record of updates. The base table contains data regarding 'Seutukunnat 2021 (1:4 500 000)', which translates to Regions 2021 (1:4 500 000) in English. This data, sourced from the 'Tilastokeskus' website, based in Finland, offers rich insights into various regional aspects.
The table includes several columns that hold a variety of information. For instance, there are columns for dates indicating when the row was added to the table ('_start_date') and when the row was updated ('_end_date'). The unique combination of '_start_date' and '_row_number' distinguishes each row in this version history table. If the '_end_date' column is null, it indicates that the row is the most recent version.
Geospatial data is stored in the columns beginning with 'geom_', including information about the geographical shape (polygon), the centroid, and the center coordinates of regions. These geographic coordinates follow the WGS 84 coordinate reference system, with longitude preceding latitude - critical information for geospatial data analytics.
Other columns store information such as the name of the region in multiple languages and a unique identifier for each region. The 'vuosi' column indicates the relevant year for the data.
The table offers numerous opportunities for data analytics. For instance, geospatial analysis can leverage the geographical data to study regional patterns or changes over time. Analysts can also track changes in regional data over time using the version history. Another possible use could be multilingual analysis, comparing the names of regions in different languages.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column indicates the date when the row was extracted from the data source, marking the beginning of the validity period for the specific version of the row. |
| _end_date | date | This column represents the date when a new version of the row was extracted from the data source, marking the end of the validity period for the specific version of the row. If the value is null, it means that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It, in combination with '_start_date', uniquely identifies each row in this version history table. |
| geom_geojson | string | This column contains the geometric data of the region in GeoJSON format, a popular format for encoding geographic data structures. |
| geom_geotext | string | This column contains the geometric data of the region in text format. |
| geom_type | string | This column specifies the type of the geometric data, in this case, a polygon. |
| geom_centroid | string | This column contains the centroid of the geometric data, which is the center point of the region. |
| geom_center_x | double | This column contains the x-coordinate of the center point of the region. |
| geom_center_y | double | This column contains the y-coordinate of the center point of the region. |
| gml_id | string | This column contains the unique identifier of the region. |
| name | string | This column contains the English name of the region. |
| namn | string | This column contains the name of the region in another language. |
| nimi | string | This column contains the name of the region in another language. |
| seutukunta | string | This column contains a code representing the region. |
| vuosi | long | This column contains 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 | 78e96e07-45d5-4c5f-93c7-5255b6acd98e |
| Package id | 98a77627-d640-4781-83f4-479559485b1d |
| Position | 1 |
| Revision id | dfeb1e6c-8728-4555-baa8-1f40c07d7e25 |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2021__table__history |