Statistics Area Regional Unit 4500k 2022 Collection

This dataset collection is a valuable aggregation of related data tables, all sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The content of the collection is derived from the service interface of Statistics Finland, providing a rich array of data for users. The tables within the collection are structured in a user-friendly format, consisting of columns and rows for easy data interpretation. The dataset collection offers a wealth of information, making it an essential resource for anyone seeking comprehensive data from Finland's statistical landscape. 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 Records of Regional Units 2022 (1:4 500 000)TSV
The 'table__history' is an invaluable component of the 'tilastointialueet_seutukunta4500k_2022' dataset collection, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland). This table is a history table, designed to store the version history of its base table rows. It offers a time-stamped record of each row, with unique identifiers created through a combination of '_start_date' and '_row_number'. The former indicates when the row was extracted, while the latter is the row's number in the raw data. If '_end_date' is null, it implies that the row is the most recent version. The base table content, 'Seutukunnat 2022 (1:4 500 000)', translates to 'Subregions 2022 (1:4 500 000)', reflecting the focus on subregional data. The columns of this table include geographic information...
Regional Units 2022 (Scale 1:4,500,000) - Data TableTSV
The table belongs to a dataset collection that contains geographical data about the regions in Finland, sourced from the Statistics Finland (Tilastokeskus) website. The main contents of the table are captured under the categories of extraction date, row number, geographical data, and region details. It includes data about regions as of the year 2022 at a scale of 1:4,500,000. The geographical data in the table is multifaceted, offering details about the type of geographical entity (polygon or multipolygon), its geographical representation in GeoJSON and GeoText formats, its centroid, and its X and Y center coordinates. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis ordered as longitude first, followed by latitude. This...

Column Descriptions

Regional Units 2022 (Scale 1:4,500,000) - Data Table

Column	Type	Comment
_extract_date	date	This column holds the date of data extraction from the source. It represents the point in time when the row data was collected.
_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'. Together with '_extract_date', this column uniquely identifies each row.
geom_geojson	string	This column contains geometric data of a given area in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column holds the geometric data of a given area in text format.
geom_type	string	This column specifies the type of geometric data stored in the row. The types can be polygon or multipolygon.
geom_centroid	string	This column contains the centroid of the geometric figure. The centroid is a point defining the geometric center of a figure.
geom_center_x	double	This column stores the x-coordinate of the center point of the geometric figure.
geom_center_y	double	This column stores the y-coordinate of the center point of the geometric figure.
gml_id	string	This column holds a unique identifier for each row, which is set by the 'Tilastokeskus' (Statistics Finland) data source.
name	string	This column contains a name, possibly the name of an area or region.
namn	string	This column holds another name, likely representing the same area or region in a different language.
nimi	string	This column contains another version of the name, likely representing the same area or region in a different language.
seutukunta	string	This column holds a string data, likely an identifier or code associated with the named area or region.
vuosi	long	This column holds an integer value, possibly representing the year associated with the data in the row.

Historical Version Records of Regional Units 2022 (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 beginning of the version of the row in this history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version.
_row_number	long	This column represents the number of the row in the raw data extracted from the data source. Combined with '_start_date', it uniquely identifies each row in this history table.
geom_geojson	string	This column contains the geometric definition of the area associated with the row in the GeoJSON format.
geom_geotext	string	This column contains the geometric definition of the area associated with the row in textual format.
geom_type	string	This column indicates the type of geometric feature used to represent the area associated with the row.
geom_centroid	string	This column contains the central point (centroid) of the geometric feature associated with the row.
geom_center_x	double	This column contains the x-coordinate of the centroid of the geometric feature associated with the row.
geom_center_y	double	This column contains the y-coordinate of the centroid of the geometric feature associated with the row.
gml_id	string	This column contains a unique identifier for each row in the table.
name	string	This column contains the English name of the regional unit associated with the row.
namn	string	This column contains the name of the regional unit associated with the row in another language.
nimi	string	This column contains the name of the regional unit associated with the row in another language.
seutukunta	string	This column contains a coded representation of the regional unit associated with the row.
vuosi	long	This column contains the year associated with the data in the row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024