Statistics Area Interface (WFS) - 2018 Dataset Collection

The dataset collection in question features several related tables of data, sourced from the Statistical Centre's Service Interface (WFS), the English translation for 'Tilastokeskus' in Finland. These tables are closely interlinked, forming a comprehensive collection of data which is organized in a systematic manner, allowing for easy analysis and interpretation. The data within this collection is highly structured, adhering to a table format with distinct columns and rows, making it easy to identify relationships and draw comparisons between different sets of data. Given the source of this data, it can be inferred that the information contained within this dataset collection is highly reliable and statistically significant. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2018 Regional Administrative Agencies' Areas (Scale 1:4 500 000)TSV
The table, part of the 'tilastointialueet_avi4500k_2018' dataset collection, carries data pertaining to the 2018 AVI regions in Finland. The data is sourced from 'Tilastokeskus' (Statistics Finland), a reliable source of statistical information in Finland. The table contains several columns that capture various details about each region. Of particular note are '_extract_date' and '_row_number', which respectively indicate when the data was extracted and the row number in the extraction. The combination of these two columns uniquely identifies each row of data. The dataset contains geographic information captured in columns beginning with 'geom_'. These provide a detailed mapping of each region, including the type of geometry used to represent the region (e.g., multipolygon), the...
Historical Versioning of AVI Regions 2018 Dataset (1:4 500 000 Scale)TSV
The 'table__history' is a history table storing detailed version information of its base table rows, sourced from the 'Tilastokeskus' (Statistics Finland) website. The table is part of the 'tilastointialueet_avi4500k_2018' dataset collection. The table includes a variety of columns encapsulating different types of data. Included among these are columns containing geographic information, which can be 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 table data is relevant to the 'AVI-alueet 2018 (1:4 500 000)' or 'AVI regions 2018 (1:4 500 000)'. This suggests that the table could contain statistical information about different...

Column Descriptions

2018 Regional Administrative Agencies' Areas (Scale 1:4 500 000)

Column	Type	Comment
_extract_date	date	This column contains the date when the data row was extracted from the data source. It helps in understanding the timeline of the data extraction.
_row_number	long	This column contains the row number of the data extracted from the source on the specified extract date. It, along with the '_extract_date', uniquely identifies each row.
avi	string	This column contains numerical identifiers, possibly representing different areas or regions.
geom_geojson	string	This column contains geographical data in GeoJSON format, a popular open standard format designed for representing simple geographical features.
geom_geotext	string	This column contains geographical data in text format. It might represent geographical features as polygons.
geom_type	string	This column describes the type of the geographical data contained in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the geographical coordinates of the centroid of the geographical feature represented in other 'geom' columns.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical feature represented in other 'geom' columns.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical feature represented in other 'geom' columns.
gml_id	string	This column contains unique identifiers in the form of strings.
id	long	This column contains numerical identifiers, likely representing unique entries in the table.
name	string	This column contains names in English language, possibly representing the names of the areas or regions.
namn	string	This column contains names in a non-English language, possibly representing the names of the areas or regions.
nimi	string	This column contains names in another non-English language, possibly representing the names of the areas or regions.
vuosi	long	This column contains integer values, likely representing the year associated with the data in the row.

Historical Versioning of AVI Regions 2018 Dataset (1:4 500 000 Scale)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It's part of a unique identifier for each row in the version history table when combined 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 means 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's part of a unique identifier for each row in the version history table when combined with '_start_date'.
avi	string	This is a string column representing some sort of identifier in the original data.
geom_geojson	string	This column contains the geographical data in GeoJSON format, likely representing the boundaries of a statistical area.
geom_geotext	string	This column contains the geographical data in text format, likely representing the boundaries of a statistical area.
geom_type	string	This column specifies the type of the geographical data contained in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the geographical coordinates of the centroid (center) of the area represented by the geographical data.
geom_center_x	double	This column contains the X coordinate (longitude) of the centroid of the area.
geom_center_y	double	This column contains the Y coordinate (latitude) of the centroid of the area.
gml_id	string	This is a string column representing a unique identifier in the original data.
id	long	This is an integer column representing a unique identifier in the original data.
name	string	This string column contains the name of the statistical area in English.
namn	string	This string column contains the name of the statistical area in another language.
nimi	string	This string column contains the name of the statistical area in another language.
vuosi	long	This integer column represents a year, likely the year the data was collected or the year the statistical area was defined.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024