Statistics Center Service Interface (WFS) - Comprehensive Dataset Collection for Province-level Regions

This dataset collection is a compilation of related tables sourced from the Statistics Finland (Tilastokeskus) website, based in Finland. The tables form a comprehensive and cohesive collection, with each table representing a unique set of related data. The data in these tables have been compiled over several years, providing a rich historical perspective. The dataset is provided via the Statistical Office's service interface (WFS), which is a testament to its reliability and credibility. The collection is meticulously organized into rows and columns, making it easy to understand and analyze. It offers a wealth of information and insights, making it a valuable resource for anyone interested in statistical data from Finland. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regions Data (1:4 500 000 scale)TSV
The table is a part of a larger dataset collection, representing Regions at 1:4 500 000 scale. It contains a wealth of information, both quantitative and qualitative, with a particular focus on geospatial data. This data is organized into various columns, each containing a different type of information. For instance, two of these columns specify when the data on each row was extracted and the row number in the data extracted, which together can uniquely identify each row. Furthermore, several columns contain geographic information, presented using the WGS 84 coordinate reference system, which can be utilized for geospatial data analytics. This geographic data includes the type of geometric shape that represents the region (e.g., polygon or multipolygon), the geometric shape itself in...
Version History of 'Counties at 1:4 500 000 Scale' TableTSV
The 'table__history' is a comprehensive historical record of geographical information derived from the dataset collection 'tilastointialueet_maakunta4500k'. This table maintains the version history of its base table rows, capturing alterations and updates over time. It includes the base table contents of 'Maakunnat' which can be translated to 'Regions' in English, offering a detailed geographical representation at a scale of 1:4 500 000. The table contains multiple columns capturing varied data points. The '_start_date' and '_row_number' columns together uniquely identify each row in this version history table. The '_start_date' records the date a row was extracted from the original data source, while the '_end_date' denotes the date when a new version of the row was extracted. If the...

Column Descriptions

Regions Data (1:4 500 000 scale)

Column	Type	Comment
_extract_date	date	This column represents the date when the data on the row 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'. The combination of '_extract_date' and '_row_number' uniquely identifies each row.
geom_geojson	string	This column holds the geographical data in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column holds the geographical data in textual format. It is a human-readable description of the shape of the geographical region.
geom_type	string	This column specifies the type of the geographical data. It could be either a Polygon or a Multipolygon.
geom_centroid	string	This column holds the centroid of the geographical region. The centroid is the arithmetic mean position of all the points in the shape.
geom_center_x	double	This column represents the x-coordinate of the center of the geographical region.
geom_center_y	double	This column represents the y-coordinate of the center of the geographical region.
gml_id	string	This column contains the unique identifier of the row in the table.
maakunta	string	This column represents a region in Finland, which is the country where the data source is located.
name	string	This column contains the English name of the region in Finland.
namn	string	This column contains the name of the region in Swedish, which is one of the official languages in Finland.
nimi	string	This column contains the name of the region in Finnish, which is the national language of Finland.
vuosi	long	This column contains the year when the data was collected.

Version History of 'Counties at 1:4 500 000 Scale' Table

Column	Type	Comment
_start_date	date	This column holds the date when a record was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in this version history table.
_end_date	date	This column contains the date when a new version of a record was extracted from the data source. If the value of this column is null, it indicates that the record is the most recent version.
_row_number	long	This column contains the number of the row as in the raw data extracted from the source. It forms a unique identifier in combination with the '_start_date' column for each row in this version history table.
geom_geojson	string	This column contains geographical data in the GeoJSON format. It can represent a variety of geographical features, such as polygons and multipolygons.
geom_geotext	string	This column contains geographical data in a text-based format. Like the 'geom_geojson' column, it can represent a variety of geographical features.
geom_type	string	This column indicates the type of geographical feature represented in the 'geom_geojson' and 'geom_geotext' columns. Values can include 'ST_MULTIPOLYGON' and 'ST_POLYGON'.
geom_centroid	string	This column contains the geographical point that represents the centroid of the geographical feature.
geom_center_x	double	This column contains the X-coordinate of the center of the geographical feature.
geom_center_y	double	This column contains the Y-coordinate of the center of the geographical feature.
gml_id	string	This column contains a unique identifier for each geographical feature that is represented in the table.
maakunta	string	This column contains the code for the region that the geographical feature represents.
name	string	This column contains the English name of the region that the geographical feature represents.
namn	string	This column contains the name of the region in a language other than English and Finnish (likely Swedish, given the region).
nimi	string	This column contains the Finnish name of the region that the geographical feature represents.
vuosi	long	This column contains the year associated with the record. Given the nature of the table, this likely represents the year the data was collected or relevant to.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024