Municipalities 2019 (Scale 1:4 500 000) from Dataset Collection 'tilastointialueet_kunta4500k_2019'
Click here for a data sample
The table is a part of a larger dataset collection that focuses on municipal data from 2019 on a scale of 1:4,500,000. This data, sourced from 'Tilastokeskus' (Statistics Finland), provides a unique insight into the geographic and demographical landscape of Finland. The table incorporates a wide range of data, all of which can be utilized for different data analytics tasks. For instance, the geographic information contained in columns starting with 'geom_' can be used for geospatial data analytics, with coordinates presented using the WGS 84 reference system. This includes longitude first, followed by latitude. Furthermore, the table includes a pair of special columns, '_extract_date' and '_row_number', which offer detailed information about the extraction process of the data. The '_extract_date' indicates the date when the data was pulled from the source, while '_row_number' gives the specific row number in the extracted data. These columns can be used to track the extraction process and uniquely identify each row. Other valuable data includes various names of municipalities and their codes, which can be used for demographic studies, urban planning, or public service distribution analysis, to name a few examples. The table provides a comprehensive and detailed resource for anyone interested in Finnish geography or demographics.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column records the date when the data on the row was extracted from the source. This can be useful for tracking when changes or updates were made to the data. |
|---|
| _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 serves as a unique identifier for each row. |
|---|
| geom_geojson | string | This column contains geographical data in the GeoJSON format, which is a format for encoding geographic data structures. |
|---|
| geom_geotext | string | This column contains geographical data in text format. It is similar to the 'geom_geojson' column, but the data is represented as text. |
|---|
| geom_type | string | This column indicates the type of geometry represented in the 'geom_geojson' and 'geom_geotext' columns. In the given sample, the type of geometry is 'ST_MULTIPOLYGON', which represents a shape formed by multiple polygons. |
|---|
| geom_centroid | string | This column records the geographical centroid of the geometry represented in the 'geom_geojson' and 'geom_geotext' columns. The centroid is the geographical center point of the shape. |
|---|
| geom_center_x | double | This column records the x-coordinate of the geographical center of the geometry represented in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_center_y | double | This column records the y-coordinate of the geographical center of the geometry represented in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| gml_id | string | This column contains a unique identifier for the geographical data in the row. The identifier is in the form of a string. |
|---|
| kunta | string | This column contains a string-based identifier for a municipality in Finland. |
|---|
| name | string | This column contains the English name of the municipality represented in the row. |
|---|
| namn | string | This column contains the Swedish name of the municipality represented in the row. |
|---|
| nimi | string | This column contains the Finnish name of the municipality represented in the row. |
|---|
| vuosi | long | This column contains the year of the data. It is a numerical value in the format of 'Integer64'. |
|---|
