Statistics Area Large Zone 2021

This dataset collection is a compilation of related data tables that provide valuable insight into a specific field of study. Originating from the Statistics Centre's service interface (Tilastokeskuksen palvelurajapinta), these data tables provide a wealth of information. The dataset collection comes from the website of the Statistics Centre (Tilastokeskus) in Finland. It is meticulously organized into rows and columns, making it easy to understand and use. Despite its technical origins, the dataset's true value lies in its practical applications in various research areas. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Large Areas 2021 (1:1 000 000) Version TrackingTSV
The 'table__history' is a historical data repository that forms part of the dataset collection titled 'tilastointialueet_suuralue1000k_2021'. The table provides a valuable insight into the major areas of Finland, as sourced from the Finnish statistical agency 'Tilastokeskus' (Statistics Finland). The core of the table's contents highlights the names of these areas in different languages such as English, Finnish and Swedish. Each of these areas is assigned a unique identifier and a corresponding geographical attribute, presented using WGS 84 coordinate reference system, with longitude preceding latitude. The geographical attributes are stored as various 'geom_' prefixed columns, which can be instrumental for geospatial data analytics, such as mapping or studying spatial patterns and...
Large Regions 2021 (Scale 1:1,000,000) - Data TableTSV
The table in focus, part of a larger dataset collection, is a rich source of geospatial data representing the 'Major Regions 2021' in Finland. The data is sourced from 'Tilastokeskus' (Statistics Finland), a reputable web source in Finland. The table is organized into several columns, each providing unique yet interconnected information. Two columns, '_extract_date' and '_row_number', play a special role in the table. They capture the date of data extraction and the row number, respectively. Together, they ensure that each row of data can be uniquely identified. The table also includes a series of 'geom_' columns. These columns contain geographic information which can be utilized for geospatial data analytics. They hold details such as geographic coordinates, types of geometry, and...

Column Descriptions

Large Regions 2021 (Scale 1:1,000,000) - Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. It is part of a unique identifier for each row when combined with '_row_number'.
_row_number	long	This column contains the row number from the data extracted from the source, creating a unique identifier for each row when combined with '_extract_date'.
geom_geojson	string	This column stores the geometric representation of the data in GeoJSON format.
geom_geotext	string	This column stores the geometric representation of the data in text format.
geom_type	string	This column indicates the type of the geometry. In this case, it is a multipolygon.
geom_centroid	string	This column contains the centroid point of the multipolygon, which is a point that defines its geometric center.
geom_center_x	double	This column contains the X-coordinate of the geometric center of the multipolygon.
geom_center_y	double	This column contains the Y-coordinate of the geometric center of the multipolygon.
gml_id	string	This column provides the unique identifier for the row in GML (Geography Markup Language) format.
name	string	This column provides the name of the area in English.
namn	string	This column provides the name of the area in Swedish.
nimi	string	This column provides the name of the area in Finnish.
suuralue	string	This column provides the code representing the large area to which the data pertains.
vuosi	long	This column indicates the year of the data.

Historical Large Areas 2021 (1:1 000 000) Version Tracking

Column	Type	Comment
_start_date	date	This column contains the date when each row was extracted from the data source, serving as the initial date for the version history of a row.
_end_date	date	This column holds 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 represents the number of the row in the raw data extracted from the data source. It, together with _start_date, uniquely identifies each row in this version history table.
geom_geojson	string	This column contains the geographical representation of each area in GeoJSON format, which is a popular format for encoding a variety of geographic data structures.
geom_geotext	string	This column holds the geographical representation of each area in geotext format.
geom_type	string	This column specifies the type of the geographic data stored in the table, which in this case is ST_MULTIPOLYGON indicating a collection of polygons.
geom_centroid	string	This column contains the coordinates of the geographical center or centroid of each area.
geom_center_x	double	This column holds the x-coordinate (longitude) of the geographical center of each area.
geom_center_y	double	This column has the y-coordinate (latitude) of the geographical center of each area.
gml_id	string	This column, of type String, is an identifier for each area.
name	string	This column, of type String, contains the English name for each area.
namn	string	This column, of type String, holds the Swedish name for each area.
nimi	string	This column, of type String, carries the Finnish name for each area.
suuralue	string	This column, of type String, is an identifier for each large area, with areas represented by numbers.
vuosi	long	This column, of type Integer, represents the year associated with the data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024