Name: TrashCaptureDeviceInspection

Display Field: InspectionID

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• InspectionID (type: esriFieldTypeString, alias: Inspection ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FacilityID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Condition (type: esriFieldTypeString, alias: Device General Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Good: Good], [Poor: Poor], ... 1 more ...)
• Capacity (type: esriFieldTypeString, alias: Current Capacity Used, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Over Capacity: Over Capacity], [Unknown: Unknown], [Less Than 50%: Less Than 50%], ... 3 more ...)
• MaintenanceRequired (type: esriFieldTypeString, alias: Device Maintenance Required, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [No: No], [Clean: Clean], [Repair: Repair], ... 3 more ...)
• DeviceFlowStatus (type: esriFieldTypeString, alias: Device Flow Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [No Issues: No Issues], [Clogged: Clogged], [Damaged: Damaged], ... 2 more ...)
• DeviceBlockage (type: esriFieldTypeString, alias: Device Blockage, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: None], [Primarily Organic Matter: Primarily Organic Matter], [Primarily Trash: Primarily Trash], ... 5 more ...)
• StormInletMaintenanceRequired (type: esriFieldTypeString, alias: Storm Inlet Maintenance Required, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• StormInletCurbMarkerNeeded (type: esriFieldTypeString, alias: Storm Inlet Curb Marker Needed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InspectStatus (type: esriFieldTypeString, alias: Inspect Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Unassigned: Unassigned], [Assigned: Assigned], [In Progress: In Progress], ... 1 more ...)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• REL_GLOBALID (type: esriFieldTypeGUID, alias: REL_GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• BypassOverflowEvidence (type: esriFieldTypeString, alias: Shows Signs of Bypass Overflow, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• ARSWorking (type: esriFieldTypeString, alias: ARS Working, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• ARSDamaged (type: esriFieldTypeString, alias: ARS Damaged, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• ARSMissing (type: esriFieldTypeString, alias: ARS Missing, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])

Templates:

Name: TrashCaptureDeviceInspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• TrashCaptureDevice (1) -- Related To: Trash Capture Device (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/7/2016 7:30:01 PM

Schema Last Edit Date: 12/7/2016 7:30:01 PM

Data Last Edit Date: 12/7/2016 7:30:01 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat