Statistics Center Service Interface (WFS) - 2020 Dataset Collection

The dataset collection, sourced from 'Tilastokeskus' (Statistics Finland), comprises of related data tables. These tables contain specific information that's meticulously organized into rows and columns, providing a streamlined way to study and analyze the data. The data is provided through the 'Tilastokeskus' service interface, showing its commitment to making statistical information accessible and understandable. This dataset collection is an invaluable resource for researchers, analysts, and anyone interested in 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

ELY Areas 2020 at Scale 1:1,000,000 - Detailed Geospatial DatasetTSV
The table, belonging to the dataset collection 'tilastointialueet_ely1000k_2020', holds a wealth of data related to the 'ELY-areas 2020' (1:1 000 000) in Finland. Every row in the table represents a specific ELY area, with each column providing detailed information about it. The table contains columns that provide geographical information, such as 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns hold data in the form of geographic coordinates, geographical shapes, and types. This data, presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude, is particularly useful for geospatial data analytics. Other columns in the table provide unique identifiers for each row...
Version History of ELY Areas 2020 (1:1 000 000) RecordsTSV
The history table provides detailed records of the version history of the ELY areas 2020 (1:1 000 000) data. The history table is a part of the 'tilastointialueet_ely1000k_2020' dataset, which is sourced from the 'Tilastokeskus' (Statistics Finland) website. This table contains specific columns that track the data extraction process and the temporal aspects of the data. Certain columns indicate the start and end dates of data extraction, and if the end date is null, it signifies that the particular row is the most recent version. Additionally, each row in this table is uniquely identified by a combination of the row number and the start date. The table also includes several geographical columns, containing data that can be used for geospatial analytics. This includes information like...

Column Descriptions

ELY Areas 2020 at Scale 1:1,000,000 - Detailed Geospatial Dataset

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the source. It helps in tracking the timeline of data extraction.
_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 uniquely identifies each row.
ely	string	This column contains string type values, which may correspond to specific regional codes or identifiers.
geom_geojson	string	This column contains GeoJSON formatted geometric data representing the geographical attributes of the data points.
geom_geotext	string	This column contains geometric data in text format which represent the geographical attributes of the data points.
geom_type	string	This column signifies the type of the geometric data stored in the row, such as 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid	string	This column contains the central point of the geometric figure represented in the row.
geom_center_x	double	This column contains the X-coordinate of the center point of the geometric figure.
geom_center_y	double	This column contains the Y-coordinate of the center point of the geometric figure.
gml_id	string	This is a string type column that uniquely identifies each row in the table.
id	long	This is an integer type column that may represent an identifier for each row.
name	string	This column contains string type values, which could represent names of entities or locations.
namn	string	This column contains string type values and may contain alternate or localized names of entities or locations.
nimi	string	This column contains string type values. It might contain names in a different local language or format.
vuosi	long	This column is of integer type and might represent the year associated with each row of data.

Version History of ELY Areas 2020 (1:1 000 000) Records

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms 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. A null value indicates 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. In combination with '_start_date', it uniquely identifies each row in this version history table.
ely	string	A string type column which represents a certain ELY center.
geom_geojson	string	This column contains geometrical data in the format of GeoJSON, which includes information about the shape and area of the geographical region.
geom_geotext	string	This column contains geometrical data in textual format, providing information about the shape and area of the geographical region.
geom_type	string	This column states the type of the geometric data stored in the row.
geom_centroid	string	This column contains the point that represents the center of the geometric shape of the region.
geom_center_x	double	This column contains the x-coordinate of the center of the geometric shape of the region.
geom_center_y	double	This column contains the y-coordinate of the center of the geometric shape of the region.
gml_id	string	A string type column which contains a unique identifier for each row.
id	long	An integer type column which provides a unique identification number for each row.
name	string	A string type column which contains the English name of the ELY center.
namn	string	This column contains the name of the ELY center in Swedish.
nimi	string	This column contains the name of the ELY center in Finnish.
vuosi	long	An integer type column that specifies the year the data was gathered.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024