Statistical Regions Interface Service 2022

This dataset collection comprises a set of data tables that are closely connected. These tables are sourced from the 'Tilastokeskus' (Statistics Finland) website based in Finland. All the data tables are structured in a manner that organizes related data in the form of rows and columns, making them easy to read and understand. The dataset is primarily focused on the service interface of the Statistics Finland, providing valuable insights into various statistical parameters. It's important to note that the dataset is updated periodically to reflect the most recent data available. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

AVI Regions 2022 (Scale 1:4,500,000) - Data TableTSV
The table, a part of the 'tilastointialueet_avi4500k_2022' dataset collection, provides detailed data about 'AVI-alueet 2022 (1:4 500 000)', which translates to 'AVI areas 2022 (1:4 500 000)'. This dataset comes from the 'Tilastokeskus' website, a Finnish statistical resource. The table contains various columns, each offering unique and valuable information. Two special columns are '_extract_date' and '_row_number', which indicate when data was extracted and the row number of extracted data respectively. This pair of columns uniquely identifies each row in the table. Geospatial data is a significant part of the table, as indicated by multiple columns starting with 'geom_'. These columns contain geographical information useful for geospatial data analytics. The geographic coordinates...
Historical Versioning of AVI Areas 2022 (Scale 1:4,500,000)TSV
The history table, belonging to a dataset collection, is a rich resource of data, focusing on version histories of base table rows. Originating from Finland's 'Tilastokeskus' (Statistics Finland), the table presents a trove of data points, from geographical information to unique identifiers. The data can be viewed through a chronological lens with the help of '_start_date' and '_end_date' columns, marking the inception and conclusion of a given row's version. In instances where '_end_date' is null, it signifies the row as the most recent version. Geographical data offered by columns beginning with 'geom_', allows for granular analysis of data points. These columns provide geographic information, using the WGS 84 coordinate reference system, with the axis order being longitude first,...

Column Descriptions

AVI Regions 2022 (Scale 1:4,500,000) - Data Table

Column	Type	Comment
_extract_date	date	This column represents the date when the data in each row was extracted from the source. It is an important column as it helps in tracking the timeline of data extraction.
_row_number	long	This column holds the row number corresponding to the data extracted from the source on the specific extract date. This, in combination with the '_extract_date', uniquely identifies each row.
avi	string	This column contains specific codes representing different areas.
geom_geojson	string	This column holds the geographical data of the areas in GeoJSON format, which is a type of open standard format designed for representing simple geographical features.
geom_geotext	string	This column contains the geographical data in textual format. The format used is dependent on the nature of the geographical data.
geom_type	string	This column describes the type of geographic data represented, such as polygons or multipolygons.
geom_centroid	string	This column contains the geographical coordinates of the centroid, or geometric center, of each area.
geom_center_x	double	This column holds the x-coordinate of the center of the geographical area.
geom_center_y	double	This column holds the y-coordinate of the center of the geographical area.
gml_id	string	This column contains a unique identifier for each row in the GML (Geography Markup Language) format, which is used for expressing geographical features.
id	long	This column contains unique integer identifiers for each row or area.
name	string	This column contains the name of each area in English.
namn	string	This column contains the name of each area in Swedish.
nimi	string	This column contains the name of each area in Finnish.
vuosi	long	This column holds the year of data collection.

Historical Versioning of AVI Areas 2022 (Scale 1:4,500,000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This, along with '_row_number', uniquely identifies each row in the version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. A null value indicates that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source. This, along with '_start_date', uniquely identifies each row in the version history table.
avi	string	A string identifier, possibly representing a region or district code.
geom_geojson	string	Contains geographic data in the format of GeoJSON, a common format for encoding a variety of geographic data structures.
geom_geotext	string	Contains geographic data in a textual format, possibly including polygon or multipolygon representations of geographic areas.
geom_type	string	Specifies the type of the geographic data, such as 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid	string	Contains the point representing the geometric center, or centroid, of the geographic area.
geom_center_x	double	The x-coordinate of the geometric center of the geographic area.
geom_center_y	double	The y-coordinate of the geometric center of the geographic area.
gml_id	string	A unique string identifier for the row.
id	long	An integer identifier for the row.
name	string	The English name of the entity represented by the row.
namn	string	The name of the entity represented by the row in a non-English language, possibly Swedish or Finnish.
nimi	string	Another non-English name for the entity represented by the row, possibly in Finnish.
vuosi	long	An integer, possibly representing the year associated with the row.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024