Name: Form_8

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Form 8","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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: sqlTypeGUID, length: 38, nullable: false, editable: false)
• uri_deviceid_calculate (type: esriFieldTypeString, alias: uri_deviceid_calculate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• username_type (type: esriFieldTypeString, alias: username_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MissionDateTime (type: esriFieldTypeDate, alias: Mission Created Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MissionProjectName (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• emailTest (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MissionStatus (type: esriFieldTypeString, alias: Mission Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [10: Requested], [20: Planning], [30: Onsite], ... 2 more ...)
• MissionType (type: esriFieldTypeString, alias: Mission Application, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [TestAircraftPayload: Aircraft/Payload Testing], [InspectAshPond: Ash Pond Inspection], [InspectCoalBunker: Coal Bunker Inspection], ... 25 more ...)
• pulldataDMS (type: esriFieldTypeString, alias: Pulldata DMS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ForeFlightUser (type: esriFieldTypeString, alias: Foreflight user (Y/N), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• hid_Lat (type: esriFieldTypeDouble, alias: hid_Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hid_Long (type: esriFieldTypeDouble, alias: hid_Long, SQL Type: sqlTypeOther, nullable: true, editable: true)
• txt_ForeflightLatLong (type: esriFieldTypeString, alias: Foreflight Lat Long, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ScheduledDateTime (type: esriFieldTypeDate, alias: Mission Scheduled Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ClassAirspace (type: esriFieldTypeString, alias: Select Class Airspace, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [TFR: TFR], [B: Class B], [C: Class C], ... 3 more ...)
• ClassAirspaceNote (type: esriFieldTypeString, alias: Airspace Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IsAuthRequired (type: esriFieldTypeString, alias: Authorization is Required, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dateAuthRequested (type: esriFieldTypeDate, alias: Date Authorization Requested, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dateAuthApproved (type: esriFieldTypeDate, alias: Date Authorization Approved, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AuthNote (type: esriFieldTypeString, alias: Authorization Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• txt_Wind (type: esriFieldTypeString, alias: Wind note, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• txt_Visiblity (type: esriFieldTypeString, alias: Visibility note, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• txt_Cloud (type: esriFieldTypeString, alias: Cloud note, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lst_ClassAirspaceOnsite (type: esriFieldTypeString, alias: Select Class Airspace, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [TFR: TFR], [B: Class B], [C: Class C], ... 3 more ...)
• opt_CheckPersons (type: esriFieldTypeString, alias: Checked (Y/N), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• opt_CheckHazards (type: esriFieldTypeString, alias: Checked (Y/N), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• txt_Hazards (type: esriFieldTypeString, alias: Hazards note, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lst_checkBriefInfo (type: esriFieldTypeString, alias: Discuss during JSB, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lst_checkAircraft (type: esriFieldTypeString, alias: Inspect, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• int_RTH (type: esriFieldTypeInteger, alias: RTH Altitude (feet), SQL Type: sqlTypeOther, nullable: true, editable: true)
• int_MaxAlt (type: esriFieldTypeInteger, alias: Maximum Altitude (feet), SQL Type: sqlTypeOther, nullable: true, editable: true)
• opt_RPC (type: esriFieldTypeString, alias: Available (Y/N), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• opt_VO (type: esriFieldTypeString, alias: VO (Y/N), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• note_IamSafe (type: esriFieldTypeString, alias: Remember "I'm Safe" influencers: Illness Medication Stress Alcohol Fatigue Eating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FratNote (type: esriFieldTypeString, alias: Pilots are required to check for TFRs and NOTAM at FAA website or through Foreflight., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FratLaunchRecoveries (type: esriFieldTypeString, alias: 1. Launch and Recoveries in last 30 days, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1 point, greater than 12], [3: 3 points, 5 to 8], [5: 5 points, less than 5])
• FratAirspace (type: esriFieldTypeString, alias: 2. Airspace, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1 point, Class G], [3: 3 points, Class D or E], [5: 5 points, Class B or C])
• FratEnvironment (type: esriFieldTypeString, alias: 3. Environment - Distance from Homes/ Highways/ Buildings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1 point, greater than 100'], [3: 3 points, less than 100'], [5: 5 points, directly over])
• FratUtilityEnv (type: esriFieldTypeString, alias: 4. Utility Environment - Distance from Energized Infrastucture / Operating Equipment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1 point, greater than 100'], [3: 3 points, less than 100'], [5: 5 points, directly over])
• FratWind (type: esriFieldTypeString, alias: 5. Wind Conditions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1 point, calm], [3: 3 points, slight breeze], [5: 5 points, gusts])
• FratExperience (type: esriFieldTypeString, alias: Experience with Specific Mission - # of flights, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1 point, greater than 10], [3: 3 points, less than 10], [5: 5 points, none])
• FratScore (type: esriFieldTypeString, alias: FRAT Assessment Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FratScoreGuide (type: esriFieldTypeString, alias: Risk Score Guide 9 or less - Fly Safe.10 to 19 - Consider Risk Mitigation Strategies, but RPIC's decision. 20 or more - RPIC required to implement Risk Mitigation Strategies to reduce the risk., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fratHighRiskNote (type: esriFieldTypeString, alias: Your FRAT score is HIGH and mission is at risk. Pilot must exert efforts to reduce risks by following suggested guidelines of the risk mitigation strategy., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FRATNote2 (type: esriFieldTypeString, alias: Risk Mitigation Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fratRiskMitigationStrategies (type: esriFieldTypeString, alias: Launch and Recoveries - Perform several launch and recoveries in a low risk environment to increase your number and thus lower your FRAT score. Airspace within TFR and/or Class B, C - For TFRs you need permission from the TFR owner. For flights within Class B, C, D & E you need a waiver or FAA authorization. Environment - Notify home owners and building owners as much as practical. Flights over moving vehicles requires a waiver from the FAA. Utility Environment - Ensure you have permission and notify the department/ business unit responsible for that area. Wind Conditions - Obtain a weather briefing from a local airport and ensure your aircraft is rated to operate in those conditions. If wind conditions are too strong, do NOT fly. Experience with Specific Mission - Consult with other experienced UAS pilots for lessons learned and best practices with your specific mission., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CompletedDateTime (type: esriFieldTypeDate, alias: Mission Completed Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• numberFlights (type: esriFieldTypeInteger, alias: Number of Flights, SQL Type: sqlTypeOther, nullable: true, editable: true)
• missionNotes (type: esriFieldTypeString, alias: Misssion Notes & Lessons Learned, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bestPractice (type: esriFieldTypeString, alias: Best Practice, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DataCatalogRequired (type: esriFieldTypeString, alias: Do you need to catalog your mision and payload data? (Y/N), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• dataLink (type: esriFieldTypeString, alias: Payload Data folder location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• portalLink (type: esriFieldTypeString, alias: Mission Portal web map, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• opt_UASValue (type: esriFieldTypeString, alias: Do you want to submit UAS Value for this mission (Y/N)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• PeopleCost_calc (type: esriFieldTypeString, alias: PeopleCost_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TruckCost_calc (type: esriFieldTypeString, alias: TruckCost_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dec_TimeTraditional (type: esriFieldTypeDouble, alias: Time (In decimal hours) to complete this job using traditional means., SQL Type: sqlTypeOther, nullable: true, editable: true)
• int_LaborTraditional (type: esriFieldTypeInteger, alias: How many people?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• int_TrucksTraditional (type: esriFieldTypeInteger, alias: How many trucks?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• txt_AddCostsTraditional (type: esriFieldTypeString, alias: Describe additional costs (resource: count*time*rate), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dec_AddCostsTraditional (type: esriFieldTypeDouble, alias: Calculate additional costs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CostTraditional_calc (type: esriFieldTypeString, alias: CostTraditional_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note_CostTraditional (type: esriFieldTypeString, alias: Total cost (USD) - traditional, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dec_TimeUAS (type: esriFieldTypeDouble, alias: Time (In decimal hours) to complete this job using UAS means., SQL Type: sqlTypeOther, nullable: true, editable: true)
• int_LaborUAS (type: esriFieldTypeInteger, alias: How many people?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• int_TrucksUAS (type: esriFieldTypeInteger, alias: How many trucks?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CostUAS_calc (type: esriFieldTypeString, alias: CostUAS_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dec_AddCostsUAS (type: esriFieldTypeDouble, alias: Calculate additional costs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• txt_AddCostsUAS (type: esriFieldTypeString, alias: Describe additional costs (resource: count*time*rate), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note_CostUAS (type: esriFieldTypeString, alias: Total cost (USD) - UAS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note_TimeDiff (type: esriFieldTypeString, alias: Time Difference (+ Time savings with UAS;- Time lost with UAS), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note_CostDiff (type: esriFieldTypeString, alias: Cost Difference (+ UAS cost less;- UAS costs more), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• txt_UASValueNotes (type: esriFieldTypeString, alias: UAS Value Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uri_deviceid (type: esriFieldTypeString, alias: Device ID with operating system identifer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• username (type: esriFieldTypeString, alias: Username, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/12/2019 4:15:39 PM

Schema Last Edit Date: 6/12/2019 4:15:39 PM

Data Last Edit Date: 6/12/2019 4:15:39 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat