Historical Versioning of AVI Regions 2018 Dataset (1:4 500 000 Scale)
The 'table__history' is a history table storing detailed version information of its base table rows, sourced from the 'Tilastokeskus' (Statistics Finland) website. The table is part of the 'tilastointialueet_avi4500k_2018' dataset collection. The table includes a variety of columns encapsulating different types of data. Included among these are columns containing geographic information, which can be particularly useful for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table data is relevant to the 'AVI-alueet 2018 (1:4 500 000)' or 'AVI regions 2018 (1:4 500 000)'. This suggests that the table could contain statistical information about different regions, specifically for the year 2018. The data within this table could be utilized for a broad range of analysis purposes, such as understanding regional trends or patterns over time.
One of the unique features of this table is its ability to track changes over time, which is accomplished through the '_start_date', '_end_date', and '_row_number' columns. The '_start_date' column records the date when the row was extracted from the data source, while the '_end_date' signifies 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. Meanwhile, the '_row_number' column keeps track of the row count in the raw data. Together, the '_start_date' and '_row_number' form a combination that uniquely identifies each row in this version history table.
This historical tracking can be instrumental in data analytics, for instance, to understand how regional statistics have evolved over time, or to track the changes in geographical boundaries. Moreover, the geographic data can be used for geospatial analytics, such as determining the centrality of certain regions or understanding spatial patterns and relationships.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It's part of a unique identifier for each row in the version history table when combined 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 means 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's part of a unique identifier for each row in the version history table when combined with '_start_date'. |
| avi | string | This is a string column representing some sort of identifier in the original data. |
| geom_geojson | string | This column contains the geographical data in GeoJSON format, likely representing the boundaries of a statistical area. |
| geom_geotext | string | This column contains the geographical data in text format, likely representing the boundaries of a statistical area. |
| geom_type | string | This column specifies the type of the geographical data contained in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid (center) of the area represented by the geographical data. |
| geom_center_x | double | This column contains the X coordinate (longitude) of the centroid of the area. |
| geom_center_y | double | This column contains the Y coordinate (latitude) of the centroid of the area. |
| gml_id | string | This is a string column representing a unique identifier in the original data. |
| id | long | This is an integer column representing a unique identifier in the original data. |
| name | string | This string column contains the name of the statistical area in English. |
| namn | string | This string column contains the name of the statistical area in another language. |
| nimi | string | This string column contains the name of the statistical area in another language. |
| vuosi | long | This integer column represents a year, likely the year the data was collected or the year the statistical area was defined. |
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 | eea77b64-77a5-422b-8ca9-148675ba1085 |
| Package id | ea64c4b0-cd83-4d90-a660-05624ccf8f15 |
| Position | 1 |
| Revision id | 8b1e2a02-26d0-4242-ad9d-d741de383670 |
| State | active |
| Table | tilastointialueet_avi4500k_2018__table__history |