Municipalities 2015 (1:1 000 000) Dataset Table
The table in discussion, part of a specific dataset collection, houses a well-organized set of data regarding municipalities as of 2015 in a very detailed format. It is sourced from 'Tilastokeskus' (Statistics Finland), a Finnish website. The data is represented in columns and rows, wherein each row signifies a unique set of data, and each column represents a specific aspect or attribute of that data.
The table incorporates various geographical data, which can be highly valuable for geospatial data analytics. It includes columns that represent geographic information in various formats such as GeoJSON and GeoText, and even the type of geometry. It also provides the centroid coordinates and the X and Y coordinates of the geometric center. These coordinates are represented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
Several other columns contain information about the municipality, including its name in various languages, and specific identifiers. You'll also find columns that represent the shape of the municipality, which could be useful for spatial analysis or data visualization.
Two special columns, namely '_extract_date' and '_row_number', play a crucial role in uniquely identifying each record. The '_extract_date' specifies when the data for a particular row was extracted, while '_row_number' denotes the row's position in the data extracted on that date.
The data contained within this table can be utilized in various ways. For instance, it can assist in understanding spatial relationships and patterns, planning infrastructure or resources in specific municipalities, or even studying socio-economic aspects when combined with other relevant data. Furthermore, the precise date of data extraction can help in tracking changes over time, thereby enabling trend analyses or predictive modeling.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column contains the date when the data on the row was extracted from the source. This, together with '_row_number', uniquely identifies each row. |
_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'. This, together with '_extract_date', uniquely identifies each row. |
geom_geojson | string | This column contains the geographical data in GeoJSON format, a format for encoding geographic data structures. |
geom_geotext | string | This column contains the geographical data in text format that describes the geospatial topology. |
geom_type | string | This column specifies the type of the geographical data, which is 'ST_MULTIPOLYGON', indicating that the data represents a collection of polygons. |
geom_centroid | string | This column contains the geographical coordinates of the centroid for the geographical area represented by the row. |
geom_center_x | double | This column contains the x-coordinate of the center point of the geographical area represented by the row. |
geom_center_y | double | This column contains the y-coordinate of the center point of the geographical area represented by the row. |
gml_id | string | This column contains a unique identifier for each row. The identifiers have the format 'kunta1000k_2015.XXX'. |
kunta | string | This column contains a numerical code that represents different municipalities in Finland. |
name | string | This column contains the name of the municipality in English. |
namn | string | This column contains the name of the municipality in Swedish. |
nimi | string | This column contains the name of the municipality in Finnish. |
shape_star | double | This column contains numerical values which may represent the area of the municipal region in square meters. |
shape_stle | double | This column contains numerical values which may represent the perimeter of the municipal region in meters. |
vuosi | double | This column contains the year the data was recorded, which is 2015 in this dataset. |
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 | e30a36d1-070b-459b-bae6-ab164f24a53c |
Package id | 2915e2c9-fdd1-481f-8ae7-e4e4bd9e6fdf |
Revision id | 9b050318-36b5-4d3c-8840-ba02b88c2db3 |
State | active |
Table | tilastointialueet_kunta1000k_2015__table |