Version History of AVI Regions 2023 (scale 1:1 000 000) from a Finnish Statistical Data Collection
The 'table__history' is a historic compilation of data, tracking alterations and updates over time. It is a component of the 'tilastointialueet_avi1000k_2023' dataset collection, emphasizing the importance of data evolution tracking in data analytics. The content of the base table is an overview of 'AVI-areas 2023' at a scale of 1:1,000,000, sourced from the Finnish 'Tilastokeskus' (Statistics Finland) website.
The table includes a variety of columns that store valuable data related to each row's version history. A unique identifier for each row is formed by a combination of the '_start_date' and '_row_number' columns, with the former capturing the date the row was extracted and the latter indicating the row's number in the raw data. The '_end_date' column records the date when a new version of the row was extracted. If this column is null, it indicates that the row is the most recent version.
The table provides geospatial data through a set of columns prefixed with 'geom_'. These columns carry geographic information useful for geospatial data analytics. They offer data like geographic coordinates in the WGS 84 coordinate reference system, with the convention of listing longitude before latitude.
Some columns store data concerning the AVI areas, such as their names in different languages, and an 'avi' column with a numerical identifier for each area. The 'gml_id' column contains unique identifiers for each row, while the 'vuosi' column indicates the year, 2023 in this case.
In terms of practical application, this table's data could be utilized in various ways. For example, tracking the evolution of AVI areas over time can provide insights into regional development and changes. The geospatial data could be used in geographical information systems (GIS) to analyze spatial relationships and trends. Additionally, the unique identifiers allow for efficient data management and reference in large-scale data operations.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column represents the date when the row was extracted from the data source, helping to track the history of data updates. |
| _end_date | date | This column indicates the date when a new version of the row was extracted from the data source. A null value implies that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the source. Together with '_start_date', it uniquely identifies each row in the history table. |
| avi | string | This column contains a string representation of a unique identifier. |
| geom_geojson | string | This column stores the geographical data in GeoJSON format, which represents various geometrical shapes. |
| geom_geotext | string | This column holds the geographical data in text format. |
| geom_type | string | This column indicates the type of the geographical data stored. |
| geom_centroid | string | This column contains the central point of the geographical shape. |
| geom_center_x | double | This column represents the X-coordinate of the center of the geographical shape. |
| geom_center_y | double | This column represents the Y-coordinate of the center of the geographical shape. |
| gml_id | string | This column contains a unique identifier in String format. |
| id | long | This column holds a unique integer identifier. |
| name | string | This column contains the English name of the respective entity. |
| namn | string | This column has the name of the respective entity in the local language. |
| nimi | string | This column includes the name of the respective entity in another local language. |
| vuosi | long | This column holds an integer value representing the year related to the row 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 | d62f6364-575a-49b4-bfb1-a58b1b0ecc11 |
| Package id | 1f594b50-b14f-4fdc-beb3-a33f04d4b81b |
| Position | 1 |
| Revision id | 5623a1ed-949e-4fd5-b3a3-3ebb24bc47d7 |
| State | active |
| Table | tilastointialueet_avi1000k_2023__table__history |