View In:   ArcGIS Online Map Viewer

Name: Tipper Cart Requests

Display Field: FirstName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: c1c735e5553a4fe6b255323804150f68

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
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: false
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:

Fields:

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

Templates:

• Name: Tipper Cart Requests
  Description:
  Prototype:
  NewAddress: null
  ReturnedCart5: null
  RequestDate: null
  Address: null
  AlternateAddress: null
  RequestedStartDate: null
  UBAccountNumber: null
  FirstName: null
  LastName: null
  PhoneNumber: null
  Email: null
  TrashServiceRequest: N
  RecyclingServiceRequest: N
  OrganicsServiceRequest: N
  CurrentTrashService: New
  RequestedTrashService: 35
  NumberTrashCarts: null
  CurrentRecyclingService: New
  RequestedRecyclingService: null
  NumberYellowBins: null
  NumberRecyclingCarts: null
  CurrentOrganicsService: New
  RequestedOrganicsService: null
  NumberCarts13Gallon: null
  NumberCarts64Gallon: null
  AdditionalComments: null
  PIN: null
  CollectionDay: null
  DeliveryDirections: null
  DeliveryNotes: null
  DispatchedBy: null
  Priority: Low
  TrashRequestStatus: New
  RecyclingRequestStatus: null
  OrganicsRequestStatus: null
  TrashCartAssignedTo: null
  RecyclingCartAssignedTo: null
  OrganicsCartAssignedTo: null
  TrashCartDeliveredBy: null
  RecyclingCartDeliveredBy: null
  OrganicsCartDeliveredBy: null
  TrashCartDeliveryDate: null
  RecyclingCartDeliveryDate: null
  OrganicsCartDeliveryDate: null
  CartSwitch: null
  IssuedCart1: null
  IssuedCart2: null
  IssuedCart3: null
  IssuedCart4: null
  IssuedCart5: null
  IssuedCart6: null
  IssuedCart7: null
  IssuedCart8: null
  IssuedCart9: null
  IssuedCart10: null
  ReturnedCart1: null
  ReturnedCart2: null
  ReturnedCart3: null
  ReturnedCart4: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Update,Uploads,Editing,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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