{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 6,
 "name": "UAS_RPIC",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "OBJECTID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "name",
   "type": "esriFieldTypeString",
   "alias": "name",
   "length": 255,
   "domain": null
  },
  {
   "name": "phone_number",
   "type": "esriFieldTypeString",
   "alias": "phone_number",
   "length": 255,
   "domain": null
  },
  {
   "name": "email",
   "type": "esriFieldTypeString",
   "alias": "email",
   "length": 255,
   "domain": null
  },
  {
   "name": "certification_number",
   "type": "esriFieldTypeString",
   "alias": "certification_number",
   "length": 255,
   "domain": null
  },
  {
   "name": "vendor_guid",
   "type": "esriFieldTypeGUID",
   "alias": "vendor_guid",
   "length": 38,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "qualified",
   "type": "esriFieldTypeString",
   "alias": "qualified",
   "length": 255,
   "domain": null
  },
  {
   "name": "CreationDate",
   "type": "esriFieldTypeDate",
   "alias": "CreationDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "Creator",
   "type": "esriFieldTypeString",
   "alias": "Creator",
   "length": 128,
   "domain": null
  },
  {
   "name": "EditDate",
   "type": "esriFieldTypeDate",
   "alias": "EditDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "Editor",
   "type": "esriFieldTypeString",
   "alias": "Editor",
   "length": 128,
   "domain": null
  },
  {
   "name": "vendorcompany_name",
   "type": "esriFieldTypeString",
   "alias": "Vendor/Company Name",
   "length": 255,
   "domain": null
  },
  {
   "name": "evaluator",
   "type": "esriFieldTypeString",
   "alias": "Evaluator",
   "length": 255,
   "domain": null
  },
  {
   "name": "assessment_date",
   "type": "esriFieldTypeDate",
   "alias": "Assessment Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "use_case",
   "type": "esriFieldTypeString",
   "alias": "Use Case",
   "length": 1000,
   "domain": null
  },
  {
   "name": "use_case_other",
   "type": "esriFieldTypeString",
   "alias": "Other - Use Case",
   "length": 255,
   "domain": null
  },
  {
   "name": "other_personnel_role",
   "type": "esriFieldTypeString",
   "alias": "Other Personnel, Role",
   "length": 1000,
   "domain": null
  },
  {
   "name": "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,
   "domain": null
  },
  {
   "name": "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,
   "domain": null
  },
  {
   "name": "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,
   "domain": null
  },
  {
   "name": "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,
   "domain": null
  },
  {
   "name": "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,
   "domain": null
  },
  {
   "name": "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,
   "domain": null
  },
  {
   "name": "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,
   "domain": null
  },
  {
   "name": "rpic_utilizes_pre_flight_checkl",
   "type": "esriFieldTypeString",
   "alias": "RPIC utilizes pre-flight checklist ensuring aircraft is safe and ready for operations. (PF)",
   "length": 255,
   "domain": null
  },
  {
   "name": "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,
   "domain": null
  },
  {
   "name": "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,
   "domain": null
  },
  {
   "name": "rpic_has_easy_accessreference_t",
   "type": "esriFieldTypeString",
   "alias": "RPIC has easy access/reference to an incident response notification system.  (SMS)",
   "length": 255,
   "domain": null
  },
  {
   "name": "rpic_has_adequate_emergency_res",
   "type": "esriFieldTypeString",
   "alias": "RPIC has adequate emergency response procedures. (SMS)",
   "length": 255,
   "domain": null
  },
  {
   "name": "evaluator_comments",
   "type": "esriFieldTypeString",
   "alias": "Evaluator Comments",
   "length": 1000,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R4448_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_20837_vendor",
   "fields": "vendor_guid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_4448",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "MASSDOT.DBO.UAS_Flight_Requests",
   "relatedTableId": 2,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{20E9EB56-AD35-41BC-964B-2F8FBBDEC283}"
  },
  {
   "id": 0,
   "name": "MASSDOT.DBO.UAS_Vendors",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "vendor_guid",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{7C72CFDC-9E76-4FAD-9DB1-27F1849BD368}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "0295e44b50634e88924f953586017957"
}