Version History of Municipalities 2014 (1:1 000 000) Table
The 'table__history' is a historical table that retains the version history of its base table rows. It's part of the dataset collection 'tilastointialueet_kunta1000k_2014', which captures data related to the municipalities in 2014 at a scale of 1:1,000,000. The table comes from the Finnish Statistical Bureau ('Tilastokeskus') in Finland.
The table records not only the raw data but also the date of data extraction and the unique row number, which together can be used to identify each row uniquely in this version history table. The table has two additional columns '_start_date' and '_end_date', relative to its base table. The '_start_date' column indicates when the row data was extracted from the source, while the '_end_date' refers to the date when a new version of the row was extracted. If '_end_date' is null, it implies that the row is the most recent version.
Geographic information is captured through columns beginning with 'geom_', including 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns contain geospatial data, represented in WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This data is crucial for geospatial analytics, such as analyzing population density in different municipalities or tracking changes in municipal borders over time.
The columns 'kunta', 'name', 'namn', 'nimi', and 'vuosi' provide further information about each municipality, including its name in different languages and the year of the data.
The data in 'table__history' can be utilized in various ways in data analytics. For instance, the geospatial data can be used to visualize the municipalities in a geographic information system (GIS). The version history can aid in tracking changes in the municipalities over time, which could be beneficial in planning and policy-making. Moreover, the multilingual names can support international research or data sharing initiatives.
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 a part of a combination with '_row_number' that uniquely identifies each row in this 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 indicates 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 unique identifier for each row when combined with '_start_date'. |
| geom_geojson | string | This column stores geometric data in GeoJSON format, which is a common format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geometric data in text format. It is a human-readable representation of the geometrical data captured in the 'geom_geojson' column. |
| geom_type | string | This column indicates the type of the geometrical data stored. For example, it could be a point, line, or polygon. |
| geom_centroid | string | This column contains the geometric centroid of the feature. It is the arithmetic mean position of all the points in all of the geometric object's coordinates. |
| geom_center_x | double | This column stores the X coordinate of the feature's center point. |
| geom_center_y | double | This column stores the Y coordinate of the feature's center point. |
| gml_id | string | This column contains a unique identifier for each feature in the table. |
| kunta | string | This column contains a string that represents the municipality in Finland. |
| name | string | This column contains the English name of the municipality. |
| namn | string | This column contains the Swedish name of the municipality. |
| nimi | string | This column contains the Finnish name of the municipality. |
| vuosi | long | This column represents the year, indicating the time frame 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 | 4f80fb9a-0c6b-4ed1-a656-cc42eca9a786 |
| Package id | 190dd43b-53dc-4d51-b2ba-1f5bcf42e863 |
| Position | 1 |
| Revision id | 3dc6b234-85f8-42cc-b5aa-0475aaa87332 |
| State | active |
| Table | tilastointialueet_kunta1000k_2014__table__history |