Version History of AVI Regions 2020 (Scale 1:1,000,000)
Click here for a data sample
The 'table__history' is a comprehensive record of the version history of AVI areas in 2020 at a scale of 1:1 000 000, sourced from the 'Tilastokeskus' (Statistics Finland) website. The table is part of the 'tilastointialueet_avi1000k_2020' dataset collection. It contains geographic data, which can be analyzed to gain a spatial understanding of different regions within Finland. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The table also includes unique identifiers for each row, along with the start and end dates for each version of the row. If the end date for a row is null, it signifies that the row is the most recent version. This feature enables tracking changes over time and identifying the most recent data. The table also includes information about the AVI areas in different languages, which can be utilized in multilingual data analysis. Potential applications of this data could include tracking changes in AVI areas over time, identifying patterns and trends in the distribution of AVI areas, or conducting geospatial analysis to understand the spatial characteristics of these areas.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with '_row_number'. |
|---|
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it implies 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 in combination with '_start_date'. |
|---|
| avi | string | This column contains a string value, possibly representing a specific region or area. |
|---|
| geom_geojson | string | This column contains geometric data in GeoJSON format, possibly representing the geographic boundaries of the area defined in the 'avi' column. |
|---|
| geom_geotext | string | This column contains geometric data in text format, likely mirroring the data in the 'geom_geojson' column. |
|---|
| geom_type | string | This column specifies the type of the geometric data contained in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_centroid | string | This column contains the geographical point that represents the center of the area defined in the 'avi' column. |
|---|
| geom_center_x | double | This column contains the X-coordinate of the geographical center of the area defined in the 'avi' column. |
|---|
| geom_center_y | double | This column contains the Y-coordinate of the geographical center of the area defined in the 'avi' column. |
|---|
| gml_id | string | This is a unique string identifier for each row. |
|---|
| id | long | This is a unique integer identifier for each row. |
|---|
| name | string | This column contains the name of the area defined in the 'avi' column in English. |
|---|
| namn | string | This column contains the name of the area defined in the 'avi' column in Swedish. |
|---|
| nimi | string | This column contains the name of the area defined in the 'avi' column in Finnish. |
|---|
| vuosi | long | This column contains an integer value, possibly representing the year of the data. |
|---|
