View In:   ArcGIS Online Map Viewer

Name: Customer Address Points

Display Field: USER_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><P><SPAN>This dataset originated from several tables that were combined into this final customer dataset. Sheboygan County's "Address Points" dataset was used as a base for this. Then we used that as a geocoder for geocoding the customer address list from the Water Utility. The final product was this dataset, which is the authoritative source for DPW garbage cart addresses. The actual carts (trash and recycling) are stored in a separate, related table. This dataset is meant to serve as a location for all garbage customers.</SPAN></P><P><SPAN>At some point, this dataset will need to be cross-referenced with the Water Utility's customer dataset. Theoretically, both should match perfectly. </SPAN></P></DIV></DIV>

Service Item Id: 11c7fd6782ce46db874b900f04989b5d

Copyright Text: City of Sheboygan, DPW

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 13142.499261070787

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: 206468.802227661
YMin: 153371.74786382169
XMax: 223133.60452791303
YMax: 191571.10814473778
Spatial Reference: 103458  (103458)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: StopType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Other
UniqueValueInfos:
• Value: Odd
  Label: Odd
  Description: N/A
  Symbol:
  
• Value: Medical
  Label: Medical
  Description: N/A
  Symbol:
  
• Value: Tipper
  Label: Tipper
  Description: N/A
  Symbol:
  
• Value: Standard
  Label: Standard
  Description: N/A
  Symbol:
  
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: StopType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• USER_Parcel_ID ( type: esriFieldTypeDouble, alias: Parcel ID, editable: true, nullable: true, defaultValue: null, modelName: Parcel_ID )
• USER_Service_Address ( type: esriFieldTypeString, alias: Service Address, editable: true, nullable: true, length: 255, defaultValue: , modelName: Service_Address )
• USER_Name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 255, defaultValue: , modelName: Name )
• USER_Cust_No ( type: esriFieldTypeString, alias: Cust No, editable: true, nullable: true, length: 255, defaultValue: , modelName: Cust_No )
• USER_Customer_Type ( type: esriFieldTypeString, alias: Customer Type, editable: true, nullable: true, length: 255, defaultValue: , modelName: Customer_Type )
• USER_Rate_Number ( type: esriFieldTypeDouble, alias: Rate Number, editable: true, nullable: true, defaultValue: null, modelName: Rate_Number )
• ReviewComments ( type: esriFieldTypeString, alias: Review Comments, editable: true, nullable: true, length: 400, defaultValue: null, modelName: ReviewComments )
• Remove ( type: esriFieldTypeString, alias: Remove, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Remove , Coded Values: [Yes: Yes] , [No: No] )
• FieldReviewed ( type: esriFieldTypeString, alias: Field Reviewed?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FieldReviewed , Coded Values: [Yes: Yes] , [No: No] )
• CollectionRoute ( type: esriFieldTypeString, alias: Collection Route, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CollectionRoute )
• EditBy ( type: esriFieldTypeString, alias: Edited By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: EditBy )
• EditDate ( type: esriFieldTypeDate, alias: Edited Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• CreatBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreatBy )
• CreateDate ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• DeliverCans ( type: esriFieldTypeString, alias: Deliver Cans?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DeliverCans , Coded Values: [Yes: Yes] , [No: No] )
• SpecialDelivery ( type: esriFieldTypeString, alias: Special Delivery Notes?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpecialDelivery , Coded Values: [Yes: Yes] , [No: No] )
• Address_DPW ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Address_DPW )
• CollectionDay ( type: esriFieldTypeString, alias: Collection Day, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CollectionDay )
• RecyclingWeek ( type: esriFieldTypeString, alias: Recycling Week, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RecyclingWeek )
• MoreInfo ( type: esriFieldTypeString, alias: MoreInfo, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MoreInfo )
• GarbageCarts ( type: esriFieldTypeSmallInteger, alias: Number of Garbage Carts, editable: true, nullable: true, defaultValue: null, modelName: GarbageCarts )
• RecyclingCarts ( type: esriFieldTypeSmallInteger, alias: Number of Recycling Carts, editable: true, nullable: true, defaultValue: null, modelName: RecyclingCarts )
• CountyParcelID ( type: esriFieldTypeString, alias: County Parcel ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CountyParcelID )
• HouseNmbr ( type: esriFieldTypeDouble, alias: HouseNumber, editable: true, nullable: true, defaultValue: null, modelName: HouseNmbr )
• AddressUnit ( type: esriFieldTypeString, alias: Address Unit, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AddressUnit )
• Odd ( type: esriFieldTypeString, alias: Odd Stop?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Odd , Coded Values: [Yes: Yes] , [No: No] )
• StopType ( type: esriFieldTypeString, alias: Stop Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StopType , Coded Values: [Standard: Standard] , [Odd: Odd] , [Tipper: Tipper] , ...1 more... )
• Zip ( type: esriFieldTypeInteger, alias: Zip, editable: true, nullable: true, defaultValue: null, modelName: Zip )
• CartAlias1 ( type: esriFieldTypeString, alias: Cart Alias 1, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CartAlias1 )
• CartAlias2 ( type: esriFieldTypeString, alias: Cart Alias 2, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CartAlias2 )
• CartCopy ( type: esriFieldTypeString, alias: Copy of Serial Numbers (copy), editable: true, nullable: true, length: 1000, defaultValue: null, modelName: CartCopy )
• TruckNumber ( type: esriFieldTypeString, alias: Garbage Truck Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TruckNumber )
• RouteNumber ( type: esriFieldTypeString, alias: Garbage Route, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RouteNumber )
• Driver ( type: esriFieldTypeString, alias: Garbage Driver, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Garbage )
• RecycleTruckNumber ( type: esriFieldTypeString, alias: Recycle Truck Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Week_A_Recycle )
• RecycleTruckRoute ( type: esriFieldTypeString, alias: Recycle Truck Route, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Week_B_Recycle )
• RecycleTruckDriver ( type: esriFieldTypeString, alias: Recycle Truck Driver, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RecycleTruckDriver )

