Statistical Service Interface (WFS) - Data Collection 2016

The dataset collection in question encompasses an array of tables that are intricately interrelated. These tables have been collated from the website of 'Tilastokeskus' (Statistics Finland), based in Finland. They comprise a wide range of data, conveniently organized in a tabular format with structured rows and columns. The dataset has been derived via Tilastokeskus' service interface (WFS). It's an invaluable resource offering comprehensive insights into the topic it covers. 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 Areas 2016 Version History (1:1 000 000)TSV
The 'table__history' contains a comprehensive record of ELY (Centre for Economic Development, Transport and the Environment) areas in Finland, as recorded in 2016. The data in this history table represents the version history of its base table rows, providing a detailed snapshot of changes over time. Each row in the table is uniquely identified by the combination of '_start_date' and '_row_number', offering precise tracking of data extraction and subsequent updates. The table includes geographic data, such as geometry in geojson and geotext formats, the type of geometry, the centroid of the geometry, and the x and y coordinates of the center. This geographic information, presented using the WGS 84 coordinate reference system, is valuable for geospatial data analytics, enabling users to...
ELY Regions 2016 (Scale 1:1 000 000) - Data TableTSV
The table, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland), provides comprehensive data on ELY-areas (Centre for Economic Development, Transport and the Environment) for the year 2016 at a scale of 1:1,000,000. It includes various columns with a mix of geographical and textual data. The geographical data is 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 data analytics, enabling the visualization and analysis of ELY-areas on a map. For example, one could examine the distribution of these areas across Finland, or analyze spatial patterns and trends over time. The table also includes textual data, such as the Finnish, Swedish, and...

Column Descriptions

ELY Regions 2016 (Scale 1:1 000 000) - Data Table

Column	Type	Comment
_extract_date	date	This column contains the date data was extracted from the source, serving to provide a historical context to the data. Each row of data is associated with a specific extraction date.
_row_number	long	This column contains the row number in the data extracted from the source. Combined with '_extract_date', it uniquely identifies each row.
ely	string	This column contains a code that represents a specific area in Finland.
geom_geojson	string	This column contains the geometric data of the area in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geometric data of the area in textual format.
geom_type	string	This column describes the type of geometric data contained in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the geographic coordinates of the centroid or geometric center of the area.
geom_center_x	double	This column contains the X coordinate (longitude) of the geometric center of the area.
geom_center_y	double	This column contains the Y coordinate (latitude) of the geometric center of the area.
gid	long	This column contains a unique identifying number for each area.
gml_id	string	This column contains a unique identification string that is used in Geography Markup Language (GML).
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.
vuosi	double	This column contains the year of the data.

ELY Areas 2016 Version History (1:1 000 000)

Column	Type	Comment
_start_date	date	This column records 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 signifies that the row is the most recent version.
_row_number	long	This column represents the number of the row in the raw data extracted from the data source. It forms a unique identifier in combination with '_start_date' for each row in this version history table.
ely	string	This is a string-type column in the base table, representing a particular category or attribute in the dataset.
geom_geojson	string	This column contains geometric data of the entity in GeoJSON format, a popular open standard format designed for representing simple geographical features.
geom_geotext	string	This column contains geometric data in a textual format. This can be used for spatial queries and analysis.
geom_type	string	This column specifies the type of the geometry stored in the 'geom_geojson' and 'geom_geotext' columns. It can help in understanding the nature of the spatial data.
geom_centroid	string	This column stores the geometric center or 'centroid' of the entity. This can be useful in spatial analysis.
geom_center_x	double	This column represents the X-coordinate of the geometric center of the entity, providing a spatial reference.
geom_center_y	double	This column represents the Y-coordinate of the geometric center of the entity, providing a spatial reference.
gid	long	This is an integer-type column in the base table, which may be used as an identifier or a key in the dataset.
gml_id	string	This is a string-type column in the base table. It could be an identifier or a key for the rows in the table.
name	string	This is a string-type column in the base table. It may contain names of entities or attributes relevant to the dataset.
namn	string	This is a string-type column in the base table, possibly containing names or labels in a different language.
nimi	string	This is a string-type column in the base table, possibly containing names or labels in a different language.
vuosi	double	This is a real number-type column in the base table, which could be used for storing various numerical data, such as year in this context.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024