Regional Administrative Agency Areas in Finland, 2013 (Scale 1:1,000,000)
The table, which is part of a larger dataset collection, contains detailed data about AVI regions in Finland for the year 2013. This information is sourced from the Finnish website 'Tilastokeskus' (Statistics Finland). The table encompasses various types of information, including identification and geographical details.
Each row in the table represents a specific AVI region, identified by features such as a unique gid, and an avi code. The row also includes the official name of the region in multiple languages.
The geographical information about these regions is presented in several formats, including GeoJSON and Geotext. These geographic details can be used for geospatial data analytics. For example, the geom_centroid column provides the central point of the region, while the geom_center_x and geom_center_y columns provide the longitude and latitude coordinates respectively, all presented using WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
Each data entry includes the date it was extracted from the source, as well as a row number. These two columns, '_extract_date' and '_row_number', together uniquely identify each row.
This data can be utilized in a number of ways in data analytics. For example, the geographical data can be used to visualize the spatial distribution of the AVI regions, or to analyze spatial relationships and patterns. The data can also be used to track changes in the AVI regions over time, based on the extraction date of the data.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This is a special column that contains the date when the data on the row of the table was extracted from the source. The format of the data is in date format. |
| _row_number | long | This is another special column that contains the row number in the data extracted from the source. It works in combination with '_extract_date' to uniquely identify each row. |
| avi | string | This column stores string type data, potentially representing various categories or classifications in the dataset. |
| geom_geojson | string | This column contains geometric data in the GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geometric data as text. It might be helpful for visualization or mapping purposes. |
| geom_type | string | This column specifies the type of the geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. For instance, the sample value 'ST_MULTIPOLYGON' indicates that the data represents multiple polygonal areas. |
| geom_centroid | string | This column contains the geometric central point of the geographic data in the row. It may be used to represent the data on a map. |
| geom_center_x | double | This column represents the X-coordinate of the geometric center of the geographic data in the row. |
| geom_center_y | double | This column represents the Y-coordinate of the geometric center of the geographic data in the row. |
| gid | long | This is an integer column, which might be used as an identifier or to link this table with other tables in the database. |
| gml_id | string | This string-type column may serve as a unique identifier for each row or represent some specific category or classification. |
| name | string | This is a string column that might contain names of entities, objects, or categories in the dataset. |
| namn | string | This column, similar to 'name', stores string data. It might contain translated or alternative names for the entities represented in the 'name' column. |
| nimi | string | This column stores another version of names, potentially in a different language or format compared to 'name' and 'namn'. |
| vuosi | long | This integer column seems to represent a year, as suggested by the sample value 2013. |
No sample for this dataset
Additional Information
| Last updated | November 8, 2024 |
|---|---|
| Created | November 8, 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 | ba64b865-977a-44ae-9d07-76093d9af8c7 |
| Package id | 4ca88a1f-f196-4283-b14e-470cfc0d7651 |
| Revision id | 2193cee3-e7d4-4211-97d0-e1b7a18186ca |
| State | active |
| Table | tilastointialueet_avi1000k_2013__table |