Statistic Areas Data Collection 2018

This dataset collection contains a group of tables sourced from the website of Tilastokeskus (Statistics Finland), located in Finland. The tables are organized in a format consisting of columns and rows, each representing related data. The data within these tables is derived from Tilastokeskus's service interface (WFS). This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Version Records of AVI Areas 2018 (1:1 000 000)TSV
The 'table__history' is a chronologically organized data archive that tracks the version history of its base table rows. It is part of a larger dataset collection focused on statistical areas in Finland. The table content is sourced from the Finnish Statistical Office (Tilastokeskus) and it contains data about AVI areas in Finland for the year 2018 at a scale of 1:1,000,000. The table comprises several columns which store a range of data. One of the key columns is '_row_number', which records the row number from the raw data extracted from the data source. This column, in combination with the '_start_date', forms a unique identifier for each row in the table. These identifiers are crucial for tracking the evolution of data over time. The table also features columns that contain...
Regions of Administrative Agencies in Finland, 2018 (Scale 1:1 000 000)TSV
The 'table' is part of the 'tilastointialueet_avi1000k_2018' dataset collection and it holds significant geographic and administrative data. The table represents the AVI areas for the year 2018, with the scale of 1:1,000,000. Each row in the table represents a unique administrative area, identified by columns such as 'avi', 'id', 'name', 'namn', and 'nimi'. These columns contain identifiers and names for the administrative areas in multiple languages, providing multilingual support for the data. The 'vuosi' column indicates the year represented by the data. The table also contains comprehensive geographical data in the 'geom_' prefixed columns. These columns contain valuable information for geospatial data analytics, including details about the geographic shape, type, centroid, and...

Column Descriptions

Regions of Administrative Agencies in Finland, 2018 (Scale 1:1 000 000)

Column	Type	Comment
_extract_date	date	This column records the date when the specific row of data was extracted from the source. It aids in identifying when the data was last updated.
_row_number	long	This column holds the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. This, in combination with '_extract_date', allows for unique identification of each row.
avi	string	This string column represents a specific identification code.
geom_geojson	string	This column contains geojson format geometrical data, representing the geographical area associated with the row.
geom_geotext	string	This column holds textual representation of geographical data, providing an alternate way to visualize the geographical area.
geom_type	string	This column indicates the type of the geographical data represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the coordinates for the geographical centroid of the area represented by the geometrical data in the row.
geom_center_x	double	This column holds the x-coordinate for the center of the geographical area represented in the row.
geom_center_y	double	This column holds the y-coordinate for the center of the geographical area represented in the row.
gml_id	string	This string column holds a unique identifier for the geographical markup language (GML) data.
id	long	This integer column is a unique identifier for each row in the table.
name	string	This string column contains the English names of the areas represented in each row.
namn	string	This string column contains the names of the areas represented in each row in a different language.
nimi	string	This string column contains the names of the areas represented in each row in yet another language.
vuosi	long	This integer column represents the year associated with the data in the row.

Historical Version Records of AVI Areas 2018 (1:1 000 000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source, serving as a unique identifier in combination with '_row_number'.
_end_date	date	The date when a new version of the row was extracted from the data source. A null value indicates 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, used in combination with '_start_date' to uniquely identify each row.
avi	string	An identifier of a specific administrative division.
geom_geojson	string	The geographical coordinates of the administrative division in GeoJSON format.
geom_geotext	string	The textual representation of the geographical coordinates of the administrative division.
geom_type	string	The type of the geographical data, in this case, a multipolygon.
geom_centroid	string	The geographical point that represents the center of the administrative division.
geom_center_x	double	The X-coordinate of the center of the administrative division.
geom_center_y	double	The Y-coordinate of the center of the administrative division.
gml_id	string	A globally unique identifier for the geographic markup language (GML) data.
id	long	A unique identifier of the row.
name	string	The English name of the administrative division.
namn	string	The name of the administrative division in Finnish Swedish.
nimi	string	The name of the administrative division in Finnish.
vuosi	long	The year associated with the data.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024