Regional Administrative Agencies (AVI) Areas 2014 at 1:1,000,000 Scale
Click here for a data sample
The table, which is part of a larger dataset collection, contains detailed geospatial data pertaining to regions in Finland, specifically the AVI regions for the year 2014. The data has been sourced from the 'Tilastokeskus' (Statistics Finland) website. The table's comprehensive data includes unique identifiers, regional names in various languages, the year of data, and specific geospatial details. Each row in the table is distinctively identified by a unique combination of an extraction date and a row number. The table also contains several columns starting with 'geom_' that hold geographic information, crucial for geospatial data analytics. This geospatial data is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The data in this table could be utilized in various ways. For example, by analyzing the geographic data, one can visualize the regions on a map for spatial analyses. The data can also be helpful in studying regional trends or changes over time by comparing the data of different years. Furthermore, the multilingual regional names can be used for international studies or for applications designed for multilingual users.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column denotes the date when the data on the row was extracted from the data source. It forms a part of a unique identifier for each row when combined with '_row_number'. |
|---|
| _row_number | long | This column represents the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It forms a part of a unique identifier for each row when combined with '_extract_date'. |
|---|
| avi | string | This is a numerical column which seems to be associated with different regions of Finland. |
|---|
| geom_geojson | string | This column contains geometric data in GeoJSON format, a popular format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains geometric data in text format, specifically, it represents multiple geographic polygons. |
|---|
| geom_type | string | This column states the type of the geometric data stored in the table. In this case, the data type is 'ST_MULTIPOLYGON', indicating that the data consists of multiple polygons. |
|---|
| geom_centroid | string | This column contains the central point (centroid) for each geographic polygon expressed as a point in a 2D space. |
|---|
| geom_center_x | double | This column represents the x-coordinate of the central point (centroid) for each geographic polygon. |
|---|
| geom_center_y | double | This column represents the y-coordinate of the central point (centroid) for each geographic polygon. |
|---|
| gml_id | string | This column contains unique identifiers for each row in the table. |
|---|
| name | string | This column contains the names of the regions in Finland in English. |
|---|
| namn | string | This column contains names of the regions in Finland in Swedish. |
|---|
| nimi | string | This column contains names of the regions in Finland in Finnish. |
|---|
| vuosi | long | This column, meaning 'year' in Finnish, likely represents the year the data was collected or relevant to. |
|---|
