Version History of AVI Regions 2017 (1:1 000 000) - Historical Data Records
The 'table__history' is a part of a dataset collection that chronologically organizes data related to AVI areas in 2017. It is an enriched version of its base table, providing additional information about the temporal validity of each row. Moreover, it contains geographic data, which can be very valuable for geospatial data analytics.
The table comprises a unique combination of columns, which help in identifying each row individually. This combination is formed by a start date, indicating when the row was extracted from the data source, and a row number that represents the position of the row in the raw data extracted from the source. There is also an end date, providing information about when a new version of the row was extracted. If this column shows a null value, it indicates that the row is the most recent version available.
The table also contains several columns that store geographic information. These columns begin with 'geom_' and carry data such as geographic coordinates, geometric shapes, and centroid coordinates, all represented using the WGS 84 coordinate reference system with longitude first, followed by latitude.
The table also contains identifiers and names of the AVI regions in multiple languages, including Finnish and Swedish.
This table, sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland, can be instrumental for various data analytics applications. For instance, it can help in tracking the historical changes in AVI regions over time due to its versioning feature. It can also be used to conduct geospatial analytics for understanding patterns and trends within different AVI regions. The multilingual support of the table also enables a wider reach, making data interpretation accessible to a global audience.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with '_row_number'. |
_end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value 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 forms a unique identifier in combination with '_start_date'. |
avi | string | This column contains a string representation of a unique identifier for the administrative division. |
geom_geojson | string | This column contains the geographical data in GeoJSON format representing the boundaries of the administrative division. |
geom_geotext | string | This column contains the geographical data in text format representing the boundaries of the administrative division. |
geom_type | string | This column contains the type of geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. |
geom_centroid | string | This column contains the central point of the geographical area of the administrative division. |
geom_center_x | double | This column contains the X-coordinate of the central point of the geographical area of the administrative division. |
geom_center_y | double | This column contains the Y-coordinate of the central point of the geographical area of the administrative division. |
gid | long | This column contains an integer representation of a unique identifier for the administrative division. |
gml_id | string | This column contains a unique identifier for the geographical data of the administrative division. |
name | string | This column contains the English name of the administrative division. |
namn | string | This column contains the Finnish name of the administrative division. |
nimi | string | This column contains the Swedish name of the administrative division. |
vuosi | double | This column contains the year of the data entry. |
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 | 26d0401a-74c8-4ac4-bb1d-473b8acdabe2 |
Package id | 0a3155d3-b381-4374-84e0-106c7298416d |
Position | 1 |
Revision id | 2e5a28aa-5cef-4990-b2bb-72d898c9352f |
State | active |
Table | tilastointialueet_avi1000k_2017__table__history |