AVI Regions 2019 Scaled 1:1,000,000 - Statistical Data Table
The table in focus is part of a larger dataset collection, particularly relating to regional statistics. This table contains a variety of data, including specific geographic information, unique identifiers, and other details, all of which are sourced from the 'Tilastokeskus' website in Finland. This table is a detailed representation of the AVI regions for the year 2019 at a scale of 1:1 000 000.
The table includes information such as specific regional identifiers ('avi'), names in various languages ('name', 'namn', 'nimi'), and the year of data ('vuosi'). Additionally, the table also includes geographic data through a series of 'geom_' prefixed columns. These include 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', which provide comprehensive geospatial data in various formats, including GeoJSON and coordinates. All geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
Two special columns, '_extract_date' and '_row_number', help in uniquely identifying each row of data. The '_extract_date' column indicates the date the data was extracted, and '_row_number' provides the specific row number for that extraction.
This table can be utilized in data analytics in several ways. For example, it can be used to analyze regional statistics over time by comparing data from different years. The geospatial data can be used for geographic mapping and analytics, which can help in visualizing regional trends or patterns. Furthermore, the data can support multilingual analysis due to the inclusion of regional names in different languages.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column signifies the date when the data in the table row was extracted from the original data source. |
| _row_number | long | This column contains the unique row number of the data extracted from the original source, corresponding with the extraction date specified in the '_extract_date' column. |
| avi | string | This column represents a code, potentially identifying different geographical regions or administrative units. |
| geom_geojson | string | This column stores geographic data in the GeoJSON format, typically defining geographic features such as points, lines, and polygons. |
| geom_geotext | string | This column contains the geographic data in the text format, likely representing the same geographic features found in the 'geom_geojson' column. |
| geom_type | string | This column identifies the type of geometric data stored in the aforementioned 'geom' columns. In this case, all entries are multi-polygon shapes. |
| geom_centroid | string | This column holds data representing the geometric center point, or centroid, of the geographic shapes defined in the 'geom' columns. |
| geom_center_x | double | This column contains the x-coordinate of the centroid of the geographic shapes. |
| geom_center_y | double | This column contains the y-coordinate of the centroid of the geographic shapes. |
| gml_id | string | This column might be an identifier for the geographic shapes defined in the 'geom' columns. |
| id | long | This column likely contains unique identifiers for the rows in the table. |
| name | string | This column consists of names, possibly denoting different regions or administrative units. |
| namn | string | This column also contains names, possibly in a different language than the 'name' column. |
| nimi | string | Yet another column containing names, presumably in another language, possibly Finnish. |
| vuosi | long | This column contains the year, possibly indicating when the corresponding data was collected or relevant. |
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 | 80ba48f9-b482-4b17-943e-8e9b7e0dd76f |
| Package id | a948e102-a403-4d02-9e64-2ef5e3caa850 |
| Revision id | 24bb2fbd-a678-4b77-a842-7f321e27421b |
| State | active |
| Table | tilastointialueet_avi1000k_2019__table |