Municipalities 2024 Statistics (1:1 000 000) - Dataset Table
The table in question is a rich data collection pertaining to the municipalities in Finland for the year 2024. It is sourced from the Finnish statistical agency, 'Tilastokeskus' (Statistics Finland). It consists of a variety of columns, each containing vital data that can be used for various forms of data analytics.
The columns include a unique identifier for each municipality, their name in different languages, and the year of the data. The table also contains intricate geometric data representing the geographic location and shape of each municipality. This includes the type of geometric representation used, as well as the centroid and center coordinates of the geographic shape. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude, making the data readily usable for geospatial analytics.
A special feature of this table is the inclusion of two columns: one indicating the date the data was extracted, and the other specifying the row number in the data extracted from the source on the extract date. These two columns together uniquely identify each row, providing a clear and organized structure for the data.
The data in this table could be utilized in various ways. For instance, the geographic data could be used to create detailed maps, visualize spatial patterns, or analyze geographic relationships. The extraction date could be used to track changes over time or verify the freshness of the data. The multilingual municipality names could be useful in international studies or localization efforts. Overall, this table provides a robust dataset for a range of analytical applications.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column indicates the date when the data in the row was extracted from the source. |
_row_number | long | This column contains the row number within the dataset that was extracted on the specific '_extract_date'. The combination of '_extract_date' and '_row_number' provides a unique identifier for each row. |
geom_geojson | string | This geojson formatted column contains the geometric representation of the respective municipality in the form of polygons or multipolygons. |
geom_geotext | string | This column contains textual representation of the geometric shape of the respective municipality. |
geom_type | string | This column specifies the type of the geometric shape used to represent the respective municipality. It can be a polygon or multipolygon. |
geom_centroid | string | This column contains the data of the geometric center point of the respective municipality. |
geom_center_x | double | This column represents the x-coordinate of the center point of the respective municipality's geometric shape. |
geom_center_y | double | This column represents the y-coordinate of the center point of the respective municipality's geometric shape. |
gml_id | string | This column provides a unique ID for each row in the table, following the format 'kunta1000k_[year].[row_number]'. |
kunta | string | This column contains the municipality code in string format. |
name | string | This column contains the name of the municipality in Finnish. |
namn | string | This column contains the name of the municipality in Swedish. |
nimi | string | This column contains the name of the municipality in another language, possibly a regional language. |
vuosi | long | This column indicates the year that the data is representative of. |
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 | 56a8a716-1305-4bea-b68b-e62a92aec6ea |
Package id | 4704ec8a-a1c4-49e4-a6ed-59cc0359adbe |
Revision id | d4bf2a32-b0fb-4249-bc5d-764136c5cfcc |
State | active |
Table | tilastointialueet_kunta1000k_2024__table |