Statistical Area Large Zone Data Collection

The dataset collection under consideration is a compilation of tables obtained from the 'Tilastokeskus' website, located in Finland. These tables contain statistics-related data, sourced from the service interface of the Statistics Center, or 'Tilastokeskuksen palvelurajapinta' in Finnish. The tables in the collection are interrelated, each offering a unique set of data. The data within the tables is presented in a structured format, with columns and rows representing different data points and categories. The collection provides a broad spectrum of statistical data, reflecting various aspects and time frames. 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 Statistical Dataset (1:4 500 000 Scale)TSV
The table is part of a dataset collection that holds information on different geographical areas at a 1:4,500,000 scale. The data in this table provides a rich set of information, including geographical identifiers, detailed geographical information, and names of the areas in various languages. This dataset is sourced from the 'Tilastokeskus' website, based in Finland. The table consists of unique identifiers for each row that are determined by a combination of the date when the data was extracted and a row number. This allows for each row to be uniquely identified and tracked over time. The table also contains geographical data, encoded in various formats, including GeoJSON and GeoText. The geographical data present in this table is based on the WGS 84 coordinate reference system, with...
Version History of Large Areas (1:4 500 000)TSV
The table 'table__history' is a historical data table that forms part of a larger dataset collection. This table captures the version history of its base table rows in a detailed and organized manner. It includes data on large areas (1:4 500 000) and has been sourced from 'Tilastokeskus' (Statistics Finland), a reputable data provider in Finland. The data contained in this table is distinguished by the dates of extraction and updates from the source, as well as the unique row numbers, ensuring each row in the version history table can be accurately identified and tracked. The table also contains geographic data, allowing for geospatial analytics. This geographic information is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by...

Column Descriptions

Large Areas Statistical Dataset (1:4 500 000 Scale)

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the 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 helps to uniquely identify each row.
geom_geojson	string	This column contains geometric data in geojson format, which represents geographical features.
geom_geotext	string	This column contains geometric data in text format, providing a textual representation of the geographical features.
geom_type	string	This column specifies the type of geometric data present in the table, for example, 'ST_MULTIPOLYGON' indicates that the data represents multiple polygonal areas.
geom_centroid	string	This column contains the geometric center or centroid of the geographical feature.
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 the geographical feature, which can be used for reference and linking.
name	string	This column contains the name of the geographical feature in English.
namn	string	This column contains the name of the geographical feature in the Swedish language.
nimi	string	This column contains the name of the geographical feature in the Finnish language.
suuralue	string	This column contains a numerical value representing a specific larger area, possibly a region or district code.
vuosi	long	This column contains the year related to the data, which could indicate when the data was collected or the year the data is relevant for.

Version History of Large Areas (1:4 500 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 for each row in the version history table in combination with the '_row_number' column.
_end_date	date	This column contains the date when a new version of the row was extracted. 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 identifier for each row in the version history table in combination with the '_start_date' column.
geom_geojson	string	This column contains the geometry of the area in GeoJSON format.
geom_geotext	string	This column contains the geometry of the area in text format.
geom_type	string	This column specifies the type of the geometry data.
geom_centroid	string	This column contains the centroid of the geographical area.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical area.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical area.
gml_id	string	This column contains an ID that is unique for each row.
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.
suuralue	string	This column contains an identifier for the major region the area belongs to.
vuosi	long	This column contains the year of the data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024