Wellbeing Regions 2022 (1:4 500 000) - Data Table
The table in question is part of a dataset collection associated with the 'Wellbeing Areas 2022' (Hyvinvointialueet 2022), an extensive data collection sourced from the website of Statistics Finland (Tilastokeskus). The data within this table provides a wealth of information intended for geospatial analysis, primarily focused around geographic and administrative regions.
The table is composed of several columns, each acting as a unique identifier or providing specific details about the data. For instance, two notable columns are '_extract_date' and '_row_number'. The former contains the date when the data was extracted, and the latter holds the unique row number for the extracted data. Together, these two columns can uniquely identify any data row within the table.
The table also contains a variety of geographic data, denoted by columns starting with 'geom_'. These columns contain details about the geospatial attributes of the wellbeing areas, including the type of geographic figure (polygon or multipolygon), the geojson representation, geotext, centroid, and the center coordinates. The geographic coordinates are presented using the WGS 84 coordinate reference system, with longitude first, followed by latitude, which is a widely accepted standard for geospatial data representation.
In addition to the geospatial columns, the table also contains the 'gml_id', which is a unique identifier for each wellbeing area. The 'hyvinvointialue' column contains the numeric code for each wellbeing region. The table also includes the names of the wellbeing areas in multiple languages including Finnish ('nimi'), Swedish ('namn'), and English ('name'). Lastly, the 'vuosi' column indicates the year for which the data is relevant.
The data contained within this table could be used in a variety of data analytics applications. For instance, it could be used to perform geospatial analysis to understand the wellbeing of different regions at a given time. It could also be used to track changes in wellbeing over time by comparing data from different '_extract_date'. Moreover, by leveraging geographic data, one could create detailed visualizations and maps that could aid in understanding regional disparities in wellbeing.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column indicates the date when the row data was extracted from the source. It plays a crucial role in uniquely identifying each row in combination with the _row_number |
| _row_number | long | The _row_number column represents the sequence of the data as it was extracted from the source. It works hand in hand with the _extract_date to uniquely identify each row. |
| geom_geojson | string | This column contains the geometric representation of the data in GeoJSON format. It's useful for mapping and spatial analysis purposes. |
| geom_geotext | string | The geom_geotext column holds the geometric data in text format. It provides an alternative representation of the spatial data. |
| geom_type | string | This column specifies the type of the geometric data. It can be a Polygon or a MultiPolygon, which are types of spatial data. |
| geom_centroid | string | The geom_centroid column contains the centroid point of the geometric data. It's a central point that can be used for spatial analysis and mapping. |
| geom_center_x | double | This column holds the X coordinate of the center point of the geometric data. It's useful for mapping and spatial analysis. |
| geom_center_y | double | The geom_center_y column contains the Y coordinate of the center point of the geometric data. It's crucial for mapping and spatial analysis. |
| gml_id | string | This column holds a unique identifier for each row in the table. It's a string type column. |
| hyvinvointialue | string | The hyvinvointialue column signifies a specific area. It's a string type column. |
| name | string | The name column contains the English name of the wellbeing area. It's a string type column. |
| namn | string | This column holds the Swedish name of the wellbeing area. It's a string type column. |
| nimi | string | The nimi column represents the Finnish name of the wellbeing area. It's a string type column. |
| vuosi | long | This integer type column indicates the year. |
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 | cec35b9e-bdf9-4a99-831d-9d4127fd290d |
| Package id | e60be648-b0fa-454b-a916-ff98c156cdee |
| Revision id | 79c08a06-9117-44ca-a5ee-5c13216850f7 |
| State | active |
| Table | tilastointialueet_hyvinvointialue4500k_2022__table |