Version History of Municipalities 2017 (1:1 000 000) Table
The 'table__history' is a comprehensive chronicle of historical data that forms part of the 'tilastointialueet_kunta1000k_2017' dataset collection. This data is sourced from 'Tilastokeskus' (Statistics Finland), which provides valuable insights on Finnish municipalities in 2017, with a scale of 1:1 000 000.
The table houses a rich array of information which includes geospatial data, municipal details, and version history. One of the unique aspects of this table is its geospatial data, which is presented using the WGS 84 coordinate reference system, with the axis order being longitude followed by latitude. This data can be utilized for in-depth geospatial analytics, allowing for the precise location and geographical characteristics of Finnish municipalities to be analyzed.
In addition to geospatial data, the table also houses detailed municipal data. This includes the unique ID of each municipality, their names in different languages, and the year of data collection. The 'table__history' also keeps track of the version history of its base table rows, offering a detailed timeline of the data extraction process. This is made possible through two additional columns that record the date the row was extracted and if applicable, the date a new version was extracted. The row number, coupled with the start date, form a unique identifier for each row in this table.
In terms of data analytics, the 'table__history' offers a wealth of opportunities. For instance, geospatial data analytics could be used to identify patterns or trends in the geographical distribution of municipalities in Finland. The version history data can be used to track changes over time, which could be crucial in studying temporal trends or changes in the municipal data. Lastly, the detailed municipal data can be used to conduct comparative analysis between different municipalities, which could be useful for policy making or urban planning purposes.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source. A null value means that the row is the most recent version. |
| _row_number | long | The number of the row in the raw data extracted from the source. It forms a unique identifier for each row when combined with '_start_date'. |
| geom_geojson | string | The geographical data of the region in GeoJSON format. |
| geom_geotext | string | The geographical data of the region in text format. |
| geom_type | string | The type of geographical data stored. |
| geom_centroid | string | The geographical point that represents the center of the region. |
| geom_center_x | double | The X-coordinate of the center of the region. |
| geom_center_y | double | The Y-coordinate of the center of the region. |
| gml_id | string | The unique identifier for each row, as provided by the data source. |
| kunta | string | The municipality code as a string. |
| name | string | The English name of the municipality. |
| namn | string | The name of the municipality in another language. |
| nimi | string | The name of the municipality in another language. |
| vuosi | double | The year the data was recorded, as a real number. |
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 | 9449dda3-d252-4a13-ba49-c65adf0eb7be |
| Package id | 552bd157-a310-4581-a445-5f12dd7f89aa |
| Position | 1 |
| Revision id | e507d488-2309-46df-bfa6-a86e0c9901d9 |
| State | active |
| Table | tilastointialueet_kunta1000k_2017__table__history |