Name: Tipper Cart Requests

Display Field: FirstName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: ef6c7dcdfae549bfbe79a4eead25b169

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 5646459.88631247
YMin: 3627215.5319998115
XMax: 5690240.520535797
YMax: 3678336.230283141
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• RequestDate ( type: esriFieldTypeDate, alias: Date of Request, length: 8 )
• Address ( type: esriFieldTypeString, alias: Address, length: 200 )
• AlternateAddress ( type: esriFieldTypeString, alias: Alternate Address, length: 200 )
• RequestedStartDate ( type: esriFieldTypeDate, alias: Requested Start Date, length: 8 )
• UBAccountNumber ( type: esriFieldTypeString, alias: Utility Billing Account Number, length: 15 )
• FirstName ( type: esriFieldTypeString, alias: First Name, length: 50 )
• LastName ( type: esriFieldTypeString, alias: Last Name, length: 50 )
• PhoneNumber ( type: esriFieldTypeString, alias: Phone Number, length: 50 )
• Email ( type: esriFieldTypeString, alias: Email Address, length: 50 )
• TrashServiceRequest ( type: esriFieldTypeString, alias: Trash Service Request?, length: 5 , Coded Values: [N: No] , [Y: Yes] )
• RecyclingServiceRequest ( type: esriFieldTypeString, alias: Recycling Service Request?, length: 5 , Coded Values: [N: No] , [Y: Yes] )
• OrganicsServiceRequest ( type: esriFieldTypeString, alias: Organics Service Request?, length: 5 , Coded Values: [N: No] , [Y: Yes] )
• CurrentTrashService ( type: esriFieldTypeString, alias: Current Trash Service, length: 50 , Coded Values: [New: New Customer] , [Basic: Basic/Non-Cart Service] , [35: 35-Gallon Cart] , ...4 more... )
• RequestedTrashService ( type: esriFieldTypeString, alias: Requested Trash Service, length: 50 , Coded Values: [Stop: Stop Current Service] , [35: 35-Gallon Cart] , [48: 48-Gallon Cart] , ...3 more... )
• NumberTrashCarts ( type: esriFieldTypeDouble, alias: # of Trash Carts to be Delivered )
• CurrentRecyclingService ( type: esriFieldTypeString, alias: Current Recycling Service, length: 50 , Coded Values: [New: New Customer] , [18: 18-Gallon Yellow Bin(s)] , [96: 96-Gallon Cart (Blue)] )
• RequestedRecyclingService ( type: esriFieldTypeString, alias: Requested Recycling Service, length: 50 , Coded Values: [Stop: Stop Service] , [18: 18-Gallon (Yellow) Bin(s)] , [96: 96-Gallon (Blue) Cart] , ...2 more... )
• NumberYellowBins ( type: esriFieldTypeDouble, alias: Number of Bins or Lids )
• NumberRecyclingCarts ( type: esriFieldTypeDouble, alias: Number of Recycling Carts )
• CurrentOrganicsService ( type: esriFieldTypeString, alias: Current Organics Service, length: 50 , Coded Values: [New: New Customer] , [13: 13-Gallon Cart] , [64: 64-Gallon Cart] )
• RequestedOrganicsService ( type: esriFieldTypeString, alias: Requested Organics Service, length: 50 , Coded Values: [Stop13: Stop Current Service - 13-Gallon] , [Stop64: Stop Current Service - 64-Gallon] , [Transfer: Transfer Cart(s) to New Address] , ...2 more... )
• NumberCarts13Gallon ( type: esriFieldTypeDouble, alias: Number of 13-gallon carts )
• NumberCarts64Gallon ( type: esriFieldTypeDouble, alias: Number of 64-gallon carts )
• AdditionalComments ( type: esriFieldTypeString, alias: Additional Comments, length: 1000 )
• PIN ( type: esriFieldTypeString, alias: PIN, length: 10 )
• CollectionDay ( type: esriFieldTypeString, alias: Collection Day, length: 10 , Coded Values: [Monday: Monday] , [Tuesday: Tuesday] , [Wednesday: Wednesday] , ...2 more... )
• DeliveryDirections ( type: esriFieldTypeString, alias: Delivery Directions, length: 1000 )
• DeliveryNotes ( type: esriFieldTypeString, alias: Delivery Notes (from Driver), length: 1000 )
• DispatchedBy ( type: esriFieldTypeString, alias: Dispatched By, length: 50 , Coded Values: [Theisen: Teresa Theisen] , [McLaughlin: Julie McLaughlin] , [Swift: Arielle Swift] , ...3 more... )
• Priority ( type: esriFieldTypeString, alias: Priority, length: 10 )
• TrashRequestStatus ( type: esriFieldTypeString, alias: Trash Request Status, length: 15 , Coded Values: [New: New] , [Received: Received] , [On Hold: On Hold] , ...8 more... )
• RecyclingRequestStatus ( type: esriFieldTypeString, alias: Recycling Request Status, length: 15 , Coded Values: [New: New] , [Received: Received] , [On Hold: On Hold] , ...8 more... )
• OrganicsRequestStatus ( type: esriFieldTypeString, alias: Organics Request Status, length: 15 , Coded Values: [New: New] , [Received: Received] , [On Hold: On Hold] , ...8 more... )
• TrashCartAssignedTo ( type: esriFieldTypeString, alias: Trash Cart Delivery Assigned To, length: 50 , Coded Values: [Berendes: Chad Berendes] , [Brosius: Jim Brosius] , [Clark: Shannon Clark] , ...19 more... )
• RecyclingCartAssignedTo ( type: esriFieldTypeString, alias: Recycling Cart/Bin Delivery Assigned To, length: 50 , Coded Values: [Berendes: Chad Berendes] , [Brosius: Jim Brosius] , [Clark: Shannon Clark] , ...19 more... )
• OrganicsCartAssignedTo ( type: esriFieldTypeString, alias: Organics Cart Delivery Assigned To, length: 50 , Coded Values: [Berendes: Chad Berendes] , [Brosius: Jim Brosius] , [Clark: Shannon Clark] , ...19 more... )
• TrashCartDeliveredBy ( type: esriFieldTypeString, alias: Trash Cart Delivered By, length: 50 , Coded Values: [Berendes: Chad Berendes] , [Brosius: Jim Brosius] , [Clark: Shannon Clark] , ...19 more... )
• RecyclingCartDeliveredBy ( type: esriFieldTypeString, alias: Recycling Cart/Bin Delivered By, length: 50 , Coded Values: [Berendes: Chad Berendes] , [Brosius: Jim Brosius] , [Clark: Shannon Clark] , ...19 more... )
• OrganicsCartDeliveredBy ( type: esriFieldTypeString, alias: Organics Cart Delivered By, length: 50 , Coded Values: [Berendes: Chad Berendes] , [Brosius: Jim Brosius] , [Clark: Shannon Clark] , ...19 more... )
• TrashCartDeliveryDate ( type: esriFieldTypeDate, alias: Trash Cart Delivery Date, length: 8 )
• RecyclingCartDeliveryDate ( type: esriFieldTypeDate, alias: Recycling Cart/Bin Delivery Date, length: 8 )
• OrganicsCartDeliveryDate ( type: esriFieldTypeDate, alias: Organics Cart Delivery Date, length: 8 )
• CartSwitch ( type: esriFieldTypeString, alias: Is one cart being switched for another?, length: 5 , Coded Values: [N: No] , [Y: Yes] )
• IssuedCart1 ( type: esriFieldTypeString, alias: Cart 1, length: 20 )
• IssuedCart2 ( type: esriFieldTypeString, alias: Cart 2, length: 20 )
• IssuedCart3 ( type: esriFieldTypeString, alias: Cart 3, length: 20 )
• IssuedCart4 ( type: esriFieldTypeString, alias: Cart 4, length: 20 )
• IssuedCart5 ( type: esriFieldTypeString, alias: Cart 5, length: 20 )
• IssuedCart6 ( type: esriFieldTypeString, alias: Cart 6, length: 20 )
• IssuedCart7 ( type: esriFieldTypeString, alias: Cart 7, length: 20 )
• IssuedCart8 ( type: esriFieldTypeString, alias: Cart 8, length: 20 )
• IssuedCart9 ( type: esriFieldTypeString, alias: Cart 9, length: 20 )
• IssuedCart10 ( type: esriFieldTypeString, alias: Cart 10, length: 20 )
• ReturnedCart1 ( type: esriFieldTypeString, alias: Cart 1, length: 20 )
• ReturnedCart2 ( type: esriFieldTypeString, alias: Cart 2, length: 20 )
• ReturnedCart3 ( type: esriFieldTypeString, alias: Cart 3, length: 20 )
• ReturnedCart4 ( type: esriFieldTypeString, alias: Cart 4, length: 20 )
• ReturnedCart5 ( type: esriFieldTypeString, alias: Cart 5, length: 20 )
• NewAddress ( type: esriFieldTypeString, alias: New Address/Transfer Cart To, length: 100 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata