2017 Statistical Area Groupings - Large Region

This dataset collection is a compilation of related data tables sourced from the website of 'Tilastokeskuksen' (Statistics Finland), from Finland. These tables are organized into a format that allows for easy readability and analysis, with each table consisting of rows and columns of related data. The data within this collection is provided through the service interface of Statistics Finland, offering a rich source of statistical information. Please note that this description is based on the original data source and may vary depending on the specific content of each table within the collection. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Major Regions 2017 (Scale 1:4,500,000) - Dataset TableTSV
The table is a part of the dataset collection that houses data related to 'Major Regions 2017 (1:4 500 000)'. The table is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. The data is organized in columns, each representing a specific aspect of the major regions. The table contains special columns such as '_extract_date', which signifies the date the data was extracted, and '_row_number', which represents the row number in the data extracted. These two columns uniquely identify each row. The table also contains several columns starting with 'geom_', these columns carry geographic information that can be used for geospatial data analytics. For instance, 'geom_center_x' and 'geom_center_y' represent the geographic coordinates of the major regions, specified...
Version History of Large Areas 2017 (Scale 1:4 500 000)TSV
The 'table__history' is a history table that forms part of the larger dataset collection. It contains a variety of information related to the 'Greater Regions 2017' (Suuralueet 2017) at a scale of 1:4,500,000, sourced from the 'Statistics Finland' (Tilastokeskus) website based in Finland. The table includes a unique combination of 'start_date' and '_row_number' that identifies each row in this version history table. The '_start_date' signifies the date when the row was extracted from the source, while the '_end_date' marks the date when a new version of the row was extracted. If '_end_date' is null, it indicates that the row is the most recent version. The table also features columns starting with 'geom' that contain geographic information, ideal for geospatial data analytics. These...

Column Descriptions

Major Regions 2017 (Scale 1:4,500,000) - Dataset Table

Column	Type	Comment
_extract_date	date	This special column contains the date when the row data was extracted from the source. It helps in tracking when the specific data was fetched.
_row_number	long	Another special column which stores the row number of the extracted data from the source. When combined with '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column contains the geographical data in the GeoJSON format representing different regions.
geom_geotext	string	Stores geographical data as text, typically used for complex geographical structures.
geom_type	string	Specifies the type of the geographical data stored. In this case, it is 'ST_MULTIPOLYGON', indicating that the data represents multiple polygon shapes.
geom_centroid	string	Contains the central point (centroid) of the geographical figure represented.
geom_center_x	double	The X-coordinate of the center point of the geographical area.
geom_center_y	double	The Y-coordinate of the center point of the geographical area.
gml_id	string	A unique identifier for each record in the table.
name	string	The English name of the region represented by the row.
namn	string	The name of the region in Swedish.
nimi	string	The name of the region in Finnish.
suuralue	string	A numerical code representing the large area (suuralue in Finnish) the region belongs to.
vuosi	double	The year the data was collected or is relevant to.

Version History of Large Areas 2017 (Scale 1:4 500 000)

Column	Type	Comment
_start_date	date	This column marks the date when the row was extracted from the data source. It forms a unique combination with the '_row_number' to identify each row in this 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 data source. It forms a unique combination with the '_start_date' to identify each row.
geom_geojson	string	This column contains the geographic data in GeoJSON format. It represents the geographic shape of the statistical area.
geom_geotext	string	This column contains the geographic data in Geotext format. It is another representation of the geographic shape of the statistical area.
geom_type	string	This column specifies the type of the geographic shape represented in 'geom_geojson' and 'geom_geotext' columns. The type is 'ST_MULTIPOLYGON' indicating a shape with multiple polygonal areas.
geom_centroid	string	This column contains the point coordinates that represent the centroid of the geographic shape of the statistical area.
geom_center_x	double	This column contains the x-coordinate of the centroid of the geographic shape of the statistical area.
geom_center_y	double	This column contains the y-coordinate of the centroid of the geographic shape of the statistical area.
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 statistical area.
namn	string	This column contains the Swedish name of the statistical area.
nimi	string	This column contains the Finnish name of the statistical area.
suuralue	string	This column contains a numerical identifier for the statistical area.
vuosi	double	This column contains the year of the data record.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024