Statistical Area Collection and Table 2016

The dataset collection under discussion is a compilation of related data tables sourced from the website of Tilastokeskus (Statistics Finland). This collection is compiled in Finland and is made up of various tables, each containing related data arranged in a tabular format, with distinct rows and columns. The primary purpose of this dataset collection is to provide a statistical interface service, as indicated by the description provided by the data source. Each table in the collection offers an in-depth and rich array of data, enhancing the overall understanding and interpretation of the dataset collection. This comprehensive dataset collection is instrumental in providing valuable insights and information for various statistical analysis and research purposes. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Subregions 2016 (1:4 500 000) - A Table from the Collection 'tilastointialueet_seutukunta4500k_2016'TSV
The table in question is part of a larger dataset collection, and it features a range of data related to the Finnish sub-regional units (Seutukunnat) in 2016. The data content of this table is a rich mix of geographic and demographic information, making it a valuable resource for various forms of data analytics. The table includes geographic data represented through multiple columns. For instance, the content of certain columns is dedicated to providing geospatial information in geojson and geotext formats, represented as multipolygons. The geographic coordinates within these columns are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This specific format is recognized for its ability to support geospatial data...
Version History of Regional Units 2016 (1:4 500 000)TSV
The 'table__history' is a history table that provides an extensive chronicle of its base table rows. Its content is derived from the 'Seutukunnat 2016' dataset, which translates to 'Regions 2016' in English. This dataset, originating from 'Tilastokeskus' (Statistics Finland), offers valuable insights into various aspects of different regions in Finland. The data is structured in a way that allows for a comprehensive understanding of changes over time, as it includes a version history of its base table rows. The table includes unique identifiers for each row, signifying the number of the row in the raw data, and the date the row was extracted, which together form a combination that uniquely identifies each row in this version history table. The table also contains a date column...

Column Descriptions

Subregions 2016 (1:4 500 000) - A Table from the Collection 'tilastointialueet_seutukunta4500k_2016'

Column	Type	Comment
_extract_date	date	This column represents the date when the data in each row was extracted from the source.
_row_number	long	This column contains the unique row number extracted from the source on the extract date specified in the '_extract_date' column.
geom_geojson	string	This column contains geometric data in GeoJSON format, which represents the geographic features of the areas.
geom_geotext	string	This column contains geometric data in text format, representing the geographic features of the areas.
geom_type	string	This column describes the type of geometric data contained in the records, which in this case is a multipolygon.
geom_centroid	string	This column contains geometric data representing the central point (centroid) of the geographic features.
geom_center_x	double	This column represents the X-coordinate of the central point of the geographic features.
geom_center_y	double	This column represents the Y-coordinate of the central point of the geographic features.
gml_id	string	This column contains a unique identifier for each record in the GML format.
name	string	This column contains the name of the area in English.
namn	string	This column contains the name of the area in a different language, possibly Swedish or Finnish.
nimi	string	This column contains the name of the area in another language, likely Finnish.
seutukunta	string	This column contains a code that represents the region of the area.
vuosi	double	This column represents the year to which the data pertains, in this case, 2016.

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

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source, indicating the start of the version history for that particular row.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source, indicating the end of the version history for that row. If the value is null, it means 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 contains the geographical data in GeoJSON format. It represents the geographical boundaries of the statistical area.
geom_geotext	string	This column also contains the geographical data, but in a text format. It represents the geographical boundaries of the statistical area.
geom_type	string	This column indicates the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. In this case, it is a multi-polygon.
geom_centroid	string	This column contains the geographical coordinates of the centroid of the statistical area. The centroid is the geometric center of a shape.
geom_center_x	double	This column contains the X coordinate of the centroid of the statistical area.
geom_center_y	double	This column contains the Y coordinate of the centroid of the statistical area.
gml_id	string	This column contains a unique identifier for each row in the table. It can be used to reference a specific row.
name	string	This column contains the name of the statistical area in English.
namn	string	This column contains the name of the statistical area in Swedish.
nimi	string	This column contains the name of the statistical area in Finnish.
seutukunta	string	This column contains a code that represents the statistical area.
vuosi	double	This column contains the year for which the statistical data is relevant.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024