2018 Statistical Areas Major Region Data Collection

This dataset collection contains multiple tables of related data, sourced from the Statistics Finland (Tilastokeskus) website, based in Finland. The data tables comprise of statistical data regarding large areas, all organized in a structured table format consisting of rows and columns. Each table in the collection presents interrelated data, providing comprehensive coverage of the subject matter. The dataset is accessible through the Statistics Finland's service interface (WFS), offering a reliable source for statistical data. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Large Areas Data 2018 (Scale 1:4,500,000)TSV
The table under discussion forms part of a dataset collection titled 'tilastointialueet_suuralue4500k_2018', and contains data related to the 'Major Areas in 2018', which is an English translation of the Finnish source description 'Suuralueet 2018'. The table includes data extracted from the Finnish website 'Tilastokeskus' (Statistics Finland). The table contains a wealth of information that can be used for various types of data analytics. For instance, the data includes geographic information, which is useful for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the order of axes being longitude first, followed by latitude. Columns in the table, such as 'geom_geojson' and 'geom_geotext', store geographic information...
Version History of Large Areas 2018 (1:4 500 000)TSV
The 'table__history' is part of a larger dataset collection, which encapsulates information pertaining to the 'Suuralueet 2018', translated to English as 'Major Areas 2018'. The data within this table is sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland, and serves as a historical archive, maintaining a version history of its base table rows. The table contains various columns, most notably, the '_start_date', '_end_date', and '_row_number' columns. The '_row_number' column signifies the raw data row number from the original data source, and along with the '_start_date', uniquely identifies each row in the table. The '_start_date' represents the date a row was extracted from the data source while the '_end_date' indicates when a new version of the row was...

Column Descriptions

Large Areas Data 2018 (Scale 1:4,500,000)

Column	Type	Comment
_extract_date	date	The date when the data on the row of the table was extracted from the data source. It helps in keeping the track of when the information was last updated.
_row_number	long	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.
geom_geojson	string	Contains the geographic data in GeoJSON format. It represents the multi-point geographical features.
geom_geotext	string	Contains the geographical data in text format. It represents the multi polygon geographical features.
geom_type	string	Specifies the type of the geographical data. In this case, it is a multi polygon.
geom_centroid	string	The centroid or the geometric center of the multi polygon.
geom_center_x	double	The x-coordinate of the center point of the geographical feature.
geom_center_y	double	The y-coordinate of the center point of the geographical feature.
gml_id	string	The Global Markup Language (GML) ID for each row. It represents a unique identifier for the geographical feature.
name	string	The name of the geographical area in English.
namn	string	The name of the geographical area in Swedish.
nimi	string	The name of the geographical area in Finnish.
suuralue	string	A numerical identifier for the large geographical area.
vuosi	long	The year of the data. It helps in understanding the time frame of the data.

Version History of Large Areas 2018 (1:4 500 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. This is part of a combination 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 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, which is part of a combination that uniquely identifies each row in this version history table.
geom_geojson	string	This column stores the geographic data in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotext	string	This column stores the geographic data in text format.
geom_type	string	This column indicates the type of the geographic data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column stores the geographic point that represents the centroid of the geographic data.
geom_center_x	double	This column stores the x-coordinate of the geographic point that represents the center of the geographic data.
geom_center_y	double	This column stores the y-coordinate of the geographic point that represents the center of the geographic data.
gml_id	string	This column contains a unique identifier for each row.
name	string	This column contains the English name of the region represented in the row.
namn	string	This column contains the name of the region represented in the row in a second language.
nimi	string	This column contains the name of the region represented in the row in a third language.
suuralue	string	This column contains a numeric code that represents the region in the row.
vuosi	long	This column contains the year in which the data for the row is relevant.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024