Statistics Bureau Service Interface (WFS) - 2014 Regional Statistical Area Collection

This dataset collection is a compilation of diverse tables that are interconnected and provide a complete and insightful view of a particular subject matter. The tables are sourced from the 'Tilastokeskus' (Statistics Finland) website, based in Finland. The description provided by the data source, when translated to English, is 'Statistics Finland Service Interface (WFS)'. These descriptions suggest that the dataset collection provides statistics data served over a Web Feature Service (WFS), which is a standard protocol for serving geographic information over the internet. The dataset collection encapsulates data in a structured and organized manner, making it easy for users to extract the information they need. 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 Variations of Finnish Regional Divisions (2014)TSV
The 'table__history' is a comprehensive history table that contains detailed version history information for each row of its base table. This data is sourced from the 'Tilastokeskus' website, based in Finland. The table is part of a dataset collection that examines regional statistical areas in Finland, providing historical data from the year 2014. Each row in the table is uniquely identified by a combination of the row number and the start date. The row number refers to the position of the row in the raw data, while the start date indicates when the row was initially extracted from the data source. To track changes, the table includes an end date column, which records when a new version of the row was extracted. If the end date is null, this signifies that the current row is the most...
Regional Units 2014 (1:1 000 000) - Extracted DataTSV
The table in question is part of a dataset collection focused on statistical regions in Finland from the year 2014. Sourced from 'Tilastokeskus' (Statistics Finland), the table provides a comprehensive set of information regarding these regions. It includes geographic details such as coordinates, geojson and geotext data, and geometric types and centroids, all of which are applicable for geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, where the order is always longitude first, followed by latitude. In addition to the geographic data, the table also provides the names of the regions in multiple languages and an identifier for each region. The data content of this table could be utilized in several ways. For instance, it...

Column Descriptions

Regional Units 2014 (1:1 000 000) - Extracted Data

Column	Type	Comment
_extract_date	date	This column contains the date when the row data was extracted from the source. It helps to identify the freshness of the data.
_row_number	long	This column contains the unique row number of the data as it was extracted from the source. This, in combination with '_extract_date', can be used to uniquely identify each row.
geom_geojson	string	This column contains the geometric data of the area in GeoJSON format, a popular open standard format designed for representing simple geographical features.
geom_geotext	string	This column contains the geometric data of the area in geotext format. Essentially, it is the textual representation of the geometric data.
geom_type	string	This column describes the type of the geometric data represented. For example, it contains values like 'ST_MULTIPOLYGON' indicating that the geographical area is represented as a multipolygon.
geom_centroid	string	This column contains the centroid or the geometric center of the area. It is represented as a point value.
geom_center_x	double	This column contains the X coordinate of the center of the geographical area.
geom_center_y	double	This column contains the Y coordinate of the center of the geographical area.
gml_id	string	This column contains a unique identifier for each geographical area.
name	string	This column contains the English name of the geographical area.
namn	string	This column contains the name of the geographical area in the local language.
nimi	string	This column contains another local name for the geographical area.
seutukunta	string	This column contains specific codes associated with each geographical area.
vuosi	long	This column represents the year corresponding to the data row. It helps to identify the temporal context of the data.

Historical Variations of Finnish Regional Divisions (2014)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source, marking the beginning of the version's validity period. It forms a unique identifier in combination with the '_row_number'.
_end_date	date	It records the date when a new version of the row was extracted from the data source, indicating the end of the version's validity. If the value is null, it signifies 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 forms a unique identifier in combination with the '_start_date'.
geom_geojson	string	This column stores the geometric data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geometric data in text format, which provides a human-readable representation of the geographic data.
geom_type	string	It specifies the type of the geometric object that the row represents. The sample values suggest that the geometric objects are of type 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the central point (centroid) of the geometric object. It is a point that defines a geometric object's center of gravity.
geom_center_x	double	This column contains the X coordinate of the central point of the geometric object.
geom_center_y	double	It contains the Y coordinate of the central point of the geometric object.
gml_id	string	This column contains a string identifier for the row as provided by the source.
name	string	This column contains the name of the region as provided by the source.
namn	string	This column contains an alternate name for the region in another language.
nimi	string	This column contains another alternate name for the region in yet another language.
seutukunta	string	This column contains a string identifier for the region as provided by the source.
vuosi	long	This column contains the year associated with the data in the row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024