Regional Administrative Agencies (AVI) Areas 2019 (Scale 1:4,500,000) - Dataset Table
The 'table' is part of the 'tilastointialueet_avi4500k_2019' dataset collection and contains information on the AVI-areas for the year 2019 at a scale of 1:4,500,000. This information is sourced from the 'Tilastokeskus' (Statistics Finland) website based in Finland. The table is organized into several columns, each containing specific details related to the AVI-areas.
Two columns, 'extract_date' and '_row_number', are unique, providing the date data was extracted and the row number from the original extraction. These two columns can be combined to uniquely identify each row of data. Other columns hold geographic information and are prefixed with 'geom'. These geographic data can be leveraged for geospatial data analytics. It's important to note that the geographic coordinates are presented using the WGS 84 coordinate reference system, with longitude first, followed by latitude.
Other columns provide further details on each AVI-area, such as its name in multiple languages and a unique identifier. The year the data pertains to is also included.
This table could be utilized in various ways in data analytics. For instance, the geographic information could be used to map the AVI-areas and visualize patterns of interest. The temporal data from the '_extract_date' could be used to track changes over time. Ultimately, the wealth of information in this table makes it a valuable resource for a wide range of analytical tasks.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column represents the date when the data was extracted from the source. It helps in tracking the version of data at different points in time. |
| _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'. This column, in combination with '_extract_date', uniquely identifies each row. |
| avi | string | This column represents an identifier for a specific attribute or feature in the dataset. |
| geom_geojson | string | This column contains the geometric representation of the data in GeoJSON format. GeoJSON is a widely used format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geometric representation of the data in text format. |
| geom_type | string | This column specifies the type of the geometric representation of the data, such as 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column represents the center point (centroid) of the geometric representation of the data. |
| geom_center_x | double | This column represents the x-coordinate of the center point of the geometric data. |
| geom_center_y | double | This column represents the y-coordinate of the center point of the geometric data. |
| gml_id | string | This column represents a unique identifier assigned to each row of data in GML (Geography Markup Language) format. |
| id | long | This column represents a unique identifier assigned to each row of data. |
| name | string | This column contains the name of the attribute or feature in English language. |
| namn | string | This column contains the name of the attribute or feature in a different language. |
| nimi | string | This column contains the name of the attribute or feature in yet another language. |
| vuosi | long | This column represents the year associated with 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 | aec69cbc-810d-4bad-825b-ce3283266a1a |
| Package id | 4b85d4d8-8eea-44d7-96b5-d064d60de616 |
| Revision id | e4ebae80-9e7d-49ba-8388-0ab365c3a76b |
| State | active |
| Table | tilastointialueet_avi4500k_2019__table |