AVI Regions 2022 (Scale 1:4,500,000) - Data Table
The table, a part of the 'tilastointialueet_avi4500k_2022' dataset collection, provides detailed data about 'AVI-alueet 2022 (1:4 500 000)', which translates to 'AVI areas 2022 (1:4 500 000)'. This dataset comes from the 'Tilastokeskus' website, a Finnish statistical resource.
The table contains various columns, each offering unique and valuable information. Two special columns are '_extract_date' and '_row_number', which indicate when data was extracted and the row number of extracted data respectively. This pair of columns uniquely identifies each row in the table.
Geospatial data is a significant part of the table, as indicated by multiple columns starting with 'geom_'. These columns contain geographical information useful for geospatial data analytics. The geographic coordinates are given using the WGS 84 coordinate reference system, with the order being longitude first, followed by latitude.
The table also includes columns with information about the AVI areas, such as their names in different languages and the year the data pertains to. These can provide insights into regional trends and variations, offering valuable inputs for analysis.
The data from this table could be utilized in various ways. For example, the geospatial data could be used to visualize the distribution of AVI areas on a map, which could be useful in urban planning or environmental studies. The names and identifiers of the AVI areas could provide context in a data analysis, enabling a deeper understanding of regional differences. The extract date and row number could be used to track changes in the data over time, which could be useful in trend analysis or forecasting. The source of this data, the 'Tilastokeskus' (Statistics Finland), ensures its reliability and relevance.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column represents the date when the data in each row was extracted from the source. It is an important column as it helps in tracking the timeline of data extraction. |
| _row_number | long | This column holds the row number corresponding to the data extracted from the source on the specific extract date. This, in combination with the '_extract_date', uniquely identifies each row. |
| avi | string | This column contains specific codes representing different areas. |
| geom_geojson | string | This column holds the geographical data of the areas in GeoJSON format, which is a type of open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column contains the geographical data in textual format. The format used is dependent on the nature of the geographical data. |
| geom_type | string | This column describes the type of geographic data represented, such as polygons or multipolygons. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid, or geometric center, of each area. |
| geom_center_x | double | This column holds the x-coordinate of the center of the geographical area. |
| geom_center_y | double | This column holds the y-coordinate of the center of the geographical area. |
| gml_id | string | This column contains a unique identifier for each row in the GML (Geography Markup Language) format, which is used for expressing geographical features. |
| id | long | This column contains unique integer identifiers for each row or area. |
| name | string | This column contains the name of each area in English. |
| namn | string | This column contains the name of each area in Swedish. |
| nimi | string | This column contains the name of each area in Finnish. |
| vuosi | long | This column holds the year of data collection. |
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 | 27262a08-927c-408a-af85-b8a4597faffe |
| Package id | 7fb3d481-3118-40ce-a91f-391ff6c625dd |
| Revision id | df05cc51-9deb-4fc9-bf0f-5954a863dd05 |
| State | active |
| Table | tilastointialueet_avi4500k_2022__table |