Name: UAS_RPIC

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 2a95786b5033446990641b5481b32d79

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• name ( type: esriFieldTypeString, alias: name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: name )
• phone_number ( type: esriFieldTypeString, alias: phone_number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: phone_number )
• email ( type: esriFieldTypeString, alias: email, editable: true, nullable: true, length: 255, defaultValue: null, modelName: email )
• certification_number ( type: esriFieldTypeString, alias: certification_number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: certification_number )
• vendor_guid ( type: esriFieldTypeGUID, alias: vendor_guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: vendor_guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• qualified ( type: esriFieldTypeString, alias: qualified, editable: true, nullable: true, length: 255, defaultValue: No, modelName: qualified )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreationDate, required: true )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Creator, required: true )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate, required: true )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Editor, required: true )
• vendorcompany_name ( type: esriFieldTypeString, alias: Vendor/Company Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: vendorcompany_name )
• evaluator ( type: esriFieldTypeString, alias: Evaluator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: evaluator )
• assessment_date ( type: esriFieldTypeDate, alias: Assessment Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: assessment_date )
• use_case ( type: esriFieldTypeString, alias: Use Case, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: use_case )
• use_case_other ( type: esriFieldTypeString, alias: Other - Use Case, editable: true, nullable: true, length: 255, defaultValue: null, modelName: use_case_other )
• other_personnel_role ( type: esriFieldTypeString, alias: Other Personnel, Role, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: other_personnel_role )
• vendor_confirms_any_changes_to ( type: esriFieldTypeString, alias: Vendor confirms any changes to site dynamics not included in the project documentaiton including hazards, privacy concerns, and personnel/pedestrians on foot and/or moving vehicles. (SE), editable: true, nullable: true, length: 255, defaultValue: null, modelName: vendor_confirms_any_changes_to )
• rpic_confirmed_airspace_classif ( type: esriFieldTypeString, alias: RPIC confirmed airspace classification and verifies no active NOTAMs or other restrictions exist within the operational location(s). , editable: true, nullable: true, length: 255, defaultValue: null, modelName: rpic_confirmed_airspace_classif )
• rpic_checked_weather_from_an_ap ( type: esriFieldTypeString, alias: RPIC checked weather from an appropriate source and confirmed weather minimums meet FAA Part 107 guidlines for sUAS operations including evaluating visibility, wind speed, wind direction, precipitation, and temperature. (PF), editable: true, nullable: true, length: 255, defaultValue: null, modelName: rpic_checked_weather_from_an_ap )
• rpic_ensured_all_participants_w ( type: esriFieldTypeString, alias: RPIC ensured all participants were briefed and/or understood the plan and their responsibilities. (PF), editable: true, nullable: true, length: 255, defaultValue: null, modelName: rpic_ensured_all_participants_w )
• rpic_andor_his_designee_visuall ( type: esriFieldTypeString, alias: RPIC and/or his designee visually checked the aircraft for any damage that may compromiseflight safety/security or airworthiness of the aircraft. (PF), editable: true, nullable: true, length: 255, defaultValue: null, modelName: rpic_andor_his_designee_visuall )
• rpic_reviews_maintenance_logs_a ( type: esriFieldTypeString, alias: RPIC reviews maintenance logs and/or flight software and firmware to determine the status and airworthiness of the aircraft. (PF), editable: true, nullable: true, length: 255, defaultValue: null, modelName: rpic_reviews_maintenance_logs_a )
• rpic_verified_faa_registration ( type: esriFieldTypeString, alias: RPIC verified FAA Registration Number is current and marked on the exterior of all aircraft being flown for the operation. (PF), editable: true, nullable: true, length: 255, defaultValue: null, modelName: rpic_verified_faa_registration )
• rpic_utilizes_pre_flight_checkl ( type: esriFieldTypeString, alias: RPIC utilizes pre-flight checklist ensuring aircraft is safe and ready for operations. (PF), editable: true, nullable: true, length: 255, defaultValue: null, modelName: rpic_utilizes_pre_flight_checkl )
• rpic_ensures_aircraft_altitude ( type: esriFieldTypeString, alias: RPIC ensures aircraft altitude and routing will adequately avoid all applicable risks in the event of a lost link condition. (PF), editable: true, nullable: true, length: 255, defaultValue: null, modelName: rpic_ensures_aircraft_altitude )
• rpic_has_the_proper_level_of_co ( type: esriFieldTypeString, alias: RPIC has the proper level of competency and currency for aircraft and mission being flown., editable: true, nullable: true, length: 255, defaultValue: null, modelName: rpic_has_the_proper_level_of_co )
• rpic_has_easy_accessreference_t ( type: esriFieldTypeString, alias: RPIC has easy access/reference to an incident response notification system. (SMS), editable: true, nullable: true, length: 255, defaultValue: null, modelName: rpic_has_easy_accessreference_t )
• rpic_has_adequate_emergency_res ( type: esriFieldTypeString, alias: RPIC has adequate emergency response procedures. (SMS), editable: true, nullable: true, length: 255, defaultValue: null, modelName: rpic_has_adequate_emergency_res )
• evaluator_comments ( type: esriFieldTypeString, alias: Evaluator Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: evaluator_comments )

Templates:

• Name: UAS_RPIC
  Description:
  Prototype:
  rpic_has_adequate_emergency_res: null
  rpic_has_easy_accessreference_t: null
  name: null
  phone_number: null
  email: null
  certification_number: null
  vendor_guid: null
  evaluator_comments: null
  rpic_has_the_proper_level_of_co: null
  rpic_ensures_aircraft_altitude: null
  rpic_utilizes_pre_flight_checkl: null
  rpic_verified_faa_registration: null
  qualified: No
  CreationDate: null
  Creator: null
  EditDate: null
  Editor: null
  vendorcompany_name: null
  evaluator: null
  assessment_date: null
  use_case: null
  use_case_other: null
  other_personnel_role: null
  vendor_confirms_any_changes_to: null
  rpic_confirmed_airspace_classif: null
  rpic_checked_weather_from_an_ap: null
  rpic_ensured_all_participants_w: null
  rpic_andor_his_designee_visuall: null
  rpic_reviews_maintenance_logs_a: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• MASSDOT.DBO.UAS_Flight_Requests (1) -- Related To: UAS_Flight_Requests (2)
• MASSDOT.DBO.UAS_Vendors (0) -- Related To: UAS_Vendors (1)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Ownership Based Access Control:

• Allow Others to Update: false
• Allow Others to Delete: false
• Allow Others to Query: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata