Municipalities 2015 (1:4 500 000) - Dataset Table
The table is a rich source of geospatial data related to the municipalities of Finland, as sourced from the Finnish statistical authority, Tilastokeskus. The data represents the key attributes of each municipality in the year 2015, at a scale of 1:4,500,000. The table is a part of a larger collection of tables, indicating its connection with other related data.
The contents of the table are organized into several columns, each carrying unique and valuable information. Two of these columns, '_extract_date' and '_row_number', serve a special function. The '_extract_date' column holds the date on which each unique row of data was extracted, while the '_row_number' provides the specific row number within the data extracted on a specific date. Together, these columns uniquely identify each row of data in the table.
The table also includes numerous columns that contain geographical data, identifiable by the 'geom_' prefix in their names. This data includes various types of geographical representations and coordinates, all of which use the WGS 84 coordinate reference system, with the longitude listed before the latitude. This information can be utilized for geospatial data analytics, providing a detailed understanding of the geographic layout and characteristics of each municipality.
In addition to these geographical details, the table also contains columns providing the names of the municipalities in various languages and their unique identifiers. These can be used for analyzing regional patterns or trends.
The data in this table can be utilized in various ways. For example, it could serve as a basis for mapping the municipalities of Finland, or for studying the geographic distribution of certain phenomena across the country. The geographic data could also be used to analyze spatial relationships between different municipalities or to study patterns and trends over time, utilizing the '_extract_date' and '_row_number' for tracking changes.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. It helps to trace the data extraction history. |
| _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 provides a unique identifier for each row in combination with '_extract_date'. |
| geom_geojson | string | This column contains the geographical data in GeoJSON format. It represents the multipolygonal shapes of the geographical areas. |
| geom_geotext | string | This column represents the geographical data as text. It is another representation of the geographical areas akin to 'geom_geojson'. |
| geom_type | string | This column indicates the type of the geographical data, which in this table is 'ST_MULTIPOLYGON', representing multipolygonal shapes. |
| geom_centroid | string | This column contains the centroid of the geographical area. It is the geometric center point of the area. |
| geom_center_x | double | This column contains the X coordinate of the center of the geographical area. It is part of the geometric description of the area. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geographical area. It is part of the geometric description of the area. |
| gml_id | string | This is an identification column for the geographical markup language data. |
| kunta | string | This column contains a unique string identifier for each municipality in the dataset. |
| name | string | This column contains the English name of the municipality. |
| namn | string | This column contains the local name of the municipality. |
| nimi | string | This column contains another local name of the municipality. |
| shape_star | double | This column contains the star shape data of the geographical area. It's a numerical representation of the shape. |
| shape_stle | double | This column contains the style shape data of the geographical area. It's another numerical representation of the shape. |
| vuosi | double | This column contains the year data. It refers to the year the data of the row was collected or refers to. |
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 | b2fb1881-1985-4a4a-a199-33f4e40d27da |
| Package id | 6f138404-2fb1-4b72-bbf0-83b27187a506 |
| Revision id | e2bf90e3-3897-4a6f-9335-9ee2bf6b8d83 |
| State | active |
| Table | tilastointialueet_kunta4500k_2015__table |