Version History of AVI Areas 2014 (1:1 000 000) Data
The 'table__history' is a rich repository of information that forms an integral part of the dataset collection 'tilastointialueet_avi1000k_2014'. This table is specifically a history table that keeps track of the version history of its base table rows. It is contributed by 'Tilastokeskus' from Finland and contains comprehensive geographical data presented in the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
The table's data content is aligned with the AVI-areas 2014 (1:1 000 000) theme and includes geographic information in various formats, which can be valuable for geospatial data analytics. It provides details on areas represented by different IDs, their names in various languages, and their geographical details in the form of coordinates.
In addition to the base table's content, the history table contains two special columns, '_start_date' and '_end_date', adding a temporal dimension to the data. The '_start_date' column specifies the date when the row data was extracted, and the '_end_date' indicates when a new version of the row was extracted. When the '_end_date' is null, it signifies that the row is the most recent version. Using the combination of '_start_date' and '_row_number', each row in the version history table can be uniquely identified.
The data in 'table__history' can be leveraged in various data analytics applications. For instance, the geographic information can be used to perform geospatial analytics, aiding in mapping and spatial trend analysis. The version history can provide insights into the temporal changes in the data, aiding in trend analysis over time. Furthermore, the multilingual names can assist in regional studies or localized data analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column represents the date when the row was extracted from the data source. It is a part of a unique identifier for each row in this history table in combination with the '_row_number' column. |
| _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. It forms a unique identifier for each row in combination with the '_start_date' column. |
| avi | string | This column holds a string value, representing a certain attribute of the table's base data. |
| geom_geojson | string | This column contains geometric data in GeoJSON format. This data often represents geographical shapes. |
| geom_geotext | string | This column contains geometric data as text, typically representing geographical shapes in a spatial reference system. |
| geom_type | string | This column defines the type of the geometric data contained in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the central point of the geometric shapes defined in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_x | double | This column represents the X coordinate of the center point of the geometric shapes. |
| geom_center_y | double | This column represents the Y coordinate of the center point of the geometric shapes. |
| gml_id | string | This column contains a unique identifier for each row of the table. This identifier is typically used in Geographic Markup Language (GML) format data. |
| name | string | This column contains the English names of the entities represented by the rows in the table. |
| namn | string | This column contains the names of the entities represented by the rows in the table in a different language (likely Swedish, given the source of the data). |
| nimi | string | This column contains the names of the entities represented by the rows in the table in yet another language (likely Finnish, given the source of the data). |
| vuosi | long | This column holds integer values, likely representing the year associated with the data in the 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 | f0037aaf-b42f-4ec3-873c-01dc009f455d |
| Package id | 5172da8a-729c-4bc2-8134-1ec06db87069 |
| Position | 1 |
| Revision id | 956cd021-2076-4c9b-b978-4498e45da2da |
| State | active |
| Table | tilastointialueet_avi1000k_2014__table__history |