Name: Water Service Locations

Display Field: SERVICESTREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: A feature class showing the all parcels with active water or sewer service in the City of Grand Rapids Service area. This layer pulls billing and service information for each parcel with active service from Cayenta. There are many scripts and related feature classes that create this layer. This layer is updated every Tuesday. Managed by the Water/ESD GIS Administrator.

Copyright Text: City of Grand Rapids, EMA, Craig Patterson, Victoria Shroyer

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 8000

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: 1.2731606395333275E7
YMin: 496039.74234063923
XMax: 1.2830136879979536E7
YMax: 561135.9253369123
Spatial Reference: PROJCS["NAD_1983_StatePlane_Michigan_South_FIPS_2113_IntlFeet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",13123359.58005249],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.36666666666666],PARAMETER["Standard_Parallel_1",42.1],PARAMETER["Standard_Parallel_2",43.66666666666666],PARAMETER["Latitude_Of_Origin",41.5],UNIT["Foot",0.3048]]

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: CITYSERVICEMAT
Field 2: PVTSERVICEMAT
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: GALV,LEAD ASSM
  Label: Lead, Lead
  Description:
  Symbol:
  
• Value: LEAD ASSM,GALV
  Label: Lead, Lead
  Description:
  Symbol:
  
• Value: LEAD,GALV
  Label: Lead, Lead
  Description:
  Symbol:
  
• Value: LEAD ASSM,LEAD
  Label: Lead, Lead
  Description:
  Symbol:
  
• Value: LEAD ASSM,LEAD ASSM
  Label: Lead, Lead
  Description:
  Symbol:
  
• Value: LEAD,LEAD
  Label: Lead, Lead
  Description:
  Symbol:
  
• Value: LEAD,LEAD ASSM
  Label: Lead, Lead
  Description:
  Symbol:
  
• Value: NA,GALV
  Label: Unknown, Lead
  Description:
  Symbol:
  
• Value: ,LEAD
  Label: Unknown, Lead
  Description:
  Symbol:
  
• Value: ,LEAD ASSM
  Label: Unknown, Lead
  Description:
  Symbol:
  
• Value: N/A,LEAD ASSM
  Label: Unknown, Lead
  Description:
  Symbol:
  
• Value: NA,LEAD
  Label: Unknown, Lead
  Description:
  Symbol:
  
• Value: NA,LEAD ASSM
  Label: Unknown, Lead
  Description:
  Symbol:
  
• Value: LEAD ASSM,OTHR
  Label: Lead, Unknown
  Description:
  Symbol:
  
• Value: LEAD,
  Label: Lead, Unknown
  Description:
  Symbol:
  
• Value: LEAD,OTHR
  Label: Lead, Unknown
  Description:
  Symbol:
  
• Value: LEAD ASSM,INSL
  Label: Lead, Unknown
  Description:
  Symbol:
  
• Value: LEAD,INSL
  Label: Lead, Unknown
  Description:
  Symbol:
  
• Value: COPP ASSM,GALV
  Label: Non-Lead, Lead
  Description:
  Symbol:
  
• Value: COPP,GALV
  Label: Non-Lead, Lead
  Description:
  Symbol:
  
• Value: COPP ASSM,LEAD
  Label: Non-Lead, Lead
  Description:
  Symbol:
  
• Value: COPP ASSM,LEAD ASSM
  Label: Non-Lead, Lead
  Description:
  Symbol:
  
• Value: COPP,LEAD
  Label: Non-Lead, Lead
  Description:
  Symbol:
  
• Value: COPP,LEAD ASSM
  Label: Non-Lead, Lead
  Description:
  Symbol:
  
• Value: COPPER,LEAD ASSM
  Label: Non-Lead, Lead
  Description:
  Symbol:
  
• Value: Copper 3-7-2016,LEAD ASSM
  Label: Non-Lead, Lead
  Description:
  Symbol:
  
• Value: Copper,LEAD ASSM
  Label: Non-Lead, Lead
  Description:
  Symbol:
  
• Value: DUCTL,LEAD ASSM
  Label: Non-Lead, Lead
  Description:
  Symbol:
  
• Value: GALV,COPP
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: LEAD ASSM,COPP
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: LEAD ASSM,COPP ASSM
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: LEAD,COPP
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: LEAD,COPP ASSM
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: LEAD,DUCTL
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: LEAD ASSM,PE
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: LEAD ASSM,POLY
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: LEAD,PE
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: LEAD,PEX
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: LEAD,POLY
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: LEAD,PVC
  Label: Lead, Non-Lead
  Description:
  Symbol:
  
• Value: NA,INSL
  Label: Unknown, Unknown
  Description:
  Symbol:
  
• Value: .,
  Label: Unknown, Unknown
  Description:
  Symbol:
  
• Value: 0,
  Label: Unknown, Unknown
  Description:
  Symbol:
  
• Value: ,
  Label: Unknown, Unknown
  Description:
  Symbol:
  
• Value: ,OTHR
  Label: Unknown, Unknown
  Description:
  Symbol:
  
• Value: HI,
  Label: Unknown, Unknown
  Description:
  Symbol:
  
• Value: N/A,
  Label: Unknown, Unknown
  Description:
  Symbol:
  
• Value: NA,
  Label: Unknown, Unknown
  Description:
  Symbol:
  
• Value: NA,OTHR
  Label: Unknown, Unknown
  Description:
  Symbol:
  
• Value: OTHR,
  Label: Unknown, Unknown
  Description:
  Symbol:
  
• Value: SMIT,
  Label: Unknown, Unknown
  Description:
  Symbol:
  
