Regional Administrative Agencies Areas 2020 (Scale 1:1 000 000)
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_date | date | The 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_number | long | The 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'. |
|---|
| avi | string | An identifier for the administrative region. Example values include 6, 2, 1, 7. |
|---|
| geom_geojson | string | The geographical coordinates in geojson format. Represents the shape of the administrative region. |
|---|
| geom_geotext | string | The geographical coordinates in text format. Represents the shape of the administrative region. |
|---|
| geom_type | string | The type of the geographical shape. In this table, it is 'ST_MULTIPOLYGON', representing multiple polygon shapes. |
|---|
| geom_centroid | string | The geographical point that represents the center of the administrative region. |
|---|
| geom_center_x | double | The x-coordinate of the geographical center of the administrative region. |
|---|
| geom_center_y | double | The y-coordinate of the geographical center of the administrative region. |
|---|
| gml_id | string | A unique identifier for each row, example values include avi1000k_2020.fi..6be_784b, avi1000k_2020.fi..6be_784a. |
|---|
| id | long | An integer identifier for each row. Example values include 6, 2, 1, 7. |
|---|
| name | string | The English name of the administrative region. Example names include 'Lapland AVI', 'Southwestern Finland AVI', 'Southern Finland AVI', 'State Department of Åland'. |
|---|
| namn | string | The name of the administrative region in the local language. |
|---|
| nimi | string | The Finnish name of the administrative region. Example names include 'Lapin AVI', 'Lounais-Suomen AVI', 'Etelä-Suomen AVI', 'Ahvenanmaan valt..nvirasto'. |
|---|
| vuosi | long | The year of the data. All sample values are 2020 in this table. |
|---|
