Version History of AVI-Regions 2021 (1:1 000 000) Dataset
The history table is a part of a dataset collection that stores versioned data of its base table. The base table represents AVI areas as mapped in 2021, which can be utilized in multiple ways, such as historical trend analysis, data validation, and geospatial data analytics. The table records each version of a row from the base table, preserving the state of data as it was at the time of extraction. This is particularly useful for tracking changes over time and analyzing historical data.
The columns of the table contain a wealth of information. For example, information on row versioning is provided by the '_start_date' and '_end_date' columns, which denote the lifespan of a specific version of a row. The '_row_number' column records the unique identification number of a row, which when combined with the '_start_date', provides a unique identifier for each row in this history table.
The table also includes a variety of geographical information encompassed within columns whose names start with 'geom_'. This data, represented in WGS 84 coordinate reference system, can be leveraged for geospatial data analytics, offering potential for in-depth geographical studies or location-based trend analysis.
The table further includes columns for names in different languages and a unique identifier for each AVI area, which could be useful for multilingual data analysis or linking data across different tables based on the unique identifier.
The data in this table is sourced from 'Tilastokeskus' (Statistics Finland), providing an authoritative and reliable source of information. The table can be a valuable resource for researchers and data analysts interested in studying historical trends in AVI areas, validating current data with past versions, conducting multilingual studies, or performing geospatial analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column holds the date on which the row was extracted from the data source. Each row's uniqueness in this version history table can be identified by a combination of this column and '_row_number'. |
| _end_date | date | This column contains the date on which 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. It forms a unique identifier for each row in combination with the '_start_date' column. |
| avi | string | This is a string column which corresponds to a specific code in the data source. |
| geom_geojson | string | This column contains the geometrical data in GeoJSON format. |
| geom_geotext | string | This column represents the geometrical data in text format. |
| geom_type | string | This column specifies the type of the geometry used. |
| geom_centroid | string | This column contains the geographical centroid point of a shape in the data. |
| geom_center_x | double | This column contains the X-coordinate of the center of a shape. |
| geom_center_y | double | This column contains the Y-coordinate of the center of a shape. |
| gml_id | string | This string column contains a unique identifier for each row in the base table. |
| id | long | This integer column serves as an identifier for each row in the base table. |
| name | string | This string column contains the English name of the region. |
| namn | string | This string column contains the Swedish name of the region. |
| nimi | string | This string column contains the Finnish name of the region. |
| vuosi | long | This integer column represents the year associated with the data. |
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 | 7d0d96a0-0a09-4e63-bc39-2777aa783cb3 |
| Package id | 11fa39c7-9843-4422-99e4-d3d1d4db7b18 |
| Position | 1 |
| Revision id | 2b478ca2-1d66-44dc-a9b0-e675034fc98a |
| State | active |
| Table | tilastointialueet_avi1000k_2021__table__history |