Municipalities 2018 (Scale 1:4,500,000)
The table under consideration is a part of an extensive dataset collection, which compiles related tables. This particular table focuses on the 'Municipalities 2018' data, offering a detailed view at the scale of 1:4 500 000. The table is sourced from the website of 'Tilastokeskus' in Finland. It holds unique geographic information, useful for geospatial data analytics, presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The data covers various aspects, including names of the municipalities in different languages, the year the data corresponds to, and unique identifiers for municipalities.
Special columns such as '_extract_date' and '_row_number' add an extra layer of specificity. The former provides the date when the data on the row of the table was extracted, and the latter provides the row number in the data extracted on the specified extract date. The combination of these two columns uniquely identifies each row.
This table can be a valuable resource for a variety of data analytics applications. For instance, urban planners and geographers could use it to study the spatial distribution of municipalities and their characteristics. It could also be used in socio-economic research to understand trends and patterns across different municipalities. Demographers could use it to analyze population trends, while marketers could use it to target specific municipalities based on their unique identifiers. The possibilities are vast and varied.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date on which the data for that particular row was extracted from the source. It plays a crucial role in uniquely identifying each row in combination with the '_row_number' column. |
| _row_number | long | This column contains the row number of the data extracted from the source on the extract date specified by the '_extract_date' column. It plays a vital role in uniquely identifying each row in combination with the '_extract_date' column. |
| geom_geojson | string | This column contains the geometric data in GeoJSON format. It provides the geographic representation of the data points. |
| geom_geotext | string | This column contains the geometric data in text format. It provides a textual representation of the geometric shape. |
| geom_type | string | This column specifies the type of the geometric shape of the data points. For example, the sample shows 'ST_MULTIPOLYGON' which indicates that the geographic representation is of a type called 'multipolygon'. |
| geom_centroid | string | This column contains the centroid point of the geometric shape. It can be used to find the center point of the geographic representation. |
| geom_center_x | double | This column records the X-coordinate of the geographic center point of the geometric shape. |
| geom_center_y | double | This column represents the Y-coordinate of the geographic center point of the geometric shape. |
| gml_id | string | This column contains the unique identifier for each row of data. The naming convention seems to include the dataset name and the row number. |
| kunta | string | This string-type column represents a specific attribute of the data, which could possibly relate to a region or administrative division. |
| name | string | This string-type column contains the English names of the entities represented in the dataset. |
| namn | string | This string-type column contains the names of the entities represented in the dataset, possibly in another language. |
| nimi | string | This column contains the names of the entities represented in the dataset. The language used for these names could be different from the 'name' and 'namn' columns. |
| vuosi | long | This integer-type column represents the year associated with each row of data. For example, the sample data indicates the year 2018. |
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 | e4e17b49-fb8d-416d-933c-f3fef6260f4d |
| Package id | 812721d2-1636-47bb-9a91-d02cfd9050a5 |
| Revision id | b4ab0aa4-4f5f-48db-b890-19996d72d915 |
| State | active |
| Table | tilastointialueet_kunta4500k_2018__table |