Statistical Areas Data Collection 2016

This dataset collection comprises of related tables sourced from the Statistics Finland (Tilastokeskus) website in Finland. These tables offer a wide array of data, meticulously organized into columns and rows for easy interpretation and analysis. The data provided in this collection is the result of a robust service interface, providing a wealth of statistical information. This makes the dataset collection particularly useful for a variety of purposes, ranging from academic research to strategic decision-making in various sectors. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2016 Regional Administrative Boundaries Version History (Scale 1:1,000,000)TSV
The 'table__history' is a rich and comprehensive historical record of the AVI regions in Finland for the year 2016, as sourced from the Finnish Statistics Bureau, 'Tilastokeskus'. This table, part of the 'tilastointialueet_avi1000k_2016' dataset collection, serves as a version history of its base table rows. The table provides detailed geographic information about the AVI regions, including the regions' names in various languages, such as English, Swedish, and Finnish. It also provides geographic coordinates and multipolygon data, which can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. A unique aspect of this table is its structure for...
AVI Regions 2016 (Scale 1:1 000 000) - Dataset TableTSV
The table in question is part of a dataset collection that focuses on the AVI areas from the year 2016, as suggested by the Finnish Statistics Bureau ('Tilastokeskus') in Finland. The content of the table is based on data that represents AVI areas at a scale of 1:1,000,000. The table includes a variety of columns with different types of data. For instance, some columns contain geographic data, while others contain identifiers and names. This wide assortment of data can be beneficial for various data analytics tasks, such as geospatial data analytics. In the table, two columns hold special significance: the date of data extraction and the row number. These two columns work together to uniquely identify each row in the table. The geographic data in the table is represented using the WGS...

Column Descriptions

AVI Regions 2016 (Scale 1:1 000 000) - Dataset Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the data source. It is a part of a unique identifier for each row when combined with '_row_number'.
_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 is a part of a unique identifier for each row when combined with '_extract_date'.
avi	string	This String type column represents a certain unidentified attribute of the dataset.
geom_geojson	string	This column contains a representation of geometrical data in GeoJson format.
geom_geotext	string	This column contains a textual representation of geometrical shapes.
geom_type	string	This column specifies the type of the geometry data in the row. For instance, a sample value 'ST_MULTIPOLYGON' indicates that the geometry is of type 'MultiPolygon'.
geom_centroid	string	This column contains the geometric centroid of the shape represented in the row.
geom_center_x	double	This column contains the X coordinate of the center of the geometrical shape represented in the row.
geom_center_y	double	This column contains the Y coordinate of the center of the geometrical shape represented in the row.
gid	long	An Integer type column representing a unique identifier for each row.
gml_id	string	A String type column serving as a unique identifier for each row in the dataset.
name	string	This String type column represents the name of the entity in English.
namn	string	This String type column represents the name of the entity in a different language.
nimi	string	This String type column represents the name of the entity in another language.
vuosi	double	This Real type column represents the year associated with the data in the row.

2016 Regional Administrative Boundaries Version History (Scale 1:1,000,000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source for the 'table__history' table, which is part of the 'tilastointialueet_avi1000k_2016' dataset collection.
_end_date	date	It refers to the date when a new version of the row was extracted from the data source. A null value in this column 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. Together with '_start_date', it forms a unique identifier for each row in this version history table.
avi	string	This string type column contains code related to specific geographical area in Finland.
geom_geojson	string	This column holds geographical data in GeoJSON format, which represents different types of geographical features.
geom_geotext	string	This column contains the geographical data in text format.
geom_type	string	This column indicates the type of the geometry stored in the row, such as 'ST_MULTIPOLYGON'.
geom_centroid	string	This column holds the geographical coordinates of the centroid of the geographical area.
geom_center_x	double	This column contains the X coordinate (longitude) of the geometrical center of the area.
geom_center_y	double	This column contains the Y coordinate (latitude) of the geometrical center of the area.
gid	long	An integer column which uniquely identifies the geographical area.
gml_id	string	This string column contains a unique identifier for each row.
name	string	This string column contains the English name of the geographical area.
namn	string	This string column contains the Swedish name of the geographical area.
nimi	string	This string column contains the Finnish name of the geographical area.
vuosi	double	A real type column which indicates the year related to the data row.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024