Name: PWFLIGHTLOG

Display Field: Name

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• date_of_flight (type: esriFieldTypeDate, alias: Date of Flight, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• purpose_of_flight (type: esriFieldTypeString, alias: Purpose of Flight, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• weather_conditions (type: esriFieldTypeString, alias: Weather Conditions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• rpic_name (type: esriFieldTypeString, alias: RPIC Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uav_pilot_name (type: esriFieldTypeString, alias: UAV Pilot Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vo_names (type: esriFieldTypeString, alias: VO Name(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uav_manufacturer (type: esriFieldTypeString, alias: UAV Manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uav_model (type: esriFieldTypeString, alias: UAV Model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• batteries_charged_secure (type: esriFieldTypeString, alias: Batteries Charged & Secure, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• aircraft_hardware_ok (type: esriFieldTypeString, alias: Aircraft Hardware OK?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• equipment_gear_ok (type: esriFieldTypeString, alias: Equipment & Gear OK?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• remote_control_ok (type: esriFieldTypeString, alias: Remote Control OK?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• propellers_ok_secured_to_uav (type: esriFieldTypeString, alias: Propellers OK & Secured to UAV?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• software_firmware_versions_are_ (type: esriFieldTypeString, alias: Software & Firmware Versions are Up to Date?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• remote_control_is_powered_on (type: esriFieldTypeString, alias: Remote Control is Powered ON?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• uav_is_powered_on (type: esriFieldTypeString, alias: UAV is Powered ON?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• uav_compass_is_calibrated (type: esriFieldTypeString, alias: UAV Compass is Calibrated?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• camera_is_on_calibrated (type: esriFieldTypeString, alias: Camera is ON & Calibrated?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• uav_gps_is_functioning (type: esriFieldTypeString, alias: UAV GPS is Functioning?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• flight_control_app_is_running_c (type: esriFieldTypeString, alias: Flight Control App is Running & Connected to UAV?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• pre_flight_notes (type: esriFieldTypeString, alias: Pre-Flight Notes:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• begin_flight (type: esriFieldTypeString, alias: Begin Flight, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• end_flight (type: esriFieldTypeString, alias: End Flight, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• post_flight_notes (type: esriFieldTypeString, alias: Post-flight Notes:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Incidentgroup (type: esriFieldTypeString, alias: Was there an Incident?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IncidentDateTime (type: esriFieldTypeDate, alias: Incident Date/Time:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Name (type: esriFieldTypeString, alias: Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PhoneNumber (type: esriFieldTypeString, alias: Phone Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MailingAddress (type: esriFieldTypeString, alias: Mailing Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Vehicle (type: esriFieldTypeString, alias: Vehicle Information, if applicable, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Injured (type: esriFieldTypeString, alias: Where they Injured?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IncLocation (type: esriFieldTypeString, alias: Incident Location:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DescofInc (type: esriFieldTypeString, alias: Description of Incident/Damaged:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• DescInjury (type: esriFieldTypeString, alias: Full Description of Injury:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• FirstAid (type: esriFieldTypeString, alias: Was first aid necessary?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• firstaidprovided (type: esriFieldTypeString, alias: If so, who provided it:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• medicalattention (type: esriFieldTypeString, alias: Accepeted medical attention?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• refusedmedical (type: esriFieldTypeString, alias: Refused medical attention?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CityInvolved (type: esriFieldTypeString, alias: Was City Involved?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EmployeeComplet (type: esriFieldTypeString, alias: Employee Completing this form:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IncidentWeather (type: esriFieldTypeString, alias: Weather Conditions at time of Incident:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IncidLocation (type: esriFieldTypeString, alias: Location of Incident:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DescriptionInci (type: esriFieldTypeString, alias: Full Descrition of Incident:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• doingincident (type: esriFieldTypeString, alias: What Were You Doing & Where Were You at Time of Incident?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• damage (type: esriFieldTypeString, alias: Describe Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cityvehicles (type: esriFieldTypeString, alias: Were City Vehicles Involved?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cityemployees (type: esriFieldTypeString, alias: Where City Employees Injured?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Witness1 (type: esriFieldTypeString, alias: Witness 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Witness2 (type: esriFieldTypeString, alias: Witness 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• weather (type: esriFieldTypeString, alias: Weather Conditions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• weather_lat (type: esriFieldTypeString, alias: weather_lat, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• weather_lon (type: esriFieldTypeString, alias: weather_lon, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• weather_api_key (type: esriFieldTypeString, alias: weather_api_key, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• weather_json (type: esriFieldTypeString, alias: weather_json, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• weather_city (type: esriFieldTypeString, alias: Location (as reported by the API), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• temperature (type: esriFieldTypeDouble, alias: Temperature (°F), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FLIGHTLOG_GUID (type: esriFieldTypeGUID, alias: FLIGHTLOG_GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: PWFLIGHTLOG
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• survey (0) -- Related To: FLIGHTREQUEST_ONLINE (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/11/2026 8:26:05 PM

Schema Last Edit Date: 9/11/2026 8:26:05 PM

Data Last Edit Date: 9/11/2026 8:26:05 PM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat