Regional Administrative Agency Areas 2016 (1:4 500 000) Data Table
The table in question is part of a dataset collection and contains important information about AVI regions for the year 2016, at a scale of 1:4,500,000. It is sourced from the Statistics Finland (Tilastokeskus) website, located in Finland. The data within this table is organized into various columns, each holding specific details about the data set.
The table contains columns that hold geospatial data, apt for analytics that involve geographic data. For example, the geospatial data can be used to conduct spatial analysis, such as identifying regional patterns or assessing the geographical distribution of certain factors within the AVI regions.
There are also columns in the table that depict the name of the regions in different languages, which could be utilized for multilingual data analytics or translation applications.
The table also contains a unique identifier for each row, formed by the combination of the extract date and row number. These columns provide the date of extraction and the position of the data within the extracted information, respectively.
In addition to these, there are columns that contain geographic coordinates, presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This can be utilized for geospatial analytics, such as mapping or spatial analysis of the AVI regions.
Overall, the table provides a rich source of data for various types of analytics, be it geographical, temporal, or linguistic.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This special column contains the date when the data on the row of the table was extracted from the data source. |
| _row_number | long | This special column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. Together with '_extract_date', it uniquely identifies each row. |
| avi | string | This column contains a string value that signifies a unique identifier. |
| geom_geojson | string | This column contains the geometric information of the data in GeoJSON format. |
| geom_geotext | string | This column contains the geometric information of the data in textual format. |
| geom_type | string | This column specifies the type of the geometric data. |
| geom_centroid | string | This column contains the centroid of the geometric data. |
| geom_center_x | double | This column represents the X-coordinate of the geometric center. |
| geom_center_y | double | This column represents the Y-coordinate of the geometric center. |
| gid | long | This column contains an integer that serves as a unique identifier. |
| gml_id | string | This column contains a string that serves as a unique identifier. |
| name | string | This column contains the name in English language. |
| namn | string | This column contains the name in a foreign language. |
| nimi | string | This column contains the name in another foreign language. |
| vuosi | double | This column contains a real number type value, likely representing a year. |
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 | 94cf52ea-d734-4ba3-a338-841120c9fe29 |
| Package id | e5e41424-9afa-48cc-b0c3-ac32d69c4148 |
| Revision id | df283cf0-8661-4846-9ebc-d4b0e7655d14 |
| State | active |
| Table | tilastointialueet_avi4500k_2016__table |