Statistical Area Dataset Collection 2013

This dataset collection is an assembly of data tables sourced from the website of the Finnish agency, 'Tilastokeskuksen' (Statistics Finland). The collection includes statistical data about various regions in Finland. Each table in the collection offers a unique perspective, providing a comprehensive understanding of the subject matter. The data is organized in a table format, making it easy to interpret and analyze. As part of the collection, each table shares a relationship with the others, contributing to the overall understanding of the statistical areas under examination. The dataset was accessed through the 'Tilastokeskuksen palvelurajapinta (WFS)' (Statistics Finland's Service Interface), underscoring its reliability and accuracy. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regional Administrative Agency Areas in Finland, 2013 (Scale 1:1,000,000)TSV
The table, which is part of a larger dataset collection, contains detailed data about AVI regions in Finland for the year 2013. This information is sourced from the Finnish website 'Tilastokeskus' (Statistics Finland). The table encompasses various types of information, including identification and geographical details. Each row in the table represents a specific AVI region, identified by features such as a unique gid, and an avi code. The row also includes the official name of the region in multiple languages. The geographical information about these regions is presented in several formats, including GeoJSON and Geotext. These geographic details can be used for geospatial data analytics. For example, the geom_centroid column provides the central point of the region, while the...
Version History of AVI Regions 2013 (Scale 1:1,000,000)TSV
The 'table__history' is a historical table that holds the version history of its base table rows, sourced from the 'Tilastokeskus' website in Finland. This table belongs to the 'tilastointialueet_avi1000k_2013' dataset collection and includes several notable columns. This table is a version of the AVI areas 2013 (1:1 000 000) base table with additional columns to track changes over time. Specifically, the table has two additional date-related columns '_start_date' and '_end_date'. The '_start_date' column holds the date when the row was extracted from the source, and '_end_date' represents when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row is the most recent version. In conjunction with the '_row_number' column, which denotes row...

Column Descriptions

Regional Administrative Agency Areas in Finland, 2013 (Scale 1:1,000,000)

Column	Type	Comment
_extract_date	date	This is a special column that contains the date when the data on the row of the table was extracted from the source. The format of the data is in date format.
_row_number	long	This is another special column that contains the row number in the data extracted from the source. It works in combination with '_extract_date' to uniquely identify each row.
avi	string	This column stores string type data, potentially representing various categories or classifications in the dataset.
geom_geojson	string	This column contains geometric data in the GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geometric data as text. It might be helpful for visualization or mapping purposes.
geom_type	string	This column specifies the type of the geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. For instance, the sample value 'ST_MULTIPOLYGON' indicates that the data represents multiple polygonal areas.
geom_centroid	string	This column contains the geometric central point of the geographic data in the row. It may be used to represent the data on a map.
geom_center_x	double	This column represents the X-coordinate of the geometric center of the geographic data in the row.
geom_center_y	double	This column represents the Y-coordinate of the geometric center of the geographic data in the row.
gid	long	This is an integer column, which might be used as an identifier or to link this table with other tables in the database.
gml_id	string	This string-type column may serve as a unique identifier for each row or represent some specific category or classification.
name	string	This is a string column that might contain names of entities, objects, or categories in the dataset.
namn	string	This column, similar to 'name', stores string data. It might contain translated or alternative names for the entities represented in the 'name' column.
nimi	string	This column stores another version of names, potentially in a different language or format compared to 'name' and 'namn'.
vuosi	long	This integer column seems to represent a year, as suggested by the sample value 2013.

Version History of AVI Regions 2013 (Scale 1:1,000,000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source, forming part of the identifier for each row in this version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If this value is null, it signifies that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table.
avi	string	A string type column representing data origin, possibly a code or identifier.
geom_geojson	string	The geographic data of the area, represented in GeoJSON format.
geom_geotext	string	The geographic data of the area, represented as text.
geom_type	string	Describes the type of the geographic data present in the row, for instance 'ST_MULTIPOLYGON'.
geom_centroid	string	The geographical center or 'centroid' of the area, represented as a point.
geom_center_x	double	The X coordinate of the geographical center of the area.
geom_center_y	double	The Y coordinate of the geographical center of the area.
gid	long	An integer type column, possibly representing a unique identifier or a code.
gml_id	string	A string type column, representing a unique identifier.
name	string	The English name of the area.
namn	string	The name of the area in a local language (possibly Finnish or Swedish).
nimi	string	The name of the area in another local language (possibly Finnish or Swedish).
vuosi	long	An integer type column representing the year, possibly the year of data collection or the year the data represents.

Additional Info

Last Updated	November 13, 2024
Created	November 8, 2024