Municipalities 2019 (1:1 000 000) - Geographical Data Collection
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_date | date | This column contains the date when the data row was extracted from the data source. |
_row_number | long | This 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_geojson | string | This column stores geometric data in GeoJSON format, representing the geographical features of the area. |
geom_geotext | string | This column contains geometric data in text format, representing geographical features of the area. |
geom_type | string | This 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_centroid | string | This column contains the central point of the geographical feature represented by the geometric data in the 'geom_geojson' and 'geom_geotext' columns. |
geom_center_x | double | This column represents the x-coordinate of the center of the geographical feature. |
geom_center_y | double | This column represents the y-coordinate of the center of the geographical feature. |
gml_id | string | This is a unique identifier for each row of data. |
kunta | string | This column represents the municipality code 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. |
vuosi | long | This 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 | |
Country | fi |
Database | fi_tilastokeskus |
Extract date | 2024-11-11 |
Id | 27c82a69-4f54-4c3e-a4ca-0197b58d0f0f |
Package id | 3482fcef-71dd-47d1-9f11-cfb226088d92 |
Revision id | 9de9a069-5d49-4502-95d9-f6d60bdfd977 |
State | active |
Table | tilastointialueet_kunta1000k_2019__table |