Statistical Regions of Major Areas in 2019

The dataset collection in question is a compilation of related data tables, sourced from the website of 'Tilastokeskus' (Statistics Center) based in Finland. The dataset was created to serve as a statistical service interface, as suggested by the original description, 'Tilastokeskuksen palvelurajapinta (WFS)'. Each table in the collection houses data that is related and organized in a table format, which includes rows and columns for easy comprehension and analysis. The dataset collection provides extensive data, which is conducive to detailed statistical analysis and 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 (Scale 1:1,000,000) - Dataset TableTSV
The table is a part of a dataset collection, and it encompasses a multitude of data primarily focused on geographic regions in Finland, specifically the major areas in 2019 (as translated from Suuralueet 2019). This data spans various geographic parameters and descriptions, providing a comprehensive profile of each region. The table includes key details about the regions such as their names in different languages, including English, Finnish, and Swedish. It also provides a numerical representation of each region and the year of the data, which in this case is 2019. A significant part of the table is dedicated to geospatial information, providing various forms of geographic data. This includes the geojson and geotext formats, the type of the geometric shape representing each region, the...
Version History of Major Regions 2019 (1:1 000 000)TSV
The table, referred to as a 'history' table, is part of a larger dataset collection. This particular table primarily serves to keep track of the version history of its base table rows, providing a comprehensive record of each row's updates over time. The contents of the base table, translated into English, are 'Major Areas 2019 (1:1 000 000)'. This suggests that the data within the table corresponds to different geographical regions or 'major areas' for the year 2019, possibly at a scale of 1:1 million. The table contains several columns, some of which are unique to this history table. These include '_start_date' and '_end_date', which represent the lifespan of each row, marking when the data was first extracted and when it was last updated or replaced. The '_row_number' is also unique...

Column Descriptions

Large Areas 2019 (Scale 1:1,000,000) - Dataset Table

Column	Type	Comment
_extract_date	date	This column records the date when the row's data was extracted from the source. It helps to track the freshness of the data.
_row_number	long	This column indicates the row number when the data was extracted from the source. It helps in maintaining the order of the data.
geom_geojson	string	This column contains geometric data in a GeoJSON format. It can be used for spatial analysis and visualizations.
geom_geotext	string	This column contains geometric data in text format. It provides a human-readable representation of the spatial data.
geom_type	string	This column defines the type of the geometry of the data. For example, it can be a multipolygon.
geom_centroid	string	This column contains the coordinates of the centroid of the geometry. It is useful for spatial analysis.
geom_center_x	double	This column contains the x-coordinate of the center of the geometry. It is used for spatial analysis and visualizations.
geom_center_y	double	This column contains the y-coordinate of the center of the geometry. It is used for spatial analysis and visualizations.
gml_id	string	This column contains a unique identifier for each record. It helps in reference and data management.
name	string	This column contains the English name of the region. It is useful for understanding the geographic context of the data.
namn	string	This column contains the Swedish name of the region. It provides a multilingual perspective on the data.
nimi	string	This column contains the Finnish name of the region. It provides a local context to the data.
suuralue	string	This column contains a numerical code for the region. It can be used for data analysis and joins with other tables.
vuosi	long	This column indicates the year the data pertains to. It can be used for temporal analysis and trend identification.

Version History of Major Regions 2019 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when a row was extracted from the data source, providing a timestamp for the version history of the row.
_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 enumerates the rows in the raw data. Combined with '_start_date', it uniquely identifies each row in the version history table.
geom_geojson	string	This column contains spatial data in the GeoJSON format, describing the geometric shape of the areas represented in each row.
geom_geotext	string	This column provides the geometric shape of the areas in text format.
geom_type	string	This column indicates the type of geometry used for the geographic data in the row. For example, 'ST_MULTIPOLYGON' indicates a shape formed by multiple polygons.
geom_centroid	string	This column contains the central point (centroid) of the geometric shape for each area.
geom_center_x	double	This column contains the X-coordinate of the central point of the geometric shape for each area.
geom_center_y	double	This column contains the Y-coordinate of the central point of the geometric shape for each area.
gml_id	string	This column contains a unique identifier for each row, typically following a specific naming convention.
name	string	This column contains the English name of the area represented in each row.
namn	string	This column contains the name of the area in another language, possibly Swedish, given the similarity to the English names.
nimi	string	This column contains the name of the area in another language, possibly Finnish, given the dataset's origin.
suuralue	string	This column contains a numerical identifier for each area.
vuosi	long	This column contains a year, possibly indicating the year the data for each row was collected or relevant for.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024