Statistics Interface Service (WFS) Dataset Collection 2016

This dataset collection originates from the Statistics Center's service interface (WFS) from the website of Tilastokeskus (Statistics Finland) in Finland. The collection encompasses a group of related data tables that provide detailed statistical information. While the specifics of the data within the tables are not specified, they typically include a variety of columns and rows presenting related data points. The dataset is named to reflect the year 2016, suggesting that the data contained within may be specific to that period. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2016 Major Areas Dataset (Scale 1:4 500 000)TSV
The table in question is part of a dataset that pertains to 'Suuralueet 2016 (1:4 500 000)', which translates to Major Areas 2016 (1:4 500 000). This dataset is hosted on the 'Tilastokeskus' (Statistics Finland) website, which is based in Finland. The table's data primarily revolves around geospatial information pertaining to these major areas, with a special focus on data extracted in the year 2016. The data in the table is organized via a series of columns. Two key columns, '_extract_date' and '_row_number', are used to identify each row uniquely. The '_extract_date' column indicates the date when the row's data was collected, while '_row_number' signifies the row's specific position in the sequence of data extraction. A significant portion of the columns start with 'geom_',...
History Version of Large Areas 2016 (Scale 1:4 500 000)TSV
The history table is part of a dataset collection that captures vital information about major regions in Finland during the year 2016. This table contains a record of various versions of each row, allowing for historical tracking of changes. Each row is uniquely identified by a combination of the start date of data extraction and a row number. The start date signifies the day the row was extracted from the data source, while an end date represents the day a new version of the same row was extracted. If the end date is null, it implies that this is the most recent version of the row. The data in this table provides a wealth of information. For instance, it includes geographical data that can be used for geospatial analytics. This data is presented using the WGS 84 coordinate reference...

Column Descriptions

2016 Major Areas Dataset (Scale 1:4 500 000)

Column	Type	Comment
_extract_date	date	The date when the data on the row of the table was extracted from the data source.
_row_number	long	The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This combination uniquely identifies each row.
geom_geojson	string	The geometric representation of the data in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotext	string	The geometric representation of the data in text format.
geom_type	string	The type of the geometric representation, in this case, it is 'ST_MULTIPOLYGON', indicating the data represents multiple polygonal areas.
geom_centroid	string	The centroid, or geometric center of the polygonal area.
geom_center_x	double	The X-coordinate of the center of the polygonal area.
geom_center_y	double	The Y-coordinate of the center of the polygonal area.
gml_id	string	The unique identifier for each row in String format.
name	string	The English name of the area.
namn	string	The Swedish name of the area.
nimi	string	The Finnish name of the area.
suuralue	string	An identifier for the large area, stored as a String.
vuosi	double	The year of the data, stored as Real type.

History Version of Large Areas 2016 (Scale 1:4 500 000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This, combined with '_row_number', uniquely identifies each row in the history table.
_end_date	date	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	The number of the row in the raw data extracted from the data source. This, combined with '_start_date', uniquely identifies each row in the history table.
geom_geojson	string	The geometric data of the area in GeoJSON format.
geom_geotext	string	The geometric data of the area in text format.
geom_type	string	The type of the geometric data, which in this case is a multipolygon.
geom_centroid	string	The centroid point of the geometric data.
geom_center_x	double	The X coordinate of the center point of the geometric data.
geom_center_y	double	The Y coordinate of the center point of the geometric data.
gml_id	string	A unique identifier for each row.
name	string	The English name of the area.
namn	string	The Swedish name of the area.
nimi	string	The Finnish name of the area.
suuralue	string	A code that represents the area.
vuosi	double	The year, represented as a real number.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024