Created
December 16, 2025 20:31
-
-
Save ryguyrg/2495ed7c3082853cad03f6a62868c570 to your computer and use it in GitHub Desktop.
public_vtol_shadowtraffic
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "generators": [ | |
| { | |
| "table": "aircraft", | |
| "vars": { | |
| "now": { | |
| "_gen": "now" | |
| } | |
| }, | |
| "row": { | |
| "aircraft_id": { | |
| "_gen": "sequentialInteger", | |
| "startingFrom": 1000 | |
| }, | |
| "registration_number": { | |
| "_gen": "uuid" | |
| }, | |
| "manufacturer": { | |
| "_gen": "oneOf", | |
| "choices": ["Joby Aviation", "Archer Aviation", "Lilium", "Volocopter", "EHang"] | |
| }, | |
| "model": { | |
| "_gen": "oneOf", | |
| "choices": ["S4", "Midnight", "Jet", "2X", "EH216"] | |
| }, | |
| "serial_number": { | |
| "_gen": "uuid" | |
| }, | |
| "manufacture_date": { | |
| "_gen": "formatDateTime", | |
| "ms": { | |
| "_gen": "math", | |
| "expr": "now - offset", | |
| "names": { | |
| "offset": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [157784760000, 473354280000] | |
| } | |
| } | |
| } | |
| }, | |
| "max_payload_kg": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [200, 450], | |
| "decimals": 1 | |
| }, | |
| "max_range_km": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [40, 250], | |
| "decimals": 1 | |
| }, | |
| "battery_capacity_kwh": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [100, 200], | |
| "decimals": 1 | |
| }, | |
| "status": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": "active", "weight": 85}, | |
| {"value": "maintenance", "weight": 10}, | |
| {"value": "retired", "weight": 5} | |
| ] | |
| } | |
| }, | |
| "localConfigs": { | |
| "maxEvents": 50 | |
| } | |
| }, | |
| { | |
| "table": "pilots", | |
| "vars": { | |
| "now": { | |
| "_gen": "now" | |
| } | |
| }, | |
| "row": { | |
| "pilot_id": { | |
| "_gen": "sequentialInteger", | |
| "startingFrom": 5000 | |
| }, | |
| "name": { | |
| "_gen": "string", | |
| "expr": "#{Name.fullName}" | |
| }, | |
| "license_number": { | |
| "_gen": "uuid" | |
| }, | |
| "certification_date": { | |
| "_gen": "formatDateTime", | |
| "ms": { | |
| "_gen": "math", | |
| "expr": "now - offset", | |
| "names": { | |
| "offset": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [157784760000, 473354280000] | |
| } | |
| } | |
| } | |
| }, | |
| "total_flight_hours": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [500, 5000], | |
| "decimals": 1 | |
| } | |
| }, | |
| "localConfigs": { | |
| "maxEvents": 25 | |
| } | |
| }, | |
| { | |
| "table": "locations", | |
| "row": { | |
| "location_id": { | |
| "_gen": "sequentialInteger", | |
| "startingFrom": 1 | |
| }, | |
| "name": { | |
| "_gen": "oneOf", | |
| "choices": [ | |
| "Downtown Vertiport Alpha", "Airport Hub Beta", "Suburban Pad Gamma", | |
| "Medical Center Landing", "Corporate Tower Delta", "Harbor Port Epsilon", | |
| "University Campus Pad", "Stadium Vertiport", "Mountain Resort Landing", | |
| "Coastal Landing Zeta" | |
| ] | |
| }, | |
| "latitude": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [37.5, 38.5], | |
| "decimals": 6 | |
| }, | |
| "longitude": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [-122.5, -121.5], | |
| "decimals": 6 | |
| }, | |
| "elevation_m": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [0, 500], | |
| "decimals": 1 | |
| }, | |
| "location_type": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": "vertiport", "weight": 60}, | |
| {"value": "landing_pad", "weight": 30}, | |
| {"value": "emergency_site", "weight": 10} | |
| ] | |
| } | |
| }, | |
| "localConfigs": { | |
| "maxEvents": 10 | |
| } | |
| }, | |
| { | |
| "table": "environmental_conditions", | |
| "row": { | |
| "environment_id": { | |
| "_gen": "sequentialInteger", | |
| "startingFrom": 1 | |
| }, | |
| "temperature_c": { | |
| "_gen": "normalDistribution", | |
| "mean": 20, | |
| "sd": 8, | |
| "decimals": 1 | |
| }, | |
| "pressure_pa": { | |
| "_gen": "normalDistribution", | |
| "mean": 101325, | |
| "sd": 1000, | |
| "decimals": 0 | |
| }, | |
| "humidity_percent": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [30, 90], | |
| "decimals": 1 | |
| }, | |
| "visibility_m": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": 10000, "weight": 70}, | |
| {"value": 5000, "weight": 20}, | |
| {"value": 2000, "weight": 10} | |
| ] | |
| }, | |
| "cloud_ceiling_m": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [500, 3000], | |
| "decimals": 0 | |
| }, | |
| "precipitation_type": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": "none", "weight": 70}, | |
| {"value": "light_rain", "weight": 15}, | |
| {"value": "moderate_rain", "weight": 10}, | |
| {"value": "fog", "weight": 5} | |
| ] | |
| }, | |
| "turbulence_intensity": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": "light", "weight": 70}, | |
| {"value": "moderate", "weight": 25}, | |
| {"value": "severe", "weight": 5} | |
| ] | |
| }, | |
| "wind_shear_flag": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": false, "weight": 90}, | |
| {"value": true, "weight": 10} | |
| ] | |
| }, | |
| "icing_conditions_flag": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": false, "weight": 95}, | |
| {"value": true, "weight": 5} | |
| ] | |
| }, | |
| "air_quality_index": { | |
| "_gen": "normalDistribution", | |
| "mean": 50, | |
| "sd": 25, | |
| "clamp": [0, 200], | |
| "decimals": 0 | |
| } | |
| }, | |
| "localConfigs": { | |
| "maxEvents": 100 | |
| } | |
| }, | |
| { | |
| "table": "flights", | |
| "vars": { | |
| "now": { | |
| "_gen": "now" | |
| }, | |
| "departure_time": { | |
| "_gen": "math", | |
| "expr": "now - offset", | |
| "names": { | |
| "offset": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [ | |
| 0, | |
| { | |
| "_gen": "duration", | |
| "days": 1 | |
| } | |
| ] | |
| } | |
| } | |
| } | |
| }, | |
| "row": { | |
| "flight_id": { | |
| "_gen": "sequentialInteger", | |
| "startingFrom": 10000 | |
| }, | |
| "aircraft_id": { | |
| "_gen": "lookup", | |
| "table": "aircraft", | |
| "path": ["row", "aircraft_id"] | |
| }, | |
| "pilot_id": { | |
| "_gen": "lookup", | |
| "table": "pilots", | |
| "path": ["row", "pilot_id"] | |
| }, | |
| "departure_time": { | |
| "_gen": "var", | |
| "var": "departure_time" | |
| }, | |
| "arrival_time": { | |
| "_gen": "math", | |
| "expr": "departure_time + offset", | |
| "names": { | |
| "offset": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [ | |
| { | |
| "_gen": "duration", | |
| "hours": 1 | |
| }, | |
| { | |
| "_gen": "duration", | |
| "hours": 12 | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| "departure_location_id": { | |
| "_gen": "lookup", | |
| "table": "locations", | |
| "path": ["row", "location_id"] | |
| }, | |
| "arrival_location_id": { | |
| "_gen": "lookup", | |
| "table": "locations", | |
| "path": ["row", "location_id"] | |
| }, | |
| "flight_phase": { | |
| "_gen": "oneOf", | |
| "choices": ["vertical_takeoff", "transition_to_forward", "cruise", "transition_to_hover", "vertical_landing"] | |
| }, | |
| "flight_purpose": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": "passenger_transport", "weight": 70}, | |
| {"value": "training", "weight": 15}, | |
| {"value": "maintenance_test", "weight": 10}, | |
| {"value": "cargo", "weight": 5} | |
| ] | |
| }, | |
| "environmental_conditions_id": { | |
| "_gen": "lookup", | |
| "table": "environmental_conditions", | |
| "path": ["row", "environment_id"] | |
| }, | |
| "weather_conditions": { | |
| "_gen": "oneOf", | |
| "choices": ["clear", "partly_cloudy", "overcast", "light_rain", "fog"] | |
| }, | |
| "flight_status": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": "completed", "weight": 85}, | |
| {"value": "in_progress", "weight": 10}, | |
| {"value": "cancelled", "weight": 5} | |
| ] | |
| } | |
| }, | |
| "localConfigs": { | |
| "maxEvents": 200 | |
| } | |
| }, | |
| { | |
| "table": "flight_telemetry", | |
| "row": { | |
| "telemetry_id": { | |
| "_gen": "sequentialInteger", | |
| "startingFrom": 1 | |
| }, | |
| "flight_id": { | |
| "_gen": "lookup", | |
| "table": "flights", | |
| "path": ["row", "flight_id"] | |
| }, | |
| "timestamp_ms": { | |
| "_gen": "now" | |
| }, | |
| "latitude": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [37.5, 38.5], | |
| "decimals": 6 | |
| }, | |
| "longitude": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [-122.5, -121.5], | |
| "decimals": 6 | |
| }, | |
| "altitude_msl_m": { | |
| "_gen": "normalDistribution", | |
| "mean": 300, | |
| "sd": 100, | |
| "clamp": [0, 1000], | |
| "decimals": 1 | |
| }, | |
| "altitude_agl_m": { | |
| "_gen": "normalDistribution", | |
| "mean": 280, | |
| "sd": 95, | |
| "clamp": [0, 950], | |
| "decimals": 1 | |
| }, | |
| "ground_speed_mps": { | |
| "_gen": "normalDistribution", | |
| "mean": 55, | |
| "sd": 15, | |
| "clamp": [0, 85], | |
| "decimals": 1 | |
| }, | |
| "vertical_speed_mps": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 2, | |
| "clamp": [-10, 10], | |
| "decimals": 2 | |
| }, | |
| "heading_deg": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [0, 360], | |
| "decimals": 1 | |
| }, | |
| "pitch_deg": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 5, | |
| "clamp": [-20, 20], | |
| "decimals": 2 | |
| }, | |
| "roll_deg": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 3, | |
| "clamp": [-30, 30], | |
| "decimals": 2 | |
| }, | |
| "yaw_rate_deg_s": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 5, | |
| "clamp": [-20, 20], | |
| "decimals": 2 | |
| }, | |
| "wind_speed_mps": { | |
| "_gen": "normalDistribution", | |
| "mean": 5, | |
| "sd": 3, | |
| "clamp": [0, 15], | |
| "decimals": 1 | |
| }, | |
| "wind_direction_deg": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [0, 360], | |
| "decimals": 1 | |
| }, | |
| "temperature_c": { | |
| "_gen": "normalDistribution", | |
| "mean": 15, | |
| "sd": 8, | |
| "decimals": 1 | |
| }, | |
| "air_density_kg_m3": { | |
| "_gen": "normalDistribution", | |
| "mean": 1.225, | |
| "sd": 0.05, | |
| "clamp": [1.0, 1.4], | |
| "decimals": 4 | |
| }, | |
| "rotor_rpm_front_left": { | |
| "_gen": "normalDistribution", | |
| "mean": 2500, | |
| "sd": 100, | |
| "clamp": [1000, 3500], | |
| "decimals": 0 | |
| }, | |
| "rotor_rpm_front_right": { | |
| "_gen": "normalDistribution", | |
| "mean": 2500, | |
| "sd": 100, | |
| "clamp": [1000, 3500], | |
| "decimals": 0 | |
| }, | |
| "rotor_rpm_rear_left": { | |
| "_gen": "normalDistribution", | |
| "mean": 2500, | |
| "sd": 100, | |
| "clamp": [1000, 3500], | |
| "decimals": 0 | |
| }, | |
| "rotor_rpm_rear_right": { | |
| "_gen": "normalDistribution", | |
| "mean": 2500, | |
| "sd": 100, | |
| "clamp": [1000, 3500], | |
| "decimals": 0 | |
| }, | |
| "motor_temp_c_front_left": { | |
| "_gen": "normalDistribution", | |
| "mean": 65, | |
| "sd": 10, | |
| "clamp": [20, 95], | |
| "decimals": 1 | |
| }, | |
| "motor_temp_c_front_right": { | |
| "_gen": "normalDistribution", | |
| "mean": 65, | |
| "sd": 10, | |
| "clamp": [20, 95], | |
| "decimals": 1 | |
| }, | |
| "motor_temp_c_rear_left": { | |
| "_gen": "normalDistribution", | |
| "mean": 65, | |
| "sd": 10, | |
| "clamp": [20, 95], | |
| "decimals": 1 | |
| }, | |
| "motor_temp_c_rear_right": { | |
| "_gen": "normalDistribution", | |
| "mean": 65, | |
| "sd": 10, | |
| "clamp": [20, 95], | |
| "decimals": 1 | |
| }, | |
| "motor_current_a_front_left": { | |
| "_gen": "normalDistribution", | |
| "mean": 85, | |
| "sd": 20, | |
| "clamp": [10, 150], | |
| "decimals": 1 | |
| }, | |
| "motor_current_a_front_right": { | |
| "_gen": "normalDistribution", | |
| "mean": 85, | |
| "sd": 20, | |
| "clamp": [10, 150], | |
| "decimals": 1 | |
| }, | |
| "motor_current_a_rear_left": { | |
| "_gen": "normalDistribution", | |
| "mean": 85, | |
| "sd": 20, | |
| "clamp": [10, 150], | |
| "decimals": 1 | |
| }, | |
| "motor_current_a_rear_right": { | |
| "_gen": "normalDistribution", | |
| "mean": 85, | |
| "sd": 20, | |
| "clamp": [10, 150], | |
| "decimals": 1 | |
| }, | |
| "battery_voltage_v": { | |
| "_gen": "normalDistribution", | |
| "mean": 400, | |
| "sd": 10, | |
| "clamp": [350, 420], | |
| "decimals": 1 | |
| }, | |
| "battery_current_a": { | |
| "_gen": "normalDistribution", | |
| "mean": 150, | |
| "sd": 40, | |
| "clamp": [10, 300], | |
| "decimals": 1 | |
| }, | |
| "battery_soc_percent": { | |
| "_gen": "normalDistribution", | |
| "mean": 70, | |
| "sd": 20, | |
| "clamp": [0, 100], | |
| "decimals": 1 | |
| }, | |
| "battery_temp_c": { | |
| "_gen": "normalDistribution", | |
| "mean": 35, | |
| "sd": 8, | |
| "clamp": [10, 60], | |
| "decimals": 1 | |
| }, | |
| "battery_cell_voltage_min_v": { | |
| "_gen": "normalDistribution", | |
| "mean": 3.7, | |
| "sd": 0.1, | |
| "clamp": [3.0, 4.2], | |
| "decimals": 3 | |
| }, | |
| "battery_cell_voltage_max_v": { | |
| "_gen": "normalDistribution", | |
| "mean": 3.75, | |
| "sd": 0.1, | |
| "clamp": [3.0, 4.2], | |
| "decimals": 3 | |
| }, | |
| "battery_cell_voltage_delta_v": { | |
| "_gen": "normalDistribution", | |
| "mean": 0.05, | |
| "sd": 0.02, | |
| "clamp": [0, 0.2], | |
| "decimals": 3 | |
| }, | |
| "total_power_consumption_w": { | |
| "_gen": "normalDistribution", | |
| "mean": 60000, | |
| "sd": 15000, | |
| "clamp": [5000, 120000], | |
| "decimals": 0 | |
| }, | |
| "propulsion_power_w": { | |
| "_gen": "normalDistribution", | |
| "mean": 50000, | |
| "sd": 12000, | |
| "clamp": [4000, 100000], | |
| "decimals": 0 | |
| }, | |
| "avionics_power_w": { | |
| "_gen": "normalDistribution", | |
| "mean": 800, | |
| "sd": 150, | |
| "clamp": [200, 1500], | |
| "decimals": 0 | |
| }, | |
| "thermal_management_power_w": { | |
| "_gen": "normalDistribution", | |
| "mean": 2000, | |
| "sd": 500, | |
| "clamp": [0, 5000], | |
| "decimals": 0 | |
| }, | |
| "gps_satellites_visible": { | |
| "_gen": "uniformDistribution", | |
| "bounds": [8, 16], | |
| "decimals": 0 | |
| }, | |
| "gps_hdop": { | |
| "_gen": "normalDistribution", | |
| "mean": 1.0, | |
| "sd": 0.3, | |
| "clamp": [0.5, 3.0], | |
| "decimals": 2 | |
| }, | |
| "imu_accel_x_g": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 0.2, | |
| "clamp": [-2, 2], | |
| "decimals": 3 | |
| }, | |
| "imu_accel_y_g": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 0.2, | |
| "clamp": [-2, 2], | |
| "decimals": 3 | |
| }, | |
| "imu_accel_z_g": { | |
| "_gen": "normalDistribution", | |
| "mean": 1.0, | |
| "sd": 0.2, | |
| "clamp": [-1, 3], | |
| "decimals": 3 | |
| }, | |
| "imu_gyro_x_deg_s": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 3, | |
| "clamp": [-20, 20], | |
| "decimals": 2 | |
| }, | |
| "imu_gyro_y_deg_s": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 3, | |
| "clamp": [-20, 20], | |
| "decimals": 2 | |
| }, | |
| "imu_gyro_z_deg_s": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 5, | |
| "clamp": [-30, 30], | |
| "decimals": 2 | |
| }, | |
| "barometer_altitude_m": { | |
| "_gen": "normalDistribution", | |
| "mean": 300, | |
| "sd": 100, | |
| "clamp": [0, 1000], | |
| "decimals": 1 | |
| }, | |
| "airspeed_mps": { | |
| "_gen": "normalDistribution", | |
| "mean": 55, | |
| "sd": 15, | |
| "clamp": [0, 85], | |
| "decimals": 1 | |
| }, | |
| "angle_of_attack_deg": { | |
| "_gen": "normalDistribution", | |
| "mean": 3, | |
| "sd": 2, | |
| "clamp": [-5, 15], | |
| "decimals": 2 | |
| }, | |
| "sideslip_angle_deg": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 2, | |
| "clamp": [-10, 10], | |
| "decimals": 2 | |
| }, | |
| "flight_mode": { | |
| "_gen": "oneOf", | |
| "choices": ["hover", "transition", "cruise", "loiter"] | |
| }, | |
| "autopilot_engaged_flag": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": false, "weight": 20}, | |
| {"value": true, "weight": 80} | |
| ] | |
| }, | |
| "terrain_following_active_flag": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": false, "weight": 70}, | |
| {"value": true, "weight": 30} | |
| ] | |
| }, | |
| "obstacle_detection_active_flag": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": false, "weight": 30}, | |
| {"value": true, "weight": 70} | |
| ] | |
| }, | |
| "geofence_breach_flag": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": false, "weight": 98}, | |
| {"value": true, "weight": 2} | |
| ] | |
| }, | |
| "emergency_descent_flag": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": false, "weight": 99}, | |
| {"value": true, "weight": 1} | |
| ] | |
| }, | |
| "stability_augmentation_active_flag": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": false, "weight": 20}, | |
| {"value": true, "weight": 80} | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "table": "structural_loads", | |
| "row": { | |
| "load_id": { | |
| "_gen": "sequentialInteger", | |
| "startingFrom": 1 | |
| }, | |
| "telemetry_id": { | |
| "_gen": "lookup", | |
| "table": "flight_telemetry", | |
| "path": ["row", "telemetry_id"] | |
| }, | |
| "gross_weight_kg": { | |
| "_gen": "normalDistribution", | |
| "mean": 2200, | |
| "sd": 200, | |
| "clamp": [1800, 2800], | |
| "decimals": 1 | |
| }, | |
| "center_of_gravity_x_m": { | |
| "_gen": "normalDistribution", | |
| "mean": 2.5, | |
| "sd": 0.2, | |
| "clamp": [2.0, 3.0], | |
| "decimals": 3 | |
| }, | |
| "center_of_gravity_y_m": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 0.05, | |
| "clamp": [-0.2, 0.2], | |
| "decimals": 3 | |
| }, | |
| "center_of_gravity_z_m": { | |
| "_gen": "normalDistribution", | |
| "mean": -0.5, | |
| "sd": 0.1, | |
| "clamp": [-1.0, 0], | |
| "decimals": 3 | |
| }, | |
| "load_factor_vertical": { | |
| "_gen": "normalDistribution", | |
| "mean": 1.0, | |
| "sd": 0.2, | |
| "clamp": [0.5, 2.5], | |
| "decimals": 3 | |
| }, | |
| "load_factor_lateral": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 0.1, | |
| "clamp": [-0.5, 0.5], | |
| "decimals": 3 | |
| }, | |
| "load_factor_longitudinal": { | |
| "_gen": "normalDistribution", | |
| "mean": 0, | |
| "sd": 0.1, | |
| "clamp": [-0.5, 0.5], | |
| "decimals": 3 | |
| }, | |
| "rotor_disk_loading_n_m2": { | |
| "_gen": "normalDistribution", | |
| "mean": 800, | |
| "sd": 100, | |
| "clamp": [400, 1200], | |
| "decimals": 1 | |
| }, | |
| "bending_moment_fuselage_nm": { | |
| "_gen": "normalDistribution", | |
| "mean": 5000, | |
| "sd": 2000, | |
| "clamp": [0, 15000], | |
| "decimals": 0 | |
| }, | |
| "torsional_moment_fuselage_nm": { | |
| "_gen": "normalDistribution", | |
| "mean": 1000, | |
| "sd": 500, | |
| "clamp": [0, 3000], | |
| "decimals": 0 | |
| }, | |
| "vibration_whole_aircraft_g_rms": { | |
| "_gen": "normalDistribution", | |
| "mean": 0.3, | |
| "sd": 0.1, | |
| "clamp": [0.05, 1.0], | |
| "decimals": 3 | |
| } | |
| } | |
| }, | |
| { | |
| "table": "flight_performance_metrics", | |
| "row": { | |
| "performance_id": { | |
| "_gen": "sequentialInteger", | |
| "startingFrom": 1 | |
| }, | |
| "flight_id": { | |
| "_gen": "lookup", | |
| "table": "flights", | |
| "path": ["row", "flight_id"] | |
| }, | |
| "hover_power_specific_w_kg": { | |
| "_gen": "normalDistribution", | |
| "mean": 550, | |
| "sd": 50, | |
| "clamp": [400, 700], | |
| "decimals": 1 | |
| }, | |
| "hover_endurance_minutes": { | |
| "_gen": "normalDistribution", | |
| "mean": 18, | |
| "sd": 4, | |
| "clamp": [10, 30], | |
| "decimals": 1 | |
| }, | |
| "cruise_efficiency_km_kwh": { | |
| "_gen": "normalDistribution", | |
| "mean": 2.5, | |
| "sd": 0.5, | |
| "clamp": [1.5, 4.0], | |
| "decimals": 2 | |
| }, | |
| "energy_consumption_total_kwh": { | |
| "_gen": "normalDistribution", | |
| "mean": 42, | |
| "sd": 15, | |
| "clamp": [10, 100], | |
| "decimals": 2 | |
| }, | |
| "energy_consumption_takeoff_kwh": { | |
| "_gen": "normalDistribution", | |
| "mean": 12, | |
| "sd": 3, | |
| "clamp": [5, 25], | |
| "decimals": 2 | |
| }, | |
| "energy_consumption_cruise_kwh": { | |
| "_gen": "normalDistribution", | |
| "mean": 20, | |
| "sd": 10, | |
| "clamp": [5, 60], | |
| "decimals": 2 | |
| }, | |
| "energy_consumption_landing_kwh": { | |
| "_gen": "normalDistribution", | |
| "mean": 10, | |
| "sd": 3, | |
| "clamp": [4, 20], | |
| "decimals": 2 | |
| }, | |
| "range_achieved_km": { | |
| "_gen": "normalDistribution", | |
| "mean": 85, | |
| "sd": 25, | |
| "clamp": [20, 180], | |
| "decimals": 1 | |
| }, | |
| "max_altitude_reached_m": { | |
| "_gen": "normalDistribution", | |
| "mean": 450, | |
| "sd": 150, | |
| "clamp": [100, 1000], | |
| "decimals": 0 | |
| }, | |
| "max_speed_achieved_mps": { | |
| "_gen": "normalDistribution", | |
| "mean": 65, | |
| "sd": 10, | |
| "clamp": [30, 85], | |
| "decimals": 1 | |
| }, | |
| "transition_time_hover_to_cruise_s": { | |
| "_gen": "normalDistribution", | |
| "mean": 35, | |
| "sd": 10, | |
| "clamp": [15, 60], | |
| "decimals": 1 | |
| }, | |
| "transition_time_cruise_to_hover_s": { | |
| "_gen": "normalDistribution", | |
| "mean": 40, | |
| "sd": 12, | |
| "clamp": [20, 70], | |
| "decimals": 1 | |
| }, | |
| "payload_weight_kg": { | |
| "_gen": "normalDistribution", | |
| "mean": 280, | |
| "sd": 60, | |
| "clamp": [100, 450], | |
| "decimals": 1 | |
| }, | |
| "payload_efficiency_kg_km_kwh": { | |
| "_gen": "normalDistribution", | |
| "mean": 5.8, | |
| "sd": 1.5, | |
| "clamp": [2, 12], | |
| "decimals": 2 | |
| } | |
| } | |
| }, | |
| { | |
| "table": "flight_anomalies", | |
| "row": { | |
| "anomaly_id": { | |
| "_gen": "sequentialInteger", | |
| "startingFrom": 1 | |
| }, | |
| "flight_id": { | |
| "_gen": "lookup", | |
| "table": "flights", | |
| "path": ["row", "flight_id"] | |
| }, | |
| "timestamp": { | |
| "_gen": "now" | |
| }, | |
| "anomaly_type": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": "motor_failure", "weight": 5}, | |
| {"value": "battery_warning", "weight": 15}, | |
| {"value": "sensor_fault", "weight": 25}, | |
| {"value": "control_saturation", "weight": 30}, | |
| {"value": "excessive_vibration", "weight": 20}, | |
| {"value": "thermal_event", "weight": 5} | |
| ] | |
| }, | |
| "severity": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": "caution", "weight": 60}, | |
| {"value": "warning", "weight": 30}, | |
| {"value": "critical", "weight": 10} | |
| ] | |
| }, | |
| "affected_system": { | |
| "_gen": "oneOf", | |
| "choices": [ | |
| "propulsion", "battery", "flight_control", "navigation", "communication", "structural" | |
| ] | |
| }, | |
| "pilot_action_taken": { | |
| "_gen": "oneOf", | |
| "choices": [ | |
| "continued_normal_ops", "reduced_power", "initiated_landing", "system_reset", "diverted_to_alternate" | |
| ] | |
| }, | |
| "auto_recovery_engaged_flag": { | |
| "_gen": "weightedOneOf", | |
| "choices": [ | |
| {"value": false, "weight": 40}, | |
| {"value": true, "weight": 60} | |
| ] | |
| }, | |
| "anomaly_description": { | |
| "_gen": "string", | |
| "expr": "#{Lorem.sentence}" | |
| } | |
| } | |
| } | |
| ], | |
| "connections": { | |
| "md": { | |
| "kind": "motherduck", | |
| "connectionConfigs": { | |
| "token": { | |
| "_gen": "env", | |
| "var": "MOTHERDUCK_TOKEN", | |
| "mask": true | |
| }, | |
| "db": "my_db" | |
| } | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment