Regions of Administrative Agencies in Finland, 2018 (Scale 1:1 000 000)
Click here for a data sample
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 center coordinates of the administrative areas. These geographic coordinates are presented using the WGS 84 coordinate reference system, where the axis order is longitude first, followed by latitude. The 'gml_id' column provides a unique identifier for each geographic feature. Special columns '_extract_date' and '_row_number' denote the date the data was extracted and the row number respectively, providing a unique identifier for each row. This table, sourced from 'Tilastokeskus' (the Statistics Bureau of Finland), serves as a rich resource for analysts studying regional characteristics or planning regional development strategies. For example, pairing this dataset with population or economic data could provide insights into the correlation between geographic characteristics and various socio-economic indicators.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
