Version History of Municipalities 2014 (1:4 500 000)
The 'table__history' is a part of a dataset collection, 'tilastointialueet_kunta4500k_2014', sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. It is a history table encapsulating the version history of its base tables' rows. It contains a unique identifier for each row, formed by a combination of the extraction date and the row number.
The table's contents primarily consist of data related to the Finnish municipalities in 2014, with geographical data presented using WGS 84 coordinate reference system, in which the axis order is longitude first, followed by latitude. This geospatial data includes the type, centroid, centre x and y coordinates, and GeoJSON and GeoText representations of the geographical features.
The table also contains information about the municipality name in different languages, the year, and a unique identifier for each municipality.
Moreover, the table has two special columns: '_start_date' and '_end_date', which pertain to the version history of the base table rows. The '_start_date' indicates when the row was extracted, and the '_end_date' signals when a new version was extracted. If the '_end_date' value is null, it signifies that the row is the most recent version.
The data in this table can be employed for various data analytics applications. For instance, the geographical data can be used in geospatial data analytics to understand patterns and trends across different municipalities. The version history information can be utilized to track changes over time in the data, providing insights into temporal trends. Furthermore, the multilingual municipality names could be beneficial in cross-cultural and linguistic studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source, marking the start of a specific version of a record. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source, marking the end of a specific version of a record. If this column's value is null, it indicates that the version of the row is the most recent. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. Together with the '_start_date', it uniquely identifies each row version in the table. |
| geom_geojson | string | This column contains the geographical representation of the area in GeoJSON format, a popular open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column contains the textual representation of the geographical area in a format, which is readable by geographical information systems. |
| geom_type | string | This column specifies the type of the geographical representation stored. In this table, the values are of type 'ST_MULTIPOLYGON' indicating the area is represented by multiple polygons. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid, or the geometric center, of the area. |
| geom_center_x | double | This column contains the x-coordinate (longitude) of the geometric center of the area. |
| geom_center_y | double | This column contains the y-coordinate (latitude) of the geometric center of the area. |
| gml_id | string | This column contains the unique identifier of the area provided by the data source. |
| kunta | string | This column contains the municipality code, a unique identifier for each municipality in Finland. |
| name | string | This column contains the Finnish name of the municipality. |
| namn | string | This column contains the Swedish name of the municipality. |
| nimi | string | This column repeats the Finnish name of the municipality. |
| vuosi | long | This column contains the year to which the data pertains. |
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 | ae7b2f35-ad98-4be6-bbe2-cc63dd1c3037 |
| Package id | 95050969-c4cc-445d-b88b-d7598ac18e25 |
| Position | 1 |
| Revision id | 7fefe91c-3aa6-4d1b-a0fc-01edaf4abec7 |
| State | active |
| Table | tilastointialueet_kunta4500k_2014__table__history |