AVI Regions 2016 (Scale 1:1 000 000) - Dataset Table
The table in question is part of a dataset collection that focuses on the AVI areas from the year 2016, as suggested by the Finnish Statistics Bureau ('Tilastokeskus') in Finland. The content of the table is based on data that represents AVI areas at a scale of 1:1,000,000.
The table includes a variety of columns with different types of data. For instance, some columns contain geographic data, while others contain identifiers and names. This wide assortment of data can be beneficial for various data analytics tasks, such as geospatial data analytics.
In the table, two columns hold special significance: the date of data extraction and the row number. These two columns work together to uniquely identify each row in the table. The geographic data in the table is represented using the WGS 84 coordinate reference system, with longitude listed before latitude.
The table includes a column that holds the year of the data, and another column that provides a unique identifier for each region. The names of the AVI areas are available in multiple languages, which can be beneficial for international data analytics.
For instance, the data in this table can be used to analyze the geographical changes in AVI areas over time by comparing the geographic data from different years. The multi-language names can be used to cater to different user bases in data analytics. The geographic information can be utilized to perform geospatial analysis to identify patterns and trends related to the AVI areas.
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. It is a part of a unique identifier for each row when combined with '_row_number'. |
| _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'. It is a part of a unique identifier for each row when combined with '_extract_date'. |
| avi | string | This String type column represents a certain unidentified attribute of the dataset. |
| geom_geojson | string | This column contains a representation of geometrical data in GeoJson format. |
| geom_geotext | string | This column contains a textual representation of geometrical shapes. |
| geom_type | string | This column specifies the type of the geometry data in the row. For instance, a sample value 'ST_MULTIPOLYGON' indicates that the geometry is of type 'MultiPolygon'. |
| geom_centroid | string | This column contains the geometric centroid of the shape represented in the row. |
| geom_center_x | double | This column contains the X coordinate of the center of the geometrical shape represented in the row. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geometrical shape represented in the row. |
| gid | long | An Integer type column representing a unique identifier for each row. |
| gml_id | string | A String type column serving as a unique identifier for each row in the dataset. |
| name | string | This String type column represents the name of the entity in English. |
| namn | string | This String type column represents the name of the entity in a different language. |
| nimi | string | This String type column represents the name of the entity in another language. |
| vuosi | double | This Real type column represents the year associated with the data in the 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 | b193785e-5f44-4ae5-bc94-d5245365edcf |
| Package id | bf3fdc39-83ae-454c-a6af-810b553affc5 |
| Revision id | 8a43c581-97b6-4071-9b0b-cdc179a22a48 |
| State | active |
| Table | tilastointialueet_avi1000k_2016__table |