Version History of Municipalities 2015 (1:1 000 000) Table
The 'table__history' is a historical data table that contains the version history of its original base rows, providing an evolutionary perspective on the data. It belongs to the 'tilastointialueet_kunta1000k_2015' dataset collection, which is a group of related tables that provide a rich and multifaceted view of the data. The table was sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland.
The table presents a comprehensive set of columns that capture various aspects of the data. For instance, it contains special columns like '_start_date' and '_end_date', which respectively indicate the date when a row was extracted from the data source and when a new version of the row was extracted. The '_row_number' column indicates the number of the row in the raw data, and together with '_start_date', it uniquely identifies each row in this version history table. If the '_end_date' is null, it signifies that the row is the most recent version.
The table also includes multiple columns starting with 'geom_', which contain geographic information and are highly useful for geospatial data analytics. Notably, the geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table hosts a variety of other columns that capture different elements of the data, such as the name of the municipality ('name', 'namn', 'nimi'), the year ('vuosi'), among others. The original base table was described by the data source as 'Kunnat 2015 (1:1 000 000)', which translates to 'Municipalities 2015 (1:1 000 000)'.
With the rich data captured in this table, there are several potential applications in data analytics. For instance, the geospatial information could be used to analyze regional trends or patterns, or to visualize the data on a map. The version history could be leveraged to understand how the data has evolved over time. The unique identifiers could be used to link this data with other related data sources for more complex analyses. Lastly, the detailed municipality information could be valuable in local government or community planning analyses.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of a combination with '_row_number' that uniquely identifies each row in the version history 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 extracted from the data source. It is part of a combination with '_start_date' that uniquely identifies each row in the version history table. |
| geom_geojson | string | This column contains the geometric representation of the area in GeoJSON format. |
| geom_geotext | string | This column contains the geometric representation of the area in Well-Known Text (WKT) format. |
| geom_type | string | This column indicates the type of the geometry used in the 'geom_geotext' and 'geom_geojson' columns. |
| geom_centroid | string | This column contains the centroid of the area represented by the geometry, which is the center point of the area. |
| geom_center_x | double | This column contains the x-coordinate of the center of the area represented by the geometry. |
| geom_center_y | double | This column contains the y-coordinate of the center of the area represented by the geometry. |
| gml_id | string | This column contains a unique identifier in GML format. |
| kunta | string | This column contains a string type data representing the municipality or area. |
| name | string | This column contains the English name of the municipality or area. |
| namn | string | This column contains the Swedish name of the municipality or area. |
| nimi | string | This column contains the Finnish name of the municipality or area. |
| shape_star | double | This column contains the area of the shape in square units. |
| shape_stle | double | This column contains the length of the shape's perimeter. |
| vuosi | double | This column contains the year, represented as a real type data, associated with the data record. |
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 | 8a4949f3-98a1-48c3-804d-3652546870f5 |
| Package id | 2915e2c9-fdd1-481f-8ae7-e4e4bd9e6fdf |
| Position | 1 |
| Revision id | 922be719-3a8b-4101-8a35-c16c6937c00f |
| State | active |
| Table | tilastointialueet_kunta1000k_2015__table__history |