Statistical Regions of Finland, Geographic Data Collection 2014

This dataset collection is a compilation of related data tables that have been gathered from the 'Tilastokeskus' (Statistics Finland) website in Finland. These tables offer a detailed view into statistical areas in Finland, including information about regions, with a scale of 1:1000,000, for the year 2014. The data contained in the collection is organized based on the web feature service (WFS) provided by Statistics Finland, allowing for efficient and comprehensive 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

Regions 2014 - Detailed Geographic Data (1:1 000 000)TSV
The table, which is part of the dataset collection 'tilastointialueet_maakunta1000k_2014', contains detailed information about the 'Regions of 2014' in Finland. The information is sourced from 'Tilastokeskus' (Statistics Finland). The columns of the table provide a range of data including extraction dates, row numbers, and geographic details, as well as specific regional identifiers and names in multiple languages. The geographic details are presented using the WGS 84 coordinate reference system, with the longitude first, followed by the latitude. This could be utilized for geospatial data analytics. For instance, one could use this data to analyze regional trends over the years, or to study the geographic distribution of certain phenomena in Finland. Two special columns,...
Version History of Regions 2014 (1:1 000 000)TSV
The 'table__history' is a comprehensive data collection that holds the version history of its base table rows. This table is a part of a larger dataset collection that includes potentially several related tables. This specific table is a history table, which means it stores the version history of data entries, allowing the tracking of changes over time. The table originates from the 'Tilastokeskus' (Statistics Finland) website from Finland. The table includes critical columns like '_start_date', '_end_date', and '_row_number'. Together, '_start_date' and '_row_number' uniquely identify each row in this table. The '_start_date' represents the date when the row was extracted from the data source, and '_end_date' signifies when a new version of the row was extracted. If the '_end_date' is...

Column Descriptions

Regions 2014 - Detailed Geographic Data (1:1 000 000)

Column	Type	Comment
_extract_date	date	This column contains the date when the row's data was extracted from the data source. The dates are formatted in the YYYY-MM-DD format.
_row_number	long	This column contains the row number in the data extracted from the source. Combined with '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column contains the geographical representation of the data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geographical data in text format. The sample values suggest that it contains multipolygon data.
geom_type	string	This column describes the type of the geographical data. In this case, it's of type 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the centroid of the geographical data. The centroid is the center point of the geographical object.
geom_center_x	double	This column represents the X coordinate of the center of the geographical object.
geom_center_y	double	This column represents the Y coordinate of the center of the geographical object.
gml_id	string	This is a technical identifier of the geographical object.
maakunta	string	This column contains a code representing a province.
name	string	This column contains the English name of the province.
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 contains the year of the data. The sample values suggest that the year is represented as an integer.

Version History of Regions 2014 (1:1 000 000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This, along with the '_row_number', uniquely identifies each row in this version history table.
_end_date	date	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	The number of the row in the raw data extracted from the data source. This, along with the '_start_date', uniquely identifies each row in this version history table.
geom_geojson	string	Contains geographical data in the GeoJSON format. This data represents the shape and location of the region.
geom_geotext	string	Contains geographical data in text format. This data represents the shape and location of the region.
geom_type	string	Specifies the type of the geographical object represented in 'geom_geojson' and 'geom_geotext'. In this case, it is a multipolygon.
geom_centroid	string	Contains the geographical coordinates of the centroid of the region represented by the 'geom_geojson' and 'geom_geotext'.
geom_center_x	double	Provides the x-coordinate of the center of the region represented by the 'geom_geojson' and 'geom_geotext'.
geom_center_y	double	Provides the y-coordinate of the center of the region represented by the 'geom_geojson' and 'geom_geotext'.
gml_id	string	The unique identifier of the region in the original data source.
maakunta	string	A string representing the region. It is a unique identifier for each region.
name	string	The English name of the region.
namn	string	The Swedish name of the region.
nimi	string	The Finnish name of the region.
vuosi	long	The year when the data was collected. This is an integer value.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024