2015 Regional Statistics Tables Collection

The dataset collection comprises a set of related tables, sourced from the Tilastokeskus (Statistics Finland) website, based in Finland. These tables contain statistical data extracted via the service interface (WFS). The data is organized in a table format, with related content arranged in columns and rows. Despite the technical complexity of the dataset collection's title, it primarily offers a comprehensive and detailed statistical overview pertinent to the region of interest. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Provinces 2015 (1:4 500 000) - Dataset Collection of Finnish Statistical RegionsTSV
The table in question belongs to a dataset collection that captures geospatial information related to the administrative regions of Finland in 2015. The data is sourced from 'Tilastokeskus' (Statistics Finland), the national statistical institution of Finland. The table contains various columns that store a wealth of information about each region. The data in the table can be broken down into three main categories - geographic, identification, and shape data. The geographic data, including geospatial coordinates and geographic type, is stored in columns that start with 'geom_'. This data is presented using the WGS 84 coordinate reference system, which uses longitude and latitude to pinpoint locations. This information could be used for geospatial data analytics, such as plotting the...
Version History of Provinces 2015 (1:4 500 000) DatasetTSV
The 'History' table is an integral part of a dataset collection, providing a comprehensive historical record of its base table rows. This history table originates from 'Tilastokeskus' (Statistics Finland) and is designed to track the changes in the data over time. It is especially useful in maintaining the integrity of the data and in facilitating data analytics that take into account the temporal aspect of the data. The table is enriched with a variety of columns. Unique identifiers for each row are formed by a combination of a start date and a row number, which help track the sequence and time frame of the data's extraction. This is further enhanced with an end date, indicating when a new version of the row was extracted from the source. If the end date is null, it signifies that the...

Column Descriptions

Provinces 2015 (1:4 500 000) - Dataset Collection of Finnish Statistical Regions

Column	Type	Comment
_extract_date	date	This column indicates the date when the data on the row of the table was extracted from the source. This, along with '_row_number' column, helps in uniquely identifying each row.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This, in combination with '_extract_date' column, uniquely identifies each row.
geom_geojson	string	This column contains geographical information in GeoJSON format, a format for encoding a variety of geographic data structures.
geom_geotext	string	This column stores the geographic data as text. It is a representation of the geographical region.
geom_type	string	This column contains the type of the geographical data, which in this dataset is usually a multi-polygon.
geom_centroid	string	This column contains the point that represents the geometric center of the region.
geom_center_x	double	This column represents the x-coordinate of the geometric center of the region.
geom_center_y	double	This column represents the y-coordinate of the geometric center of the region.
gml_id	string	This column holds a unique identifier for each record.
maakunta	string	This column contains the codes for the regions or provinces in Finland.
name	string	This column contains the English names of the regions or provinces.
namn	string	This column contains the Swedish names of the regions or provinces.
nimi	string	This column contains the Finnish names of the regions or provinces.
shape_star	double	This column contains the area size of each region.
shape_stle	double	This column contains the perimeter length of each region.
vuosi	double	This column contains the year of the data, which in this dataset, is the year 2015.

Version History of Provinces 2015 (1:4 500 000) Dataset

Column	Type	Comment
_start_date	date	This column contains the date when the respective row was extracted from the data source. It is part of a unique combination with '_row_number' that identifies each row in the version history table.
_end_date	date	This column records the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version.
_row_number	long	This column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier for each row in combination with '_start_date'.
geom_geojson	string	This column contains geometric data in GeoJSON format, which can represent a variety of geographic data structures.
geom_geotext	string	This column stores the geometric data as a text string, which can represent various geographic data structures.
geom_type	string	This column specifies the type of geometric data structure represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the centroid of the geometric shape represented by the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This column represents the X coordinate of the center of the geometric shape.
geom_center_y	double	This column represents the Y coordinate of the center of the geometric shape.
gml_id	string	This is a unique identifier for each row in the table.
maakunta	string	This string type column represents the code of the administrative division in Finland.
name	string	This column contains the English name of the administrative division.
namn	string	This column contains the administrative division name in Swedish.
nimi	string	This column contains the administrative division name in Finnish.
shape_star	double	This column holds a real number that represents the geometric area of the administrative division.
shape_stle	double	This column holds a real number that represents the geometric perimeter of the administrative division.
vuosi	double	This column contains the year of the data record.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024