History of AVI Areas 2013 (1:4 500 000) Version Changes
The 'table__history' is part of a dataset collection aimed at preserving and providing insights into historical data. This particular table serves as a historical archive for its base table, storing a version history of each row.
The table is a rich source of information, presenting data related to the AVI regions in 2013 at a scale of 1:4,500,000. The content of the table can be broadly classified into three categories: version information, geographical data, and general information.
The version information includes details about when a row was extracted from the data source and when a new version of the row was extracted. This is made possible through a combination of the 'start date' and 'end date' columns, which also enable the unique identification of each row in the history table.
The geographical data is presented using the WGS 84 coordinate reference system. This subset of data, distinguishable by the 'geom_' prefix in column names, includes details such as the geoJSON and geotext of the regions, type of geometry used, centroid of the geometry, and the x and y coordinates of the center of the geometry. This data can be utilized for geospatial data analytics, aiding in visualizing and understanding spatial patterns and relationships.
The general information includes the row number, AVI code, and other details pertaining to the AVI regions, such as their names in various languages.
This table, sourced from the 'Tilastokeskus' (Statistics Finland) website, can serve various purposes in data analytics. For instance, it could be used for tracking changes in the geographic distribution of AVI regions over time, or for analyzing the spatial characteristics of these regions in relation to other socio-economic factors. Additionally, it can assist in studying data lineage and maintaining the integrity of the base table.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of a unique identifier for each row in this version history table, along with the '_row_number' column. |
| _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 represents the row number in the raw data extracted from the data source. It forms a unique identifier for each row in combination with the '_start_date' column. |
| avi | string | This is a string type column and it is likely to represent a code or identifier corresponding to a particular region or area. |
| geom_geojson | string | This column contains geographical data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geographical data represented as text. It is likely to correspond to the 'geom_geojson' column. |
| geom_type | string | This column specifies the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. In this table, it appears to be 'ST_MULTIPOLYGON', indicating that the geographical data represents multiple polygons. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid, or geometric center, of the geographic areas represented by the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_x | double | This column contains the x-coordinate (longitude) of the geometric center of the geographic areas represented by the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_y | double | This column contains the y-coordinate (latitude) of the geometric center of the geographic areas represented by the 'geom_geojson' and 'geom_geotext' columns. |
| gid | long | This is an integer type column. It could be an identifier for the geographical areas represented in the 'geom_geojson' and 'geom_geotext' columns. |
| gml_id | string | This is a string type column. It seems to be a unique identifier for each row in this table. |
| name | string | This is a string type column, containing the English names of the regions or areas represented in the rows. |
| namn | string | This is a string type column, containing the names of the regions or areas in a different language, possibly Swedish. |
| nimi | string | This is a string type column, containing the names of the regions or areas in a different language, possibly Finnish. |
| vuosi | long | This is an integer type column. It could represent the year associated with the data in the row, based on the sample values provided. |
No sample for this dataset
Additional Information
| Last updated | November 8, 2024 |
|---|---|
| Created | November 8, 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 | e9cc425f-fbdf-4281-b563-eaf3d835366b |
| Package id | 5f49795b-9ea4-4988-a823-159d6fefcf3b |
| Position | 1 |
| Revision id | 6c2a52ec-b526-4233-8863-dc7b6bd8c5be |
| State | active |
| Table | tilastointialueet_avi4500k_2013__table__history |