Statistical Area Dataset Collection 2016

The dataset collection in question consists of related data tables grouped together. These tables, sourced from the 'Tilastokeskus' website in Finland, structure related data in a convenient table format, made up of columns and rows for easy data analysis. The description provided by Tilastokeskus, which can be translated as the 'Statistical Centre's service interface (WFS)', indicates that the dataset collection may involve statistical data made available through a web feature service. This dataset collection might be particularly useful for individuals or organizations seeking Finnish statistical data, possibly related to specific service interfaces. 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 Geographical Data (1:4 500 000 Scale)TSV
The table, a component of the dataset collection, holds data related to the ELY areas for the year 2016, as scaled to 1:4 500 000. This information comes from the 'Tilastokeskus' website, located in Finland. The data encapsulates different aspects of the ELY areas, including unique identifiers, geographic coordinates, and names in various languages. These names represent the ELY centers, such as the Lapland ELY Centre, Häme ELY Centre, and North Savo ELY Centre, among others. Two special columns, '_extract_date' and '_row_number', provide information about the data extraction process. The '_extract_date' showcases the date on which the data for the row was collected, while the '_row_number' is an identifier for the row number in the data extracted on the specified date. The combination...
Version History of ELY Areas 2016 (1:4 500 000) TableTSV
The table named 'table__history' is an integral part of the dataset collection 'tilastointialueet_ely4500k_2016'. This table serves as a historical record, keeping track of the version history of its base table rows. The table contains data pertaining to ELY-areas in 2016, at a scale of 1:4,500,000, sourced from 'Tilastokeskus' (the Finnish Statistics Bureau) located in Finland. The table's columns hold a wide range of data types, including date timestamps, row numbers, geographic information, and text fields. A unique feature of this history table is its two additional columns, '_start_date' and '_end_date', which respectively denote the dates when a row was extracted from the source data and when a new version of the row was extracted. If the '_end_date' is null, it signifies that the...

Column Descriptions

ELY Areas 2016 Geographical Data (1:4 500 000 Scale)

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table 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 '_extract_date' column. Combined with '_extract_date', this column uniquely identifies every row.
ely	string	This string column represents a code associated with a geographical area.
geom_geojson	string	This column represents the geographical shape of the area in GeoJSON format, a type of format for encoding a variety of geographic data structures.
geom_geotext	string	This column represents the geographical shape of the area in text format.
geom_type	string	This column specifies the type of geographical structure represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the geographical coordinates of the centroid, or geometric center, of the area.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the area.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the area.
gid	long	This integer column represents a unique identifier for each row.
gml_id	string	This string column contains an identifier for the geographical data of the row.
name	string	This string column contains the English name of the geographical area associated with the row.
namn	string	This string column contains the name of the geographical area associated with the row in another language.
nimi	string	This string column contains the name of the geographical area associated with the row in yet another language.
vuosi	double	This real type column represents the year associated with the data of the row.

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

Column	Type	Comment
_start_date	date	This column records the date when the row was extracted from the data source. It forms a combination with the '_row_number' column 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 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. Together with the '_start_date' column, it forms a unique identifier for each row in this version history table.
ely	string	This is a string type column in the dataset, although the sample values appear to be numerical.
geom_geojson	string	This column contains geojson data representing the geographical area related to the row.
geom_geotext	string	This column contains text-based geographical data.
geom_type	string	This column specifies the type of the geographical data present in the row.
geom_centroid	string	This column contains the geographical point that represents the centroid of the area related to the row.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical area related to the row.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical area related to the row.
gid	long	This column is of integer type and could be a unique identifier for the geographical area.
gml_id	string	This column is of string type and contains a unique identifier for the geographical data.
name	string	This column contains the English name of the entity related to the row, such as a government or administrative body.
namn	string	This column contains the name of the entity related to the row in another language.
nimi	string	This column contains the name of the entity related to the row in yet another language.
vuosi	double	This column, of real type, contains the year associated with the row.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024