Name: Dumpster Inspection Table

Display Field: ComDumpsterIssues

Type: Table

Geometry Type: N/A

Description:

Service Item Id: e38fa64605804b45aea4b3f9bbbddc82

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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

Feature Draw Order:

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: 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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ComDumpsterIssues ( type: esriFieldTypeString, alias: Com Dumpster Issues, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ComDumpsterIssues , Coded Values: [Overage: Overage] , [Incorrect Placement: Incorrect Placement] , [Fire Damge: Fire Damage] , ...6 more... )
• ComDumsterIssuesResolved ( type: esriFieldTypeString, alias: Com Dumster Issues Resolved, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComDumsterIssuesResolved , Coded Values: [No: No] , [Yes: Yes] )
• ComRollOffDumsterConcernIssues ( type: esriFieldTypeString, alias: Com Roll Off Dumster Concern Issues, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ComRollOffDumsterConcernIssues , Coded Values: [Incorrect Placement: Incorrect Placement] , [Gate Unable to Open: Gate Unable to Open or Close] , [Graffiti Paint: Graffiti Paint] , ...4 more... )
• ComRollOffDumsterConcernIssuesR ( type: esriFieldTypeString, alias: Com Roll Off Dumster Concern Issues Resolved, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComRollOffDumsterConcernIssuesResolved , Coded Values: [No: No] , [Yes: Yes] )
• ComEnclosureConcernIssues ( type: esriFieldTypeString, alias: Com Enclosure Concern Issues, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ComEnclosureConcernIssues , Coded Values: [Debris: Debris Left on Ground] , [Gate Door Damage: Gate or Door Damage or Missing] , [Bulk Items: Bulk Items Inside or Outside] , ...1 more... )
• ComEnclosureConcernIssuesResolv ( type: esriFieldTypeString, alias: Com Enclosure Concern Issues Resolved, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComEnclosureConcernIssuesResolved , Coded Values: [No: No] , [Yes: Yes] )
• ComCollectionVehicle ( type: esriFieldTypeString, alias: Com Collection Vehicle, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ComCollectionVehicle , Coded Values: [No Tarp: No Tarp in Use] , [Vehicle Requires Washing: Vehicle Requires Washing] , [Decal Faded: Decal Faded or Missing] , ...4 more... )
• ComCollectionVehicleResolved ( type: esriFieldTypeString, alias: Com Collection Vehicle Resolved, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComCollectionVehicleResolved , Coded Values: [No: No] , [Yes: Yes] )
• ComSitePropertyConcernsIssues ( type: esriFieldTypeString, alias: Com Site Property Concerns Issues, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ComSitePropertyConcernsIssues , Coded Values: [Dumpster Outside: Dumpster Left Outside Enclosure] , [Debris in Roadway: Debris Left in Roadway] , [Property Damage Structure: Property Damage Structure] , ...6 more... )
• ComSitePropertyConcernsIssuesRe ( type: esriFieldTypeString, alias: Com Site Property Concerns Issues, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComSitePropertyConcernsIssuesResolved , Coded Values: [No: No] , [Yes: Yes] )
• ComDumpsterMissedCollection ( type: esriFieldTypeString, alias: ComDumpsterIssues, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComDumpsterMissedCollection , Coded Values: [No: No] , [Yes: Yes] )
• ComDumpsterMissedCollectionCons ( type: esriFieldTypeString, alias: Com Dumpster Missed Collection Construction and Demolition, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComDumpsterMissedCollectionConstructionandDemolition , Coded Values: [No: No] , [Yes: Yes] )
• ComDumpsterMissedCollectionHaza ( type: esriFieldTypeString, alias: Com Dumpster Missed Collection Hazardous Materials, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComDumpsterMissedCollectionHazardousMaterials , Coded Values: [No: No] , [Yes: Yes] )
• ComDumpsterMissedCollectionTooH ( type: esriFieldTypeString, alias: Com Dumpster Missed Collection Too Heavy, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComDumpsterMissedCollectionTooHeavy , Coded Values: [No: No] , [Yes: Yes] )
• ComSitePropertyConcernIssuesRes ( type: esriFieldTypeDate, alias: Commercial Site Property Concern Issues Resolved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ComSitePropertyConcernIssuesResolvedDate )
• ComSitePropertyConcernIssuesR_1 ( type: esriFieldTypeString, alias: Commercial Site Property Concern Issues Resolved Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ComSitePropertyConcernIssuesResolvedComment )
• ComSitePropertyConcernIssuesR_2 ( type: esriFieldTypeDate, alias: Commercial Site Property Concern Issues Resolved Follow Up Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ComSitePropertyConcernIssuesResolvedFollowUpDate )
• ComRollOffDumpsterConcernIssues ( type: esriFieldTypeString, alias: Commercial Roll Off Dumpster, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComRollOffDumpsterConcernIssues , Coded Values: [No: No] , [Yes: Yes] )
• ComRollOffDumpsterConcernIssu_1 ( type: esriFieldTypeDate, alias: Commercial Roll Off DumpsterConcern Issues Resolved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ComRollOffDumpsterConcernIssu_1 )
• ComRollOffDumpsterConcernIssu_2 ( type: esriFieldTypeString, alias: Com Roll Off Dumpster Concern Issues Resolved Comments, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ComRollOffDumpsterConcernIssu_2 )
• ComRollOffDumpsterConcernIssu_3 ( type: esriFieldTypeDate, alias: Commercial Roll Off Dumpster Concern Issues Resolved Follow Up Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ComRollOffDumpsterConcernIssu_3 )
• ComEnclosureConcernIssuesYesNo ( type: esriFieldTypeString, alias: Commercial Enclosure Concern Issues Yes or No, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComEnclosureConcernIssuesYesNo , Coded Values: [No: No] , [Yes: Yes] )
• ComEnclosureConcernIssuesReso_1 ( type: esriFieldTypeDate, alias: Commercial Enclosure Concern Issues Resolved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ComEnclosureConcernIssuesReso_1 )
• ComEnclosureConcernIssuesReso_2 ( type: esriFieldTypeString, alias: Commercial Enclosure Concern Issues Resolved Comments, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ComEnclosureConcernIssuesReso_2 )
• ComEnclosureConcernIssuesFollow ( type: esriFieldTypeDate, alias: Commercial Enclosure Concern Issues Follow Up Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ComEnclosureConcernIssuesFollow )
• ComCollectionVehicleYesNo ( type: esriFieldTypeString, alias: Commercial Collection Vehicle Yes No, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComCollectionVehicleYesNo , Coded Values: [No: No] , [Yes: Yes] )
• ComCollectionVehicleResolvedDat ( type: esriFieldTypeDate, alias: Commercial Collection Vehicle Resolved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ComCollectionVehicleResolvedDat )
• ComCollectionVehicleResolvedCom ( type: esriFieldTypeString, alias: Commercial Collection Vehicle Resolved Comments, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ComCollectionVehicleResolvedCom )
• ComCollectionVehicleFollowUpDat ( type: esriFieldTypeDate, alias: Commercial Collection Vehicle Follow Up Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ComCollectionVehicleFollowUpDat )
• ComSitePropertyConcernsIssuesYe ( type: esriFieldTypeString, alias: Commercial Site Property Concerns Issues Yes No, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ComSitePropertyConcernsIssuesYe , Coded Values: [No: No] , [Yes: Yes] )
• ComDumpsterIssuesResolvedDate ( type: esriFieldTypeDate, alias: Commercial Dumpster Issues Resolved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ComDumpsterIssuesResolvedDate )
• ComDumpsterIssuesResolvedCommen ( type: esriFieldTypeString, alias: Commercial Dumpster Issues Resolved Comments, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ComDumpsterIssuesResolvedCommen )
• ComDumpsterIssuesFollowUpDate ( type: esriFieldTypeDate, alias: Commercial Dumpster Issues Follow Up Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ComDumpsterIssuesFollowUpDate )
• DUMPSTEROBJECTID ( type: esriFieldTypeInteger, alias: DUMPSTEROBJECTID, editable: true, nullable: true, defaultValue: null, modelName: DUMPSTEROBJECTID )
• Inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector )

