Version History of AVI Regions 2017 (1:1 000 000) - Historical Data Records

To download the data set, please sign up or log in ×

Click here for a data sample

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_datedateThis column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with '_row_number'.
_end_datedateThis 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_numberlongThis 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'.
avistringThis column contains a string representation of a unique identifier for the administrative division.
geom_geojsonstringThis column contains the geographical data in GeoJSON format representing the boundaries of the administrative division.
geom_geotextstringThis column contains the geographical data in text format representing the boundaries of the administrative division.
geom_typestringThis column contains the type of geographical data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroidstringThis column contains the central point of the geographical area of the administrative division.
geom_center_xdoubleThis column contains the X-coordinate of the central point of the geographical area of the administrative division.
geom_center_ydoubleThis column contains the Y-coordinate of the central point of the geographical area of the administrative division.
gidlongThis column contains an integer representation of a unique identifier for the administrative division.
gml_idstringThis column contains a unique identifier for the geographical data of the administrative division.
namestringThis column contains the English name of the administrative division.
namnstringThis column contains the Finnish name of the administrative division.
nimistringThis column contains the Swedish name of the administrative division.
vuosidoubleThis 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
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Id26d0401a-74c8-4ac4-bb1d-473b8acdabe2
Package id0a3155d3-b381-4374-84e0-106c7298416d
Position1
Revision id2e5a28aa-5cef-4990-b2bb-72d898c9352f
Stateactive
Tabletilastointialueet_avi1000k_2017__table__history