Municipalities of 2016 (Scale 1:1,000,000) - Data Table
This table, part of a dataset from Finland's Statistical Bureau (Tilastokeskus), is a rich source of geospatial data. It presents information about Finnish municipalities in 2016. Each row corresponds to a unique data extraction, identified by a combination of extraction date and row number. This allows for tracking of data evolution over time.
The table contains multiple geographical information columns, beginning with 'geom_', which can be utilized for geospatial data analytics. These include geometric types, centroids, and center coordinates, all expressed using the WGS 84 coordinate reference system, with longitude first, followed by latitude.
The 'kunta' column contains unique identifiers for each municipality. The names of these municipalities are provided in multiple languages, including Finnish ('nimi'), Swedish ('namn'), and English ('name'). This multilingual approach allows for wide accessibility and usability of the data.
The 'vuosi' column indicates the year of the data, in this case, 2016.
Data from this table can be utilized in multiple ways in data analytics. For example, the geospatial data can be used to map the municipalities, visualize their boundaries, and identify their geographic centroids. The multilingual names can be used to integrate this data with other datasets in different languages. The unique identifiers can be used to track changes in the municipalities over time, such as changes in size, population, or other demographic factors.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column represents the date when the data on the row was extracted from the source. It is a special column that helps identify when the data was pulled. |
_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'. This is a special column that when combined with '_extract_date', helps to uniquely identify each row. |
geom_geojson | string | This column contains GeoJSON formatted geographical data which represents various geographical features with their non-spatial attributes. |
geom_geotext | string | This column contains geographic data in text format. It represents the same data as in the 'geom_geojson' column but in a different format. |
geom_type | string | This column specifies the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. The sample value 'ST_MULTIPOLYGON' suggests that the data represents multiple polygonal areas. |
geom_centroid | string | This column contains points representing the geometric central point of the geographical feature(s). |
geom_center_x | double | This column represents the x-coordinate of the central point of the geographical feature(s). |
geom_center_y | double | This column represents the y-coordinate of the central point of the geographical feature(s). |
gml_id | string | This column contains a unique identifier for each row, following a specific naming convention that includes the dataset collection name and the row number. |
kunta | string | This column contains string type data. The exact meaning of the data is not provided by the source. |
name | string | This column contains string type data. Based on the sample values, it appears to represent names of geographical areas or entities. |
namn | string | This column contains string type data, likely representing names of geographical areas or entities in a different language. |
nimi | string | This column contains string type data. Similar to 'name' and 'namn', it seems to represent names of geographical areas or entities in yet another language. |
vuosi | double | This column contains real type data. The exact nature of the data is not specified by the source. However, based on the column name 'vuosi' (year in Finnish) and the sample values, it appears to represent years. |
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 | f8f7531b-0e7b-47fd-9905-8fe2e70011c1 |
Package id | dbd5549f-bbb4-49cf-ad97-a418d0624887 |
Revision id | 2585a625-7096-4a94-b182-fed3d76cfde7 |
State | active |
Table | tilastointialueet_kunta1000k_2016__table |