Difference between revisions of "UAV High-Throughput Phenotyping Database"
From Poland Lab Wiki
(→Example Queries) |
(→Flight Images Query) |
||
| Line 14: | Line 14: | ||
Select all image data records for a specific flight: | Select all image data records for a specific flight: | ||
| − | SELECT * from uas_images WHERE flight_id ='<flight_id from uas_run table> ' | + | SELECT * from uas_images WHERE flight_id ='<flight_id from uas_run table> ' |
Revision as of 18:52, 10 July 2017
The UAV High-Throughput Phenotyping Database contains information about images collected by camera-equipped aerial platforms. There are two basic classes of information that are collected:
1. Flight metadata - Contains information about the date, time and location of each flight where image data is collected. 2. Image metadata - Contains inforamation about date, time and UAV position for each image collected during a flight.
The current database schema for UAV HTP data is shown in the figure below:
Example Queries
Flight Images Query
Select all image data records for a specific flight:
SELECT * from uas_images WHERE flight_id ='<flight_id from uas_run table> '
