Name: Refuse_Large_Item_Pickup_Request

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Refuse Large Item Pickup Request","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• trashnight (type: esriFieldTypeString, alias: Your trash pickup night, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [4: Sunday], [5: Monday], [6: Tuesday], ... 2 more ...)
• todaysdate (type: esriFieldTypeDate, alias: request date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• possible_date (type: esriFieldTypeDate, alias: next possible pickup date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• possible_date_format (type: esriFieldTypeString, alias: possible_date_format, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pickup_date (type: esriFieldTypeDate, alias: scheduled Pickup Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pickup_date_format (type: esriFieldTypeString, alias: pickup_date_format, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pickup_year (type: esriFieldTypeString, alias: pickup_year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• pickup_confnum (type: esriFieldTypeString, alias: pickup_confnum, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• requesttype (type: esriFieldTypeString, alias: Request Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [website: website], [phone: phone])
• orderid (type: esriFieldTypeString, alias: orderid, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ordertype (type: esriFieldTypeString, alias: ordertype, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• driverserial (type: esriFieldTypeString, alias: driverserial, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• driver (type: esriFieldTypeString, alias: driver, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• location (type: esriFieldTypeString, alias: location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• routedate (type: esriFieldTypeString, alias: routedate, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email_text (type: esriFieldTypeString, alias: Note to include with approve or deny email to citizen, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• postpickup_text (type: esriFieldTypeString, alias: Note to record information captured by refuse staff post-pickup, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• internal_note (type: esriFieldTypeString, alias: Internal Note, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• email_sent (type: esriFieldTypeString, alias: Email Sent, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [yes: yes], [no: no], [phone: phone], ... 1 more ...)
• update_email_check (type: esriFieldTypeString, alias: Update Email Check, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [no: no], [yes: yes])

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/21/2026 6:40:15 PM

Schema Last Edit Date: 9/21/2026 6:40:15 PM

Data Last Edit Date: 9/21/2026 6:40:15 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat