Wellbeing Areas at Scale 1:4,500,000 - Data Table
The table in question, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland), contains information related to the 'Hyvinvointialueet' which translates to 'Wellbeing Areas' at a scale of 1:4 500 000. It is a part of a larger dataset collection focusing on wellbeing areas. This table carries a set of columns showcasing various types of data.
Two of these columns, '_extract_date' and '_row_number', are used to provide unique identification for each row. The '_extract_date' indicates the date when the data was extracted, while the '_row_number' assigns a unique number to each row of data from the source on the specified extract date.
Several columns in this table provide geographic information and are prefixed with 'geom_'. These columns include 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The data in these columns can be used for geospatial data analytics. 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 columns that provide information about the wellbeing area including its ID 'hyvinvointialue', and its name in different languages 'name', 'namn', and 'nimi'. Another column, 'vuosi', indicates the year of the data.
This data could be used in a variety of ways in data analytics. For instance, analyzing the geographic information could provide insights into spatial patterns or trends across different wellbeing areas. The temporal data could be utilized to track changes over time. Moreover, language-specific names can be used for localization in multilingual studies or applications.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. It is one of the special columns in the table and helps in identifying the time of data extraction. |
| _row_number | long | This special column contains the row number of the data extracted from the source. Together with '_extract_date', it uniquely identifies each row in the table. |
| geom_geojson | string | This column contains geometric data in GeoJSON format. This data represents the geographic boundaries of the well-being areas. |
| geom_geotext | string | This column features geometric data in text format. Similar to 'geom_geojson', it represents the geographic boundaries of the well-being areas. |
| geom_type | string | This column indicates the type of geometric data represented in the 'geom_geojson' and 'geom_geotext' columns, such as multipolygon or polygon. |
| geom_centroid | string | This column contains the geographic point that represents the centroid or the geometric center of the well-being area. |
| geom_center_x | double | This column represents the X-coordinate of the geometric center of the well-being area. |
| geom_center_y | double | This column represents the Y-coordinate of the geometric center of the well-being area. |
| gml_id | string | This column contains a unique identifier for each well-being area. It is a string value. |
| hyvinvointialue | string | This column contains the identifier for the well-being area. It is a string value. |
| name | string | This column holds 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 features the name of the well-being area in Finnish. |
| vuosi | long | This column records the year of the data. It is an integer value. |
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 | 19e838d1-fd18-42a4-995d-d194ef619a61 |
| Package id | 1df4ead1-00f6-47c0-8a8e-19b12bc5e645 |
| Revision id | ebc7179c-a865-4a80-9e21-a1bf4dbbb2d4 |
| State | active |
| Table | tilastointialueet_hyvinvointialue4500k__table |