2019 Statistical Area Dataset Collection

This dataset collection is a compilation of related data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The tables contained within the collection are rich in information, offering in-depth insight for users. The data is organized in a user-friendly format of columns and rows, allowing for easy data interpretation and analysis. Furthermore, the data source provides a service interface (WFS), which enhances the accessibility and usability of the data. The dataset collection is ideal for anyone looking to explore comprehensive statistics from Finland. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

History of AVI Regions 2019 (Scale 1:4,500,000)TSV
The 'table__history' is a robust record of historical versions of data, sourced from the 'Statistics Finland' website, based in Finland. Its primary focus is on the AVI areas in 2019 at a 1:4 500 000 scale, which holds crucial geographical data. This data can be utilized for geospatial analytics, which could be tremendously beneficial in understanding the geographical patterns, trends, and complexities. The table contains columns that hold geographical information, including the type of geographical area, its centroid, and the coordinates of its center. This geographic data is presented in the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude, which is a standard format in geospatial analytics. The table also contains a unique identifier for each...
Regional Administrative Agencies (AVI) Areas 2019 (Scale 1:4,500,000) - Dataset TableTSV
The 'table' is part of the 'tilastointialueet_avi4500k_2019' dataset collection and contains information on the AVI-areas for the year 2019 at a scale of 1:4,500,000. This information is sourced from the 'Tilastokeskus' (Statistics Finland) website based in Finland. The table is organized into several columns, each containing specific details related to the AVI-areas. Two columns, 'extract_date' and '_row_number', are unique, providing the date data was extracted and the row number from the original extraction. These two columns can be combined to uniquely identify each row of data. Other columns hold geographic information and are prefixed with 'geom'. These geographic data can be leveraged for geospatial data analytics. It's important to note that the geographic coordinates are...

Column Descriptions

Regional Administrative Agencies (AVI) Areas 2019 (Scale 1:4,500,000) - Dataset Table

Column	Type	Comment
_extract_date	date	This column represents the date when the data was extracted from the source. It helps in tracking the version of data at different points in time.
_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'. This column, in combination with '_extract_date', uniquely identifies each row.
avi	string	This column represents an identifier for a specific attribute or feature in the dataset.
geom_geojson	string	This column contains the geometric representation of the data in GeoJSON format. GeoJSON is a widely used format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geometric representation of the data in text format.
geom_type	string	This column specifies the type of the geometric representation of the data, such as 'ST_MULTIPOLYGON'.
geom_centroid	string	This column represents the center point (centroid) of the geometric representation of the data.
geom_center_x	double	This column represents the x-coordinate of the center point of the geometric data.
geom_center_y	double	This column represents the y-coordinate of the center point of the geometric data.
gml_id	string	This column represents a unique identifier assigned to each row of data in GML (Geography Markup Language) format.
id	long	This column represents a unique identifier assigned to each row of data.
name	string	This column contains the name of the attribute or feature in English language.
namn	string	This column contains the name of the attribute or feature in a different language.
nimi	string	This column contains the name of the attribute or feature in yet another language.
vuosi	long	This column represents the year associated with the data row.

History of AVI Regions 2019 (Scale 1:4,500,000)

Column	Type	Comment
_start_date	date	This column contains the date when the data row was extracted from the source. It forms a unique identifier in combination with the '_row_number' column for 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 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 original data extracted from the source. It forms a unique identifier in combination with the '_start_date' column for each row in this version history table.
avi	string	This string type column from the base table represents an identifier of the administrative division.
geom_geojson	string	This column contains the geographical data of the administrative division in GeoJSON format.
geom_geotext	string	This column contains the geographical data of the administrative division in text format.
geom_type	string	This column specifies the type of the geographical data of the administrative division.
geom_centroid	string	This column contains the geographical center of the administrative division.
geom_center_x	double	This column contains the x-coordinate of the geographical center of the administrative division.
geom_center_y	double	This column contains the y-coordinate of the geographical center of the administrative division.
gml_id	string	This string type column from the base table represents the unique geographical markup language identifier.
id	long	This Integer64 type column from the base table provides the unique identifier for each row.
name	string	This string type column from the base table provides the English name of the administrative division.
namn	string	This string type column from the base table provides the Swedish name of the administrative division.
nimi	string	This string type column from the base table provides the Finnish name of the administrative division.
vuosi	long	This Integer64 type column from the base table represents the year of the data row.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024