Municipalities at 1:4,500,000 Scale
The table belongs to a dataset collection, and it contains data on Municipalities at a detailed scale of 1:4,500,000. Originating from the website of Statistics Finland ('Tilastokeskus'), the table features several columns that carry valuable information. Two special columns in this table are '_extract_date' and '_row_number', which contain the date when the data was extracted and the corresponding row number in the data extracted on that particular date, providing a unique identifier for each row.
The table also contains multiple 'geom_' columns, which hold geographic information useful for geospatial data analytics. For instance, 'geom_geojson' contains Geographical JSON data, 'geom_geotext' and 'geom_centroid' provide geographical text and centroid points, and 'geom_center_x' and 'geom_center_y' display the geographical center coordinates. All these geographic coordinates are presented using the WGS 84 coordinate reference system, with longitude listed first, followed by latitude.
Other columns such as 'gml_id', 'kunta', 'name', 'namn', 'nimi', and 'vuosi' offer specific details about each municipality, including its unique ID, municipality code, and names in different languages, alongside the year of data extraction.
This table can serve as a rich resource for data analytics. For instance, the geospatial data can be used to map the municipalities of Finland, track changes over time, or analyze spatial patterns and correlations. The '_extract_date' and '_row_number' can be useful in tracking data extraction workflows and ensuring data integrity.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column records the date when the data on the specific row was extracted from the source. It allows tracking of the data extraction timeline. |
| _row_number | long | This column contains the row number in the data extracted from the source. Along with the '_extract_date', it uniquely identifies each row. |
| geom_geojson | string | This column contains geographical data in GeoJSON format. It might include details such as coordinates and polygons representing geographical regions. |
| geom_geotext | string | This column contains geographical data in plain text format. It is a textual representation of geographical shapes and coordinates. |
| geom_type | string | This column describes the type of the geographical data stored in the table. |
| geom_centroid | string | This column contains the centroid of the geographical data. The centroid is the central point of a region represented by geographical data. |
| geom_center_x | double | This column represents the x-coordinate of the center point of the geographical region. |
| geom_center_y | double | This column represents the y-coordinate of the center point of the geographical region. |
| gml_id | string | This column contains unique identifications assigned to each row. |
| kunta | string | This column contains string values. As the specific description is not provided, it might represent an identifier or a category of the data. |
| name | string | This column contains string values, possibly representing names related to each row's data. |
| namn | string | This column contains string values. It seems to contain similar information as the 'name' column, possibly in a different language or representing a different aspect of the data. |
| nimi | string | This column contains string values. It seems to contain similar information as the 'name' and 'namn' columns, possibly in a different language or representing a different aspect of the data. |
| vuosi | long | This column contains integer values, possibly representing a year associated with each row's data. |
No sample for this dataset
Additional Information
| Last updated | January 2, 2025 |
|---|---|
| Created | January 2, 2025 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2025-01-02 |
| Id | 50af62fa-d449-4af3-9e2c-48a37df28e07 |
| Package id | 98d301a9-da2a-4c32-9071-f0263b6d101e |
| Revision id | 276a3f31-7072-410b-a343-b1aa4631b1c6 |
| State | active |
| Table | tilastointialueet_kunta4500k__table |