Wellbeing Areas 2023 (1:4 500 000) - Data Table
Click here for a data sample
The table, sourced from Finland's 'Tilastokeskus' (Statistics Finland), contains data on 'Hyvinvointialueet 2023' (Well-being Areas 2023). It includes various types of columns, each serving a distinct purpose. The special columns 'extract_date' and '_row_number' store the date of data extraction and the row number from the source, respectively, making each row uniquely identifiable. Columns with prefix 'geom' hold geographic information, useful for geospatial data analytics, represented in the WGS 84 coordinate reference system, with longitude first, followed by latitude. The table also includes columns that provide names of the well-being areas in different languages, and a column 'vuosi' indicating the year of the data. This data can be highly beneficial in various data analytic scenarios, such as studying spatial patterns of well-being across Finland, planning resource allocation based on well-being areas, or tracking changes in these areas over time.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column holds the date when data from a row in the table was extracted. It's crucial for data traceability and understanding when the data was recorded. |
|---|
| _row_number | long | This column contains the row number as extracted from the source. It's used in combination with the '_extract_date' to uniquely identify each row in the table. |
|---|
| geom_geojson | string | This column contains the geographic data in GeoJSON format. It represents the geometry of the area in terms of polygons or multipolygons. |
|---|
| geom_geotext | string | Similar to 'geom_geojson', this column holds geographic data, but in text format. It's useful for visualizing and understanding the geographic layout of the area. |
|---|
| geom_type | string | This column indicates the type of the geographic data stored in the 'geom_geojson' and 'geom_geotext' columns. It could be either a polygon or a multipolygon. |
|---|
| geom_centroid | string | This column contains the geographic point data representing the centroid of the area. The centroid is the arithmetic mean position of all the points in the shape. |
|---|
| geom_center_x | double | This column represents the X-coordinate (longitude) of the geometric center of the area. |
|---|
| geom_center_y | double | This column represents the Y-coordinate (latitude) of the geometric center of the area. |
|---|
| gml_id | string | This column contains a unique identifier for each row in the table. |
|---|
| hyvinvointialue | string | This column holds a code that represents a specific area. It's useful for categorizing the data based on geographic regions. |
|---|
| name | string | This column contains the English name of the area. |
|---|
| namn | string | This column contains the name of the area in the Swedish language. |
|---|
| nimi | string | This column contains the name of the area in the Finnish language. |
|---|
| vuosi | long | This column holds the year related to the data row. It's useful for understanding the time context of the data. |
|---|
