Municipalities 2020 (Scale 1:4,500,000) - Dataset Table
Click here for a data sample
The table, which is a part of a larger dataset collection, contains information about different municipalities in Finland. The data is sourced from the 'Tilastokeskus' website, also known as the Statistic Centre of Finland. The table represents data related to the year 2020, showcasing each municipality's unique identifier, name, and geographical data. This geographical data includes various forms of presentation, such as GeoJSON, Geotext, and centroid points, all represented using the WGS 84 coordinate reference system. Each row in the table is uniquely identified by an extract date and a row number, marking when the specific data was extracted from the source. This table can be highly useful in data analytics, especially in spatial analysis. For instance, it can provide insights into population distribution across different municipalities, or it can be used to visualize geographical data for analytical or presentation purposes. This can be instrumental in planning infrastructure or public services, studying patterns of urbanization, and conducting various socio-economic studies.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column captures the date when the data row was extracted from the source. It plays a crucial role in identifying each row uniquely in combination with the '_row_number' column. |
|---|
| _row_number | long | This column represents the row number in the data extracted from the source. Along with '_extract_date', it helps in unique identification of each row. |
|---|
| geom_geojson | string | This column contains geometric data in GeoJSON format, which is a format for encoding geographic data structures. |
|---|
| geom_geotext | string | This column stores geometric data as text. It complements the 'geom_geojson' column by providing a textual representation of geographical data. |
|---|
| geom_type | string | This column specifies the type of geometric shape represented by the data in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_centroid | string | This column provides the centroid of the geometric shape represented in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_center_x | double | This column contains the x coordinate of the geometric shape's center, providing a more precise location reference. |
|---|
| geom_center_y | double | This column contains the y coordinate of the geometric shape's center, complementing the 'geom_center_x' column. |
|---|
| gml_id | string | This column contains an identifier for the row. The identifier is unique to the dataset and is used for reference and indexing purposes. |
|---|
| kunta | string | This column contains a string representation of the municipality code. |
|---|
| name | string | This column holds the name of the municipality in English. |
|---|
| namn | string | This column holds the name of the municipality in a different language, possibly local or regional. |
|---|
| nimi | string | This column holds another version of the municipality name. The difference between 'name', 'namn', and 'nimi' could be due to regional language variations. |
|---|
| vuosi | long | This column contains an integer representing the year associated with the row data. |
|---|
