Statistics Center Service Interface (WFS) - Dataset Collection 2014

The dataset collection in question comprises of a series of related data tables, sourced from the website of the 'Tilastokeskus' (Statistics Finland) in Finland. The data within this collection is organized into columns and rows, forming a structured and coherent presentation of information. The data has been provided via the service interface of Statistics Finland. The nature of the dataset collection suggests it's a statistical compilation of areas, highly suitable for a variety of analytical tasks and research purposes. This comprehensive collection offers a detailed look into specific data, making it a valuable asset for data-driven decision making. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Centres for Economic Development, Transport and the Environment (ELY) Areas, 2014 (Scale 1:4,500,000)TSV
The table in question is a part of a larger dataset collection and contains data related to ELY-areas for the year 2014, sourced from the statistical center 'Tilastokeskus' in Finland. The table comprises various columns that include geographic, temporal, and descriptive data. Among the columns, two special ones, '_extract_date' and '_row_number', form a unique identification for each row. The '_extract_date' column indicates the date when the particular data row was extracted from the source, and '_row_number' represents the row number in the data extracted on that particular date. The table also includes geographic data in columns starting with 'geom_', which can be utilized for geospatial analytics. This geographic data, such as 'geom_geojson', 'geom_geotext', 'geom_type',...
Version History of ELY Areas 2014 (1:4 500 000) DatasetTSV
The 'table__history' is a historical data table that originates from the 'Tilastokeskus' (Statistics Finland) website, based in Finland. It is a part of the 'tilastointialueet_ely4500k_2014' dataset collection. This historical data table provides a version history of its base table rows, documenting changes over time. The content of the base table can be described as 'ELY-areas 2014 (1:4 500 000)'. The table contains multiple columns with different types of data. Each row of the table is uniquely identified by the combination of '_start_date' and '_row_number' columns. The column '_start_date' indicates when the data was extracted from the source, while the '_end_date' shows when a new version of the row was extracted. If the '_end_date' value is null, it suggests that the row is the...

Column Descriptions

Centres for Economic Development, Transport and the Environment (ELY) Areas, 2014 (Scale 1:4,500,000)

Column	Type	Comment
_extract_date	date	This column represents the date when the data on the row of the table was extracted from the data source. It is used together with the '_row_number' to uniquely identify each row.
_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'. This column is used in combination with '_extract_date' to uniquely identify each row.
ely	string	This string column represents a certain entity or group in the dataset.
geom_geojson	string	This column contains GeoJSON-formatted geographical data, representing the geographical boundaries of the entity or group represented in the 'ely' column.
geom_geotext	string	This column contains geographical data in text format, similar to the data in 'geom_geojson' column but in a different format.
geom_type	string	This column indicates the type of the geographical data stored in 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the coordinates of the centroid point of the geographical area represented in 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This column represents the X-coordinate of the center of the geographical area represented in 'geom_geojson' and 'geom_geotext' columns.
geom_center_y	double	This column represents the Y-coordinate of the center of the geographical area represented in 'geom_geojson' and 'geom_geotext' columns.
gml_id	string	This string column contains a unique identifier for each row in the table.
name	string	This column contains the English name of the entity or group represented in the 'ely' column.
namn	string	This column contains the name of the entity or group represented in the 'ely' column in a different language.
nimi	string	This column contains the name of the entity or group represented in the 'ely' column in another different language.
vuosi	long	This integer column represents the year related to the data in the row.

Version History of ELY Areas 2014 (1:4 500 000) Dataset

Column	Type	Comment
_start_date	date	This represents the date a certain version of the row was extracted from the data source. This date, combined with '_row_number', uniquely identifies each row in the history table.
_end_date	date	This indicates the date when a newer version of the row was extracted from the data source. A null value in this column signifies that the row is the latest version.
_row_number	long	This contains the unique number of the row in the raw data, which in combination with '_start_date', allows for the identification of individual versions of rows in the history table.
ely	string	This is a string variable in the base table which possibly denotes a certain administrative or geospatial area within Finland.
geom_geojson	string	This contains geometric data in the GeoJSON format. It is likely linked to the geographical representation of the data in each row.
geom_geotext	string	This contains geometric data in text form. It is likely a different representation of the geographical data contained in 'geom_geojson'.
geom_type	string	This indicates the type of geometric data represented in the 'geom_geotext' and 'geom_geojson' columns.
geom_centroid	string	This contains the centroid of the geographic area represented by the 'geom_geojson' and 'geom_geotext' data. The centroid is the geometric center of a shape.
geom_center_x	double	This represents the x-coordinate of the geometric center or centroid of the shape represented by 'geom_geojson' and 'geom_geotext'.
geom_center_y	double	This indicates the y-coordinate of the geometric center or centroid of the shape represented by 'geom_geojson' and 'geom_geotext'.
gml_id	string	This is a string variable in the base table which possibly serves as a unique identifier for each row.
name	string	This column contains English names of entities represented in the data. This could be regions, administrative areas or other geospatial entities within Finland.
namn	string	This column contains the names of entities represented in the data in Swedish. This could be regions, administrative areas or other geospatial entities within Finland.
nimi	string	This column contains the names of entities in Finnish. This could be regions, administrative areas or other geospatial entities within Finland.
vuosi	long	This is an integer variable in the base table which likely represents the year associated with the data in the row.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024