Statistical Areas Large Region 2019 Data Collection

The dataset collection is a comprehensive grouping of related tables, sourced from the 'Tilastokeskus' (Statistical Centre) website in Finland. It consists of several interrelated data tables, each organized in a structured format with columns and rows for easy understanding and usage. The dataset is based on the Statistical Centre's service interface, providing valuable insights and detailed information. This dataset collection is well-structured and could potentially serve as a valuable resource for those conducting statistical analysis or research. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Large Areas 2019 - Geospatial Statistics (Scale: 1:4 500 000)TSV
The table captures comprehensive data related to the 'Great Areas 2019' (1:4 500 000), sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The table consists of detailed geographic and observational data, including specific identifiers such as the date of data extraction and row numbers, which together uniquely identify each row. The geographic data is presented in multiple formats, including GeoJSON and geotext, and is built upon the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The dataset also contains the geographic center coordinates for each area. The table provides multi-lingual naming data for each area in Finnish, Swedish, and English, and includes a unique identifying number for each large area. The...
Version History for Major Regions 2019 (1:4 500 000) TableTSV
The table 'table__history' is a history table that is part of the dataset collection 'tilastointialueet_suuralue4500k_2019'. It contains the version history of the base table rows, including the date when each row was extracted from the source, as well as the date when a new version of the row was extracted. If the end date is null, it signifies that the row is the most recent version. The table includes a unique identifier for each row, formed by the combination of the start date and row number. The content of the table is related to 'Major Areas 2019 (1:4 500 000)' in Finland, as sourced from the 'Statistical Centre' (Tilastokeskus) website. The data includes geographic information, such as geographic coordinates, presented using the WGS 84 coordinate reference system, with the axis...

Column Descriptions

Large Areas 2019 - Geospatial Statistics (Scale: 1:4 500 000)

Column	Type	Comment
_extract_date	date	The date when the data on the table row was extracted from the data source.
_row_number	long	The row number in the data extracted from the source on the extract date specified by the '_extract_date' column.
geom_geojson	string	The geographical data of the area represented in GeoJSON format.
geom_geotext	string	The geographical data of the area represented in text format.
geom_type	string	The type of the geographical data.
geom_centroid	string	The geographical point representing the centroid of the area.
geom_center_x	double	The x-coordinate of the geographic center of the area.
geom_center_y	double	The y-coordinate of the geographic center of the area.
gml_id	string	The unique identifier for each entry in the table.
name	string	The English name of the area.
namn	string	The name of the area in Finnish.
nimi	string	The name of the area in Swedish.
suuralue	string	Numerical code representing the area.
vuosi	long	The year that the data refers to.

Version History for Major Regions 2019 (1:4 500 000) Table

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 this version history table, together 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 means that the row is the most recent version of the row.
_row_number	long	This column contains the number of the row in the raw data as extracted from the data source. It forms a unique identifier for each row in this version history table, together with '_start_date'.
geom_geojson	string	This column contains geographic information in GeoJSON format representing the geographical boundaries of the area.
geom_geotext	string	This column contains geometric data in text format representing the geographical boundaries of the area.
geom_type	string	This column indicates the type of geometric representation used for the area, for example, ST_MULTIPOLYGON.
geom_centroid	string	This column contains the geometric centroid of the area in point format.
geom_center_x	double	This column contains the x-coordinate of the centroid of the area.
geom_center_y	double	This column contains the y-coordinate of the centroid of the area.
gml_id	string	This column contains the ID of the row as provided by the source 'Tilastokeskus' from Finland.
name	string	This column contains the name of the area in English.
namn	string	This column contains the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
suuralue	string	This column contains a numerical identifier for the area.
vuosi	long	This column contains the year related to the data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024