Version History of Valokuva Table from Geologian tutkimuskeskus in Finland
Click here for a data sample
This table contains the version history of the rows in the 'Geological Survey of Finland (GTK) Photo Service - Aerial Photos' base table. It provides information about the historical versions of each row, including the '_start_date' and '_end_date' which indicate when the row was extracted from the data source. The table includes various columns such as 'gml_id', 'objectid', 'pohjoiskoordinaatti', 'itakoordinaatti', 'havaintotunnus', 'valokuvatunnus', 'kuvausaika', 'valokuva_linkki', 'etaisyys_kohteesta_metria', 'kuvaussuunta', 'huomautukset', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns contain valuable data that can be utilized in data analytics. For example, the 'valokuva_linkki' column provides links to the actual photos, allowing analysis of specific locations, time periods, or patterns across the aerial photos. The 'etaisyys_kohteesta_metria' column provides the distance from the photographed object, which can be helpful in analyzing spatial relationships. The 'kuvausaika' column provides the timestamp of each photo, enabling temporal analysis of changes in the photographed areas. The 'geom_geojson' and 'geom_type' columns contain geometric data, allowing geometrical analysis and visualization of the aerial photos. This data table is sourced from the website of the Geological Survey of Finland (GTK), originating from the country with the ISO country code 'FI' (Finland).
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for the row version. |
|---|
| _end_date | date | The end date of the validity period for the row version. |
|---|
| _row_number | long | The row number of the version history. |
|---|
| gml_id | string | The GML identifier of the row. |
|---|
| objectid | int | The identifier of the object. |
|---|
| pohjoiskoordinaatti | int | The Northern coordinate of the location. |
|---|
| itakoordinaatti | int | The Eastern coordinate of the location. |
|---|
| havaintotunnus | string | The observation code. |
|---|
| valokuvatunnus | string | The photograph code. |
|---|
| kuvausaika | int | The time of the photograph. |
|---|
| valokuva_linkki | string | The link to the photograph. |
|---|
| etaisyys_kohteesta_metria | int | The distance from the object in meters. |
|---|
| kuvaussuunta | int | The direction of the photograph. |
|---|
| huomautukset | string | Any additional remarks or comments. |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row in Geotext format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The X-coordinate of the center point of the geometry. |
|---|
| geom_center_y | double | The Y-coordinate of the center point of the geometry. |
|---|
| geom | binary | The geometry of the row. |
|---|
