Version History of AVI Regions 2020 (1:4 500 000)
Click here for a data sample
The table 'table__history' is a historical record that is part of the dataset collection 'tilastointialueet_avi4500k_2020'. This table provides valuable insights into the version history of its base table rows, presenting a chronological sequence of data from the time it was extracted until a new version of the row was generated. This is particularly useful in tracing the evolution of data over time. The table features a unique identification system for each row, formed by the combination of the start date and row number of the data extraction. The table also includes columns for geographic information which can be utilized for geospatial data analytics. The geographic coordinates used in these columns are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The contents of the table are described as 'AVI areas 2020 (1:4 500 000)' which could refer to various geographical areas and their attributes for the year 2020. The data in this table could be utilized in various ways in data analytics. For example, the geospatial information could be used to analyze patterns, trends, and changes in the AVI areas over time. The version history could be used to trace the evolution of these areas and their attributes. The table is sourced from the 'Tilastokeskus' website, located in Finland. The rich historical and geospatial data contained in this table makes it a valuable resource for various data analytics applications.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when a row was extracted from the data source. This column, along with '_row_number', uniquely identifies each row in the history table. |
|---|
| _end_date | date | This column has the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
|---|
| _row_number | long | This is the number of the row in the raw data extracted from the data source. It forms a unique identifier in combination with the '_start_date' column. |
|---|
| avi | string | This column contains a string identifier related to the dataset. |
|---|
| geom_geojson | string | This column contains geospatial data in GeoJSON format, providing spatial representation for the data row. |
|---|
| geom_geotext | string | This column contains geospatial data in text format, offering another way to represent the spatial data. |
|---|
| geom_type | string | This column specifies the type of the geospatial data represented in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_centroid | string | This column contains the central point of the geospatial data. |
|---|
| geom_center_x | double | This column has the X-coordinate of the geospatial data's center. |
|---|
| geom_center_y | double | This column holds the Y-coordinate of the geospatial data's center. |
|---|
| gml_id | string | This column contains a unique string identifier for the row. |
|---|
| id | long | This column contains an integer identifier for the row. |
|---|
| name | string | This column contains the English name for the data row. |
|---|
| namn | string | This column contains the name for the data row in another language. |
|---|
| nimi | string | This column contains the name for the data row in another language. |
|---|
| vuosi | long | This column contains an integer representing the year related to the data row. |
|---|
