In continuation of the previous article on the schema of the public objects indexed from aerial drone video, the following are comparisons with earlier approaches: 

1. SkyQuery: Aerial Drone Video Sensing Platform 

Index Schema Highlights: 

• Video Clip Table/Dataframe 

• Clip ID 

• Source Video ID 

• Geographic Region (polygon/coordinates) 

• Start/End Timestamps 

• Scene Category (e.g., traffic, agriculture, surveillance) 

• Camera Path (6D position, orientation—computed by SLAM) 

• Frame Alignment Info 

• Object Detection Results (IDs, bounding boxes, classes, detection confidence) 

• Annotation (manual/automated tags) 

• Event/Activity label (e.g., congestion, growth, wildlife count) 

• Priority Score (for routing next tours) 

Index Operations: 

• Allows spatial-temporal querying for all objects/events detected in video clips. 

• Video clip metadata links to analytics and route planning. 

 

2. DVCD18K Dataset and Automated Cinematography 

Index Schema Includes: 

• Video Clip Metadata 

• Clip ID / Sequence ID 

• Source and edited version indicator (e.g., drone only, drone + edited) 

• Location/Scene Description (manual ground truth) 

• Scene Category (urban, forest, water, etc.) 

• Camera Path (6D position+orientation per frame/clip) 

• 3D Scene Reconstruction Data (point cloud/mesh references) 

• Event Tags (manual, computed; e.g., "drone flight", "fast forward", "rewind") 

• Social Media Metadata (views, likes, comments) 

• Video Editing Effects flag 

Useful for: 

• Geo-spatial browsing, camera path search, semantic scene queries. 

 

3. Scene Mosaics Indexing for UAV Imagery 

Index Structure: 

• Mosaic Image ID 

• Contributing Video Sequence IDs/Clip IDs 

• Summary of Frame Alignment (which frames included) 

• Aggregated Object Detection Results for the mosaic 

• Mosaic Scene Description 

• Time/Location Span 

• Linked Metadata (mission ID, platform, operator) 

Search Capability: 

• Visual “at-a-glance” analysis; search by location/time/event/object type 

 

Index Schema Summary Table 

Attribute/Field	Description
Clip/Sequence ID	Unique identifier for video segment
Source Video ID	Reference to original video file
Geographic Region (polygon/coords)	Spatial info for scene/clip
Start/End Timestamps	Temporal boundaries of clip/event
Scene Category/Description	Labeled content context
Camera Path (6D, SLAM)	3D movement/orientation of drone camera
Object Detection List	ID, class, bbox, confidence per detected object
Priority Score/Event Label	For tasking/routing
3D Scene Reconstruction Data	Linked to mesh/point cloud files
Annotation/Event Tag	Manual or automated semantic indexing
Social Metadata	Views, likes, comments
Video Editing Effects Flag	Identifies altered footage

These index schemas demonstrate sophisticated metadata catalogs to enable spatial-temporal-object search, route planning, and analytics in drone video systems, supporting much richer queries than raw frame analysis.