2017 Regional Statistics Data Collection

The dataset collection under discussion is a compilation of related data tables, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland). These tables, containing data structured in rows and columns, are connected by a common theme. The description provided by the data source, 'Tilastokeskuksen palvelurajapinta (WFS)', translates to 'Statistics Finland's service interface (WFS)'. This indicates that the data within these tables is likely to be statistical in nature, possibly related to various sectors and demographics within Finland. Each table within this dataset collection is meticulously curated to ensure relevance and coherence, thereby providing a comprehensive view of the theme they represent. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Versioning of Subregions 2017 (1:4 500 000)TSV
The 'table__history' is a history table, sourced from 'Tilastokeskus' (Statistics Finland), providing a chronological record of the data extracted from its base table. It preserves the version history of each row in the base table, identified uniquely by a combination of the date the row was extracted and its row number. The table holds additional columns for start and end dates of each row version. If the end date column has a null value, it indicates the row is the most recently updated version. The primary content of the table is geographic and demographic data corresponding to different regions in Finland. This includes names of the regions in multiple languages, and a variety of geospatial data in the form of polygons, centroids, and center coordinates. The geographic coordinates...
Regions 2017 (1:4 500 000) - Organized Data CollectionTSV
The table, a part of the 'tilastointialueet_seutukunta4500k_2017' dataset, contains detailed geospatial data, specifically pertaining to the 2017 Regional Units at a scale of 1:4 500 000. This intricate data, sourced from the 'Tilastokeskus' website in Finland, offers a wealth of information suitable for a variety of data analytics. It encompasses unique identifiers for each data row along with the date of data extraction, and a range of geographic details that can be leveraged for geospatial data analytics. For instance, the columns beginning with 'geom_' house geographic coordinates and types, such as 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These fields provide data in formats like GeoJSON and GeoText, with geographic types...

Column Descriptions

Regions 2017 (1:4 500 000) - Organized Data Collection

Column	Type	Comment
_extract_date	date	This is a special column that contains the date when the data on the row was extracted from the source. It helps in tracking the historical data extraction process.
_row_number	long	This is another special column that contains the row number in the data extracted from the source, as per the extract date specified by the '_extract_date' column. Together, these two columns uniquely identify each row.
geom_geojson	string	This column contains geographical data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column holds the geographical data in text format. The data represents multiple polygons that define the geographical boundaries.
geom_type	string	This column specifies the type of the geographical data contained in the 'geom_geojson' and 'geom_geotext' columns. In this case, it is a multipolygon type.
geom_centroid	string	This column contains the centroid of the geographical area represented by the multipolygon. The centroid is the geometric center of a two-dimensional shape.
geom_center_x	double	This column holds the X coordinate of the center of the geographical area represented by the multipolygon.
geom_center_y	double	This column contains the Y coordinate of the center of the geographical area represented by the multipolygon.
gml_id	string	This column contains a unique identifier for each row, possibly related to the geographical data.
name	string	This column contains the English name of the geographical area represented by the multipolygon.
namn	string	This column contains the name of the geographical area in another language, which could be local or regional.
nimi	string	This column also holds the name of the geographical area in another language.
seutukunta	string	This column contains some form of code or identifier related to the geographical area.
vuosi	double	This column contains real-type data, possibly indicating a year or time-related aspect.

Historical Versioning of Subregions 2017 (1:4 500 000)

Column	Type	Comment
_start_date	date	This column records the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in this version history table.
_end_date	date	This column records 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. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column stores the geographic information in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column stores the geographic information in text format.
geom_type	string	This column specifies the type of the geographic data stored in the 'geom_geojson' and 'geom_geotext' columns. For example, 'ST_MULTIPOLYGON' indicates a complex geographic shape.
geom_centroid	string	This column captures the centroid or geometric center of the geographic shape represented in the 'geom_geojson' column.
geom_center_x	double	This column records the X-coordinate of the center of the geographic shape.
geom_center_y	double	This column records the Y-coordinate of the center of the geographic shape.
gml_id	string	This column contains a unique identifier for the geographic data.
name	string	This column records the name of the geographic area in the default language.
namn	string	This column records the name of the geographic area in an alternative language.
nimi	string	This column contains another representation of the geographic area's name.
seutukunta	string	This column contains a specific code associated with the geographic area.
vuosi	double	This column records the year associated with the data row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024