Version History of AVI Regions 2022 (1:1 000 000)
The 'table__history' is a part of a larger dataset collection that encapsulates the version history of its base table rows. This history table is sourced from 'Tilastokeskus' (Statistics Finland), based in Finland. The primary content of this table reflects the AVI areas for 2022 at a scale of 1:1 000 000, as provided by the data source.
This table contains several columns with varied information. Firstly, there are columns that provide geographic information suitable for geospatial data analytics. These columns, prefixed by 'geom_', present geographic coordinates using the WGS 84 coordinate reference system, with longitude appearing first, followed by latitude.
Then, there are columns that include details such as the start and end dates of the data extraction from the source, and the unique row number, which together can be used to uniquely identify each version of a row in this table. Specifically, the start date refers to when the row was extracted, while the end date signifies when a new version of the row was extracted. If the value of the end date column is null, it indicates the most recent version of the row.
The table also features columns that contain information like unique identifiers, names in different languages, and the year of interest. These columns can be leveraged to compare and analyze data across different regions and years.
This table can be utilized in various ways for data analytics. For instance, the geographical information can be used to conduct geospatial analytics, allowing users to identify patterns and trends based on location. Additionally, the version history can be used to track changes over time, providing historical context to the data. Furthermore, the multilingual name columns can assist in international data comparisons and analyses.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column represents the date when the row was extracted from the data source, serving as a start date for the version history of a particular row. |
| _end_date | date | The '_end_date' column contains the date when a new version of the row was extracted from the data source. If the column value is null, it signifies that the row is the most recent version. |
| _row_number | long | This column holds the row number in the raw data extracted from the data source. Along with the '_start_date', it uniquely identifies each row in the version history table. |
| avi | string | The 'avi' column represents a unique code or identifier, possibly related to a certain geographical area or entity. |
| geom_geojson | string | The 'geom_geojson' column contains the geographical data in GeoJSON format, a standard format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column, 'geom_geotext', stores geographical data in text format. |
| geom_type | string | The 'geom_type' column specifies the type of the geographic data represented in the 'geom_geojson' and 'geom_geotext' columns. In this case, it is a 'ST_MULTIPOLYGON', representing a multi polygon geographical entity. |
| geom_centroid | string | The 'geom_centroid' column contains the central point of the geographical entity represented as a point on the map. |
| geom_center_x | double | The 'geom_center_x' column holds the X-coordinate of the geographical entity's center point. |
| geom_center_y | double | The 'geom_center_y' column holds the Y-coordinate of the geographical entity's center point. |
| gml_id | string | The 'gml_id' column holds a unique identifier for each geographical entity. |
| id | long | The 'id' column contains a unique numerical identifier for each row. |
| name | string | The 'name' column contains the English name of the geographical entity. |
| namn | string | The 'namn' column contains the name of the geographical entity in another language, possibly Swedish. |
| nimi | string | The 'nimi' column holds the name of the geographical entity in Finnish. |
| vuosi | long | The 'vuosi' column represents the year associated with the row, possibly the year of data collection or the year the data pertains to. |
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 | d7b8fb7f-5062-4616-9110-fcbf8a248499 |
| Package id | e4fd8fec-1ffa-4d0c-8eaf-7f8b478fea6b |
| Position | 1 |
| Revision id | 42cc0003-95a4-4596-8f5e-41a58bc42511 |
| State | active |
| Table | tilastointialueet_avi1000k_2022__table__history |