Municipalities 2019 (1:1 000 000) - Geographical Data Collection

To download the data set, please sign up or log in

Click here for a data sample

The table under consideration is a collection of related data that forms part of a larger dataset, specifically 'tilastointialueet_kunta1000k_2019'. This table is of particular interest for its focus on municipalities in 2019, as translated from the original Finnish description, 'Kunnat 2019 (1:1 000 000)'. Sourced from the Finnish web site 'Tilastokeskus' (Statistics Finland), the table provides a wealth of data ripe for analysis.

One of the main features of this table is its geographical data, as evidenced by several columns beginning with 'geom_'. These columns contain various types of geographic information, making the table a valuable resource for geospatial data analytics. The geographic coordinates are presented in the WGS 84 coordinate reference system, with longitude listed first, followed by latitude. This level of detail can facilitate a range of studies, from tracking population movements to planning public services or infrastructure within municipalities.

In addition to geographic data, the table also includes other noteworthy columns such as '_extract_date' and '_row_number'. The '_extract_date' column indicates the date when the data on a row was extracted, while the '_row_number' corresponds to the row number from the extracted data. These two columns together provide a unique identifier for each row, enhancing the data's traceability and reliability.

Furthermore, the table includes columns that contain details such as names, identifiers, and years, offering deeper insights into each municipality. For instance, data analytics could be used to compare and contrast different municipalities based on various parameters, or to track changes over time.

In conclusion, this table is a robust data source that can significantly contribute to a multitude of data analytics projects, particularly those involving geospatial analysis and municipal studies.

Field Descriptions

Name Data type Description
_extract_datedateThis column contains the date when the data row was extracted from the data source.
_row_numberlongThis column contains the row number in the data extracted from the source on a specific extract date. Together with '_extract_date', it uniquely identifies each row.
geom_geojsonstringThis column stores geometric data in GeoJSON format, representing the geographical features of the area.
geom_geotextstringThis column contains geometric data in text format, representing geographical features of the area.
geom_typestringThis column describes the type of geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. For example, it may indicate that the geometric data represents a multipolygon.
geom_centroidstringThis column contains the central point of the geographical feature represented by the geometric data in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_xdoubleThis column represents the x-coordinate of the center of the geographical feature.
geom_center_ydoubleThis column represents the y-coordinate of the center of the geographical feature.
gml_idstringThis is a unique identifier for each row of data.
kuntastringThis column represents the municipality code in Finland.
namestringThis column contains the name of the municipality in English.
namnstringThis column contains the name of the municipality in Swedish.
nimistringThis column contains the name of the municipality in Finnish.
vuosilongThis column indicates the year for which the data is relevant.

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
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Id27c82a69-4f54-4c3e-a4ca-0197b58d0f0f
Package id3482fcef-71dd-47d1-9f11-cfb226088d92
Revision id9de9a069-5d49-4502-95d9-f6d60bdfd977
Stateactive
Tabletilastointialueet_kunta1000k_2019__table