Version History of AVI Regions 2024 (1:1 000 000)
The 'table__history' is a history table presenting version history data of its base table. It belongs to a dataset collection titled 'AVI-alueet 2024 (1:1 000 000)', translated to English as 'AVI regions 2024 (1:1 000 000)'. This collection is sourced from 'Tilastokeskus' (Statistics Finland), a website based in Finland.
The table includes a variety of columns, each containing specific types of data. For instance, certain columns contain geographic information that can be used for geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
The table also holds special columns like '_start_date', '_end_date' and '_row_number'. The '_row_number' signifies the number of the row in raw data, while the '_start_date' and '_end_date' indicate the timeframe during which each row was the latest version. If '_end_date' is null, it indicates that the row is the most recent version.
The data in 'table__history' can be utilized in a number of ways. For instance, the geographic information can be used to conduct regional analysis over time, examining how the AVI regions have evolved. The version history data could help in understanding trends or changes over time, which could be beneficial in predictive modelling or time series analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column records the date when the row was extracted from the data source, marking the beginning of a version of a row in the history table. |
| _end_date | date | This column records the date when a new version of the row was extracted from the data source, marking the end of the current version. If this column contains a null value, 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 source. Together with '_start_date', it uniquely identifies each row in this history table. |
| avi | string | This column contains a string representation of a certain attribute associated with the data row. |
| geom_geojson | string | This column contains geometric data in GeoJSON format. The data represents the spatial characteristics of the data row. |
| geom_geotext | string | This column contains geometric data in text format. This is another representation of the spatial characteristics of the data row. |
| geom_type | string | This column describes the type of the geometric data present in the row. The data can represent various types of shapes like polygons or multipolygons. |
| geom_centroid | string | This column contains the geometric centroid of the spatial data associated with the data row. |
| geom_center_x | double | This column contains the x-coordinate of the center point of the geometric shape associated with the data row. |
| geom_center_y | double | This column contains the y-coordinate of the center point of the geometric shape associated with the data row. |
| gml_id | string | This column contains a unique identifier associated with the data row. It is a string data type. |
| id | long | This column contains a unique integer identifier associated with the data row. |
| name | string | This column contains a string representation of the name associated with the data row in English. |
| namn | string | This column contains a string representation of the name associated with the data row in Swedish. |
| nimi | string | This column contains a string representation of the name associated with the data row in Finnish. |
| vuosi | long | This column contains an integer representing the year associated with the data 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 | 5a7d656b-fe38-4f86-9fb6-f82b1fbd177b |
| Package id | 01dbd8fe-7792-409b-b08b-c54b3024ec95 |
| Position | 1 |
| Revision id | 5b919f5e-fe83-45da-9250-d5657b8802a9 |
| State | active |
| Table | tilastointialueet_avi1000k_2024__table__history |