Statistics Bureau Service Interface (WFS) - Dataset Collection 2023

The dataset collection at hand pertains to a group of related tables sourced from 'Tilastokeskus' (Statistical Bureau), located in Finland. These tables are carefully curated and organized in a format that allows easy understanding and analysis of the data they contain. The data is derived via the Statistical Bureau's service interface, ensuring its reliability and accuracy. This collection is a valuable resource for researchers and analysts looking for substantial and reliable data. As per the information provided by the data source, the tables in this collection have been extracted through a service interface, which emphasizes their credibility and precision. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regional Administrative Agencies (AVI) Areas Forecast for 2023 (Scale 1:4,500,000)TSV
The table in question, sourced from the 'Tilastokeskus' (Statistics Finland) website, is part of the 'tilastointialueet_avi4500k_2023' dataset collection. The table's content revolves around AVI regions for the year 2023 at a scale of 1:4,500,000. This includes sections like the geographic geojson, geotext, and type data, which can be employed for geospatial data analytics. The geographic coordinates are configured using the WGS 84 coordinate reference system, where longitude is followed by latitude. It also contains data on the geographical center, with separate columns for longitude (geom_center_x) and latitude (geom_center_y). The table also contains rows that identify each AVI region, providing names in multiple languages. The 'avi' column represents the identification number of...
Version History of AVI Areas 2023 Data TableTSV
The 'table__history' is a unique collection of data that maintains a record of the version history of its base table rows. It is part of a larger dataset collection focused on statistical regions for the year 2023, depicted at a 1:4,500,000 scale. This history table is an enriched version of its base table, with two additional columns that track the time span of each row's validity, making it a valuable resource for analyzing changes over time. The table is sourced from the 'Tilastokeskus' website based in Finland. The table includes various columns that store diverse types of data. For instance, some columns hold geographical data in the form of geographic coordinates, enabling geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference...

Column Descriptions

Regional Administrative Agencies (AVI) Areas Forecast for 2023 (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 column, of string type, contains numerical identifiers. For example, values like 3, 4, 1 can be found in this column.
geom_geojson	string	This column contains geographical data in GeoJSON format, a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geographical data presented as text.
geom_type	string	This column contains the type of geographical data stored in the row, such as 'ST_POLYGON' or 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the centroid of the geographic data stored in the row.
geom_center_x	double	This column contains the x-coordinate of the center of the geographic data.
geom_center_y	double	This column contains the y-coordinate of the center of the geographic data.
gml_id	string	This column, of string type, contains unique identifiers, possibly related to the geographic data.
id	long	This column, of integer type, contains identifiers. These identifiers may correlate with the 'avi' column.
name	string	This column, of string type, contains names in English language. These names might be related to the geographic areas represented by the geographical data.
namn	string	This column, of string type, contains names possibly in Swedish language.
nimi	string	This column, of string type, contains names presumably in Finnish language.
vuosi	long	This column, of integer type, contains the year related to the data in the row.

Version History of AVI Areas 2023 Data Table

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It is part of a combination with '_row_number' that uniquely identifies 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 the value of this column 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. Together with '_start_date', it forms a unique identifier for each row in the version history table.
avi	string	This column contains a string value representing a unique identifier.
geom_geojson	string	This column contains the geometric representation of the data in GeoJSON format.
geom_geotext	string	This column contains the geometric representation of the data in text format.
geom_type	string	This column indicates the type of the geometric data.
geom_centroid	string	This column contains the centroid point of the geometric data.
geom_center_x	double	This column contains the x-coordinate of the center of the geometric data.
geom_center_y	double	This column contains the y-coordinate of the center of the geometric data.
gml_id	string	This column contains a unique identifier in GML format.
id	long	This column contains an integer value representing a unique identifier.
name	string	This column contains the name in English.
namn	string	This column contains the name in Swedish.
nimi	string	This column contains the name in Finnish.
vuosi	long	This column contains an integer value representing the year.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024