Skip to content

drones.md

Latest commit

 

History

History
320 lines (248 loc) · 8.13 KB

drones.md

File metadata and controls

320 lines (248 loc) · 8.13 KB
Raw

Drones Pack

  • Name: drones
  • Version: 0.1.0
  • Schema: v1
  • Owner: scalytics
  • Core minimum version: 0.5.0

Unmanned systems pack for readiness, sortie, and EW correlation workflows.

Entity Types

  • component
  • contact
  • ew_event
  • fault
  • fault_mode
  • mission
  • operator
  • platform
  • signoff
  • software
  • sortie
  • subsystem
  • team
  • trial
  • variant

Edge Types

  • affected
  • approves
  • assigned_to
  • encountered
  • experienced
  • installed_in
  • instance_of
  • part_of
  • platform_runs
  • references
  • suspected_cause

Map Layers

ID Name Kind Entity Types Render
live-platforms Live Platforms overlay platform point
no-engage-areas No-Engage Areas overlay area polygon

Detectors

autonomy-rollback-candidate

  • Severity: high
  • Window: 168h
  • Explanation: Software {{software_version}} correlates with a fleet fault-rate increase on {{variant_id}}.
  • Suggested actions:
    • evaluate rollback readiness for the autonomy build
    • compare faults against the previous approved release
SELECT software_version, variant_id, fault_rate_delta
  FROM view_drone_autonomy_regressions
 WHERE deployed_at >= :window_start
   AND fault_rate_delta > 0.25

cohort-failure-early-warning

  • Severity: high
  • Window: 72h
  • Explanation: {{affected_platforms}} platforms of variant {{variant_id}} produced fault mode {{fault_mode_id}} inside the active window.
  • Suggested actions:
    • inspect autonomy software lineage on affected platforms
    • review recent maintenance changes for the variant cohort
SELECT variant_id, fault_mode_id, COUNT(DISTINCT platform_id) AS affected_platforms
  FROM view_drone_faults_by_variant
 WHERE observed_at >= :window_start
 GROUP BY variant_id, fault_mode_id
HAVING COUNT(DISTINCT platform_id) >= 3

lot-anomaly

  • Severity: medium
  • Window: 720h
  • Explanation: Component lot {{component_lot}} is over-indexed for fault mode {{fault_mode_id}}.
  • Suggested actions:
    • inspect inventory and maintenance records for the lot
    • compare failed units against the fleet baseline
SELECT component_lot, fault_mode_id, z_score
  FROM view_drone_component_lot_anomalies
 WHERE observed_at >= :window_start
   AND z_score >= 3

pre-mission-readiness-gap

  • Severity: critical
  • Window: 24h
  • Explanation: Mission {{mission_id}} is blocked because {{platform_id}} still has open readiness gaps.
  • Suggested actions:
    • resolve open faults before launch
    • complete the remaining signoff evidence chain
SELECT mission_id, platform_id, open_faults, open_signoffs
  FROM view_drone_pre_mission_gaps
 WHERE scheduled_at >= :window_start
   AND (open_faults > 0 OR open_signoffs > 0)

roe-drift

  • Severity: high
  • Window: 24h
  • Explanation: Sortie {{sortie_id}} crossed the restricted area {{area_id}} during the active window.
  • Suggested actions:
    • review mission routing and ROE settings
    • attach telemetry excerpts to the sortie incident record
SELECT sortie_id, area_id, crossed_at
  FROM view_drone_roe_drift
 WHERE crossed_at >= :window_start

silent-subsystem

  • Severity: medium
  • Window: 6h
  • Explanation: Subsystem {{subsystem_id}} on {{platform_id}} went silent during sortie {{sortie_id}}.
  • Suggested actions:
    • inspect subsystem telemetry continuity
    • compare the gap against recent maintenance actions
SELECT sortie_id, platform_id, subsystem_id, heartbeat_gap_seconds
  FROM view_drone_silent_subsystems
 WHERE observed_at >= :window_start
   AND heartbeat_gap_seconds >= expected_gap_seconds * 3

Views

component

  • Entity type: component
  • Title: Component
Field Label Format Hidden
serial Serial false
lot Lot false
subsystem_id Installed In false
state State false

ew_event

  • Entity type: ew_event
  • Title: EW Event
Field Label Format Hidden
effect Effect false
severity Severity false
area_id Area false
observed_at Observed At false

fault

  • Entity type: fault
  • Title: Fault
Field Label Format Hidden
fault_mode_id Fault Mode false
subsystem_id Subsystem false
severity Severity false
detected_at Detected At false

mission

  • Entity type: mission
  • Title: Mission
Field Label Format Hidden
mission_code Mission Code false
status Status false
launch_window Launch Window false
platform_id Platform false

platform

  • Entity type: platform
  • Title: Platform
Field Label Format Hidden
serial Serial false
callsign Callsign false
readiness Readiness false
autonomy_version Autonomy Version false

signoff

  • Entity type: signoff
  • Title: Signoff
Field Label Format Hidden
trial_id Trial false
approver Approver false
status Status false
approved_at Approved At false

sortie

  • Entity type: sortie
  • Title: Sortie
Field Label Format Hidden
sortie_code Sortie Code false
mission_id Mission false
platform_id Platform false
outcome Outcome false

subsystem

  • Entity type: subsystem
  • Title: Subsystem
Field Label Format Hidden
platform_id Platform false
subsystem_name Subsystem false
readiness Readiness false
heartbeat_gap_seconds Heartbeat Gap (s) false

Query Templates

platforms-running-software

  • Title: Platforms Running Software X
  • Description: Find every platform currently tied to a software release.
Parameter Type Required Description
software_version string true Software Version 
SELECT platform_id, software_version, observed_at
  FROM view_drone_platform_software
 WHERE software_version = :software_version
 ORDER BY observed_at DESC

show-same-failure-mode-across-fleet

  • Title: Show Same Failure Mode Across Fleet
  • Description: Rank shared fault modes by fleet spread and recency.
Parameter Type Required Description
fault_mode_id string true Fault Mode 
SELECT platform_id, variant_id, last_seen
  FROM view_drone_fault_mode_spread
 WHERE fault_mode_id = :fault_mode_id
 ORDER BY last_seen DESC

sorties-with-degraded-comms-in-area

  • Title: Sorties With Degraded Comms In Area
  • Description: Find sorties that experienced degraded communications inside a selected area and window.
Parameter Type Required Description
area_id string true Area
window_start string true Window Start 
SELECT sortie_id, platform_id, degraded_at
  FROM view_drone_degraded_comms
 WHERE area_id = :area_id
   AND degraded_at >= :window_start
 ORDER BY degraded_at DESC

what-changed-since-last-signoff

  • Title: What Changed Since Last Signoff
  • Description: Compare maintenance, software, and component churn after the last approved signoff.
Parameter Type Required Description
platform_id string true Platform 
SELECT changed_at, change_type, summary
  FROM view_drone_changes_since_signoff
 WHERE platform_id = :platform_id
 ORDER BY changed_at DESC

Report Templates

  • no-go-decision-memo.md.tmpl
  • post-incident-engineering-review.md.tmpl
  • validation-report.md.tmpl