Version History of AVI Areas 2023 Data Table
The 'table__history' is a unique collection of data that maintains a record of the version history of its base table rows. It is part of a larger dataset collection focused on statistical regions for the year 2023, depicted at a 1:4,500,000 scale. This history table is an enriched version of its base table, with two additional columns that track the time span of each row's validity, making it a valuable resource for analyzing changes over time. The table is sourced from the 'Tilastokeskus' website based in Finland.
The table includes various columns that store diverse types of data. For instance, some columns hold geographical data in the form of geographic coordinates, enabling geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. Other columns store information about the statistical region, such as its ID and name in different languages. Additionally, every row in the table has unique identifiers formed by combining the date when the row was extracted and its row number.
The potential uses of the data within this table are vast. The historical data can be used to track changes in geographical areas over time or to analyze trends. The multilingual dataset can support international research or localization efforts. Furthermore, the geospatial data can be used in mapping services, spatial data analysis, or in creating geographically aware machine learning models.
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 a 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 indicates 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. Together with '_start_date', it forms a unique identifier for each row in the version history table. |
| avi | string | This column contains a string value representing a unique identifier. |
| geom_geojson | string | This column contains the geometric representation of the data in GeoJSON format. |
| geom_geotext | string | This column contains the geometric representation of the data in text format. |
| geom_type | string | This column indicates the type of the geometric data. |
| geom_centroid | string | This column contains the centroid point of the geometric data. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric data. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric data. |
| gml_id | string | This column contains a unique identifier in GML format. |
| id | long | This column contains an integer value representing a unique identifier. |
| name | string | This column contains the name in English. |
| namn | string | This column contains the name in Swedish. |
| nimi | string | This column contains the name in Finnish. |
| vuosi | long | This column contains an integer value representing the year. |
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 | 1b0ee3bc-6e22-4454-a592-05c5ebc087a8 |
| Package id | f2c86a31-1125-48c6-9170-59779d4c5040 |
| Position | 1 |
| Revision id | 72d31a59-5c53-477a-bc48-ea7df0e2f2c4 |
| State | active |
| Table | tilastointialueet_avi4500k_2023__table__history |