Statistics Service Interface for Large Area Data Collection 2024

The dataset collection in question is a comprehensive compilation of related data tables. These tables are intricately linked and are sourced from the Statistical Services Interface (WFS) provided by 'Tilastokeskus' (Statistics Finland), a reputable web platform in Finland. The data tables captured in this collection provide valuable statistical insights, making it an essential asset for various analytical endeavors. Please note that the data contained in this collection is well-structured in table format with distinct columns and rows, facilitating easy interpretation and analysis. 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 Versioning of Major Areas 2024 (Scale 1:4 500 000)TSV
The 'table__history' is a historical data table that is part of the larger dataset collection. This table stores the version history of its base table rows. Its contents are primarily sourced from 'Tilastokeskus' (Statistics Finland), a Finnish statistical agency. The table's content represents 'Suuralueet 2024' translated as 'Large Areas 2024', which is a geographical designation at scale 1:4 500 000. The table features a variety of columns that hold valuable data. For instance, it includes a chronological record of when each row was extracted from the source ('start_date') and when a new version of the same row was extracted ('_end_date'). These two, along with the '_row_number' which indicates the row number in the raw data, make each row in the table uniquely identifiable. If the...
Large Areas Projection for 2024 (Scale 1:4,500,000)TSV
This table, a part of the 'tilastointialueet_suuralue4500k_2024' dataset collection, provides an in-depth view into the regional geography of Finland. It contains important information about 'The Major Regions of Finland in 2024', which is the English translation of the table's original description: 'Suuralueet 2024 (1:4 500 000)'. The information in the table is diverse and includes geographical data, such as 'geom_geojson' and 'geom_geotext', which offer multi-dimensional shapes of the regions. The 'geom_type' column indicates the type of the geographical shape. Furthermore, the table provides the center point of each region, as depicted by 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These geographical coordinates are presented using the WGS 84 coordinate reference system,...

Column Descriptions

Large Areas Projection for 2024 (Scale 1:4,500,000)

Column	Type	Comment
_extract_date	date	This column contains the date when the data on each row was extracted from the data source. This helps in tracking the timeline of data extraction.
_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. It helps in uniquely identifying each row.
geom_geojson	string	This is a geographical data column that contains geometric data in the form of GeoJSON, a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geometric data in a text format, which represents various geographical structures.
geom_type	string	This column specifies the type of the geometric data. In this case, it is 'ST_MULTIPOLYGON', indicating that the data represents a collection of polygons.
geom_centroid	string	This column contains the geometric centroid of the geographic feature. The centroid is the arithmetic mean position of all the points in the shape.
geom_center_x	double	This column contains the X coordinates of the geometric center of the feature.
geom_center_y	double	This column contains the Y coordinates of the geometric center of the feature.
gml_id	string	This is a unique identifier for each geographic feature in the GML (Geography Markup Language) format.
name	string	This column presents the names of geographical areas in English.
namn	string	This column presents the names of geographical areas in Swedish.
nimi	string	This column presents the names of geographical areas in Finnish.
suuralue	string	This column contains a numerical identifier for each large area.
vuosi	long	This column contains the year associated with the data. In this case, the sample data is from the year 2024.

Historical Versioning of Major Areas 2024 (Scale 1:4 500 000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source, marking the beginning of a specific version of a row.
_end_date	date	The date when a new version of the row was extracted from the data source, marking the end of that particular version of a row. If the value is null, it indicates that the row is the most recent version.
_row_number	long	Contains the number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in the version history table.
geom_geojson	string	Contains geographical coordinates in GeoJSON format, defining the geospatial data for the areas.
geom_geotext	string	Contains the geospatial data as text, defining the shape of the areas in a multipolygon format.
geom_type	string	Specifies the type of the geo-spatial data, in this case, it is a multipolygon.
geom_centroid	string	Contains the geographical coordinates of the centroid (geographical center) of the areas.
geom_center_x	double	The 'X' coordinate of the centroid (geographical center) of the areas.
geom_center_y	double	The 'Y' coordinate of the centroid (geographical center) of the areas.
gml_id	string	A unique identifier for each row in the table.
name	string	The English name for the larger area to which the data row relates.
namn	string	The name for the larger area in Swedish.
nimi	string	The name for the larger area in Finnish.
suuralue	string	A numerical identifier for the larger area to which the data row relates.
vuosi	long	The year associated with the data row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024