Statistical Regions 2022 (Scale 1:1 000 000)
The table, sourced from 'Tilastokeskus' (Statistics Finland) website, encapsulates comprehensive information about the 'AVI areas 2022' with a granularity of 1:1,000,000. This data is part of the 'tilastointialueet_avi1000k_2022' dataset collection.
The table comprises various columns, each storing unique information. Two special columns are '_extract_date' and '_row_number'. '_extract_date' indicates the date when data was extracted, while '_row_number' denotes the row number of the extracted data, making each row unique when combined.
Several columns prefixed with 'geom_' encompass geospatial data. These columns store data such as the type of the geographic area (polygon or multipolygon), its centroid, center coordinates, and geographic information in GeoJSON and GeoText formats. This geospatial information is represented using the WGS 84 coordinate reference system, with longitude listed before latitude.
In addition to these, there are columns storing identifiers and names of the AVI areas in multiple languages, which can be handy for multilingual analysis or reporting.
The data in this table could be instrumental for several data analytics applications. For instance, the geospatial data could be used to perform geospatial analysis, helping to understand regional trends or patterns. It could also be used to develop maps or other visual geographical representations of the AVI areas. The '_extract_date' and '_row_number' could aid in tracking data changes over time, providing insights into temporal trends. Furthermore, the multilingual names of the AVI areas can support international studies or comparisons.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. |
| avi | string | This column contains coded values representing different Administrative Judicial Regions in Finland. |
| geom_geojson | string | This column provides the geographical coordinates of the Administrative Judicial Regions in GeoJSON format. |
| geom_geotext | string | This column provides the geographical coordinates of the Administrative Judicial Regions in text format. |
| geom_type | string | This column specifies the type of the geographical coordinate, either a Polygon or a MultiPolygon. |
| geom_centroid | string | This column provides the centroid of the geographical coordinates of the Administrative Judicial Regions. |
| geom_center_x | double | This column provides the X-coordinate of the center of the Administrative Judicial Regions. |
| geom_center_y | double | This column provides the Y-coordinate of the center of the Administrative Judicial Regions. |
| gml_id | string | This column contains unique identifiers for each row in the table. |
| id | long | This column contains unique numerical identifiers for each Administrative Judicial Region. |
| name | string | This column contains the names of the Administrative Judicial Regions in English. |
| namn | string | This column contains the names of the Administrative Judicial Regions in Swedish. |
| nimi | string | This column contains the names of the Administrative Judicial Regions in Finnish. |
| vuosi | long | This column indicates the year that the data was collected. |
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 | 81891191-21f3-44fe-a628-708d62cda84b |
| Package id | e4fd8fec-1ffa-4d0c-8eaf-7f8b478fea6b |
| Revision id | 0d6a12b0-a5e3-4091-994e-aa92d3d55415 |
| State | active |
| Table | tilastointialueet_avi1000k_2022__table |