Statistics Finland Service Interface (WFS) - 2017 Regional Statistical Area Dataset Collection

This dataset collection contains a group of related data tables, all of which are sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. These tables are structured in a format consisting of columns and rows, encompassing a wide array of related information. The data is provided via the Statistics Finland's service interface, which is a reliable source for comprehensive and detailed statistical data. The data tables in the collection are interconnected, providing a substantial body of information for detailed analysis. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

ELY Regions 2017 (1:4 500 000) - Data TableTSV
The table encapsulates data pertaining to the ELY Centres in Finland for the year 2017, as sourced from the 'Statistics Finland' (Tilastokeskus) website. Each row of the table represents an individual ELY Centre, with relevant information organized in various columns. The table provides geographic information for each ELY Centre. This includes the geographic shape ('geom_geojson', 'geom_geotext'), type of geometry ('geom_type'), centroid of the geographic shape ('geom_centroid'), and the geographic center coordinates ('geom_center_x', 'geom_center_y'). The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This geographic information can be utilized for geospatial analytics, such as spatial...
Version History of ELY Areas 2017 (1:4 500 000) TableTSV
The 'table__history' is a history table that contains the version history of its base table rows, sourced from 'Tilastokeskus' in Finland. The table is part of a larger dataset collection and each row in this table is uniquely identified by a combination of the start date and row number. The table captures the date when each row was extracted from the data source and when a new version of the row was extracted. If the end date is null, it indicates that the row is the most recent version. This table provides comprehensive data on ELY-areas in 2017 at a scale of 1:4 500 000, with each row representing an ELY area. The data includes geographic information which can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference...

Column Descriptions

ELY Regions 2017 (1:4 500 000) - Data Table

Column	Type	Comment
_extract_date	date	The date when the data on the row was extracted from the data source. This, in combination with '_row_number', uniquely identifies each row.
_row_number	long	The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This, in combination with '_extract_date', uniquely identifies each row.
ely	string	A string code representing a specific region, as defined by the source.
geom_geojson	string	Geospatial data in GeoJSON format, typically representing the geometry of the region identified by the 'ely' code.
geom_geotext	string	Geospatial data in a textual format, typically representing the geometry of the region identified by the 'ely' code.
geom_type	string	The type of the geospatial data represented in 'geom_geojson' and 'geom_geotext'.
geom_centroid	string	The geospatial coordinates of the centroid of the region represented by the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	The x-coordinate of the center of the region represented by the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y	double	The y-coordinate of the center of the region represented by the 'geom_geojson' and 'geom_geotext' columns.
gid	long	An integer identifier, possibly corresponding to the region represented by the 'ely' code.
gml_id	string	A unique string identifier for each row, provided by the source.
name	string	The English name of the region represented by the 'ely' code.
namn	string	The name of the region represented by the 'ely' code in another language.
nimi	string	The name of the region represented by the 'ely' code in another language, possibly Finnish.
vuosi	double	A real number, possibly representing the year of data collection.

Version History of ELY Areas 2017 (1:4 500 000) Table

Column	Type	Comment
_start_date	date	This column contains the date a row was extracted from the data source.
_end_date	date	This column contains the date when a newer version of the row was extracted. A null value indicates the most recent version.
_row_number	long	This column contains the row number from the raw data extracted from the source. Together with '_start_date', it uniquely identifies each row in this version history table.
ely	string	This column contains a string code representing a specific ELY Centre in Finland.
geom_geojson	string	This column contains the geographical data of the ELY Centre in GeoJSON format.
geom_geotext	string	This column contains the geographical data of the ELY Centre in geotext format.
geom_type	string	This column indicates the type of geographical data stored, in this case, a type of polygon.
geom_centroid	string	This column contains the geographical point at the center of the ELY Centre.
geom_center_x	double	This column contains the x-coordinate of the geographical center of the ELY Centre.
geom_center_y	double	This column contains the y-coordinate of the geographical center of the ELY Centre.
gid	long	This column contains an integer identifier unique to each ELY Centre.
gml_id	string	This column contains a string identifier unique to each ELY Centre.
name	string	This column contains the English name of the ELY Centre.
namn	string	This column contains the name of the ELY Centre in Swedish.
nimi	string	This column contains the name of the ELY Centre in Finnish.
vuosi	double	This column contains a real number indicating the year of data reference.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024