History of AVI Regions 2019 (Scale 1:4,500,000)

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

Click here for a data sample

The 'table__history' is a robust record of historical versions of data, sourced from the 'Statistics Finland' website, based in Finland. Its primary focus is on the AVI areas in 2019 at a 1:4 500 000 scale, which holds crucial geographical data. This data can be utilized for geospatial analytics, which could be tremendously beneficial in understanding the geographical patterns, trends, and complexities. The table contains columns that hold geographical information, including the type of geographical area, its centroid, and the coordinates of its center. This geographic data is presented in the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude, which is a standard format in geospatial analytics.

The table also contains a unique identifier for each row, a row number, and dates when each row was extracted and when a newer version was extracted. This provides a comprehensive version history of the data, which can be beneficial for tracking changes over time. In the absence of an 'end date', it signifies that the row is the most recent version.

An example of using this table in data analytics could be to monitor the changes in geographic areas over time, such as understanding how the boundaries of AVI areas have changed. This could be important in various fields, from environmental studies to urban planning. Another example could be to use the historical data to predict future changes in the geographical areas, based on the trends observed in the data.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date when the data row was extracted from the source. It forms a unique identifier in combination with the '_row_number' column for each row in this version history table.
_end_datedateThis column contains the date when a new version of the row was extracted from the source. If the value is null, it indicates that the row is the most recent version.
_row_numberlongThis column contains the number of the row in the original data extracted from the source. It forms a unique identifier in combination with the '_start_date' column for each row in this version history table.
avistringThis string type column from the base table represents an identifier of the administrative division.
geom_geojsonstringThis column contains the geographical data of the administrative division in GeoJSON format.
geom_geotextstringThis column contains the geographical data of the administrative division in text format.
geom_typestringThis column specifies the type of the geographical data of the administrative division.
geom_centroidstringThis column contains the geographical center of the administrative division.
geom_center_xdoubleThis column contains the x-coordinate of the geographical center of the administrative division.
geom_center_ydoubleThis column contains the y-coordinate of the geographical center of the administrative division.
gml_idstringThis string type column from the base table represents the unique geographical markup language identifier.
idlongThis Integer64 type column from the base table provides the unique identifier for each row.
namestringThis string type column from the base table provides the English name of the administrative division.
namnstringThis string type column from the base table provides the Swedish name of the administrative division.
nimistringThis string type column from the base table provides the Finnish name of the administrative division.
vuosilongThis Integer64 type column from the base table represents the year of the data row.

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
Id5052328e-fc2f-4171-aa52-f8828cfe49e1
Package id4b85d4d8-8eea-44d7-96b5-d064d60de616
Position1
Revision idabf0ae02-01c2-4b38-bc27-26fdfb700514
Stateactive
Tabletilastointialueet_avi4500k_2019__table__history