Municipalities 2021 (1:1 000 000) - Table from the Dataset Collection
Click here for a data sample
The table is a component of a dataset collection that focuses on Municipalities in 2021 (1:1 000 000). It is sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The table is rich in data and provides various types of information. Specifically, it contains a unique row identifier and extraction date, enabling efficient tracking and versioning of the data. It also comprises geographic details represented in the WGS 84 coordinate reference system, which is a standard for geospatial data analytics. With this, users can analyze geographic patterns and trends, like identifying clusters of municipalities based on their geographic coordinates. The table also includes names of municipalities in different languages, allowing for multilingual data analysis. Furthermore, it contains a unique identifier for each municipality, which can be used, for instance, to correlate this data with other data sources to enrich the analysis. Overall, this table embodies a valuable resource for statistical and geospatial analysis of Finnish municipalities.
Field Descriptions
Name |
Data type |
Description |
_extract_date | date | This column contains the date when the row's data was extracted from the data source. It helps in identifying the freshness of the data. |
_row_number | long | This column indicates the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It uniquely identifies each row together with '_extract_date'. |
geom_geojson | string | This column holds the geometric shape of the area related to the row in GeoJSON format. It helps in visualizing the spatial data. |
geom_geotext | string | This column contains the geometric shape of the area in text format, which can be useful for non-graphical data processing. |
geom_type | string | This column describes the type of the geometric shape. It can be either a Polygon or a MultiPolygon. |
geom_centroid | string | This column holds the coordinates of the centroid of the geometric shape. It can be used to calculate the center point of the area. |
geom_center_x | double | This column contains the x coordinate of the center of the geometric shape. It's part of the spatial information about the area. |
geom_center_y | double | This column contains the y coordinate of the center of the geometric shape. It's another part of the spatial information about the area. |
gml_id | string | This column holds a unique identifier for each row. It follows the format 'kunta1000k_2021.XX' where XX is a unique number. |
kunta | string | This column contains a unique code for each municipality. It helps in identifying the area related to the row. |
name | string | This column contains the name of the area in English. |
namn | string | This column contains the name of the area in Swedish. |
nimi | string | This column contains the name of the area in Finnish. |
vuosi | long | This column indicates the year when the data was collected. It helps in understanding the temporal context of the data. |