Version History of AVI Areas (1:4 500 000) Data Table
The 'table__history' is a historical dataset that tracks the version history of its base table rows. It's part of a larger dataset collection called 'tilastointialueet_avi4500k'. This historical table is sourced from 'Tilastokeskus' (Statistics Finland) and primarily contains information about the AVI areas in Finland represented at a scale of 1:4 500 000. The data includes elements such as region names in different languages and unique identifiers for each area. It also includes a variety of geographic information that can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
Unique identifiers for each row are formed by a combination of the start date and the row number. The start date indicates when a row was extracted from the data source, while the end date signifies when a new version of that row was extracted. If the end date value is null, it denotes that the row is the most recent version.
This table has a multitude of potential applications in data analytics. For instance, the geographical data could be used to map the historical changes in AVI areas over time, or to analyze spatial patterns and trends. The version history could also be utilized to trace data quality issues back to their source, or to study how certain areas have evolved. Additionally, the multilingual region names could assist in international data compilations or comparative studies between regions.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column stores the date when a specific row was extracted from the data source, serving as a starting point for the row's version history. It is part of a combination with the '_row_number' column that uniquely identifies each row in this history table. |
| _end_date | date | The '_end_date' column contains the date when a new version of the row was extracted from the data source, marking the end of the current version's validity. A null value in this column indicates that the row represents the most recent version. |
| _row_number | long | The '_row_number' column is a unique identifier for each row, representing the order of extraction from the data source. It is part of a combination with the '_start_date' column that uniquely identifies each row in this history table. |
| avi | string | This column represents a unique string identifier. |
| geom_geojson | string | This column stores the geographical data in GeoJSON format, a popular format for encoding a variety of geographic data structures. |
| geom_geotext | string | The 'geom_geotext' column contains the textual representation of the geographical data. |
| geom_type | string | This column specifies the type of geographical data stored in the row, for example, whether it's a polygon or multipolygon. |
| geom_centroid | string | The 'geom_centroid' column contains the centroid point of the geographical data. |
| geom_center_x | double | This column represents the X coordinate of the centroid point of the geographical data. |
| geom_center_y | double | The 'geom_center_y' column represents the Y coordinate of the centroid point of the geographical data. |
| gml_id | string | The 'gml_id' column is a unique string identifier for the geographical data. |
| id | long | This column is an integer identifier for each row. |
| name | string | The 'name' column contains the English name of the region. |
| namn | string | The 'namn' column contains the name of the region in another language. |
| nimi | string | The 'nimi' column contains the name of the region in another language, providing multilingual support. |
| vuosi | long | The 'vuosi' column represents the year associated with the data in the row. |
No sample for this dataset
Additional Information
| Last updated | November 8, 2024 |
|---|---|
| Created | November 8, 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 | 35b0519f-c561-47ac-a99f-e3575368766a |
| Package id | afd64340-d315-4d05-9f8f-80dd9f1d464f |
| Position | 1 |
| Revision id | cfddc75c-dd23-42fb-a4b6-974ad540192e |
| State | active |
| Table | tilastointialueet_avi4500k__table__history |