Municipalities 2022 (1:4 500 000) - Data Table
Click here for a data sample
The table is a component of a dataset collection which encapsulates a wealth of data pertaining to the municipalities in Finland for the year 2022, at a scale of 1:4 500 000. The information is sourced from the Finnish statistical agency, 'Tilastokeskus'. The table encapsulates a wealth of geographical data, as well as information regarding the municipalities, with data points such as the name of the municipality in multiple languages. Each row of data in the table is uniquely identified by a combination of the date of extraction and the row number in the original data source. Special emphasis is placed on geographical data, with several columns dedicated to the geographical coordinates and types of geographical features. These geographic data are presented using the WGS 84 coordinate reference system, with longitude listed first, followed by latitude. This table could be utilized for various data analytics purposes, such as geospatial analysis of the municipalities, tracking changes in the municipalities over time by comparing data from different extraction dates, or even linguistic analysis of the different names of the municipalities.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column stores the date when the data on the row was extracted from the source. It is one of the special columns in this table. |
|---|
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It is the other special column in this table. |
|---|
| geom_geojson | string | This column stores the geometry of the area represented as a GEOJSON object. |
|---|
| geom_geotext | string | This column stores the geometry of the area represented as a textual string. |
|---|
| geom_type | string | This column specifies the type of the geometry used to represent the area. |
|---|
| geom_centroid | string | This column contains the centroid of the area represented by the geometry in the form of a point. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the center of the geometrical area. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the center of the geometrical area. |
|---|
| gml_id | string | This column contains unique identifiers for each row in the table. |
|---|
| kunta | string | This column stores an identifier for the municipality. |
|---|
| name | string | This column contains the English name of the municipality. |
|---|
| namn | string | This column contains the Swedish name of the municipality. |
|---|
| nimi | string | This column contains the Finnish name of the municipality. |
|---|
| vuosi | long | This column contains the year of the data. |
|---|
