Regional Administrative Agencies' Areas Forecast for 2024 (Scale 1:1 000 000)
The table under examination contains valuable data related to the AVI regions in the year 2024, as indicated by the Finnish Statistics Bureau. The information is organized in a specific structure with various columns each representing a different attribute. Two critical columns, '_extract_date' and '_row_number', provide unique identifiers for each row, representing the date of data extraction and the row number respectively. These may be used to track changes in data over time or to locate specific entries.
Geographical information is comprehensively covered in columns with the prefix 'geom_'. These geographic coordinates, presented using the WGS 84 coordinate reference system (with axis order longitude first, followed by latitude), can be instrumental in geospatial data analytics. For instance, the 'geom_centroid' column provides the central point of each region, while 'geom_center_x' and 'geom_center_y' indicate respective coordinates. These geographic details can be used to map the regions, analyze spatial relationships, or model geographic patterns.
Additional columns include 'avi', 'id', 'name', 'namn', 'nimi', and 'vuosi'. These hold data on the region's identification number, its English, Swedish, and Finnish names, and the year of the data, respectively. This can enable comparative studies across regions, analysis of regional trends, and predictive modeling. The 'gml_id' column, with unique identifiers for each region, can be useful for data integrity checks and to link with other datasets.
The table provides an excellent resource for data analytics, particularly for studies focusing on regional differences, geospatial analyses, or temporal trends in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column marks the date when the data row was extracted from the source. It helps in tracking the data extraction history. |
| _row_number | long | This column represents the row number in the data extracted from the source. Together with '_extract_date', it uniquely identifies each row. |
| avi | string | This column stores a string value representing a specific identifier. The identifiers are unique within the dataset. |
| geom_geojson | string | This column contains the geometric representation of the data in GeoJSON format, a popular format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column holds the geometric representation of the data in text format. It is another way of illustrating the geographical aspects of the data. |
| geom_type | string | This column specifies the type of the geometry being used, such as point, line, polygon, etc. |
| geom_centroid | string | This column contains the centroid (geometric center) of the multi-polygon shapes. The centroid is a point that defines a geometric object's center. |
| geom_center_x | double | This column contains the X-coordinate of the centroid. It is part of the geometric representation of the data. |
| geom_center_y | double | This column contains the Y-coordinate of the centroid. It is also part of the geometric representation of the data. |
| gml_id | string | This column contains a unique identifier for each row following the GML standard. It is used to ensure data integrity. |
| id | long | This column denotes an integer identifier for each row. It serves as a primary key for the data table. |
| name | string | This column contains the English name of the represented entity. |
| namn | string | This column holds the name of the represented entity in Swedish. |
| nimi | string | This column lists the name of the represented entity in Finnish. |
| vuosi | long | This column indicates the year related to the data row. |
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 | 450ae59f-71c1-43eb-a45d-3467c1e65ac6 |
| Package id | 01dbd8fe-7792-409b-b08b-c54b3024ec95 |
| Revision id | 9be703c4-41bd-47e0-b18d-901775f01204 |
| State | active |
| Table | tilastointialueet_avi1000k_2024__table |