Version History of Regional Units 2021 (1:1 000 000)
Click here for a data sample
The 'table__history' is a part of the 'tilastointialueet_seutukunta1000k_2021' dataset collection and serves as a history table, providing a version history of its base table rows. This table contains data on regional areas for the year 2021 at a scale of 1:1 000 000, sourced from the Statistics Finland (Tilastokeskus) website. The data content includes geographic information, unique identifiers, and names in different languages. The geographic information, indicated by columns starting with 'geom_', is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. These geographic details can be used in geospatial data analytics to study regional patterns or changes over time. The table also includes unique identifiers, such as row number and gml_id, which can be used to track data changes over time, ensuring data integrity and version control. Names of the regional areas are provided in three languages, which can be used for multilingual data analysis or localization purposes. The table also includes two additional columns, '_start_date' and '_end_date', which contain the dates of when the row was extracted from the data source and when a new version of the row was extracted respectively. This allows for temporal analysis of the data, such as studying the evolution of the regions over time. The table, therefore, offers a wealth of information that can be used in various data analytics applications, ranging from geospatial analysis to multilingual studies and temporal trend analysis.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the row was extracted from the data source. This column plays a crucial role in uniquely identifying each row in this version history table along with the '_row_number' column. |
|---|
| _end_date | date | The date when a new version of the row was extracted from the data source. If this column has a null value, 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 the '_start_date' column, uniquely identifies each row in this version history table. |
|---|
| geom_geojson | string | Contains geographical data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | Contains geographical data, in the form of text, that corresponds to the GeoJSON data in the 'geom_geojson' column. |
|---|
| geom_type | string | Specifies the type of the geographical data contained in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_centroid | string | Contains the central point of the geographical data represented in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_center_x | double | Represents the X coordinate of the central point of the geographical data. |
|---|
| geom_center_y | double | Represents the Y coordinate of the central point of the geographical data. |
|---|
| gml_id | string | A unique identifier for each row in the table. |
|---|
| name | string | The name of the area in English. |
|---|
| namn | string | The name of the area, likely in a local language. |
|---|
| nimi | string | The name of the area, possibly in another local language. |
|---|
| seutukunta | string | A code representing a specific region within Finland. |
|---|
| vuosi | long | The year associated with the data in each row. |
|---|
