Welfare Areas 2024 (Scale 1:4,500,000) - Data Table
The table, part of the dataset collection titled 'tilastointialueet_hyvinvointialue4500k_2024', is a rich source of geographic and wellbeing information projected for the year 2024. It presents a comprehensive view of wellbeing areas in Finland, sourced from the 'Tilastokeskus' (Statistics Finland) website. The table contains a variety of columns, each offering unique insights into the areas studied.
For instance, the columns starting with 'geom_' provide geographic data, useful for geospatial analytics. These columns offer information such as the type of geographic shape, the geojson and geotext data, and the center coordinates of the areas. It's important to note that 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 includes columns like 'name', 'namn', and 'nimi' which provide the names of the wellbeing areas in different languages, while the 'hyvinvointialue' column provides a specific code for each area. The 'gml_id' column offers a unique ID for each entry.
Two special columns, '_extract_date' and '_row_number', serve to uniquely identify each row, with the former indicating the date when the data was extracted and the latter specifying the row number in the extracted data.
Given the depth and breadth of data in this table, it can be used in a variety of data analytics applications. For example, the geographic data could be used to create detailed maps showing the distribution of wellbeing areas across Finland. The data could also serve as a basis for trend analysis over time, given the extract dates included. Moreover, multilingual area names could be utilized for research involving cross-language comparisons and international collaboration.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column contains the date when the data on the row was extracted from the data source. It plays a key role in uniquely identifying each row in conjunction with the '_row_number' column. |
_row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It is a crucial component in uniquely identifying each row. |
geom_geojson | string | This column holds geometric data in GeoJSON format, a widely-used format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains geometrical data in text format. |
geom_type | string | This column specifies the type of the geometric data stored in the table, such as 'ST_POLYGON' indicating that the geometric data forms a polygon. |
geom_centroid | string | This column holds the centroid of the geometric figure. The centroid is a point representing the center of the geometric figure. |
geom_center_x | double | This column contains the X-coordinate of the center point of the geometric figure. |
geom_center_y | double | This column contains the Y-coordinate of the center point of the geometric figure. |
gml_id | string | This is a string type column which presumably holds a unique identifier for each row. |
hyvinvointialue | string | This column is of type string, however, the specific content is not clarified in the provided information. |
name | string | This column contains names of entities or areas in English. |
namn | string | This column contains names of entities or areas in another language, presumably Finnish or Swedish. |
nimi | string | This column contains names of entities or areas in another language, presumably Finnish. |
vuosi | long | This column is of type integer and it seemingly holds year-related information. |
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 | e3dddb74-16a7-419e-b997-f7966b0ae519 |
Package id | 014b5b0a-1dea-4b66-9f1f-fd88b925e10b |
Revision id | e8100910-0876-411f-90c3-37a3b1493ede |
State | active |
Table | tilastointialueet_hyvinvointialue4500k_2024__table |