Statistics Area Province 1000k 2018 Dataset Collection

This dataset collection comprises of related data tables sourced from the 'Tilastokeskus' website based in Finland. The dataset provides an invaluable resource for understanding statistical areas in Finland, featuring detailed data tables that cover a variety of aspects. The data within these tables are meticulously organized in a column and row format, making it easy to analyze and draw insights from. The dataset collection has been retrieved using the service interface (WFS) of the Finnish Statistics Bureau, ensuring the data is accurate, reliable, and up-to-date. 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 2018 (Scale 1:1 000 000) - Geospatial DataTSV
The table is part of a dataset collection that encapsulates data related to the administrative regions of Finland for the year 2018. It is sourced from 'Tilastokeskus' (Statistics Finland), offering a detailed depiction of regions at a 1:1 000 000 scale. The information included ranges from the unique identifiers of these regions, their names in different languages, to the year of the data. It also provides a wealth of geospatial data, enabling the analysis of the regions' geographical characteristics. For instance, it includes geographical information in various formats, such as GeoJSON and GeoText, the type of the geometry, and the coordinates of the centroid of the geometry. The geographical coordinates are presented using the WGS 84 coordinate reference system, with the longitude...
Version History of Provinces 2018 (1:1 000 000) DatasetTSV
The 'table__history' belongs to the dataset named 'tilastointialueet_maakunta1000k_2018' and it serves as a version history of its base table rows. The table's contents are sourced from the 'Tilastokeskus' (Statistics Finland) website. The table contains data pertaining to regions in Finland as per the 2018 census, which is indicated in the 'vuosi' column. Each row in the table represents a specific version of the data as indicated by the 'row_number' column, and the '_start_date' and '_end_date' columns denote the duration for which that particular version was valid. A null value in the '_end_date' column signifies that the version is the most recent. The geographical data contained in the 'geom' prefixed columns is particularly useful for geospatial data analytics. These columns hold...

Column Descriptions

Regions 2018 (Scale 1:1 000 000) - Geospatial Data

Column	Type	Comment
_extract_date	date	This column records the date when the data row was extracted from the data source.
_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'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row.
geom_geojson	string	This column stores the geographical data in GeoJSON format which represents simple geographical features.
geom_geotext	string	This column contains the geographical data in text format.
geom_type	string	This column defines the type of the geographical object.
geom_centroid	string	This column represents the geographical center of the object in the form of a point.
geom_center_x	double	This column represents the X-coordinate of the geographical center of the object.
geom_center_y	double	This column represents the Y-coordinate of the geographical center of the object.
gml_id	string	This column contains a unique identifier for each row.
maakunta	string	This column represents the province code.
name	string	This column contains 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 represents the year to which the data refers.

Version History of Provinces 2018 (1:1 000 000) Dataset

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source in the format YYYY-MM-DD. It forms a unique identifier for each row in combination with the '_row_number' column.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source in the format YYYY-MM-DD. If the value is null, it 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 the '_start_date' column.
geom_geojson	string	This column contains geometric data in GeoJSON format, a common format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geometric data as text. The format used is 'MULTIPOLYGON', encapsulating multiple polygonal shapes.
geom_type	string	This column indicates the type of geometric data represented. In this case, it is 'ST_MULTIPOLYGON', a collection of polygons.
geom_centroid	string	This column contains the coordinates of the centroid of the geometric shape represented in the 'geom' column.
geom_center_x	double	This column contains the X coordinate of the center of the geometric shape.
geom_center_y	double	This column contains the Y coordinate of the center of the geometric shape.
gml_id	string	This is an identifier column. It contains unique identifiers for each row in the table.
maakunta	string	This column contains string identifiers for the province.
name	string	This column contains the English names of the provinces.
namn	string	This column contains the Swedish names of the provinces.
nimi	string	This column contains the Finnish names of the provinces.
vuosi	long	This column contains the year that the data refers to.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024