Regional Administrative Agencies Areas 2021 (Scale 1:1,000,000)
The 'table' is part of a larger dataset collection known as 'tilastointialueet_avi1000k_2021'. This table contains important information about the AVI areas in 2021 at a scale of 1:1,000,000. It is sourced from the Statistics Finland (Tilastokeskus) web site based in Finland. This table contains geographic data that can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order of longitude first, followed by latitude.
The data in the table is organized in various columns. Two special columns, '_extract_date' and '_row_number', provide key details about each row of data. The '_extract_date' indicates the date when the data on the row was extracted from the source, while the '_row_number' determines the row number in the data extracted from the source on the specific extraction date. This combination uniquely identifies each row in the table.
Several columns in the table contain geographic information, including 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y'. These columns provide various forms of geographic representations of the AVI areas, including their type, centroid, and central coordinates.
Other columns provide unique identifiers for each area ('gml_id', 'id'), the area's Finnish name ('nimi'), Swedish name ('namn'), and English name ('name'), and the year of the data ('vuosi').
The data in this table can be used for various analytical purposes. For instance, the geographic information can be used to conduct geospatial analyses to understand the spatial distribution of AVI areas. The extraction date and row number can be used to track changes in the data over time. The names in different languages can be used to create multilingual visual representations of the data. Overall, the data in this table provides a comprehensive overview of the AVI areas in 2021, serving as a valuable resource for data analysis.
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. It helps in identifying the freshness of the data. |
| _row_number | long | A unique identifier for each row, representing the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| avi | string | A string column that presumably contains some form of identifier or code. |
| geom_geojson | string | This column stores the geometric data in GeoJSON format. The data represents geographical features with their non-spatial attributes. |
| geom_geotext | string | This column contains the geometric data in the form of text. It may include various geometrical shapes and structures. |
| geom_type | string | This column specifies the type of geometric data stored in the row. The types could be multipolygon, polygon etc. |
| geom_centroid | string | This column contains the centroid of the geometric data. The centroid is the geometric center of a plane figure or shape. |
| geom_center_x | double | This column represents the x-coordinate of the geometric center of the data. |
| geom_center_y | double | This column represents the y-coordinate of the geometric center of the data. |
| gml_id | string | This string column contains identifiers, likely used to link to other data or as a unique identifier for the geometric data. |
| id | long | An integer column, which is typically used to uniquely identify each record in the table. |
| name | string | A string column that presumably contains names or titles in English. |
| namn | string | A string column that presumably contains names or titles in another language, possibly Finnish or Swedish. |
| nimi | string | A string column that presumably contains names or titles in yet another language, possibly Finnish. |
| vuosi | long | An integer column, possibly representing a year or duration. |
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 | a506f4fb-c03a-403d-8a3a-058a2890c5fc |
| Package id | 11fa39c7-9843-4422-99e4-d3d1d4db7b18 |
| Revision id | 3a9f2381-e39b-4108-9a5c-e76bd8b84abb |
| State | active |
| Table | tilastointialueet_avi1000k_2021__table |