Historical Version Records of the 'Municipalities 2016' Dataset in Geo Boundaries Format
The history table contains a record of changes of its base table. It holds the version history of each row in the base table, documenting the chronological sequence of changes. Each row is uniquely identified by the combination of the date of extraction and the row number from the raw data source. The table includes two additional fields to track the start and end dates of each version of the row. If the end date is null, it indicates the most recent version. Geographic information is stored in various formats, enabling geospatial data analysis. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the longitude appearing before the latitude.
The base table's content, 'Municipalities 2016 (1:1 000 000)', provides information about the municipalities in Finland, as sourced from 'Tilastokeskus' (Statistics Finland). This includes the name of the municipality in different languages and the year of the data record.
The data in this table can be used in various ways for data analytics. For instance, it can be used to track changes in geographic boundaries of municipalities over time, or to perform geospatial analyses to understand patterns and trends. Additionally, the language variations of municipality names can be used in multilingual data applications.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. This is one of the additional columns in this version history table compared to its base table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it means that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
| geom_geojson | string | This column contains the geographical data of the row in GeoJSON format. |
| geom_geotext | string | This column contains the geographical data of the row in Geotext format. |
| geom_type | string | This column describes the type of the geographical data. |
| geom_centroid | string | This column contains the centroid of the geographical data. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical data. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical data. |
| gml_id | string | This column contains the ID of the row in GML format. |
| kunta | string | This column contains a string value. |
| name | string | This column contains a string value. |
| namn | string | This column contains a string value. |
| nimi | string | This column contains a string value. |
| vuosi | double | This column contains a real number value. |
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 | b8bf5b20-1a34-4d76-992d-f17f067294a3 |
| Package id | dbd5549f-bbb4-49cf-ad97-a418d0624887 |
| Position | 1 |
| Revision id | 42a8b9e7-dc37-4468-ad9d-1ea391f1b37a |
| State | active |
| Table | tilastointialueet_kunta1000k_2016__table__history |