Templates:

• Name: Dumpster Inspection Table
  Description:
  Prototype:
  DUMPSTEROBJECTID: null
  Inspector: null
  ComDumpsterIssues: null
  ComDumsterIssuesResolved: null
  ComRollOffDumsterConcernIssues: null
  ComRollOffDumsterConcernIssuesR: null
  ComEnclosureConcernIssues: null
  ComEnclosureConcernIssuesResolv: null
  ComCollectionVehicle: null
  ComCollectionVehicleResolved: null
  ComSitePropertyConcernsIssues: null
  ComSitePropertyConcernsIssuesRe: null
  ComDumpsterMissedCollection: null
  ComDumpsterMissedCollectionCons: null
  ComDumpsterMissedCollectionHaza: null
  ComDumpsterMissedCollectionTooH: null
  ComSitePropertyConcernIssuesRes: null
  ComSitePropertyConcernIssuesR_1: null
  ComSitePropertyConcernIssuesR_2: null
  ComRollOffDumpsterConcernIssues: null
  ComRollOffDumpsterConcernIssu_1: null
  ComRollOffDumpsterConcernIssu_2: null
  ComRollOffDumpsterConcernIssu_3: null
  ComEnclosureConcernIssuesYesNo: null
  ComEnclosureConcernIssuesReso_1: null
  ComEnclosureConcernIssuesReso_2: null
  ComEnclosureConcernIssuesFollow: null
  ComCollectionVehicleYesNo: null
  ComCollectionVehicleResolvedDat: null
  ComCollectionVehicleResolvedCom: null
  ComCollectionVehicleFollowUpDat: null
  ComSitePropertyConcernsIssuesYe: null
  ComDumpsterIssuesResolvedDate: null
  ComDumpsterIssuesResolvedCommen: null
  ComDumpsterIssuesFollowUpDate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• CommercialMultiFamilyDumpsterLoc (0) -- Related To: Commercial Multi-Family Dumpster Locations (1)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

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