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: 83701f6a5cf54ba3a6d3b15ffb6f0ff6

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

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

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata