Regional Administrative Agencies Areas 2020 (Scale 1:1 000 000)

To download the data set, please sign up or log in

Click here for a data sample

The table under consideration is a part of a larger dataset collection and comprises data related to AVI regions in 2020 at a scale of 1:1,000,000. It is sourced from the website of the Statistical Centre (Tilastokeskus) in Finland. The table contains key columns that store specific data such as the AVI region identifier, the name of the AVI region in multiple languages, and the year of data collection. The table also includes geospatial data columns that contain geographic coordinates in the WGS 84 coordinate reference system, which positions longitude first, followed by latitude. This geospatial data can be useful for geospatial data analytics. For instance, it can be used to visualize the spatial distribution of AVI regions on a map or to analyze geographic trends and patterns. Two special columns in the table, '_extract_date' and '_row_number', indicate the date of data extraction and the row number respectively, thereby uniquely identifying each row of data. This can be particularly useful in tracking changes in the data over time or identifying specific entries. It is important to note that this table is a valuable data source for researchers studying regional patterns in Finland, policy makers who need to make data-driven decisions, or businesses that operate across different AVI regions and need to understand regional variations.

Field Descriptions

Name Data type Description
_extract_datedateThe date when the data on the row was extracted from the source. This is part of the unique identifier for each row along with the '_row_number'.
_row_numberlongThe row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This is part of the unique identifier for each row along with the '_extract_date'.
avistringAn identifier for the administrative region. Example values include 6, 2, 1, 7.
geom_geojsonstringThe geographical coordinates in geojson format. Represents the shape of the administrative region.
geom_geotextstringThe geographical coordinates in text format. Represents the shape of the administrative region.
geom_typestringThe type of the geographical shape. In this table, it is 'ST_MULTIPOLYGON', representing multiple polygon shapes.
geom_centroidstringThe geographical point that represents the center of the administrative region.
geom_center_xdoubleThe x-coordinate of the geographical center of the administrative region.
geom_center_ydoubleThe y-coordinate of the geographical center of the administrative region.
gml_idstringA unique identifier for each row, example values include avi1000k_2020.fi..6be_784b, avi1000k_2020.fi..6be_784a.
idlongAn integer identifier for each row. Example values include 6, 2, 1, 7.
namestringThe English name of the administrative region. Example names include 'Lapland AVI', 'Southwestern Finland AVI', 'Southern Finland AVI', 'State Department of Åland'.
namnstringThe name of the administrative region in the local language.
nimistringThe Finnish name of the administrative region. Example names include 'Lapin AVI', 'Lounais-Suomen AVI', 'Etelä-Suomen AVI', 'Ahvenanmaan valt..nvirasto'.
vuosilongThe year of the data. All sample values are 2020 in this table.

No sample for this dataset

Additional Information

Last updated November 11, 2024
Created November 11, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Id5c493cc2-b5e2-48a5-9fc7-cee13610c2cb
Package id048ee375-fcdd-4cfa-aee1-e710ea60e94e
Revision id13dd6ebf-0928-422e-aea5-7e4fe97229ab
Stateactive
Tabletilastointialueet_avi1000k_2020__table