Geospatial Distribution of Administrative Regions in 2017 (Scale 1:4,500,000)
The table, part of the dataset collection, represents the AVI areas for the year 2017, at a scale of 1:4 500 000, sourced from the 'Tilastokeskus' website, located in Finland. The data includes geographic information, which is particularly useful for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The data also includes details such as the name of the AVI area in different languages, and an identifying number for each AVI area. For instance, one could find the Finnish, English, and another language name for 'Southern Finland AVI'. This multi-language data could aid international research or studies requiring bilingual/multilingual data.
Two columns, '_extract_date' and '_row_number', play a crucial role as they uniquely identify each row. '_extract_date' signifies the date when the specific row of data was extracted, and '_row_number' indicates the row number in the data extracted on the specified extract date.
The data in this table could be utilized in various ways in data analytics. For instance, the geographic information could be used to plot the AVI areas on a map for visual analytics. The dataset could also be used to track changes over time, given the inclusion of the extract date. Furthermore, the multilingual names allow for global studies or comparative analyses between different AVI areas.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the data source. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| avi | string | This is a string column that may contain numerical values. |
| geom_geojson | string | This column contains geojson data, which is a format for encoding geographic data structures. |
| geom_geotext | string | This column contains geographical data in text format. |
| geom_type | string | This column specifies the type of the geographical data structure. |
| geom_centroid | string | This column contains the coordinates of the centroid point of the geographical structure. |
| geom_center_x | double | This column contains the x-coordinate of the center point of the geographical structure. |
| geom_center_y | double | This column contains the y-coordinate of the center point of the geographical structure. |
| gid | long | This is an integer column that may contain numerical values. |
| gml_id | string | This is a string column that may contain unique identifiers. |
| name | string | This is a string column that may contain names in English. |
| namn | string | This is a string column that may contain names in a language other than English. |
| nimi | string | This is a string column that may contain names in a language other than English. |
| vuosi | double | This is a real type column that may contain numerical values, possibly representing years. |
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 | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | e3ad45f5-60a1-4022-b653-21baca37564e |
| Package id | 4b116828-6b3e-4951-a52d-cf091e12958d |
| Revision id | 83c0a0a5-2ca7-4a81-aa42-33424a4ce123 |
| State | active |
| Table | tilastointialueet_avi4500k_2017__table |