Version History of AVI Regions 2014 (1:4 500 000)
The 'table__history' is a history table offering an important historical record of the dataset 'tilastointialueet_avi4500k_2014'. The data contained in this table provides the version history of its base table rows, making it a rich resource for tracking changes over time. The base table is titled as 'AVI-alueet 2014 (1:4 500 000)', which translates to 'AVI Areas 2014 (1:4 500 000)' in English, indicating the geographical focus of the dataset.
The table records a variety of data, including geographical information with WGS 84 coordinate reference system, longitude first, followed by latitude, which can be utilized for geospatial data analytics. This can be seen in the columns beginning with 'geom_', which contains geographic information in various formats such as 'geojson', 'geotext' and geographical center points 'x' and 'y'.
Each row is uniquely identified by a combination of a start date and a row number. The start date indicates when the row was extracted from the data source, and the end date signifies when a new version of the row was extracted. If the end date is null, it indicates that the row is the most recent version.
By analyzing this data, one could track changes in the geographical areas over time, observe trends, and even predict future changes. For instance, the data could be used to analyze the change in the size or boundaries of the AVI areas over the years.
The table is sourced from the 'Tilastokeskus' (Statistics Finland) website, based in Finland. The information offered by this table could serve as an invaluable resource for researchers, policy makers, and data analysts interested in the historical changes of AVI areas.
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 part of the 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 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. This number, in combination with the '_start_date', uniquely identifies each row in this version history table. |
| avi | string | This column contains a string identifier, possibly related to a specific regional or administrative value. |
| geom_geojson | string | This column contains geographical data in the GeoJSON format. This data likely represents specific geographical areas. |
| geom_geotext | string | This column contains geographical data in the text format. This data likely represents specific geographical areas. |
| geom_type | string | This column specifies the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the geographical point that represents the center of the geographical area. The point is provided in the format 'POINT (longitude latitude)'. |
| geom_center_x | double | This column contains the longitude of the center of the geographical area. |
| geom_center_y | double | This column contains the latitude of the center of the geographical area. |
| gml_id | string | This column contains a unique string identifier for each row. |
| name | string | This column contains the name of the geographical area in English. |
| namn | string | This column contains the name of the geographical area in another language, possibly Swedish or Finnish. |
| nimi | string | This column contains the name of the geographical area in another language, possibly Finnish. |
| vuosi | long | This column contains an integer value, likely representing the year associated with the data in the 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 | 618829c4-5288-4ca3-898c-162f85689f7c |
| Package id | e6878ebf-4b1e-4333-9c23-673f00dc4955 |
| Position | 1 |
| Revision id | c4f4def6-1f5a-4bb0-9ed1-f5739f13c9ee |
| State | active |
| Table | tilastointialueet_avi4500k_2014__table__history |