Version History of AVI Regions 2015 (1:4 500 000) Table
The table in focus is a historical table that contains an organized collection of related data, specifically, the version history of its base table rows. It originates from the 'Tilastokeskus' (Statistics Finland) website in Finland. This historical table is a part of a larger dataset collection, which consists of one or more related tables.
The content of the table is derived from the 2015 AVI areas at a 1:4 500 000 scale. AVI stands for 'alueviranomainen', which is Finnish for regional administration. These areas are represented through a variety of columns that contain detailed information about each row.
The table includes special columns: '_start_date', '_end_date', and '_row_number'. These columns provide valuable information about the extraction and version history of each row. The '_start_date' column indicates when the row was extracted from the data source, while the '_end_date' indicates when a new version of the row was extracted. If the '_end_date' is null, it indicates that the row is the most recent version. Together, '_start_date' and '_row_number' create a unique identifier for each row in the history table.
The table also contains columns with geographic information, which are prefixed with 'geom_'. These columns provide geospatial data that can be utilized for geospatial data analytics. Specifically, they provide information about the geographic coordinates in the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
Understanding the data in this table can support a variety of data analytics applications. For instance, the geospatial data can be used to perform spatial analysis or map visualizations of historical changes in the AVI areas over time. The version history could be used to track changes and trends in the regional administration areas. The data could also be used for predictive modeling to anticipate future changes in these areas.
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 part of the combination with '_row_number' that uniquely identifies each row in this 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. It is used in conjunction with '_start_date' to uniquely identify each row in this version history table. |
| avi | string | This column holds a string value representing a certain classification or category. |
| geom_geojson | string | This column stores the geometric configuration of the area in GeoJSON format which is a geospatial data interchange format based on JavaScript Object Notation (JSON). |
| geom_geotext | string | This column contains the geometric configuration of the area in text format. This can be used for visual representations or analytics. |
| geom_type | string | This column indicates the type of the geometry stored in the 'geom_geojson' and 'geom_geotext' columns. The value is 'ST_MULTIPOLYGON' indicating that the geometry is a multipolygon. |
| geom_centroid | string | This column holds the geographical point that represents the center of the area's geometry. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the area. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the area. |
| gid | long | This column holds an integer value which serves as a unique identifier for the area. |
| gml_id | string | This column contains a unique string identifier for the row. |
| name | string | This column stores the English name of the area. |
| namn | string | This column holds the name of the area in another language. |
| nimi | string | This is another column that stores the name of the area but in a different language. |
| shape_star | double | This column contains a real number which might represent a certain property of the area's shape. |
| shape_stle | double | This column holds a real number which could represent another property of the area's shape. |
| vuosi | double | This column stores a real number which seems to represent a specific 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 | f8a48b47-852b-46da-bef3-185d15285151 |
| Package id | 2bd1beb3-6d4b-40b5-a390-5713c83805de |
| Position | 1 |
| Revision id | cedd2ad0-9a11-4c8a-ae0f-6de7a645804a |
| State | active |
| Table | tilastointialueet_avi4500k_2015__table__history |