Statistics Area Regional Unit Collection 2024

The dataset collection in question comprises a group of related data tables that source from the website of 'Tilastokeskus' (Statistic Finland), located in Finland. These tables hold a range of related data, neatly organized in a table format with columns and rows for easy comprehension and use. The content provided by Tilastokeskus's service interface (WFS) forms the basis of these tables, offering a rich and thorough dataset for various analytical 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

Historical Versioning of Regional Units 2024 (1:4 500 000)TSV
The 'table__history' is an integral part of the 'tilastointialueet_seutukunta4500k_2024' dataset collection. As a history table, it maintains the version history of its base table rows, ensuring that every change in the data is recorded and preserved for future reference. The table houses a variety of data, including geographical and temporal information, all sourced from 'Tilastokeskus' in Finland. The table comprises unique identifiers for each row, formed by a combination of the extraction date and the row number. This information, along with the table's history functionality, makes it an invaluable tool for tracking data evolution over time. If an '_end_date' is not present for a row, it signifies that the entry is the most recent version. A significant portion of the table is...
Regions 2024 Geographic Dataset Table (Scale 1:4,500,000)TSV
The table in question is a structured collection of data belonging to a larger dataset, specifically related to the regions of Finland as projected for the year 2024. It is sourced from the 'Tilastokeskus' website, which can be translated to 'Statistics Finland'. The table provides a wealth of information, including geographical and regional data, and has a number of potential applications in the field of data analytics. The table includes a range of columns. Of particular note are two special columns: '_extract_date' and '_row_number'. The former indicates the date when data was extracted, while the latter provides a unique identifier for each row based on the extraction date. This unique combination allows for precise tracking and referencing of each individual data entry....

Column Descriptions

Regions 2024 Geographic Dataset Table (Scale 1:4,500,000)

Column	Type	Comment
_extract_date	date	This column contains the date when the row data was extracted from the data source. It uniquely identifies the extraction date of each data row.
_row_number	long	This column contains the row number from the data source on the date of extraction. In combination with '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column contains geometric data in GeoJSON format, which describes the shapes and structures of the geographical features.
geom_geotext	string	This column contains geometric data as textual representation. It provides similar information as 'geom_geojson' but in a different format.
geom_type	string	This column specifies the type of geometric data. It classifies the geometric data into categories like 'ST_POLYGON', 'ST_MULTIPOLYGON', etc.
geom_centroid	string	This column contains the geometric center or centroid of the geographical feature represented by the data row.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the geographical feature.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the geographical feature.
gml_id	string	This column contains a unique identifier for each data row. It is usually a combination of the table name and the row number.
name	string	This column contains the name of the geographical feature represented by the data row. The names are in multiple languages.
namn	string	This column contains the name of the geographical feature in another language.
nimi	string	This column contains the name of the geographical feature in yet another language.
seutukunta	string	This column contains a unique code representing the region of the geographical feature.
vuosi	long	This column contains the year related to the data row. It provides a temporal context to the data.

Historical Versioning of Regional Units 2024 (1:4 500 000)

Column	Type	Comment
_start_date	date	This column shows the date when the row was extracted from the data source. It forms a unique combination with '_row_number' to identify each row in the version 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 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 source. It forms a unique combination with '_start_date' to identify each row in the version history table.
geom_geojson	string	This column contains the geometric representation of the area in GeoJSON format. The data is a polygon.
geom_geotext	string	This column contains the geometric representation of the area in text format.
geom_type	string	This column indicates the type of the geometric data. In this case, it is a polygon.
geom_centroid	string	This column contains the geographical coordinates of the centroid of the area.
geom_center_x	double	This column contains the x-coordinate (longitude) of the centroid of the area.
geom_center_y	double	This column contains the y-coordinate (latitude) of the centroid of the area.
gml_id	string	This column contains a unique identifier for each row, which is a combination of the dataset name and the year.
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.
seutukunta	string	This column contains a code representing a specific region.
vuosi	long	This column contains the year the data represents. All data in this table pertains to the year 2024.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024