Regional Administrative Agencies (AVI) Areas 2023 Scaled 1:1 000 000
The table, which is part of the 'tilastointialueet_avi1000k_2023' dataset collection, contains detailed information on the AVI regions for the year 2023, at a map scale of 1:1,000,000. Each row in the table is uniquely identified by a combination of the extraction date and the row number. The extraction date signifies when the data was pulled from the source, while the row number represents the order of the data extracted on that specific date. The table offers rich geographic information with columns containing geojson, geotext, and other geospatial elements. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the longitude coming first, followed by the latitude.
The table includes identifiers such as 'avi', 'gml_id', and 'id', and naming information available in different languages ('name', 'namn', 'nimi'). The 'avi' column signifies the AVI region numeric identifier, and 'gml_id' is a unique identifier for each row. The naming columns provide the names of the AVI regions in English, Swedish, and Finnish respectively.
The data from this table can be utilized in various data analytics scenarios. For instance, one could analyze the distribution of different AVI regions, study spatial patterns, or investigate changes in geographical boundaries over time. Furthermore, with the multilingual naming information, cross-cultural studies or multilingual applications can be developed.
The data for this table is sourced from 'Tilastokeskus' (Statistical Bureau), Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on each row of the table was extracted from the data source. |
| _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'. |
| avi | string | This column contains numerical data. The specific meaning of this column is not provided by the source. |
| geom_geojson | string | This column contains geometric data in the GeoJSON format, which describes the shapes of geographical features. |
| geom_geotext | string | This column contains textual representations of geographic polygons. |
| geom_type | string | This column specifies the type of geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. In this case, the type is 'ST_MULTIPOLYGON', meaning that the data represents multiple polygons. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid, or geometric center, of each polygon. |
| geom_center_x | double | This column contains the x-coordinate of the center of each polygon. This is part of the information needed to plot the polygon on a map. |
| geom_center_y | double | This column contains the y-coordinate of the center of each polygon. This is part of the information needed to plot the polygon on a map. |
| gml_id | string | This column contains a unique identifier for each row in the table. |
| id | long | This column contains numerical data. The specific meaning of this column is not provided by the source. |
| name | string | This column contains the English names of geographical areas. |
| namn | string | This column contains the names of geographical areas in a language other than English. |
| nimi | string | This column contains the names of geographical areas in a language other than English. |
| vuosi | long | This column contains numerical data. The specific meaning of this column is not provided by the source. |
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 | 1d95133d-fe4e-430b-b8e1-4baf4275aa45 |
| Package id | 1f594b50-b14f-4fdc-beb3-a33f04d4b81b |
| Revision id | 5c508dc4-8c1d-4711-896f-a0a5693a7ad9 |
| State | active |
| Table | tilastointialueet_avi1000k_2023__table |