{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 2,
 "name": "Dumpster Inspection Table",
 "type": "Table",
 "description": null,
 "copyrightText": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "ComDumpsterIssues",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "ComDumpsterIssues",
   "type": "esriFieldTypeString",
   "alias": "Com Dumpster Issues",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "DumpsterIssues",
    "description": "Dumpster Concern and Issues",
    "codedValues": [
     {
      "name": "Overage",
      "code": "Overage"
     },
     {
      "name": "Incorrect Placement",
      "code": "Incorrect Placement"
     },
     {
      "name": "Fire Damage",
      "code": "Fire Damge"
     },
     {
      "name": "Prohibited Materials - Hazardous Materials",
      "code": "Hazardous Materials"
     },
     {
      "name": "Container Rusted or Holes",
      "code": "Container Rusted"
     },
     {
      "name": "Wheel Damaged or Missing",
      "code": "Wheel Damaged"
     },
     {
      "name": "Lid Cracked or Missing",
      "code": "Lid Cracked"
     },
     {
      "name": "Label Faded or Missing",
      "code": "Label Faded"
     },
     {
      "name": "Prohibited Materials - Construction and Demolition",
      "code": "Construction and Demolition"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComDumsterIssuesResolved",
   "type": "esriFieldTypeString",
   "alias": "Com Dumster Issues Resolved",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComRollOffDumsterConcernIssues",
   "type": "esriFieldTypeString",
   "alias": "Com Roll Off Dumster Concern Issues",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "RolloffDumpsterIssues",
    "description": "Roll Off Dumpster Concern and Issues",
    "codedValues": [
     {
      "name": "Incorrect Placement",
      "code": "Incorrect Placement"
     },
     {
      "name": "Gate Unable to Open or Close",
      "code": "Gate Unable to Open"
     },
     {
      "name": "Graffiti Paint",
      "code": "Graffiti Paint"
     },
     {
      "name": "Container Rusted or Holes",
      "code": "Container Rusted"
     },
     {
      "name": "Label faded or Missing",
      "code": "Label Faded"
     },
     {
      "name": "Missed Delivery Date",
      "code": "Missed Delivery Date"
     },
     {
      "name": "Missed Removal Date",
      "code": "Missed Removal Date"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComRollOffDumsterConcernIssuesR",
   "type": "esriFieldTypeString",
   "alias": "Com Roll Off Dumster Concern Issues Resolved",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComEnclosureConcernIssues",
   "type": "esriFieldTypeString",
   "alias": "Com Enclosure Concern Issues",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "EnclosureConcernIssues",
    "description": "Enclosure Concern and Issues",
    "codedValues": [
     {
      "name": "Debris Left on Ground",
      "code": "Debris"
     },
     {
      "name": "Gate or Door Damage or Missing",
      "code": "Gate Door Damage"
     },
     {
      "name": "Bulk Items Inside or Outside",
      "code": "Bulk Items"
     },
     {
      "name": "Hazardous Materials Inside or Outside",
      "code": "Hazardous Materials"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComEnclosureConcernIssuesResolv",
   "type": "esriFieldTypeString",
   "alias": "Com Enclosure Concern Issues Resolved",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComCollectionVehicle",
   "type": "esriFieldTypeString",
   "alias": "Com Collection Vehicle",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "CollectionVehicle",
    "description": "Collection Vehicle",
    "codedValues": [
     {
      "name": "No Tarp in Use",
      "code": "No Tarp"
     },
     {
      "name": "Vehicle Requires Washing",
      "code": "Vehicle Requires Washing"
     },
     {
      "name": "Decal Faded or Missing",
      "code": "Decal Faded"
     },
     {
      "name": "Erratic Driving",
      "code": "Erratic Driving"
     },
     {
      "name": "Leaking Leachate",
      "code": "Leaking Leachate"
     },
     {
      "name": "Leaking Oil",
      "code": "Leaking Oil"
     },
     {
      "name": "Fire Damage",
      "code": "Fire Damage"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComCollectionVehicleResolved",
   "type": "esriFieldTypeString",
   "alias": "Com Collection Vehicle Resolved",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComSitePropertyConcernsIssues",
   "type": "esriFieldTypeString",
   "alias": "Com Site Property Concerns Issues",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SitePropertyConcernsIssues",
    "description": "Site Property Concerns and Issues",
    "codedValues": [
     {
      "name": "Dumpster Left Outside Enclosure",
      "code": "Dumpster Outside"
     },
     {
      "name": "Debris Left in Roadway",
      "code": "Debris in Roadway"
     },
     {
      "name": "Property Damage Structure",
      "code": "Property Damage Structure"
     },
     {
      "name": "Property Damage Enclosure",
      "code": "Property Damage Enclosure"
     },
     {
      "name": "Property Damage Mailbox",
      "code": "Property Damage Mailbox"
     },
     {
      "name": "Property Damage Landscape or Swale",
      "code": "Property Damage Landscape"
     },
     {
      "name": "Property Damge Vehicle",
      "code": "Property Damage Vehicle"
     },
     {
      "name": "Property Damage Oil",
      "code": "Property Damage Oil"
     },
     {
      "name": "Oil Spill",
      "code": "Oil Spill"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComSitePropertyConcernsIssuesRe",
   "type": "esriFieldTypeString",
   "alias": "Com Site Property Concerns Issues",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComDumpsterMissedCollection",
   "type": "esriFieldTypeString",
   "alias": "ComDumpsterIssues",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComDumpsterMissedCollectionCons",
   "type": "esriFieldTypeString",
   "alias": "Com Dumpster Missed Collection Construction and Demolition",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComDumpsterMissedCollectionHaza",
   "type": "esriFieldTypeString",
   "alias": "Com Dumpster Missed Collection Hazardous Materials",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComDumpsterMissedCollectionTooH",
   "type": "esriFieldTypeString",
   "alias": "Com Dumpster Missed Collection Too Heavy",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComSitePropertyConcernIssuesRes",
   "type": "esriFieldTypeDate",
   "alias": "Commercial Site Property Concern Issues Resolved Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ComSitePropertyConcernIssuesR_1",
   "type": "esriFieldTypeString",
   "alias": "Commercial Site Property Concern Issues Resolved Comment",
   "length": 50,
   "domain": null
  },
  {
   "name": "ComSitePropertyConcernIssuesR_2",
   "type": "esriFieldTypeDate",
   "alias": "Commercial Site Property Concern Issues Resolved Follow Up Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ComRollOffDumpsterConcernIssues",
   "type": "esriFieldTypeString",
   "alias": "Commercial Roll Off Dumpster",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComRollOffDumpsterConcernIssu_1",
   "type": "esriFieldTypeDate",
   "alias": "Commercial Roll Off DumpsterConcern Issues Resolved Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ComRollOffDumpsterConcernIssu_2",
   "type": "esriFieldTypeString",
   "alias": "Com Roll Off Dumpster Concern Issues Resolved Comments",
   "length": 50,
   "domain": null
  },
  {
   "name": "ComRollOffDumpsterConcernIssu_3",
   "type": "esriFieldTypeDate",
   "alias": "Commercial Roll Off Dumpster Concern Issues Resolved Follow Up Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ComEnclosureConcernIssuesYesNo",
   "type": "esriFieldTypeString",
   "alias": "Commercial Enclosure Concern Issues Yes or No",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComEnclosureConcernIssuesReso_1",
   "type": "esriFieldTypeDate",
   "alias": "Commercial Enclosure Concern Issues Resolved Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ComEnclosureConcernIssuesReso_2",
   "type": "esriFieldTypeString",
   "alias": "Commercial Enclosure Concern Issues Resolved Comments",
   "length": 50,
   "domain": null
  },
  {
   "name": "ComEnclosureConcernIssuesFollow",
   "type": "esriFieldTypeDate",
   "alias": "Commercial Enclosure Concern Issues Follow Up Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ComCollectionVehicleYesNo",
   "type": "esriFieldTypeString",
   "alias": "Commercial Collection Vehicle Yes No",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComCollectionVehicleResolvedDat",
   "type": "esriFieldTypeDate",
   "alias": "Commercial Collection Vehicle Resolved Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ComCollectionVehicleResolvedCom",
   "type": "esriFieldTypeString",
   "alias": "Commercial Collection Vehicle Resolved Comments",
   "length": 50,
   "domain": null
  },
  {
   "name": "ComCollectionVehicleFollowUpDat",
   "type": "esriFieldTypeDate",
   "alias": "Commercial Collection Vehicle Follow Up Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ComSitePropertyConcernsIssuesYe",
   "type": "esriFieldTypeString",
   "alias": "Commercial Site Property Concerns Issues Yes No",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes No Domain",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ComDumpsterIssuesResolvedDate",
   "type": "esriFieldTypeDate",
   "alias": "Commercial Dumpster Issues Resolved Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ComDumpsterIssuesResolvedCommen",
   "type": "esriFieldTypeString",
   "alias": "Commercial Dumpster Issues Resolved Comments",
   "length": 50,
   "domain": null
  },
  {
   "name": "ComDumpsterIssuesFollowUpDate",
   "type": "esriFieldTypeDate",
   "alias": "Commercial Dumpster Issues Follow Up Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "DUMPSTEROBJECTID",
   "type": "esriFieldTypeInteger",
   "alias": "DUMPSTEROBJECTID",
   "domain": null
  },
  {
   "name": "Inspector",
   "type": "esriFieldTypeString",
   "alias": "Inspector",
   "length": 50,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R361_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_309_DUMPSTER",
   "fields": "DUMPSTEROBJECTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "CommercialMultiFamilyDumpsterLoc",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "DUMPSTEROBJECTID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{A6505E20-D47E-47F4-A5C5-48880E21BC01}"
  }
 ],
 "capabilities": "Query,Map,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": "2d93ca35fe2f4f0b9a2ccb1a8230156e"
}