Statistics Area Collection 2018

This dataset collection comprises a set of related data tables that have been sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The tables in the collection hold interconnected data, neatly arranged in an easy-to-understand format of columns and rows. The data in this collection is made accessible via the Tilastokeskus's service interface (WFS). It's important to note that the information provided through this dataset collection is fundamental for statistical purposes and offers valuable insights into various aspects of the subject matter 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 2018 (Scale 1:4 500 000) - A Subset of the 'tilastointialueet_ely4500k_2018' DatasetTSV
The table in question is part of a larger dataset collection. It comprises a wealth of information, particularly on the ELY-areas from 2018, presented at a scale of 1:4,500,000. This table is sourced from the Statistics Finland (Tilastokeskus) website, based in Finland. The data in this table can be utilized for various data analytics applications due to its rich and diverse content. Each row in the table represents a unique data entry, with the date of extraction from the source and the row number in the data denoted by the special columns '_extract_date' and '_row_number', respectively. These two columns serve as unique identifiers for each row. There are several geographic columns in the table that provide details such as geographic coordinates, geographic text, and other geospatial...
Historical Records of ELY Areas 2018 (Scale 1:4,500,000)TSV
The 'table__history' is a historical data repository that documents the evolution of its base table entries over time. This table is part of a dataset collection pertaining to statistical areas in Finland, specifically the ELY-areas in 2018 at a scale of 1:4,500,000. The information captured in this table is derived from the Finnish statistical agency, 'Tilastokeskus'. The table's columns provide a wealth of information. Key among them are a pair of columns, '_start_date' and '_row_number', which together create a unique identifier for each row. The '_start_date' column records the date an entry was extracted from the source, while the '_end_date' column notes when a new row version was extracted. If the '_end_date' is null, it signifies that the row is the latest version. This table is...

Column Descriptions

ELY Areas 2018 (Scale 1:4 500 000) - A Subset of the 'tilastointialueet_ely4500k_2018' Dataset

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the particular row 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 column '_extract_date'.
ely	string	This column contains string values, likely representing a unique identifier or code.
geom_geojson	string	This column contains GeoJSON representations of multi-polygon geometric shapes.
geom_geotext	string	This column contains textual representations of multi-polygon geometric shapes.
geom_type	string	This column specifies the type of geometric object represented in the 'geom_geojson' and 'geom_geotext' columns. In this case, all the objects are MultiPolygons.
geom_centroid	string	This column contains the geographic coordinates of the centroid, or geometric center, of the multi-polygon.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the multi-polygon.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the multi-polygon.
gml_id	string	This column contains a unique string identifier for each row, likely related to the dataset's source.
id	long	This column contains integer values, which could be identifiers for each row.
name	string	This column contains string values, which could represent names or titles.
namn	string	This column contains string values, which could represent names or titles in a different language.
nimi	string	This column contains string values, which could represent names or titles in a different language.
vuosi	long	This column contains integer values, likely representing years.

Historical Records of ELY Areas 2018 (Scale 1:4,500,000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This column, together with '_row_number', uniquely identifies each row in the history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source. This column, together with '_start_date', uniquely identifies each row in the history table.
ely	string	A string indicating an identifier associated with the row.
geom_geojson	string	Contains geographical data in GeoJSON format.
geom_geotext	string	Contains geographical data in text format.
geom_type	string	The type of the geographical data.
geom_centroid	string	The central point of the geographical data.
geom_center_x	double	The X coordinate of the center of the geographical data.
geom_center_y	double	The Y coordinate of the center of the geographical data.
gml_id	string	A string identifier for the row.
id	long	An integer identifier for the row.
name	string	A string containing the name associated with the row.
namn	string	A string containing an alternate name associated with the row.
nimi	string	A string containing another alternate name associated with the row.
vuosi	long	An integer indicating the year associated with the row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024