Name: litterPickupRequest

Display Field: GROUP_NAME

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• FK_GROUP_ID (type: esriFieldTypeString, alias: Group ID (FK), SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• FK_GROUP_REL_GLOBALID (type: esriFieldTypeGUID, alias: Group Universally Unique ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• FK_OOM_HWY_PROGRAMS_ID (type: esriFieldTypeString, alias: OMOC Unique ID, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• GROUP_NAME (type: esriFieldTypeString, alias: Group Name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• GROUP_PHONE (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CLEANUP_DATE (type: esriFieldTypeDate, alias: Road Clean-up Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NUMBER_OF_PEOPLE (type: esriFieldTypeSmallInteger, alias: Number of Participants, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TIME_ON_SITE (type: esriFieldTypeSmallInteger, alias: Time On Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BAGS_COLLECTED (type: esriFieldTypeSmallInteger, alias: Number of Bags Collected, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BAGS_LOCATION (type: esriFieldTypeString, alias: Bags Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• HAZ_PICKUP (type: esriFieldTypeString, alias: Hazardous Materials Present, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• HAZ_PICKUP_COMMENT (type: esriFieldTypeString, alias: Hazardous or Heavy Materials Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• NEED_SUPPLIES (type: esriFieldTypeString, alias: Needs Supplies, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SUPPLIES_NEEDED (type: esriFieldTypeString, alias: Supplies Needed, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• SIGN_REPAIR (type: esriFieldTypeString, alias: Sign Repair Needed, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SIGN_ISSUE_DESC (type: esriFieldTypeString, alias: Sign Issue Description, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CLEANUP_COMMENT (type: esriFieldTypeString, alias: Cleanup Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• MAINT_SHOP (type: esriFieldTypeSmallInteger, alias: SHA Maintenance Shop, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [8334: Marlboro], [8225: Elkton], [8770: Dayton], ... 26 more ...)
• M_SHOP_TXT (type: esriFieldTypeString, alias: Maintenance Shop (label), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SHOP_EMAIL (type: esriFieldTypeString, alias: Shop Reviewer Email, SQL Type: sqlTypeOther, length: 320, nullable: true, editable: true)
• SHOP_COORDINATOR (type: esriFieldTypeString, alias: Shop AAH Coordinator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FOR_PUBLISH (type: esriFieldTypeString, alias: For Publishing by OC, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PARTICIPANTS_UNDER_18 (type: esriFieldTypeString, alias: Participants Under 18, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SOCIAL_MEDIA_URL (type: esriFieldTypeString, alias: Social Media URL, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• NARRATIVE (type: esriFieldTypeString, alias: Narrative for OC, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• MEDIA_ATTACHED (type: esriFieldTypeString, alias: Photos Videos Attached, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• FRIENDLY_ROUTE_ID (type: esriFieldTypeString, alias: Route, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ROAD_NAME (type: esriFieldTypeString, alias: Road Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LAST_AUTO_EDIT_BY (type: esriFieldTypeString, alias: Last Automated Editor, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LAST_AUTO_EDIT_DATE (type: esriFieldTypeDate, alias: Last Automated Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FORM_VERSION (type: esriFieldTypeString, alias: Form Version, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• APP_VERSION (type: esriFieldTypeString, alias: App Version, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• REL_GROUP_LEADER (type: esriFieldTypeString, alias: REL_GROUP_LEADER, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• REL_GROUP_EMAIL (type: esriFieldTypeString, alias: REL_GROUP_EMAIL, SQL Type: sqlTypeOther, length: 320, nullable: true, editable: true)

Templates:

Name: litterPickupRequest
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• adoptAHighwayGroup (1) -- Related To: adoptAHighwayGroup (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/23/2026 6:03:40 PM

Schema Last Edit Date: 1/14/2026 2:02:42 PM

Data Last Edit Date: 2/23/2026 6:03:40 PM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat