Municipalities 2018 (1:1 000 000) Data Table
Click here for a data sample
The table, sourced from the 'Tilastokeskus' website based in Finland, presents a detailed dataset on the municipalities as of 2018. The data includes diverse types of information, from unique extraction dates and row numbers to geographical data and specific details about each municipality. For instance, the table houses data regarding the geographical layout of the municipalities represented in geojson and geotext formats; it also includes the geographical center points and the type of geographical shape of each municipality. These geographical coordinates are presented using the WGS 84 coordinate reference system, signifying the order of longitude first, followed by latitude. The table further details unique identifiers and names of the municipalities in different languages, and the year the data was recorded. The table's unique feature is the ability to identify each row uniquely through a combination of the extraction date and the row number. This dataset could be particularly useful in geospatial data analytics to study the geographical layout and distribution of municipalities in Finland or to track changes in these municipalities over time. Moreover, the language-specific data could be utilized to create multilingual interfaces for applications that provide municipality related information.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column records the date when the data on the row of the table was extracted from the source. The format of the date is YYYY-MM-DD. |
|---|
| _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'. |
|---|
| geom_geojson | string | This column stores the geometric data in GeoJSON format, representing the geographical boundaries of the respective area. |
|---|
| geom_geotext | string | This column contains the geographical data in text format. It provides details about the geographical shape of the area. |
|---|
| geom_type | string | This column specifies the type of the geographical data. In this dataset, the geographical data type is 'ST_MULTIPOLYGON', indicating that the geographical data is a set of polygons. |
|---|
| geom_centroid | string | This column contains the centroid of the geographical data. The centroid is the geometric center of the area. |
|---|
| geom_center_x | double | This column records the x-coordinate of the center of the geographical area. |
|---|
| geom_center_y | double | This column records the y-coordinate of the center of the geographical area. |
|---|
| gml_id | string | This string column is a unique identifier for each row in the table. |
|---|
| kunta | string | This string column contains codes representing different municipalities in Finland. |
|---|
| name | string | This string column contains the names of the municipalities in English. |
|---|
| namn | string | This string column contains the names of the municipalities in Swedish, one of the official languages of Finland. |
|---|
| nimi | string | This string column contains the names of the municipalities in Finnish, the other official language of Finland. |
|---|
| vuosi | long | This integer column represents the year for which the data is recorded. |
|---|
