Version History of AVI Areas 2017 (1:4 500 000) Table
Click here for a data sample
The 'table__history' is a historical dataset that provides a comprehensive record of regional administrative divisions in Finland for the year 2017, sourced from the Finnish statistical organization, 'Tilastokeskus' (Statistics Finland). This history table maintains a version history record of its base table, allowing for a detailed analysis of data changes over time. The table includes a unique combination of 'row number' and 'start date' for each row, indicating the order of extraction and the date of extraction from the data source, respectively. 'End date' signifies when a new version of the row was extracted. A null 'end date' implies the latest version of the row. The table also contains geographical data prefixed with 'geom_', which provides a variety of geospatial data such as the type of geographical feature, coordinates for the centroid, and the center of the feature using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This information could be invaluable for geospatial data analytics, enabling the visual representation of regional administrative boundaries, and tracking shifts over time. Other columns provide additional details such as the regional administrative division name in multiple languages and the corresponding unique identifiers. This historical data table could be utilized in a variety of analytics, including trend analysis of regional administrative changes, spatial analysis of geographical boundaries, and historical data validation.
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 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 forms a unique identifier in combination with '_start_date'. |
|---|
| avi | string | This string-based column holds identification information. |
|---|
| geom_geojson | string | This column contains geometric data in the GeoJSON format, which represents multiple polygons. |
|---|
| geom_geotext | string | This column contains geometric data in text format representing multiple polygons. |
|---|
| geom_type | string | This column specifies the type of the geometric data, which in this case is a multi-polygon. |
|---|
| geom_centroid | string | This column contains the central point of the geometric shape represented by coordinates. |
|---|
| geom_center_x | double | This column contains the X-coordinate of the geometric shape's center. |
|---|
| geom_center_y | double | This column contains the Y-coordinate of the geometric shape's center. |
|---|
| gid | long | This integer-based column serves as an identifier. |
|---|
| gml_id | string | This string-based column serves as an identifier. |
|---|
| name | string | This string-based column contains the name of the region in English. |
|---|
| namn | string | This string-based column contains the name of the region in Swedish. |
|---|
| nimi | string | This string-based column contains the name of the region in Finnish. |
|---|
| vuosi | double | This real-based column holds year information. |
|---|
