Statistics Agency Interface Collection (2017)

The dataset collection in question is composed of related tables of data, sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. These tables provide comprehensive statistical data, which are organized in a structured format of rows and columns. The information from the data source, Tilastokeskuksen palvelurajapinta (WFS), translates to 'Statistics Finland's Service Interface (WFS)'. This suggests that the data is provided through a web feature service, which allows users to manipulate and analyze spatial data. In essence, this dataset collection provides valuable statistical information related to specific areas, presented in a format that allows for in-depth analysis and interpretation. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Geospatial Distribution of Administrative Regions in 2017 (Scale 1:4,500,000)TSV
The table, part of the dataset collection, represents the AVI areas for the year 2017, at a scale of 1:4 500 000, sourced from the 'Tilastokeskus' website, located in Finland. The data includes geographic information, which is 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 data also includes details such as the name of the AVI area in different languages, and an identifying number for each AVI area. For instance, one could find the Finnish, English, and another language name for 'Southern Finland AVI'. This multi-language data could aid international research or studies requiring bilingual/multilingual data. Two columns,...
Version History of AVI Areas 2017 (1:4 500 000) TableTSV
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...

Column Descriptions

Geospatial Distribution of Administrative Regions in 2017 (Scale 1:4,500,000)

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the data source.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
avi	string	This is a string column that may contain numerical values.
geom_geojson	string	This column contains geojson data, which is a format for encoding geographic data structures.
geom_geotext	string	This column contains geographical data in text format.
geom_type	string	This column specifies the type of the geographical data structure.
geom_centroid	string	This column contains the coordinates of the centroid point of the geographical structure.
geom_center_x	double	This column contains the x-coordinate of the center point of the geographical structure.
geom_center_y	double	This column contains the y-coordinate of the center point of the geographical structure.
gid	long	This is an integer column that may contain numerical values.
gml_id	string	This is a string column that may contain unique identifiers.
name	string	This is a string column that may contain names in English.
namn	string	This is a string column that may contain names in a language other than English.
nimi	string	This is a string column that may contain names in a language other than English.
vuosi	double	This is a real type column that may contain numerical values, possibly representing years.

Version History of AVI Areas 2017 (1:4 500 000) Table

Column	Type	Comment
_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.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024