Types:

ID: Odd
Name: Odd
Domains:
• Remove:
  Inherited
• FieldReviewed:
  Inherited
• DeliverCans:
  Inherited
• SpecialDelivery:
  Inherited
• Odd:
  Inherited
• StopType:
  Inherited
Templates:
• Name: Odd
  Description:
  Prototype:
  Odd: null
  USER_Parcel_ID: null
  USER_Service_Address:
  USER_Name:
  USER_Cust_No:
  RecycleTruckRoute: null
  USER_Customer_Type:
  USER_Rate_Number: null
  ReviewComments: null
  Remove: null
  FieldReviewed: null
  CollectionRoute: null
  RecycleTruckNumber: null
  Driver: null
  RouteNumber: null
  TruckNumber: null
  RecycleTruckDriver: null
  DeliverCans: null
  SpecialDelivery: null
  Address_DPW: null
  CollectionDay: null
  RecyclingWeek: null
  MoreInfo: null
  GarbageCarts: null
  RecyclingCarts: null
  CountyParcelID: null
  HouseNmbr: null
  AddressUnit: null
  StopType: Odd
  Zip: null
  CartAlias1: null
  CartAlias2: null
  CartCopy: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Medical
Name: Medical
Domains:
• Remove:
  Inherited
• FieldReviewed:
  Inherited
• DeliverCans:
  Inherited
• SpecialDelivery:
  Inherited
• Odd:
  Inherited
• StopType:
  Inherited
Templates:
• Name: Medical
  Description:
  Prototype:
  Odd: null
  USER_Parcel_ID: null
  USER_Service_Address:
  USER_Name:
  USER_Cust_No:
  RecycleTruckRoute: null
  USER_Customer_Type:
  USER_Rate_Number: null
  ReviewComments: null
  Remove: null
  FieldReviewed: null
  CollectionRoute: null
  RecycleTruckNumber: null
  Driver: null
  RouteNumber: null
  TruckNumber: null
  RecycleTruckDriver: null
  DeliverCans: null
  SpecialDelivery: null
  Address_DPW: null
  CollectionDay: null
  RecyclingWeek: null
  MoreInfo: null
  GarbageCarts: null
  RecyclingCarts: null
  CountyParcelID: null
  HouseNmbr: null
  AddressUnit: null
  StopType: Medical
  Zip: null
  CartAlias1: null
  CartAlias2: null
  CartCopy: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Tipper
Name: Tipper
Domains:
• Remove:
  Inherited
• FieldReviewed:
  Inherited
• DeliverCans:
  Inherited
• SpecialDelivery:
  Inherited
• Odd:
  Inherited
• StopType:
  Inherited
Templates:
• Name: Tipper
  Description:
  Prototype:
  Odd: null
  USER_Parcel_ID: null
  USER_Service_Address:
  USER_Name:
  USER_Cust_No:
  RecycleTruckRoute: null
  USER_Customer_Type:
  USER_Rate_Number: null
  ReviewComments: null
  Remove: null
  FieldReviewed: null
  CollectionRoute: null
  RecycleTruckNumber: null
  Driver: null
  RouteNumber: null
  TruckNumber: null
  RecycleTruckDriver: null
  DeliverCans: null
  SpecialDelivery: null
  Address_DPW: null
  CollectionDay: null
  RecyclingWeek: null
  MoreInfo: null
  GarbageCarts: null
  RecyclingCarts: null
  CountyParcelID: null
  HouseNmbr: null
  AddressUnit: null
  StopType: Tipper
  Zip: null
  CartAlias1: null
  CartAlias2: null
  CartCopy: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Standard
Name: Standard
Domains:
• Remove:
  Inherited
• FieldReviewed:
  Inherited
• DeliverCans:
  Inherited
• SpecialDelivery:
  Inherited
• Odd:
  Inherited
• StopType:
  Inherited
Templates:
• Name: Standard
  Description:
  Prototype:
  Odd: null
  USER_Parcel_ID: null
  USER_Service_Address:
  USER_Name:
  USER_Cust_No:
  RecycleTruckRoute: null
  USER_Customer_Type:
  USER_Rate_Number: null
  ReviewComments: null
  Remove: null
  FieldReviewed: null
  CollectionRoute: null
  RecycleTruckNumber: null
  Driver: null
  RouteNumber: null
  TruckNumber: null
  RecycleTruckDriver: null
  DeliverCans: null
  SpecialDelivery: null
  Address_DPW: null
  CollectionDay: null
  RecyclingWeek: null
  MoreInfo: null
  GarbageCarts: null
  RecyclingCarts: null
  CountyParcelID: null
  HouseNmbr: null
  AddressUnit: null
  StopType: Standard
  Zip: null
  CartAlias1: null
  CartAlias2: null
  CartCopy: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• GarbageRecyclingCarts (0) -- Related To: Garbage and Recycling Carts (3)

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

Edit Fields Info:

• Creation Date Field: CreateDate
• Creator Field: CreatBy
• Edit Date Field: EditDate
• Editor Field: EditBy

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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