Name: TBL_MS4_AAH_Pickups_H

Display Field: ROUTENAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 2cd5a0d5538043db94ecc4752ab60ae4

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PERMITNO ( type: esriFieldTypeString, alias: PERMITNO, length: 255 )
• ROUTE_NUMBER ( type: esriFieldTypeString, alias: ROUTE_NUMBER, length: 255 )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, length: 255 )
• PICKUPDATE ( type: esriFieldTypeDate, alias: PICKUPDATE, length: 8 )
• NO_OF_HRS ( type: esriFieldTypeDouble, alias: NO_OF_HRS )
• COMMENTS__ ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• HAZ_MAT ( type: esriFieldTypeString, alias: HAZ_MAT, length: 255 )
• ANIMAL ( type: esriFieldTypeString, alias: ANIMAL, length: 255 )
• TRASH_TYPE ( type: esriFieldTypeString, alias: TRASH_TYPE, length: 255 , Coded Values: [Beer and soft drink cans: Beer and soft drink cans] , [Plastic/Styrofoam/fast food containers: Plastic/Styrofoam/fast food containers] , [Glass containers: Glass containers] , ...5 more... )
• TRASH_CODE ( type: esriFieldTypeDouble, alias: TRASH_CODE )
• PICKUP_IDKEY ( type: esriFieldTypeDouble, alias: PICKUP_idkey )
• ROUTE_IDKEY ( type: esriFieldTypeDouble, alias: ROUTE_idkey )
• PERMIT_UNIQUE_ ( type: esriFieldTypeString, alias: Permit Number Unique ID, length: 255 )
• ADOPTIONSEGMENT ( type: esriFieldTypeString, alias: Adoption Segment, length: 255 )
• APPLICANTID ( type: esriFieldTypeString, alias: ApplicantID, length: 255 )
• RESIDENCY_ ( type: esriFieldTypeString, alias: Residency, length: 255 , Coded Values: [Abingdon: Abingdon] , [Accomac: Accomac] , [Appomattox: Appomattox] , ...30 more... )
• ROUTENAME ( type: esriFieldTypeString, alias: Route Name, length: 255 )
• GROUPNAME_ ( type: esriFieldTypeString, alias: Group Name, length: 255 )
• PRIMARYCONTACTNAME ( type: esriFieldTypeString, alias: Primary Contact name, length: 255 )
• EMAIL ( type: esriFieldTypeString, alias: Email Address, length: 255 )
• PHONENUMBER ( type: esriFieldTypeString, alias: Phone Number, length: 255 )
• DATEPLANNED ( type: esriFieldTypeDate, alias: Date of Planned Pickup, length: 8 )
• COMMENTS_ ( type: esriFieldTypeString, alias: Comments or other Equipment Needed, length: 255 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• NUMBPERS ( type: esriFieldTypeInteger, alias: Number of Persons )
• NUMBERBAGS ( type: esriFieldTypeInteger, alias: Number of Bags Pickedup )
• NOVOLUNTEERS ( type: esriFieldTypeInteger, alias: Number of Volunteers Expected )
• NUMBERVESTS ( type: esriFieldTypeInteger, alias: Number of Vests Needed )
• NUMBERBAGSNEEDED ( type: esriFieldTypeInteger, alias: Number of Bags Needed )
• JURISDICTION ( type: esriFieldTypeString, alias: Jurisdiction, length: 255 )
• CREATIONDATE ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• CREATOR ( type: esriFieldTypeString, alias: Creator, length: 255 )
• EDITDATE ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• EDITOR ( type: esriFieldTypeString, alias: Editor, length: 255 )
• MILESCLEANED ( type: esriFieldTypeDouble, alias: Miles Cleaned )
• BAGSREMOVED ( type: esriFieldTypeString, alias: Bags Removed, length: 5 )
• SOURCEID ( type: esriFieldTypeString, alias: SOURCEID, length: 25 )
• IMPORTED ( type: esriFieldTypeString, alias: IMPORTED, length: 50 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata