Municipalities Projection for 2024 (Scale 1:4,500,000)
Click here for a data sample
The table in question is part of a dataset that encapsulates data related to municipalities as projected for the year 2024 at a scale of 1:4,500,000. This data is sourced from 'Tilastokeskus' (Statistics Finland), a reliable data provider in Finland. The table includes a variety of columns carrying distinct types of data. For instance, it features columns that store geographic data. This geospatial data, represented using the WGS 84 coordinate reference system, could be instrumental in conducting geospatial data analytics. It includes aspects such as 'geojson' and 'geotext' data types, the type of the geographic data, and even the centroid and center coordinates of the geometric shape representing a municipality. In addition to this, the table also accommodates information about the municipalities themselves, with columns for the municipality's code, and its name in different languages. There are also two special columns; '_extract_date' and '_row_number'. These contain the date when the row's data was extracted and the respective row number. Together, these two columns uniquely identify each row in the table. For data analytics, this table could be used in a variety of ways. For instance, it could help in visualizing the geographical distribution of municipalities, in understanding trends and patterns in their development over time, or in comparing linguistic variations in municipality names. The geographic coordinates could also be used for creating heat maps or conducting location-based analysis.
Field Descriptions
Name |
Data type |
Description |
_extract_date | date | The date on which the data in the row was extracted from the source. This, in combination with '_row_number', uniquely identifies each row. |
_row_number | long | The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
geom_geojson | string | The geometric representation of the area in GeoJSON format, which is a popular open standard format designed for representing simple geographical features. |
geom_geotext | string | The geometric representation of the area in text format. |
geom_type | string | The type of geometric shape that represents the area. This could be either a Polygon or MultiPolygon. |
geom_centroid | string | The geographical point that represents the centroid of the area. |
geom_center_x | double | The X-coordinate of the geographical point that represents the center of the area. |
geom_center_y | double | The Y-coordinate of the geographical point that represents the center of the area. |
gml_id | string | An identifier for each row that is unique within the dataset. |
kunta | string | The code that represents the municipality. |
name | string | The name of the municipality in English. |
namn | string | The name of the municipality in Swedish. |
nimi | string | The name of the municipality in Finnish. |
vuosi | long | The year of the data. |