2016 Statistical Area Data Collection

The dataset collection is a comprehensive set of data tables derived from the 'Tilastokeskus' (Statistics Finland) website in Finland. These tables form an interconnected group, each contributing to a broader understanding of the topic. The contents of the dataset are organized into a table format, with related data systematically arranged into rows and columns. The data within this collection is primarily sourced from the 'Tilastokeskuksen palvelurajapinta (WFS)', which translates to 'Statistics Finland's service interface (WFS)'. This denotes the source of the data, signifying that it has been retrieved from a reliable and authoritative statistical service in 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

History of Municipalities 2016 - Version History Log (1:4 500 000)TSV
The 'table__history' is a unique historical table that contains the version history of its base table rows. It provides a comprehensive record of the municipalities in Finland, as sourced from 'Tilastokeskus' (Statistics Finland), a notable Finnish data source. The table captures details about each municipality, including their names in different languages and the geographical coordinates that uses the WGS 84 coordinate reference system, with longitude first, followed by latitude. The table has been structured to support a robust version control system. Each row in the table is uniquely identified by a combination of the date it was extracted from the data source and its row number. These details are captured in special columns, '_start_date' and '_row_number'. To track updates to each...
Municipalities 2016 (Scale 1:4,500,000) - Data TableTSV
The table in question is part of a dataset collection that is primarily focused on municipalities in 2016 at a scale of 1:4 500 000. The data within the table is quite comprehensive and versatile, encompassing various areas of information, including geographic and temporal details. The table houses geographical information with the prefix 'geom_', which can be applied in geospatial data analysis. This information includes geojson data, geotext, type, centroid, and center coordinates (x and y), all presented in WGS 84 coordinate reference system, where longitude comes first, followed by latitude. The table also includes columns for the municipality code ('kunta'), and the name of the municipality in three different languages ('name', 'namn', 'nimi'), which can be useful for...

Column Descriptions

Municipalities 2016 (Scale 1:4,500,000) - Data Table

Column	Type	Comment
_extract_date	date	This column stores the date when the data row was extracted from the source. It helps track when the data was updated.
_row_number	long	This column holds the row number of the extracted data. It, combined with the extract date, uniquely identifies each row.
geom_geojson	string	This column contains the geographical data of the area represented in GeoJSON format, a common format for encoding geographical data.
geom_geotext	string	The column includes the geographical data of the area in text format.
geom_type	string	This column specifies the type of the geographical data, which in this case is 'ST_MULTIPOLYGON', indicating that the data represents multiple polygon areas.
geom_centroid	string	This column contains the geographical coordinates of the centroid or geometric center of the area.
geom_center_x	double	This column holds the x-coordinate of the geometric center of the area.
geom_center_y	double	This column holds the y-coordinate of the geometric center of the area.
gml_id	string	This string-type column stores a unique identifier for the data row.
kunta	string	This string-type column holds an identifier for the municipality or area.
name	string	This string-type column stores the name of the area or municipality.
namn	string	This string-type column also stores the name of the area or municipality, possibly in a different language or format.
nimi	string	This string-type column contains another version of the name of the area or municipality.
vuosi	double	This real-type column stores the year associated with the data row, indicating the time period the data represents.

History of Municipalities 2016 - Version History Log (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 is part of a unique identifier for each row in the version history table, 'table__history', in combination with '_row_number'.
_end_date	date	This column contains 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	This column contains the number of the row in the raw data extracted from the data source. It forms part of a unique identifier for each row in combination with '_start_date'.
geom_geojson	string	This column contains the geographic data in GeoJSON format, a common format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geographic data represented as text.
geom_type	string	This column specifies the type of the geometry data. The sample values suggest that the data type is 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the centroid of the geometry data, which is the center point of the geometric object.
geom_center_x	double	This column specifies the X coordinate of the center of the geometric object.
geom_center_y	double	This column specifies the Y coordinate of the center of the geometric object.
gml_id	string	This column contains a unique identifier provided by the data source.
kunta	string	This column contains a string value. The specific meaning is not provided by the data source.
name	string	This column contains a string value, possibly representing the name of a specific entity.
namn	string	This column contains a string value. The specific meaning is not provided by the data source.
nimi	string	This column contains a string value. The specific meaning is not provided by the data source.
vuosi	double	This column contains a real number value, possibly representing a year.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024