Regional Administrative Agencies (AVI) Areas Forecast for 2023 (Scale 1:4,500,000)
Click here for a data sample
The table in question, sourced from the 'Tilastokeskus' (Statistics Finland) website, is part of the 'tilastointialueet_avi4500k_2023' dataset collection. The table's content revolves around AVI regions for the year 2023 at a scale of 1:4,500,000. This includes sections like the geographic geojson, geotext, and type data, which can be employed for geospatial data analytics. The geographic coordinates are configured using the WGS 84 coordinate reference system, where longitude is followed by latitude. It also contains data on the geographical center, with separate columns for longitude (geom_center_x) and latitude (geom_center_y). The table also contains rows that identify each AVI region, providing names in multiple languages. The 'avi' column represents the identification number of each region. The 'gml_id' column is another identifier, perhaps used for more technical purposes. Additionally, two special columns, 'extract_date' and '_row_number', are included. The '_extract_date' column denotes when the data was pulled from the source, while the '_row_number' corresponds to the order of the extracted data. With this combination, each row in the table can be uniquely identified. This table could be utilized for various analytical purposes, such as studying trends over time by referencing the '_extract_date' or analyzing geographical patterns and the distribution of regions based on the 'geom' columns.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the data on the 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, of string type, contains numerical identifiers. For example, values like 3, 4, 1 can be found in this column. |
|---|
| geom_geojson | string | This column contains geographical data in GeoJSON format, a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains geographical data presented as text. |
|---|
| geom_type | string | This column contains the type of geographical data stored in the row, such as 'ST_POLYGON' or 'ST_MULTIPOLYGON'. |
|---|
| geom_centroid | string | This column contains the centroid of the geographic data stored in the row. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the center of the geographic data. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the center of the geographic data. |
|---|
| gml_id | string | This column, of string type, contains unique identifiers, possibly related to the geographic data. |
|---|
| id | long | This column, of integer type, contains identifiers. These identifiers may correlate with the 'avi' column. |
|---|
| name | string | This column, of string type, contains names in English language. These names might be related to the geographic areas represented by the geographical data. |
|---|
| namn | string | This column, of string type, contains names possibly in Swedish language. |
|---|
| nimi | string | This column, of string type, contains names presumably in Finnish language. |
|---|
| vuosi | long | This column, of integer type, contains the year related to the data in the row. |
|---|
