Version History for Well-being Areas (1:1 000 000)
The 'table__history' is a dynamic and comprehensive record of the 'Wellbeing Areas' (Hyvinvointialueet) dataset, captured at the granularity of 1:1 000 000. This table is a part of a larger dataset collection, which provides an extensive overview of these areas. The table is sourced from the Finnish Statistics Bureau, 'Tilastokeskus', in Finland.
The 'table__history' primarily serves to maintain a version history of its base table rows. It offers a unique combination of columns, '_start_date' and '_row_number', which identifies each row in this version history table. The '_start_date' refers to the date when the row was extracted from the data source, while the '_end_date' signifies the date when a new version of the row was extracted. If the '_end_date' is null, it indicates that the row is the most recent version.
Further, the table includes a series of columns prefixed with 'geom_', storing geographic information useful for geospatial data analytics. These geographic coordinates are represented using the WGS 84 coordinate reference system, with axis order being longitude first, followed by latitude.
The table also includes a set of columns containing information about the 'Wellbeing Areas'. This includes their names presented in different languages and a unique identification number. Another column states the year of the data.
The rich geographical and historical information within the 'table__history' provides a myriad of opportunities for data analytics. For example, geospatial analytics could be performed to study the evolution of the 'Wellbeing Areas' over time, analyze trends, and make predictions. The data could also be used to understand regional differences in wellbeing, helping policymakers to better allocate resources.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column represents the date when the row was extracted from the data source. It forms a unique combination with '_row_number' to identify each row in this version history table. |
| _end_date | date | This column represents the date when a new version of the row was extracted from the data source. If the value in this column is null, it signifies that the row is the most recent version. |
| _row_number | long | This column indicates the number of the row in the raw data extracted from the source. It forms a unique combination with '_start_date' to identify each row in this version history table. |
| geom_geojson | string | This column contains geometric data for the well-being area in geojson format. The data could represent various geometric shapes like polygons or multipolygons. |
| geom_geotext | string | This column contains geometric data for the well-being area in text format. The data could represent various geometric shapes like polygons or multipolygons. |
| geom_type | string | This column denotes the type of the geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. It can be of types like 'ST_POLYGON' or 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column contains the coordinates of the centroid of the geometric shape representing the well-being area. |
| geom_center_x | double | This column contains the x-coordinate of the centroid of the geometric shape representing the well-being area. |
| geom_center_y | double | This column contains the y-coordinate of the centroid of the geometric shape representing the well-being area. |
| gml_id | string | This is a unique identifier for each well-being area in the table. |
| hyvinvointialue | string | This column signifies the code for each well-being area. |
| name | string | This column contains the English name of the well-being area. |
| namn | string | This column contains the name of the well-being area in Swedish. |
| nimi | string | This column contains the name of the well-being area in Finnish. |
| vuosi | long | This column represents the year of the data. This table contains data from the year 2024. |
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 | eb73784d-1ce8-4773-8f6e-8cba2b98070f |
| Package id | 52e5c929-116a-423d-9c32-c668b0145eec |
| Position | 1 |
| Revision id | 52f45547-2cfa-42af-83f0-0d5ef6e95eba |
| State | active |
| Table | tilastointialueet_hyvinvointialue1000k__table__history |