Name: Dumpster Inspection Table

Display Field: ComDumpsterIssues

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 2d93ca35fe2f4f0b9a2ccb1a8230156e

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: 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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ComDumpsterIssues ( type: esriFieldTypeString, alias: Com Dumpster Issues, length: 50 , Coded Values: [Overage: Overage] , [Incorrect Placement: Incorrect Placement] , [Fire Damge: Fire Damage] , ...6 more... )
• ComDumsterIssuesResolved ( type: esriFieldTypeString, alias: Com Dumster Issues Resolved, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComRollOffDumsterConcernIssues ( type: esriFieldTypeString, alias: Com Roll Off Dumster Concern Issues, length: 50 , 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, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComEnclosureConcernIssues ( type: esriFieldTypeString, alias: Com Enclosure Concern Issues, length: 50 , 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, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComCollectionVehicle ( type: esriFieldTypeString, alias: Com Collection Vehicle, length: 50 , 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, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComSitePropertyConcernsIssues ( type: esriFieldTypeString, alias: Com Site Property Concerns Issues, length: 50 , 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, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComDumpsterMissedCollection ( type: esriFieldTypeString, alias: ComDumpsterIssues, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComDumpsterMissedCollectionCons ( type: esriFieldTypeString, alias: Com Dumpster Missed Collection Construction and Demolition, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComDumpsterMissedCollectionHaza ( type: esriFieldTypeString, alias: Com Dumpster Missed Collection Hazardous Materials, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComDumpsterMissedCollectionTooH ( type: esriFieldTypeString, alias: Com Dumpster Missed Collection Too Heavy, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComSitePropertyConcernIssuesRes ( type: esriFieldTypeDate, alias: Commercial Site Property Concern Issues Resolved Date, length: 8 )
• ComSitePropertyConcernIssuesR_1 ( type: esriFieldTypeString, alias: Commercial Site Property Concern Issues Resolved Comment, length: 50 )
• ComSitePropertyConcernIssuesR_2 ( type: esriFieldTypeDate, alias: Commercial Site Property Concern Issues Resolved Follow Up Date, length: 8 )
• ComRollOffDumpsterConcernIssues ( type: esriFieldTypeString, alias: Commercial Roll Off Dumpster, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComRollOffDumpsterConcernIssu_1 ( type: esriFieldTypeDate, alias: Commercial Roll Off DumpsterConcern Issues Resolved Date, length: 8 )
• ComRollOffDumpsterConcernIssu_2 ( type: esriFieldTypeString, alias: Com Roll Off Dumpster Concern Issues Resolved Comments, length: 50 )
• ComRollOffDumpsterConcernIssu_3 ( type: esriFieldTypeDate, alias: Commercial Roll Off Dumpster Concern Issues Resolved Follow Up Date, length: 8 )
• ComEnclosureConcernIssuesYesNo ( type: esriFieldTypeString, alias: Commercial Enclosure Concern Issues Yes or No, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComEnclosureConcernIssuesReso_1 ( type: esriFieldTypeDate, alias: Commercial Enclosure Concern Issues Resolved Date, length: 8 )
• ComEnclosureConcernIssuesReso_2 ( type: esriFieldTypeString, alias: Commercial Enclosure Concern Issues Resolved Comments, length: 50 )
• ComEnclosureConcernIssuesFollow ( type: esriFieldTypeDate, alias: Commercial Enclosure Concern Issues Follow Up Date, length: 8 )
• ComCollectionVehicleYesNo ( type: esriFieldTypeString, alias: Commercial Collection Vehicle Yes No, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComCollectionVehicleResolvedDat ( type: esriFieldTypeDate, alias: Commercial Collection Vehicle Resolved Date, length: 8 )
• ComCollectionVehicleResolvedCom ( type: esriFieldTypeString, alias: Commercial Collection Vehicle Resolved Comments, length: 50 )
• ComCollectionVehicleFollowUpDat ( type: esriFieldTypeDate, alias: Commercial Collection Vehicle Follow Up Date, length: 8 )
• ComSitePropertyConcernsIssuesYe ( type: esriFieldTypeString, alias: Commercial Site Property Concerns Issues Yes No, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• ComDumpsterIssuesResolvedDate ( type: esriFieldTypeDate, alias: Commercial Dumpster Issues Resolved Date, length: 8 )
• ComDumpsterIssuesResolvedCommen ( type: esriFieldTypeString, alias: Commercial Dumpster Issues Resolved Comments, length: 50 )
• ComDumpsterIssuesFollowUpDate ( type: esriFieldTypeDate, alias: Commercial Dumpster Issues Follow Up Date, length: 8 )
• DUMPSTEROBJECTID ( type: esriFieldTypeInteger, alias: DUMPSTEROBJECTID )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata