2015 Statistics Area Collection for Finnish Regions

The dataset collection at hand comprises a set of related tables, which were sourced from the 'Tilastokeskus' (Statistics Finland) website, based in Finland. The tables contain statistical data, as indicated by their source, and are organized in a format that includes rows and columns to simplify the process of data interpretation. As per the dataset description provided by the data source, these tables are a part of the 'Tilastokeskuksen palvelurajapinta' (Statistics Finland's service interface), suggesting they have been used to provide statistical services or analyses. The dataset collection, therefore, appears to be a valuable resource for those seeking detailed statistical data from Finland. 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 Version Records of Regional Units 2015 (1:4 500 000)TSV
The 'table__history' is a comprehensive compilation of historical data, part of the dataset collection 'tilastointialueet_seutukunta4500k_2015'. This history table embodies the version history of its base table rows, capturing information such as the distinct row number, start and end dates of data extraction, and geographic details relevant for geospatial analysis. It does not merely present the raw data but gives it a temporal context, enabling tracking changes over time. The table provides insights into regional data from 2015 with a focus on Finnish regions (Seutukunnat) at a scale of 1:4 500 000. The table lays out detailed geographic information, including types of geographic areas (like MultiPolygon), centroid points, and center coordinates. It is important to note that...
Regional Units 2015 (Scale 1:4,500,000) - Data TableTSV
The table under review is part of a dataset collection focusing on regional divisions in Finland in the year 2015. The data has been sourced from 'Tilastokeskus' (Statistics Finland), a reputable Finnish agency. This table contains detailed geographical and statistical data about different regions in the country, providing a rich source for various types of data analytics. The table contains a variety of columns that hold different types of data. There are columns that contain geographical data, presented in the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This geographical data can be used for geospatial data analytics, providing valuable insights into regional trends and patterns. In addition to the geographical data, the table also...

Column Descriptions

Regional Units 2015 (Scale 1:4,500,000) - Data Table

Column	Type	Comment
_extract_date	date	This column represents the date when the data on the row was extracted from the data source. It helps to keep track of the data extraction history.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date. It, in combination with the '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains the geometric representation of the data in GeoJSON format, which is a popular open standard format designed for representing simple geographical features.
geom_geotext	string	This column contains the geometric representation of the data in text format.
geom_type	string	This column specifies the type of the geometric data.
geom_centroid	string	This column contains the geometric center (centroid) of the geographical features represented in the row.
geom_center_x	double	This column represents the X coordinate of the geometric center.
geom_center_y	double	This column represents the Y coordinate of the geometric center.
gml_id	string	This is a unique identifier for each row in the table.
name	string	This column contains the name of the geographical area in English language.
namn	string	This column contains the name of the geographical area in Swedish language.
nimi	string	This column contains the name of the geographical area in Finnish language.
seutukunta	string	This column contains a unique identifier for each geographical area.
shape_star	double	This column contains the area of the geographical feature as calculated from the geometric data.
shape_stle	double	This column contains the perimeter of the geographical feature as calculated from the geometric data.
vuosi	double	This column represents the year of the data.

Historical Version Records of Regional Units 2015 (1:4 500 000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies each row in the version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If the value of this column 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, in combination with '_start_date', uniquely identifies each row in the version history table.
geom_geojson	string	Geospatial data representing the area of interest in GeoJSON format.
geom_geotext	string	Geospatial data representing the area of interest in text format.
geom_type	string	The type of geometry used to represent the area of interest.
geom_centroid	string	The centre point of the area of interest represented as a geometric point.
geom_center_x	double	The x-coordinate of the centre point of the area of interest.
geom_center_y	double	The y-coordinate of the centre point of the area of interest.
gml_id	string	A unique identifier for each row in the table.
name	string	The English name of the region of interest.
namn	string	The regional name of the region of interest.
nimi	string	The local name of the region of interest.
seutukunta	string	A code representing the region of interest.
shape_star	double	A measure of the area size of the region of interest.
shape_stle	double	A measure of the perimeter of the region of interest.
vuosi	double	The year of the data entry.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024