• Value: HIGH,CAST
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: N/A,CAST
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: NA,CAST ASSM
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: ,COPP
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: N/A,COPP
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: N/A,COPP ASSM
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: NA,COPP
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: NA,COPP ASSM
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: ,DUCTL
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: N/A,DUCTL
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: NA,DUCTL
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: TEE,DUCTL
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: ,PE
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: ,PEX
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: ,POLY
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: N/A,PE
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: NA,POLY
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: OTHR,PEX
  Label: Unknown, Non-Lead
  Description:
  Symbol:
  
• Value: CI,INSL
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: CAST,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: CI,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: CI,OTHR
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: COP,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: COPP to PE after SB.,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: COPP,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: COPP,OTHR
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: COPP,OTHR-UNKNOWN
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: COPPER,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: CU,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: Cu,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: copp,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: copper,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: cu,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: COPP,INSL
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: DI,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: DUCT IRON,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: DUCT,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: DUCT,OTHR
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: DUCTL,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: DUCTL,OTHR
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: POLY,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: POLY,OTHR
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: PVC,
  Label: Non-Lead, Unknown
  Description:
  Symbol:
  
• Value: C.I.,CAST
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CAST,CAST
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CAST,CAST ASSM
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CI,CAST
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CI,CAST ASSM
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CAST,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CAST,COPP ASSM
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CI,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CI,COPP ASSM
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CAST,DUCTL
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CI,DUCTL
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CAST,PE
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CAST,POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CI,POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,brass
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,CAST
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP (PVC CRBX TOP SECTION),COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP (TOP SECTION PVC),COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP ASSM,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP ASSM,COPP ASSM
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,COPP ASSM
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,K COPPER
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPPER,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPPER,COPP ASSM
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPPR,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: CU,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: Copper - partial lead abatement - 4-6-2016,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: Copper 9-9-2015,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: Copper,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COP,DUCTL
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,DUCTL
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP (PVC TOP SECTION),POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP (TOP SECTION PVC),POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP to PEX,POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,BLUE POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,OTHR- plastic
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,PE
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,PEX
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPP,PVC
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPPER,PE
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPPER,PEX
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: COPPER,POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: Copper to PE,PE
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: Copper,PE
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: Copper,PEX
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: Copper,POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: Cu,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: Cu,POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DI,CAST
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCT,CAST
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCTL,CAST
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCT,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCTL,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCTL,COPP ASSM
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DI,DUCTL
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DI,DUCTL ASSM
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCT IRON,DUCTL
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCT,DUCT
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCT,DUCTL
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCT,DUCTL ASSM
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCTILE,DUCTL
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCTL,DUCTL
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: DUCTL,POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: POLY,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: PVC,COPP
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: POLY,POLY
  Label: Non-Lead, Non-Lead
  Description:
  Symbol:
  
• Value: PVC,PVC
  Label: Non-Lead, Non-Lead
  Description:
  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 )
• LOCATIONNO ( type: esriFieldTypeInteger, alias: Location Number )
• SERVICEHOUSENO ( type: esriFieldTypeString, alias: House Number, length: 50 )
• SERVICESTREETNAME ( type: esriFieldTypeString, alias: Service Address, length: 255 )
• PARCELID ( type: esriFieldTypeString, alias: Parcel ID, length: 255 )
• PROPADDRESS ( type: esriFieldTypeString, alias: Parcel Property Address, length: 255 )
• QUADRANT ( type: esriFieldTypeString, alias: Quadrant Code, length: 255 )
• TAPLOCATION ( type: esriFieldTypeString, alias: Tap Location, length: 255 )
• CURBBOXLOCATION ( type: esriFieldTypeString, alias: Curb Box Location, length: 255 )
• CITYSERVICESIZE ( type: esriFieldTypeString, alias: City Service Size, length: 255 )
• CITYSERVICEMAT ( type: esriFieldTypeString, alias: City Service Material, length: 255 )
• PVTSERVICESIZE ( type: esriFieldTypeString, alias: Private Service Size, length: 50 )
• PVTSERVICEMAT ( type: esriFieldTypeString, alias: Private Service Material, length: 50 )
• TAPNO ( type: esriFieldTypeString, alias: Tap Number, length: 255 )
• TAPDATE ( type: esriFieldTypeString, alias: Tap Date, length: 255 )
• TAPSZ ( type: esriFieldTypeString, alias: Tap Size, length: 255 )
• SERVICETYPE ( type: esriFieldTypeString, alias: Service Type, length: 255 )
• SERIALNO ( type: esriFieldTypeString, alias: Meter Serial Number, length: 255 )
• METERTP ( type: esriFieldTypeString, alias: Meter Type Code, length: 255 )
• SETDT ( type: esriFieldTypeString, alias: Meter Set Date, length: 8 )
• COMPANYCD ( type: esriFieldTypeString, alias: Meter Manufacturer Code, length: 255 )
• MXUFLAG ( type: esriFieldTypeString, alias: MXU Code, length: 255 )
• PITFLAG ( type: esriFieldTypeString, alias: Pit, length: 255 )
• ACCTNO ( type: esriFieldTypeInteger, alias: Account Number )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: Customer Name, length: 255 )
• PHONENO ( type: esriFieldTypeString, alias: Customer Phone Number, length: 255 )
• LOCCLASS ( type: esriFieldTypeString, alias: Location Class, length: 255 )
• CYCLECD ( type: esriFieldTypeString, alias: Bill Cycle Code, length: 255 )
• ROUTENO ( type: esriFieldTypeInteger, alias: Meter Reading Route Number )
• GOVT ( type: esriFieldTypeString, alias: Governmental Code, length: 255 )
• RESBFDEVTYPE ( type: esriFieldTypeString, alias: Residential Back Flow Device Type, length: 50 )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 10 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata