View In:   ArcGIS Online Map Viewer

Name: Tipper Cart Management

Display Field: Address

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: ef366225185e4128b3f101f3036bfbf5

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 5646028.829431802
YMin: 3625460.8986980617
XMax: 5691566.280351475
YMax: 3678919.0299705565
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: DUBUQUE.TipperCartManagement.RefuseService1
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSFSSolid
Color: [250, 211, 15, 255]
Outline:
Style: esriSLSSolid
Color: [255, 140, 2, 255]
Width: 0
Default Label: No Service
UniqueValueInfos:
• Value: S035
  Label: 35-Gallon Carts
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [201, 32, 32, 255]
  Outline:
  Style: esriSLSSolid
  Color: [162, 42, 51, 255]
  Width: 0
• Value: S048
  Label: 48-Gallon Carts
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [3, 58, 168, 255]
  Outline:
  Style: esriSLSSolid
  Color: [26, 41, 84, 255]
  Width: 0
• Value: A064
  Label: 64-Gallon Carts
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [55, 183, 90, 255]
  Outline:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 0
• Value: S064
  Label: 64-Gallon Carts
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [55, 183, 90, 255]
  Outline:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 0
• Value: A096
  Label: 96-Gallon Carts
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [106, 64, 125, 255]
  Outline:
  Style: esriSLSSolid
  Color: [64, 30, 83, 255]
  Width: 0
• Value: S096
  Label: 96-Gallon Carts
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [106, 64, 125, 255]
  Outline:
  Style: esriSLSSolid
  Color: [64, 30, 83, 255]
  Width: 0
Transparency: 40
Labeling Info:

Feature Draw Order:

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: true
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: RefuseService1

Fields:

• Shape__Area ( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STArea(), required: true )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Address )
• UBAccount ( type: esriFieldTypeString, alias: UB Account Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: UBAccount )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 3, defaultValue: -00, modelName: SerialNumber )
• RefuseService ( type: esriFieldTypeString, alias: Refuse Service?, editable: true, nullable: true, length: 10, defaultValue: Yes, modelName: RefuseService , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• ServiceCount ( type: esriFieldTypeSmallInteger, alias: Number of Carts, editable: true, nullable: true, defaultValue: 1, modelName: ServiceCount )
• ServiceCount2 ( type: esriFieldTypeSmallInteger, alias: Number of Carts (2nd Service), editable: true, nullable: true, defaultValue: 0, modelName: ServiceCount2 )
• 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... )
• RecyclingCart ( type: esriFieldTypeString, alias: Recycling Cart?, editable: true, nullable: true, length: 10, defaultValue: Unk, modelName: RecyclingCart , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• OnHold ( type: esriFieldTypeString, alias: On Hold for Another Size?, editable: true, nullable: true, length: 10, defaultValue: No, modelName: OnHold , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• DeliveredDate ( type: esriFieldTypeDate, alias: Cart Delivered on, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DeliveredDate )
• DeliveredBy ( type: esriFieldTypeString, alias: Cart Delivered By, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DeliveredBy , Coded Values: [Berendes: Chad Berendes] , [Brosius: Jim Brosius] , [Clark: Shannon Clark] , ...19 more... )
• VerifiedCart ( type: esriFieldTypeString, alias: Cart Verified at this address?, editable: true, nullable: true, length: 10, defaultValue: Unk, modelName: VerifiedCart , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• VerifiedCartSize ( type: esriFieldTypeSmallInteger, alias: Verified Cart Size, editable: true, nullable: true, defaultValue: null, modelName: VerifiedCartSize , Coded Values: [48: 48 gallons] , [64: 64 gallons] , [96: 96 gallons] , ...3 more... )
• VerificationDate ( type: esriFieldTypeDate, alias: Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VerificationDate )
• VerifiedCartNumber ( type: esriFieldTypeSmallInteger, alias: Verified Number of Carts, editable: true, nullable: true, defaultValue: null, modelName: VerifiedCartNumber )
• VerifiedCartNumber2 ( type: esriFieldTypeSmallInteger, alias: Verified Number of Carts 2nd Service, editable: true, nullable: true, defaultValue: null, modelName: VerifiedCartNumber2 )
• VerifiedCartSize2 ( type: esriFieldTypeSmallInteger, alias: 2nd Service Verified Cart Size, editable: true, nullable: true, defaultValue: null, modelName: VerifiedCartSize2 , Coded Values: [48: 48 gallons] , [64: 64 gallons] , [96: 96 gallons] , ...3 more... )
• CartID1 ( type: esriFieldTypeString, alias: CartID1, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID1 )
• CartID2 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID2 )
• CartID3 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID3 )
• CartID4 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID4 )
• CartID5 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID5 )
• CartID6 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID6 )
• CartID7 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID7 )
• CartID8 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID8 )
• CartID9 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID9 )
• CartID10 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID10 )
• CartID11 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID11 )
• CartID12 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID12 )
• CartID13 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID13 )
• CartID14 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID14 )
• CartID15 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID15 )
• CartID16 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID16 )
• CartID17 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID17 )
• CartID18 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID18 )
• CartID19 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID19 )
• CartID20 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID20 )
• CartID21 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID21 )
• CartID22 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID22 )
• CartID23 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID23 )
• CartID24 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID24 )
• CartID25 ( type: esriFieldTypeString, alias: Cart ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CartID25 )
• 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 )
• gisdata_DUBUQUE_TipperCartManag ( type: esriFieldTypeString, alias: DUBUQUE.TipperCartManagement.SerialNumber, editable: true, nullable: true, length: 512, defaultValue: null, modelName: gisdata_DUBUQUE_TipperCartManag )
• RefuseService1 ( type: esriFieldTypeString, alias: RefuseService1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RefuseService1 , Coded Values: [A048: Alley Cart Basic] , [A064: Alley Cart 64 Gallon] , [A096: Alley Cart 96 Gallon] , ...11 more... )
• RefuseService2 ( type: esriFieldTypeString, alias: RefuseService2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RefuseService2 , Coded Values: [A048: Alley Cart Basic] , [A064: Alley Cart 64 Gallon] , [A096: Alley Cart 96 Gallon] , ...11 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Notes )

Types:

ID: S035
Name: 35-Gallon Carts
Domains:
• RefuseService:
  Inherited
• CollectionDay:
  Inherited
• RecyclingCart:
  Inherited
• OnHold:
  Inherited
• DeliveredBy:
  Inherited
• VerifiedCart:
  Inherited
• VerifiedCartSize:
  Inherited
• VerifiedCartSize2:
  Inherited
• RefuseService1:
  Inherited
• RefuseService2:
  Inherited
Templates:
• Name: S035
  Description:
  Prototype:
  RefuseService2: null
  gisdata_DUBUQUE_TipperCartManag: null
  Notes: null
  RefuseService1: null
  Address: null
  UBAccount: null
  SerialNumber: -00
  RefuseService: Yes
  ServiceCount: 1
  ServiceCount2: 0
  CollectionDay: null
  RecyclingCart: Unk
  OnHold: No
  DeliveredDate: null
  DeliveredBy: null
  VerifiedCart: Unk
  VerifiedCartSize: null
  VerificationDate: null
  VerifiedCartNumber: null
  VerifiedCartNumber2: null
  VerifiedCartSize2: null
  CartID1: null
  CartID2: null
  CartID3: null
  CartID4: null
  CartID5: null
  CartID6: null
  CartID7: null
  CartID8: null
  CartID9: null
  CartID10: null
  CartID11: null
  CartID12: null
  CartID13: null
  CartID14: null
  CartID15: null
  CartID16: null
  CartID17: null
  CartID18: null
  CartID19: null
  CartID20: null
  CartID21: null
  CartID22: null
  CartID23: null
  CartID24: null
  CartID25: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: S048
Name: 48-Gallon Carts
Domains:
• RefuseService:
  Inherited
• CollectionDay:
  Inherited
• RecyclingCart:
  Inherited
• OnHold:
  Inherited
• DeliveredBy:
  Inherited
• VerifiedCart:
  Inherited
• VerifiedCartSize:
  Inherited
• VerifiedCartSize2:
  Inherited
• RefuseService1:
  Inherited
• RefuseService2:
  Inherited
Templates:
• Name: S048
  Description:
  Prototype:
  RefuseService2: null
  gisdata_DUBUQUE_TipperCartManag: null
  Notes: null
  RefuseService1: null
  Address: null
  UBAccount: null
  SerialNumber: -00
  RefuseService: Yes
  ServiceCount: 1
  ServiceCount2: 0
  CollectionDay: null
  RecyclingCart: Unk
  OnHold: No
  DeliveredDate: null
  DeliveredBy: null
  VerifiedCart: Unk
  VerifiedCartSize: null
  VerificationDate: null
  VerifiedCartNumber: null
  VerifiedCartNumber2: null
  VerifiedCartSize2: null
  CartID1: null
  CartID2: null
  CartID3: null
  CartID4: null
  CartID5: null
  CartID6: null
  CartID7: null
  CartID8: null
  CartID9: null
  CartID10: null
  CartID11: null
  CartID12: null
  CartID13: null
  CartID14: null
  CartID15: null
  CartID16: null
  CartID17: null
  CartID18: null
  CartID19: null
  CartID20: null
  CartID21: null
  CartID22: null
  CartID23: null
  CartID24: null
  CartID25: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: A064
Name: 64-Gallon Carts
Domains:
• RefuseService:
  Inherited
• CollectionDay:
  Inherited
• RecyclingCart:
  Inherited
• OnHold:
  Inherited
• DeliveredBy:
  Inherited
• VerifiedCart:
  Inherited
• VerifiedCartSize:
  Inherited
• VerifiedCartSize2:
  Inherited
• RefuseService1:
  Inherited
• RefuseService2:
  Inherited
Templates:
• Name: A064
  Description:
  Prototype:
  RefuseService2: null
  gisdata_DUBUQUE_TipperCartManag: null
  Notes: null
  RefuseService1: null
  Address: null
  UBAccount: null
  SerialNumber: -00
  RefuseService: Yes
  ServiceCount: 1
  ServiceCount2: 0
  CollectionDay: null
  RecyclingCart: Unk
  OnHold: No
  DeliveredDate: null
  DeliveredBy: null
  VerifiedCart: Unk
  VerifiedCartSize: null
  VerificationDate: null
  VerifiedCartNumber: null
  VerifiedCartNumber2: null
  VerifiedCartSize2: null
  CartID1: null
  CartID2: null
  CartID3: null
  CartID4: null
  CartID5: null
  CartID6: null
  CartID7: null
  CartID8: null
  CartID9: null
  CartID10: null
  CartID11: null
  CartID12: null
  CartID13: null
  CartID14: null
  CartID15: null
  CartID16: null
  CartID17: null
  CartID18: null
  CartID19: null
  CartID20: null
  CartID21: null
  CartID22: null
  CartID23: null
  CartID24: null
  CartID25: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: S064
Name: 64-Gallon Carts
Domains:
• RefuseService:
  Inherited
• CollectionDay:
  Inherited
• RecyclingCart:
  Inherited
• OnHold:
  Inherited
• DeliveredBy:
  Inherited
• VerifiedCart:
  Inherited
• VerifiedCartSize:
  Inherited
• VerifiedCartSize2:
  Inherited
• RefuseService1:
  Inherited
• RefuseService2:
  Inherited
Templates:
• Name: S064
  Description:
  Prototype:
  RefuseService2: null
  gisdata_DUBUQUE_TipperCartManag: null
  Notes: null
  RefuseService1: null
  Address: null
  UBAccount: null
  SerialNumber: -00
  RefuseService: Yes
  ServiceCount: 1
  ServiceCount2: 0
  CollectionDay: null
  RecyclingCart: Unk
  OnHold: No
  DeliveredDate: null
  DeliveredBy: null
  VerifiedCart: Unk
  VerifiedCartSize: null
  VerificationDate: null
  VerifiedCartNumber: null
  VerifiedCartNumber2: null
  VerifiedCartSize2: null
  CartID1: null
  CartID2: null
  CartID3: null
  CartID4: null
  CartID5: null
  CartID6: null
  CartID7: null
  CartID8: null
  CartID9: null
  CartID10: null
  CartID11: null
  CartID12: null
  CartID13: null
  CartID14: null
  CartID15: null
  CartID16: null
  CartID17: null
  CartID18: null
  CartID19: null
  CartID20: null
  CartID21: null
  CartID22: null
  CartID23: null
  CartID24: null
  CartID25: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: A096
Name: 96-Gallon Carts
Domains:
• RefuseService:
  Inherited
• CollectionDay:
  Inherited
• RecyclingCart:
  Inherited
• OnHold:
  Inherited
• DeliveredBy:
  Inherited
• VerifiedCart:
  Inherited
• VerifiedCartSize:
  Inherited
• VerifiedCartSize2:
  Inherited
• RefuseService1:
  Inherited
• RefuseService2:
  Inherited
Templates:
• Name: A096
  Description:
  Prototype:
  RefuseService2: null
  gisdata_DUBUQUE_TipperCartManag: null
  Notes: null
  RefuseService1: null
  Address: null
  UBAccount: null
  SerialNumber: -00
  RefuseService: Yes
  ServiceCount: 1
  ServiceCount2: 0
  CollectionDay: null
  RecyclingCart: Unk
  OnHold: No
  DeliveredDate: null
  DeliveredBy: null
  VerifiedCart: Unk
  VerifiedCartSize: null
  VerificationDate: null
  VerifiedCartNumber: null
  VerifiedCartNumber2: null
  VerifiedCartSize2: null
  CartID1: null
  CartID2: null
  CartID3: null
  CartID4: null
  CartID5: null
  CartID6: null
  CartID7: null
  CartID8: null
  CartID9: null
  CartID10: null
  CartID11: null
  CartID12: null
  CartID13: null
  CartID14: null
  CartID15: null
  CartID16: null
  CartID17: null
  CartID18: null
  CartID19: null
  CartID20: null
  CartID21: null
  CartID22: null
  CartID23: null
  CartID24: null
  CartID25: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: S096
Name: 96-Gallon Carts
Domains:
• RefuseService:
  Inherited
• CollectionDay:
  Inherited
• RecyclingCart:
  Inherited
• OnHold:
  Inherited
• DeliveredBy:
  Inherited
• VerifiedCart:
  Inherited
• VerifiedCartSize:
  Inherited
• VerifiedCartSize2:
  Inherited
• RefuseService1:
  Inherited
• RefuseService2:
  Inherited
Templates:
• Name: S096
  Description:
  Prototype:
  RefuseService2: null
  gisdata_DUBUQUE_TipperCartManag: null
  Notes: null
  RefuseService1: null
  Address: null
  UBAccount: null
  SerialNumber: -00
  RefuseService: Yes
  ServiceCount: 1
  ServiceCount2: 0
  CollectionDay: null
  RecyclingCart: Unk
  OnHold: No
  DeliveredDate: null
  DeliveredBy: null
  VerifiedCart: Unk
  VerifiedCartSize: null
  VerificationDate: null
  VerifiedCartNumber: null
  VerifiedCartNumber2: null
  VerifiedCartSize2: null
  CartID1: null
  CartID2: null
  CartID3: null
  CartID4: null
  CartID5: null
  CartID6: null
  CartID7: null
  CartID8: null
  CartID9: null
  CartID10: null
  CartID11: null
  CartID12: null
  CartID13: null
  CartID14: null
  CartID15: null
  CartID16: null
  CartID17: null
  CartID18: null
  CartID19: null
  CartID20: null
  CartID21: null
  CartID22: null
  CartID23: null
  CartID24: null
  CartID25: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

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

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:

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