Statistical Areas and Regions Dataset 2013

The dataset collection in question is a compilation of related data tables sourced from the website of 'Tilastokeskus' (Statistics Finland), a reputable resource based in Finland. This dataset collection comprises of several tables that are meticulously organized into rows and columns for ease of interpretation and analysis. The data encapsulated in these tables is primarily received from the Statistics Finland's Service Interface (WFS). This diversified collection of data tables presents a comprehensive set of information, making it a valuable resource for various statistical analyses and studies. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regions 2013 (1:4 500 000) - Dataset TableTSV
The table is a well-structured data set focusing on 'Regions in 2013 (1:4 500 000)', sourced from 'Tilastokeskus' (Statistics Finland). It is part of a more extensive dataset collection that includes related information. The table comprises several columns that offer various pieces of information. For instance, two specific columns, the extract date and the row number, allow for the tracking and unique identification of each piece of data. The extract date indicates when the information was gathered, and the row number provides the sequence in which it was collected. Geographical data is also a significant aspect of this table, with several columns dedicated to this aspect. These columns, starting with 'geom_', include geographic coordinates, which follow the WGS 84 coordinate reference...
Version History of Maakunnat 2013 (1:4 500 000) - Regional DataTSV
The history table, part of a larger dataset, captures the version history of its base table rows, which are primarily focused on the geographic and demographic information of regions in Finland. Derived from the Finnish Statistical Bureau's (Tilastokeskus) dataset, this table provides a time-stamped record of each row's extraction from the source data, forming a progression of data versions over time. A unique identifier is created for each row in this version history table, combining the date of extraction and the row number. The table also indicates when a new version of a row was extracted, with a null value signifying the most recent version. Geospatial data forms a significant part of the table content, with multiple columns dedicated to storing geographic information. These...

Column Descriptions

Regions 2013 (1:4 500 000) - Dataset Table

Column	Type	Comment
_extract_date	date	This column represents the date when the data for the corresponding row was extracted. It helps in tracking the history of data updates.
_row_number	long	This column contains the unique row number in the data extracted. It is used in conjunction with '_extract_date' to uniquely identify each row in the data.
geom_geojson	string	This column holds the GeoJSON representation of the geographical data. This is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the text representation of the geographical data. It is typically in a format such as 'MULTIPOLYGON'.
geom_type	string	This column indicates the type of geometric data stored in the row. For example, 'ST_MULTIPOLYGON' signifies that the geographic data represents a multipart polygon.
geom_centroid	string	This column provides the geographic coordinates of the centroid, or geometric center, of the geographic feature.
geom_center_x	double	This column stores the X coordinate of the geometric center of the geographic feature.
geom_center_y	double	This column stores the Y coordinate of the geometric center of the geographic feature.
gml_id	string	This column holds a unique identifier for the geographic feature. It typically includes the dataset name and an individual ID for the feature.
maakunta	string	This column represents the 'province' in Finnish. It is an administrative division in Finland.
name	string	This column contains the English names of the provinces.
namn	string	This column contains the Swedish names for the provinces. Finland is a bilingual country with Finnish and Swedish as the official languages.
nimi	string	This column provides the Finnish names for the provinces.
vuosi	long	This column specifies the year to which the data pertains.

Version History of Maakunnat 2013 (1:4 500 000) - Regional Data

Column	Type	Comment
_start_date	date	This column signifies the date when the row was extracted from the data source. It works in combination with the '_row_number' column to uniquely identify each row in the history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If its 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 is used in combination with the '_start_date' column to uniquely identify each row in the history table.
geom_geojson	string	This column contains the geometric data in GeoJSON format.
geom_geotext	string	This column stores the geometric data in text format.
geom_type	string	This column denotes the type of the geometric data.
geom_centroid	string	This column signifies the centroid of the geometric shape.
geom_center_x	double	This column indicates the x-coordinate of the center of the geometric shape.
geom_center_y	double	This column indicates the y-coordinate of the center of the geometric shape.
gml_id	string	This column represents the unique identifier of the row.
maakunta	string	This column contains a string data type that signifies the province.
name	string	This column stores the name of the province in English.
namn	string	This column contains the name of the province in Swedish.
nimi	string	This column contains the name of the province in Finnish.
vuosi	long	This column, an integer data type, represents the year.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024