AVI Regions 2017 Scaled 1:1,000,000 Data Table
Click here for a data sample
The table, part of a dataset collection, encapsulates valuable information about the AVI areas in 2017, as per the data source. It includes diverse data fields, each holding unique information. For instance, the date when the data row was extracted and the row number from the source are included, providing a unique identifier for each row. Furthermore, the table contains geographic data, useful for geospatial analytics, represented in the WGS 84 coordinate reference system with axis order longitude first, followed by latitude. This geospatial data includes information such as geojson and geotext, along with the centroid and the X and Y coordinates of the center of the geometry. The table also contains identifiers, names in various languages, and the year of the data. Sourced from the 'Tilastokeskus' website from Finland, this data could be leveraged in numerous ways. Data analysts could use this information to track changes in these areas over time, conduct regional planning and development, or perform spatial analysis on the geographic information for various research purposes.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column records the date on which the data row was extracted from the original data source. |
|---|
| _row_number | long | This column contains the row number of the data extracted from the source on the extraction date specified by the '_extract_date' column. The combination of '_extract_date' and '_row_number' uniquely identifies each row. |
|---|
| avi | string | This column holds a string value that represents a specific identifier. |
|---|
| geom_geojson | string | This column contains GeoJSON data, which is used to represent simple geographical features. |
|---|
| geom_geotext | string | This column contains geometric data in text form. |
|---|
| geom_type | string | This column indicates the type of geometric data represented. |
|---|
| geom_centroid | string | This column stores the centroid or geometric central point of the data. |
|---|
| geom_center_x | double | This column records the X-coordinate of the geometric center point. |
|---|
| geom_center_y | double | This column records the Y-coordinate of the geometric center point. |
|---|
| gid | long | This column contains an integer value that serves as a unique identifier. |
|---|
| gml_id | string | This column contains a string value that serves as an identifier. |
|---|
| name | string | This column holds the name in English of the entity represented in the data row. |
|---|
| namn | string | This column contains the name in Swedish of the entity represented in the data row. |
|---|
| nimi | string | This column holds the name in Finnish of the entity represented in the data row. |
|---|
| vuosi | double | This column records the year associated with the data row. |
|---|
