History of AVI Regions 2019 (Scale 1:4,500,000)
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_date | date | This 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_date | date | This 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_number | long | This 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. |
avi | string | This string type column from the base table represents an identifier of the administrative division. |
geom_geojson | string | This column contains the geographical data of the administrative division in GeoJSON format. |
geom_geotext | string | This column contains the geographical data of the administrative division in text format. |
geom_type | string | This column specifies the type of the geographical data of the administrative division. |
geom_centroid | string | This column contains the geographical center of the administrative division. |
geom_center_x | double | This column contains the x-coordinate of the geographical center of the administrative division. |
geom_center_y | double | This column contains the y-coordinate of the geographical center of the administrative division. |
gml_id | string | This string type column from the base table represents the unique geographical markup language identifier. |
id | long | This Integer64 type column from the base table provides the unique identifier for each row. |
name | string | This string type column from the base table provides the English name of the administrative division. |
namn | string | This string type column from the base table provides the Swedish name of the administrative division. |
nimi | string | This string type column from the base table provides the Finnish name of the administrative division. |
vuosi | long | This 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 | |
Country | fi |
Database | fi_tilastokeskus |
Extract date | 2024-11-11 |
Id | 5052328e-fc2f-4171-aa52-f8828cfe49e1 |
Package id | 4b85d4d8-8eea-44d7-96b5-d064d60de616 |
Position | 1 |
Revision id | abf0ae02-01c2-4b38-bc27-26fdfb700514 |
State | active |
Table | tilastointialueet_avi4500k_2019__table__history |