Name: TBL_MS4_AAH_Pickups_H

Display Field: ROUTENAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 75d55a71d1d844a386007b9cefb4fc33

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: TBL_MS4_AAH_Pickups_H
  Description:
  Prototype:
  SOURCEID: null
  BAGSREMOVED: null
  PERMITNO: null
  ROUTE_NUMBER: null
  COUNTY: null
  PICKUPDATE: null
  NO_OF_HRS: null
  COMMENTS__: null
  HAZ_MAT: null
  ANIMAL: null
  TRASH_TYPE: null
  TRASH_CODE: null
  PICKUP_IDKEY: null
  ROUTE_IDKEY: null
  PERMIT_UNIQUE_: null
  ADOPTIONSEGMENT: null
  APPLICANTID: null
  RESIDENCY_: null
  ROUTENAME: null
  GROUPNAME_: null
  PRIMARYCONTACTNAME: null
  EMAIL: null
  PHONENUMBER: null
  DATEPLANNED: null
  COMMENTS_: null
  IMPORTED: null
  GUID: null
  NUMBPERS: null
  NUMBERBAGS: null
  NOVOLUNTEERS: null
  NUMBERVESTS: null
  NUMBERBAGSNEEDED: null
  JURISDICTION: null
  MILESCLEANED: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: CREATIONDATE
• Creator Field: CREATOR
• Edit Date Field: EDITDATE
• Editor Field: EDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata