Statistics Finland's Service Interface (WFS) - Dataset Collection 2013

This dataset collection contains a group of related data tables, sourced from 'Tilastokeskus' (Statistical Centre), a website based in Finland. All tables in this collection are organized in a structured table format, consisting of rows and columns that hold related data. The data contained in this collection stems from the Statistics Centre's service interface (WFS). Each table within this collection contributes to a larger, more comprehensive view of the data, providing a detailed statistical overview relevant to the dataset's context. Please note that the specifics of the data content are determined by the nature of the data source and the information they choose to include in their service interface. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Large Areas 2013 - Geospatial Data at 1:1 Million ScaleTSV
The table in discussion is a part of a larger dataset collection, and it offers detailed geospatial data, specifically focusing on the larger areas of Finland in 2013. The contents of the table, translating from Finnish, can be described as 'Larger Areas 2013 (1:1 000 000)'. This indicates that the table provides data related to geographical areas in Finland, collected in the year 2013, at a scale of 1:1 million. The data in this table is organized into numerous columns, each offering a unique piece of information. Key columns hold data about the extraction date and row number, with each row being uniquely identified by a combination of these two. This means that the table offers a well-structured timeline of data extraction, which can be crucial in understanding data trends over time....
Version History of Major Regions in 2013 (1:1 000 000 Scale)TSV
The 'table__history' is a valuable resource that captures the version history of its base table rows. This table belongs to the dataset collection 'tilastointialueet_suuralue1000k_2013', which provides a wealth of information about the 'Large Areas 2013' at a scale of 1:1 000 000. The data in this table is sourced from the Finnish Statistics Bureau (Tilastokeskus) website, making it a reliable source for researchers and data analysts. The table is unique in its structure as it incorporates specific columns that provide insights into the extraction and version history of each row. These special columns include the 'start date' and 'end date', which respectively indicate when the row was extracted from the data source and when a new version of the row was extracted. Furthermore, each row...

Column Descriptions

Large Areas 2013 - Geospatial Data at 1:1 Million Scale

Column	Type	Comment
_extract_date	date	This column contains the date on which the data in the respective row was extracted from the source. It is a special column that, in combination with '_row_number', uniquely identifies each row.
_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 is a special column that, along with '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains the geographical data of the area in GeoJSON format, a popular open standard format designed for representing simple geographical features, along with their non-spatial attributes.
geom_geotext	string	This column contains the geographical data of the area in WKT (Well-Known Text) format, a text markup language for representing vector geometry objects.
geom_type	string	This column specifies the type of the geographical data. In this case, the type is 'ST_MULTIPOLYGON', indicating that the geographical data represents multiple polygons.
geom_centroid	string	This column contains the centroid point of the geographical data. The centroid is the geometric center of a plane figure or shape.
geom_center_x	double	This column represents the x-coordinate of the center of the geographical data.
geom_center_y	double	This column represents the y-coordinate of the center of the geographical data.
gml_id	string	This column contains a unique identifier for each geographical area.
name	string	This column contains the English name of the area.
namn	string	This column contains the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
suuralue	string	This column contains a numeric identifier for the area.
vuosi	long	This column contains the year related to the data. In this case, all data is from the year 2013.

Version History of Major Regions in 2013 (1:1 000 000 Scale)

Column	Type	Comment
_start_date	date	This column indicates 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 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 is part of a combination with '_start_date' that uniquely identifies each row in this version history table.
geom_geojson	string	Contains the geometric data of the area in GeoJSON format, a type of format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geometric data of the area in text format.
geom_type	string	This column indicates the type of the geometric data. In this case, the type is ST_MULTIPOLYGON, which represents a shape that is a collection of polygons.
geom_centroid	string	This column contains the centroid of the geometric data, which is the center point of the shape.
geom_center_x	double	This column shows the x-coordinate of the geometric center of the shape.
geom_center_y	double	This column shows the y-coordinate of the geometric center of the shape.
gml_id	string	This is a unique identifier for each row. It is a string type data.
name	string	This column contains the name of the area in English.
namn	string	This column contains the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
suuralue	string	This column contains an identifier for the large area (suuralue) that the data point belongs to. It is a string type data.
vuosi	long	This column contains the year of the data. It is an integer type data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024