Statistical Area Dataset Collection 2013
Source
Tilastokeskus
Description
This dataset collection is an assembly of data tables sourced from the website of the Finnish agency, 'Tilastokeskuksen' (Statistics Finland). The collection includes statistical data about various regions in Finland. Each table in the collection offers a unique perspective, providing a comprehensive understanding of the subject matter. The data is organized in a table format, making it easy to interpret and analyze. As part of the collection, each table shares a relationship with the others, contributing to the overall understanding of the statistical areas under examination. The dataset was accessed through the 'Tilastokeskuksen palvelurajapinta (WFS)' (Statistics Finland's Service Interface), underscoring its reliability and accuracy. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).
Keywords
No keywords
Version History of AVI Regions 2013 (Scale 1:1,000,000)
Fetching map
Description
The 'table__history' is a historical table that holds the version history of its base table rows, sourced from the 'Tilastokeskus' website in Finland. This table belongs to the 'tilastointialueet_avi1000k_2013' dataset collection and includes several notable columns.
This table is a version of the AVI areas 2013 (1:1 000 000) base table with additional columns to track changes over time. Specifically, the table has two additional date-related columns '_start_date' and '_end_date'. The '_start_date' column holds the date when the row was extracted from the source, and '_end_date' represents when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row is the most recent version. In conjunction with the '_row_number' column, which denotes row numbers from the raw data, these columns serve to uniquely identify each row in this history table.
The table further provides detailed geographic data in columns starting with 'geom_', which can be leveraged for geospatial data analytics. This geographic information is presented using the WGS 84 coordinate reference system, with the order of longitude first, followed by latitude.
The data in this table, such as AVI areas and their geographic locations, could be used for a variety of analytical purposes. For instance, analysts could track changes in geographic areas over time, comparing different versions of the data. In addition, the geospatial information could be used to visualize the spatial distribution of AVI areas, providing insights into patterns and trends. The historical data also allows for the analysis of data trends over time, which could be crucial in strategic planning and policy-making.