Statistical Region Mapping: Major Areas 2022

This dataset collection is an assembly of related data tables that originate from the 'Tilastokeskus' website, Finland. The tables are organized into columns and rows, providing a structured format for better understanding and analysis. The data source, Tilastokeskuksen palvelurajapinta (Statistics Finland Service Interface), suggests that the dataset is likely to feature statistical data. While the content specifics of each data table are not provided, the collection's composition indicates a focus on a significant area, potentially offering rich insights into specific sectors or phenomena at a substantial scale. 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 Version Details of Large Areas 2022 (1:1 000 000)TSV
The 'table__history' is a historical accumulation of records, each representing a version of a row from its base table. It belongs to the dataset collection 'tilastointialueet_suuralue1000k_2022'. This history table is unique in the sense that it contains two additional columns to keep track of the version history of each row in the base table, namely the '_start_date' and '_end_date'. The '_start_date' indicates when the row was initially extracted from the data source, while the '_end_date' shows when a newer version of the row was extracted. If the '_end_date' is null, it indicates that the row is the most recent version. The table presents a detailed geographical dataset, specifically the 'Major Areas 2022 (1:1 000 000)' originating from the Finnish Statistics Bureau...
Large Areas 2022 (1:1 000 000) - Data Table from Finnish Statistical DatabaseTSV
The table, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland), contains comprehensive data about the 'Large Areas of 2022' at a scale of 1:1 000 000. The data is organized into several columns, each with a unique purpose. Two special columns, '_extract_date' and '_row_number', provide context about when the data was extracted and the row number within the data source, respectively. Each row is uniquely identified by the combination of these two columns. The table also includes a set of columns beginning with 'geom_', which contain geospatial data that can be utilized for geospatial data analytics. This data is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. In terms of content, the table...

Column Descriptions

Large Areas 2022 (1:1 000 000) - Data Table from Finnish Statistical Database

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the data source. It helps to track when the data was last updated.
_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'. It uniquely identifies each row.
geom_geojson	string	This column contains the geojson representation of the geographical area. It is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the text representation of the geographical area. It is a format for encoding complex geometric structures.
geom_type	string	This column defines the type of the geometric object. For example, in this table, the type is 'ST_MULTIPOLYGON' indicating that the object is a multipolygon.
geom_centroid	string	This column contains the geometric center or 'centroid' of the geographical area. It is typically represented as a point.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the geographical area.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the geographical area.
gml_id	string	This column contains an identifier for the geographical markup language (GML). It is a standard used for expressing geographical features.
name	string	This column contains the name of the geographical area in English.
namn	string	This column contains the name of the geographical area in Swedish.
nimi	string	This column contains the name of the geographical area in Finnish.
suuralue	string	This column contains a numerical identifier for the large area the geographical area belongs to.
vuosi	long	This column contains the year pertaining to the data in the row. It is an integer value.

Historical Version Details of Large Areas 2022 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains 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 the 'table__history' history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value in this column is null, it signifies 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 in combination with the '_start_date' column for each row in this history table.
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 as text, specifically the geometrical representation of the feature.
geom_type	string	This column specifies the type of the geographical data, which is 'ST_MULTIPOLYGON' indicating the data represents a complex geographical feature.
geom_centroid	string	This column contains the central point of the geographical feature.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical feature.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical feature.
gml_id	string	This column contains a unique identifier for each row in the base table.
name	string	This column contains the English name of the geographical region.
namn	string	This column contains the name of the geographical region in Swedish.
nimi	string	This column contains the name of the geographical region in Finnish.
suuralue	string	This column contains the identifier of the larger area that the region belongs to.
vuosi	long	This column contains the year associated with the data row, indicating the year the data represents.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024