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

o Clip ID

o Source Video ID

o Geographic Region (polygon/coordinates)

o Start/End Timestamps

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

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

o Frame Alignment Info

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

o Annotation (manual/automated tags)

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

o 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

o Clip ID / Sequence ID

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

o Location/Scene Description (manual ground truth)

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

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

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

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

o Social Media Metadata (views, likes, comments)

o 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.