Version History of AVI Regions 2021 (1:4 500 000)
The 'table__history' is a specialized history table that stores the version history of its base table rows. It belongs to a dataset collection primarily revolving around the AVI areas 2021 (1:4 500 000). The data content of the table is organized in rows and columns, where each row contains a unique combination of a start date and row number, serving as a unique identifier for each row in the table.
The table contains a variety of columns, including special ones like '_start_date', '_end_date', and '_row_number'. The '_start_date' denotes the date when the row was extracted from the data source, and '_end_date' signifies the date when a new version of the row was extracted. If '_end_date' is null, it means that the row is the most current version. The '_row_number' gives the order of the row in the raw data extracted from the source.
The table also contains geographic information in columns starting with 'geom_', a prefix used for columns that house geospatial data. This data is presented using the WGS 84 coordinate reference system, which orders its axes with longitude first, followed by latitude.
As for practical applications, the data in this table can be utilized in a variety of data analytics scenarios. For instance, the geographic information could be used in geospatial data analytics to examine spatial patterns and trends over time. The version history of the base table rows can be valuable in tracking changes in the AVI areas over the years. The table can also serve as a rich source of data for temporal analyses, given its detailed version history.
The 'table__history' is sourced from 'Tilastokeskus' (Statistics Finland) based in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It helps in maintaining version history of the rows in the table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If this value 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 helps in uniquely identifying each row in this version history table. |
| avi | string | This column contains string type data. The exact content and purpose of this column is not provided by the data source. |
| geom_geojson | string | This column contains the geographical data in GeoJSON format. It is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geographical data in text format. It represents the shapes of geographical features. |
| geom_type | string | This column represents the type of the geographical data like Polygon or MultiPolygon. |
| geom_centroid | string | This column contains the central point of the geographical feature. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical feature. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical feature. |
| gml_id | string | This column contains a unique string identifier. |
| id | long | This column contains a unique integer identifier. |
| name | string | This column contains the English name of the geographical feature. |
| namn | string | This column contains the name of the geographical feature in a different language. |
| nimi | string | This column contains the name of the geographical feature in a different language. |
| vuosi | long | This column contains the year related data as integer. |
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 | b19b729a-d283-49cb-8feb-faef39f1d04b |
| Package id | d1aebc88-d72f-4a0f-a612-d6541f306623 |
| Position | 1 |
| Revision id | e5bc8513-52af-45b9-aa0c-0b4aff96044a |
| State | active |
| Table | tilastointialueet_avi4500k_2021__table__history |