Name: UAS_RPIC

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 0295e44b50634e88924f953586017957

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• name ( type: esriFieldTypeString, alias: name, length: 255 )
• phone_number ( type: esriFieldTypeString, alias: phone_number, length: 255 )
• email ( type: esriFieldTypeString, alias: email, length: 255 )
• certification_number ( type: esriFieldTypeString, alias: certification_number, length: 255 )
• vendor_guid ( type: esriFieldTypeGUID, alias: vendor_guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• qualified ( type: esriFieldTypeString, alias: qualified, length: 255 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 128 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 128 )
• vendorcompany_name ( type: esriFieldTypeString, alias: Vendor/Company Name, length: 255 )
• evaluator ( type: esriFieldTypeString, alias: Evaluator, length: 255 )
• assessment_date ( type: esriFieldTypeDate, alias: Assessment Date, length: 8 )
• use_case ( type: esriFieldTypeString, alias: Use Case, length: 1000 )
• use_case_other ( type: esriFieldTypeString, alias: Other - Use Case, length: 255 )
• other_personnel_role ( type: esriFieldTypeString, alias: Other Personnel, Role, length: 1000 )
• 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), length: 255 )
• 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). , length: 255 )
• 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), length: 255 )
• rpic_ensured_all_participants_w ( type: esriFieldTypeString, alias: RPIC ensured all participants were briefed and/or understood the plan and their responsibilities. (PF), length: 255 )
• 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), length: 255 )
• 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), length: 255 )
• 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), length: 255 )
• rpic_utilizes_pre_flight_checkl ( type: esriFieldTypeString, alias: RPIC utilizes pre-flight checklist ensuring aircraft is safe and ready for operations. (PF), length: 255 )
• 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), length: 255 )
• 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., length: 255 )
• rpic_has_easy_accessreference_t ( type: esriFieldTypeString, alias: RPIC has easy access/reference to an incident response notification system. (SMS), length: 255 )
• rpic_has_adequate_emergency_res ( type: esriFieldTypeString, alias: RPIC has adequate emergency response procedures. (SMS), length: 255 )
• evaluator_comments ( type: esriFieldTypeString, alias: Evaluator Comments, length: 1000 )

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata