Version History of Municipalities 2013 (1:4 500 000)
The table captures historical data pertaining to municipalities in Finland, as sourced from the 'Tilastokeskus' website. It serves as a historical record, tracking the changes in data over time. The information in the table is structured into multiple columns that contain various data points. Each column represents a unique attribute of the data, like dates of data extraction, row numbers, geographic coordinates, and municipality identifiers.
The table's contents include geographical data related to municipalities as of 2013, which can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This data captures the shape and position of the municipalities, including multi-polygonal geographical shapes and their respective centroid points.
The table also includes unique identifiers for each municipality and the respective names. The row numbers serve as unique identifiers for the data within the table, with each row representing a unique version of the data.
The table has two unique columns: the start and end dates. These columns capture the dates when a row was extracted from the source and when a new version of the same row was extracted, respectively. This information helps in understanding the timeline of the data changes, allowing us to track its history.
The data in this table could be utilized in various ways in data analytics. For instance, it could be used to analyze the changes in geographical boundaries of municipalities over time. Researchers could also use the data to study the changes in names or identifiers of municipalities. Moreover, the geographic data could be useful for conducting geospatial analyses related to environmental studies, urban planning, or transportation logistics.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the data row was initially extracted from the data source. This column, in combination with the '_row_number' column, uniquely identifies each row in the history table. |
| _end_date | date | The date when a new version of the data row was extracted from the source. If this column contains a null value, it means that the current row is the most recent version of the data. |
| _row_number | long | The number of the row as it was in the raw data extracted from the source. This column, in combination with the '_start_date' column, uniquely identifies each row in the history table. |
| geom_geojson | string | Contains the geographical data in the GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | Contains the geographical data in textual form. |
| geom_type | string | Identifies the type of the geographical data structure, for example, 'ST_MULTIPOLYGON'. |
| geom_centroid | string | Contains the geographical point that represents the centroid (geometric center) of the geographical data structure. |
| geom_center_x | double | The X coordinate of the center point of the geographical data structure. |
| geom_center_y | double | The Y coordinate of the center point of the geographical data structure. |
| gml_id | string | A unique identifier for each geographical feature in the data set. |
| kunta | string | A code representing a specific municipality in Finland. |
| name | string | The name of the municipality in Finland. |
| namn | string | This is another representation of the name of the municipality, typically in a different local language. |
| nimi | string | This is another representation of the name of the municipality, typically in a different local language. |
| vuosi | long | The year to which the data row 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 | f43d47be-280f-41c3-a344-96a2b590496f |
| Package id | c5f5d897-af19-42f6-b07c-f4ca0ab20c97 |
| Position | 1 |
| Revision id | 99d63677-3497-4469-8767-dbdb73e30b4a |
| State | active |
| Table | tilastointialueet_kunta4500k_2013__table__history |