Statistical Areas and Regional Community Dataset 2014

The dataset collection in discussion is a compilation of related data tables, sourced from the 'Tilastokeskus' website, located in Finland. These tables are organized systematically into columns and rows, containing interconnected data. The data within this dataset collection is provided via the 'Tilastokeskus' Service Interface (WFS). Please note that the dataset collection can consist of one or multiple related tables, depending on the range and extent of the data. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2014 Subregions Statistical Data (Scale: 1:4 500 000)TSV
The table, a component of a dataset collection named 'tilastointialueet_seutukunta4500k_2014', contains a wealth of information related to the Regional Units of Finland in 2014, as provided by the Finnish statistical authority, Statistics Finland ('Tilastokeskus' in Finnish). The data includes geographic, demographic, and administrative details, making it a valuable resource for a variety of data analytics applications. The table has columns that capture both the geographic and demographic attributes of each Regional Unit. The geographic information, contained in columns starting with 'geom_', is crucial for geospatial data analytics. This includes details about the centroid of the region, the type of geographic shape, and its geographic text representation. These geographic coordinates...
Version History of Regional Units 2014 (1:4 500 000)TSV
The 'table__history' is a historical data table that forms part of a dataset collection of related tables. This table specifically deals with the version history of its base table rows, presenting a timeline of data extraction from the source. The base table content is described as 'Seutukunnat 2014 (1:4 500 000)', which translates to 'Sub-regions 2014 (1:4 500 000)' in English. The table contains a number of columns, each providing specific information. There are columns that detail the date of data extraction ('_start_date') and the date when a new version of the row was extracted ('_end_date'). These columns together with the row number ('_row_number') provide a unique identifier for each row, allowing for precise tracking and management of data changes over time. If the '_end_date'...

Column Descriptions

2014 Subregions Statistical Data (Scale: 1:4 500 000)

Column	Type	Comment
_extract_date	date	The date when the data on the row was extracted from the source.
_row_number	long	The row number in the data extracted from the source on the extract date. This, combined with '_extract_date', uniquely identifies each row.
geom_geojson	string	The geometric data of the region in GeoJSON format.
geom_geotext	string	The geometric data of the region in geotext format.
geom_type	string	The type of the geometric data, in this case, a multipolygon.
geom_centroid	string	The central point of the geometric figure of the region.
geom_center_x	double	The X coordinate of the central point of the geometric figure.
geom_center_y	double	The Y coordinate of the central point of the geometric figure.
gml_id	string	The unique identifier of the region in the GML format.
name	string	The name of the region in English.
namn	string	The name of the region in Swedish.
nimi	string	The name of the region in Finnish.
seutukunta	string	The regional code of the region.
vuosi	long	The year the data was collected.

Version History of Regional Units 2014 (1:4 500 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' for each row in this version history table.
_end_date	date	This column contains the date when a new version of the row was extracted. If the column value is null, it denotes that the row is the most recent version.
_row_number	long	This column contains the number of the row as it appears in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column contains the geographic data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geographic data as text. The data is typically represented as polygons or multipolygons.
geom_type	string	This column specifies the type of the geographic data. In this case, the type is ST_MULTIPOLYGON, which means the data represents multiple polygons.
geom_centroid	string	This column contains the centroid of the geographic data. The centroid is the geometric center of a shape.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the shape.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the shape.
gml_id	string	This column is a unique identifier for each row in the table.
name	string	This column contains the name of the region in English.
namn	string	This column contains the name of the region in Swedish.
nimi	string	This column contains the name of the region in Finnish.
seutukunta	string	This column contains the regional code for the region.
vuosi	long	This column contains the year of the data. All the data in this table is from the year 2014.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024