Version History of Well-being Areas 2022 (1:4 500 000) Table
The 'table__history' is a part of the 'tilastointialueet_hyvinvointialue4500k_2022' dataset collection. This table is known as a history table, which keeps track of the version history of its base table rows. The base table's content, 'Hyvinvointialueet 2022 (1:4 500 000)', translates to 'Wellbeing Areas 2022 (1:4 500 000)' in English. This information suggests that the table contains geographic and demographic data relating to different wellbeing areas in the year 2022.
The table has unique columns to maintain its historical nature. There is a column for the start date, indicating when the row was first added, and an end date, indicating when a new version of the row was added. If the end date is null, it signifies that the row is the most recent version. Another unique feature of this table is its row number column, which combined with the start date, uniquely identifies each row in the table.
Geographic information is stored in the columns beginning with 'geom_', including GeoJSON data, plain text geometric data, the type of geometry, and the centroid of the geometry. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table also contains other columns such as a unique identifier (GML ID), a wellbeing area identifier, and the names of the wellbeing areas in multiple languages.
This data could be beneficial for analytics purposes. For example, it could be utilized in geospatial data analytics to study the geographical distribution of wellbeing areas over time. It could also be used to analyze the demographic changes within these areas, as the data includes information about the wellbeing areas in different languages, indicating a multilingual population.
This valuable dataset is sourced from 'Tilastokeskus' (Statistics Finland), a reliable data source based in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with '_row_number'. |
| _end_date | date | This column comprises the date when a new version of the row was extracted from the data source. If the value is null, 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 source. It forms a unique identifier in combination with '_start_date'. |
| geom_geojson | string | This column contains geometric data of the wellness area in GeoJSON format, which can be a polygon or multiple polygons. |
| geom_geotext | string | This column contains geometric data of the wellness area in a plain text format, which can be a polygon or multiple polygons. |
| geom_type | string | This column specifies the type of the geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. It can be either a single polygon (ST_POLYGON) or multiple polygons (ST_MULTIPOLYGON). |
| geom_centroid | string | This column contains the geographical point that represents the centroid of the geometric shape of the wellness area. |
| geom_center_x | double | This column contains the x-coordinate of the centroid of the geometric shape of the wellness area. |
| geom_center_y | double | This column contains the y-coordinate of the centroid of the geometric shape of the wellness area. |
| gml_id | string | This column contains unique identifiers for each row. |
| hyvinvointialue | string | This column contains the wellness area identifier. |
| name | string | This column contains the English name of the wellness area. |
| namn | string | This column contains the Swedish name of the wellness area. |
| nimi | string | This column contains the Finnish name of the wellness area. |
| vuosi | long | This column contains the year for the data 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 | 169a17c9-a433-4625-8477-987f797bd11b |
| Package id | e60be648-b0fa-454b-a916-ff98c156cdee |
| Position | 1 |
| Revision id | a7b17dab-b11f-4239-b49c-3b20872085e9 |
| State | active |
| Table | tilastointialueet_hyvinvointialue4500k_2022__table__history |