2021 Statistical Survey Areas

The dataset collection in question is a compilation of related tables, all sourced from the Statistics Centre (Tilastokeskus) in Finland. It features data accessed via the Statistical Centre's service interface (WFS). The tables within the collection are interconnected, each providing unique yet harmonious data. The data contained within these tables is arranged in a systematic manner, with data points sorted into specific rows and columns for easy interpretation. This dataset collection is a valuable resource for those seeking information from the Finnish statistical archives. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regions Administrative Division 2021 - Detailed Geospatial Data (Scale 1:4 500 000)TSV
The table in discussion is part of a broader dataset collection. This table is specifically dedicated to AVI areas of 2021 at a scale of 1:4,500,000. It is derived from the 'Tilastokeskus' website, located in Finland. The table is rich with a variety of columns that carry specific and unique data. Two notable columns, 'extract_date' and '_row_number', present the date of data extraction and the row number in the extracted data, respectively. These two columns together create a unique identifier for each row. The table also carries geographical data in various forms across multiple 'geom' prefixed columns. This data can be beneficial in geospatial analytics, with coordinates presented using the WGS 84 coordinate reference system, where axis order is longitude first, followed by latitude....
Version History of AVI Regions 2021 (1:4 500 000)TSV
The 'table__history' is a specialized history table that stores the version history of its base table rows. It belongs to a dataset collection primarily revolving around the AVI areas 2021 (1:4 500 000). The data content of the table is organized in rows and columns, where each row contains a unique combination of a start date and row number, serving as a unique identifier for each row in the table. The table contains a variety of columns, including special ones like '_start_date', '_end_date', and '_row_number'. The '_start_date' denotes the date when the row was extracted from the data source, and '_end_date' signifies the date when a new version of the row was extracted. If '_end_date' is null, it means that the row is the most current version. The '_row_number' gives the order of...

Column Descriptions

Regions Administrative Division 2021 - Detailed Geospatial Data (Scale 1:4 500 000)

Column	Type	Comment
_extract_date	date	This column records the date when the specific row of data was extracted from the data source.
_row_number	long	This column contains the sequential row number of the data extracted from the source on the given extract date. The combination of '_extract_date' and '_row_number' uniquely identifies each row.
avi	string	This column represents an identifier.
geom_geojson	string	This column contains the geographical data in GeoJSON format, which describes the shapes of the geographical areas.
geom_geotext	string	This column contains the geographical data in geotext format, providing another way to represent the shapes of geographical areas.
geom_type	string	This column indicates the type of the geographical data, for instance, whether the data represents a multipolygon or a single polygon.
geom_centroid	string	This column contains the centroid of the geographical area represented by the row of data. The centroid is the center point of the shape.
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 a unique identifier for each row in the GML (Geography Markup Language) format.
id	long	This column contains a unique integer identifier for each row.
name	string	This column contains the English name of the geographical area.
namn	string	This column contains the Swedish name of the geographical area.
nimi	string	This column contains the Finnish name of the geographical area.
vuosi	long	This column contains the year associated with the data, given as an integer.

Version History of AVI Regions 2021 (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 helps in maintaining version history of the rows in the table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If this value is null, it means 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. It helps in uniquely identifying each row in this version history table.
avi	string	This column contains string type data. The exact content and purpose of this column is not provided by the data source.
geom_geojson	string	This column contains the geographical data in GeoJSON format. It is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geographical data in text format. It represents the shapes of geographical features.
geom_type	string	This column represents the type of the geographical data like Polygon or MultiPolygon.
geom_centroid	string	This column contains the central point of the geographical feature.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical feature.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical feature.
gml_id	string	This column contains a unique string identifier.
id	long	This column contains a unique integer identifier.
name	string	This column contains the English name of the geographical feature.
namn	string	This column contains the name of the geographical feature in a different language.
nimi	string	This column contains the name of the geographical feature in a different language.
vuosi	long	This column contains the year related data as integer.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024