Statistics Bureau Service Interface (WFS): Comprehensive Data Tables Collection

The dataset collection in question is a compilation of related data tables sourced from the 'Tilastokeskus' (Statistics Finland) website. This collection comprises multiple tables, each of which represents a distinct year. The information within these tables is organised into columns and rows, facilitating easy data analysis and interpretation. The content of these tables is provided by the WFS service interface of Statistics Finland, ensuring a high level of accuracy and reliability. The data covers a range of years, providing a comprehensive overview of the subject matter over time. This collection is a valuable resource for those looking to conduct in-depth analysis or research in the relevant field. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Versioning of AVI Regions (1:1 000 000)TSV
The 'table__history' is a historical record of the AVI areas (1:1 000 000) table, providing a chronological view of the data changes. The table is part of the 'tilastointialueet_avi1000k' dataset collection, which is sourced from the 'Tilastokeskus' website in Finland. It is a valuable resource for understanding the evolution of AVI areas over time. The table consists of several columns that contain a variety of data types. It presents geographic data, which is particularly useful for geospatial analytics. The geographic data, represented in columns starting with 'geom_', uses the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This geographic information includes the type, the GeoJSON and geotext representations, the centroid, and...
Regional Administrative Agency Areas (Scale 1:1,000,000) - Data TableTSV
The table under consideration belongs to a dataset collection named 'Tilastointialueet_avi1000k'. It comprises of a diverse set of columns that carry a rich variety of data, including specific geographic information, identifiers and names, among other elements. The table is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. One of the key components of the table is the geographic information contained in several columns, all beginning with the prefix 'geom_'. These contain various forms of geographic details such as geographic coordinates, which are presented using the WGS 84 coordinate reference system. The axis order for these coordinates follows the structure: longitude first, followed by latitude. This geographical data is particularly valuable for...

Column Descriptions

Regional Administrative Agency Areas (Scale 1:1,000,000) - Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. It plays a crucial role in uniquely identifying each row in combination with the '_row_number' column.
_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'. It uniquely identifies each row when used in conjunction with the '_extract_date' column.
avi	string	This column contains string values which might be identifiers or codes for a certain feature or entity in the dataset.
geom_geojson	string	This column contains geographic data in the GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geographic data in textual format, probably representing various geographic features.
geom_type	string	This column specifies the type of geographic data stored in the 'geom_geotext' and 'geom_geojson' columns. It appears to contain a single, constant value 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the coordinates of the centroid, or geometric center, of the feature represented in the 'geom_geotext' and 'geom_geojson' columns.
geom_center_x	double	This column contains the X coordinate of the geometric center of the feature represented in the 'geom_geotext' and 'geom_geojson' columns.
geom_center_y	double	This column contains the Y coordinate of the geometric center of the feature represented in the 'geom_geotext' and 'geom_geojson' columns.
gml_id	string	This column contains unique identifiers for each row, likely sourced from the original data source.
id	long	This column contains integer values, possibly representing unique identifiers for the entities or features referenced in the dataset.
name	string	This column contains string values, likely representing the names of the entities or features in English language.
namn	string	This column contains string values, likely representing the names of the entities or features in another language, possibly Swedish.
nimi	string	This column contains string values, likely representing the names of the entities or features in Finnish language.
vuosi	long	This column contains integer values, possibly indicating the year associated with the data on each row.

Historical Versioning of AVI Regions (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a combination with '_row_number' to uniquely identify each row in this version history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If its value is null, that indicates 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 is part of the unique identifier of each row in combination with '_start_date'.
avi	string	This string type column is sourced from the base table.
geom_geojson	string	This column contains geospatial data in GeoJSON format.
geom_geotext	string	This column contains geospatial data in text format.
geom_type	string	This column describes the type of the geospatial data.
geom_centroid	string	This column contains the centroid of the geospatial data.
geom_center_x	double	This column contains the x-coordinate of the geospatial data center.
geom_center_y	double	This column contains the y-coordinate of the geospatial data center.
gml_id	string	This string type column is sourced from the base table.
id	long	This integer type column is sourced from the base table.
name	string	This string type column is sourced from the base table.
namn	string	This string type column is sourced from the base table.
nimi	string	This string type column is sourced from the base table.
vuosi	long	This integer type column is sourced from the base table.

Additional Info

Last Updated	November 13, 2024
Created	November 8, 2024