Historical Versions of AVI Regions 2019 (1:1 000 000)
Click here for a data sample
The 'table__history' is a comprehensive dataset that records the version history of its base table rows, specifically pertaining to the AVI regions in Finland for the year 2019. This data originates from 'Tilastokeskus' (Statistics Finland), a Finnish institution known for data accuracy and credibility. The table offers a time-stamped version history of each row and is particularly useful for tracking changes over time. The table includes columns for both the start and end date of each row's validity, allowing users to trace the lineage of data changes. Notably, if the end date value is null, it indicates that the row is the most recent version. The table also offers a unique row identification system, where the row number combined with the start date creates a unique identifier for each row. In addition to this temporal data, the table also contains geographical data which can be utilized for geospatial data analytics. This includes information such as the center and type of the geographical area, represented in WGS 84 coordinate reference system. The data in this table could be utilized in several ways for data analytics. For instance, it could be used to track changes in the geographical boundaries of the AVI regions over time, or to analyze trends in the data linked to these regions. The historical data also provides a reliable source for backtesting hypotheses or models related to this geographical region. Moreover, the geospatial data can offer insights into spatial relationships and patterns, which could be valuable in fields such as urban planning, environmental studies, and transportation logistics.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the row was extracted from the data source. This column, combined with '_row_number', uniquely identifies each row in the table. |
|---|
| _end_date | date | The date when a new version of the row was extracted from the data source. A null value indicates that the row is the most recent version. |
|---|
| _row_number | long | The number of the row in the raw data extracted from the data source. |
|---|
| avi | string | A string value, which is part of the original data from the base table. |
|---|
| geom_geojson | string | A representation of the geographic features in GeoJSON format. |
|---|
| geom_geotext | string | A text representation of the geographic features in the form of a MultiPolygon. |
|---|
| geom_type | string | The type of the geographic feature, which in this case is a MultiPolygon. |
|---|
| geom_centroid | string | The centroid or geometric center of the MultiPolygon. |
|---|
| geom_center_x | double | The x-coordinate of the geometric center of the MultiPolygon. |
|---|
| geom_center_y | double | The y-coordinate of the geometric center of the MultiPolygon. |
|---|
| gml_id | string | An identifier for the data row, provided in the format of the base table. |
|---|
| id | long | A unique numerical identifier for the row, as provided in the base table. |
|---|
| name | string | The English name of the AVI (Administrative District) the data refers to. |
|---|
| namn | string | The name of the AVI in Swedish. |
|---|
| nimi | string | The name of the AVI in Finnish. |
|---|
| vuosi | long | The year associated with the data row, as an integer. |
|---|
