ArcGIS REST Services Directory
Home
>
services
>
SHA_AAH_Program_Data_Prod_S123_Submit (FeatureServer)
>
All Layers and Tables
|
API Reference
JSON
All Layers and Tables (SHA_AAH_Program_Data_Prod_S123_Submit)
Layers:
Tables:
adoptAHighwayGroup
(2)
Name:
adoptAHighwayGroup
Display Field:
GROUP_NAME
Type:
Table
Is View:
true
Is Updatable View:
true
Source Schema Changes Allowed:
true
Description:
Copyright Text:
Max Record Count:
2000
Supported query Formats:
JSON, geoJSON, PBF
Use Standardized Queries:
True
HasZ:
false
HasM:
false
Has Attachments:
false
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)
PK_GROUP_ID
(type: esriFieldTypeString, alias: Group ID (PK), SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
FK_OOM_HWY_PROGRAMS_ID
(type: esriFieldTypeString, alias: OMOC Unique ID, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
FK_SEGMENT_REL_GLOBALID
(type: esriFieldTypeGUID, alias: Related Segment Global ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
FK_RETURN_ID
(type: esriFieldTypeString, alias: Returning Group ID, SQL Type: sqlTypeOther, length: 301, nullable: true, editable: true)
GROUP_NAME
(type: esriFieldTypeString, alias: Group Name, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
GROUP_MAILING_ADDRESS
(type: esriFieldTypeString, alias: Street Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
GROUP_CITY
(type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
GROUP_STATE
(type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
GROUP_ZIP_CODE
(type: esriFieldTypeString, alias: ZIP Code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
GROUP_LEADER
(type: esriFieldTypeString, alias: Primary Contact Person, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
GROUP_EMAIL
(type: esriFieldTypeString, alias: E-Mail Address, SQL Type: sqlTypeOther, length: 320, nullable: true, editable: true)
GROUP_PHONE
(type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
PREVIOUS_FULL_ADDRESS
(type: esriFieldTypeString, alias: Previous Full Address, SQL Type: sqlTypeOther, length: 170, nullable: true, editable: true)
ORIGINAL_ADOPT_DATE
(type: esriFieldTypeDate, alias: Original Adoption Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ADOPT_START_DATE
(type: esriFieldTypeDate, alias: Current Adoption Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ADOPT_END_DATE
(type: esriFieldTypeDate, alias: Current Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LAST_RENEWAL_DATE
(type: esriFieldTypeDate, alias: Last Renewal Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PREVIOUS_EXPIRATION_DATE
(type: esriFieldTypeDate, alias: Previous Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
GROUP_STATUS
(type: esriFieldTypeString, alias: Group Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Active: Active], [Inactive: Inactive], [Pending: Pending], ... 1 more ...)
DISCLAIMER_CHECKED
(type: esriFieldTypeString, alias: Disclaimer Checked, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
M_SHOP_TXT
(type: esriFieldTypeString, alias: Maintenance Shop (label), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
MAINT_SHOP
(type: esriFieldTypeSmallInteger, alias: Maintenance Shop, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [8334: Marlboro], [8225: Elkton], [8770: Dayton], ... 26 more ...)
SHOP_RME
(type: esriFieldTypeString, alias: Resident Maintenance Engineer, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
SHOP_COORDINATOR
(type: esriFieldTypeString, alias: Shop AAH Coordinator, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
SHOP_EMAIL
(type: esriFieldTypeString, alias: Shop Reviewer Email, SQL Type: sqlTypeOther, length: 320, nullable: true, editable: true)
SHOP_REVIEWER
(type: esriFieldTypeString, alias: Maint. Shop Reviewer, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
SHOP_APPROVAL
(type: esriFieldTypeString, alias: Maint. Shop Approval, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
SHOP_REVIEW_DATE
(type: esriFieldTypeDate, alias: Maint. Shop Review Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SHOP_REVIEW_COMMENT
(type: esriFieldTypeString, alias: Maint. Shop Comments, SQL Type: sqlTypeOther, length: 1001, nullable: true, editable: true)
CANCEL_MODE
(type: esriFieldTypeString, alias: Cancellation Mode, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [group_leader: Group Leader], [shop: Shop], [oom: OOM], ... 1 more ...)
CANCEL_REASON
(type: esriFieldTypeString, alias: Cancellation Reason, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [self_cancel: Group Leader Self-Cancels], [group_disbanded: Group Disbanded], [road_character: Road Characteristics Changed], ... 5 more ...)
CANCEL_COMMENT
(type: esriFieldTypeString, alias: Cancellation Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
CANCEL_DATE
(type: esriFieldTypeDate, alias: Cancellation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CANCEL_USER
(type: esriFieldTypeString, alias: Cancellation User, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ROAD_NAME
(type: esriFieldTypeString, alias: Road Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
FRIENDLY_ROUTE_ID
(type: esriFieldTypeString, alias: Friendly Route ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
FROM_MEASURE
(type: esriFieldTypeDouble, alias: From Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
TO_MEASURE
(type: esriFieldTypeDouble, alias: To Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
FORM_VERSION
(type: esriFieldTypeString, alias: Survey123 Form Version, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
APP_VERSION
(type: esriFieldTypeString, alias: Survey123 App Version, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
LAST_AUTO_EDIT_DATE
(type: esriFieldTypeDate, alias: Last Automated Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LAST_AUTO_EDIT_BY
(type: esriFieldTypeString, alias: Last Automated Editor, SQL Type: sqlTypeOther, length: 100, 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)
GROUP_NAME_LINE1
(type: esriFieldTypeString, alias: Group Name Line 1, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
GROUP_NAME_LINE2
(type: esriFieldTypeString, alias: Group Name Line 2, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
Templates:
Name: adoptAHighwayGroup
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
Relationships:
litterPickupRequest (1) --
Related To
:
litterPickupRequest
(3)
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
2/19/2026 8:42:48 PM
Schema Last Edit Date:
2/3/2026 3:53:56 PM
Data Last Edit Date:
2/19/2026 8:42:51 PM
litterPickupRequest
(3)
Name:
litterPickupRequest
Display Field:
GROUP_NAME
Type:
Table
Is View:
true
Is Updatable View:
true
Source Schema Changes Allowed:
true
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/19/2026 8:42:48 PM
Schema Last Edit Date:
1/14/2026 2:02:42 PM
Data Last Edit Date:
2/19/2026 8:42:51 PM