Parent Layer:
Service Materials Overview
Name: Material Overview
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: 0
Max Scale: 3000
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:
Default Label: null
UniqueValueInfos:
-
Value: LEAD,
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: N/A,LEAD ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,OTHR
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: NA,LEAD
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD ASSM,OTHR
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: ,LEAD
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD ASSM,INSL
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,INSL
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: ,LEAD ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: COPP ASSM,GALV
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: COPP,GALV
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: COPP ASSM,LEAD
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: COPP ASSM,LEAD ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: COPP,LEAD
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: COPP,LEAD ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: COPPER,LEAD ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: Copper 3-7-2016,LEAD ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: Copper,LEAD ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: DUCTL,LEAD ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: GALV,COPP
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: GALV,LEAD ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD ASSM,COPP
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD ASSM,COPP ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,COPP
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,COPP ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,DUCTL
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD ASSM,GALV
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,GALV
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD ASSM,LEAD
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD ASSM,LEAD ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,LEAD
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,LEAD ASSM
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD ASSM,PE
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD ASSM,POLY
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,PE
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,PEX
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,POLY
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: LEAD,PVC
Label: Replacement Needed, Service Line Contains Lead
Description:
Symbol:
-
Value: ,POLY
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: OTHR,PEX
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: cu,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: DUCTL,OTHR
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: TEE,DUCTL
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: copp,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: NA,COPP ASSM
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: N/A,PE
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: CI,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: COPP,OTHR-UNKNOWN
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: CU,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: Cu,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: 0,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: CI,INSL
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: COPP,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: PVC,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: ,COPP
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: DUCT,OTHR
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: N/A,CAST
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: N/A,COPP
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: ,DUCTL
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: ,OTHR
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: N/A,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: COP,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: NA,INSL
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: .,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: CI,OTHR
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: COPP,INSL
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: NA,COPP
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: NA,LEAD ASSM
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: copper,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: DUCT,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: N/A,DUCTL
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: NA,OTHR
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: OTHR,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: COPP,OTHR
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: N/A,COPP ASSM
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: NA,DUCTL
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: NA,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: SMIT,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: DUCTL,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: ,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: CAST,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: POLY,OTHR
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: NA,CAST ASSM
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: NA,GALV
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: HI,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: NA,POLY
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: ,PE
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: ,PEX
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: DUCT IRON,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: COPP to PE after SB.,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: COPPER,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: DI,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: POLY,
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: HIGH,CAST
Label: Inspection Needed, Missing Service Material Information
Description:
Symbol:
-
Value: C.I.,CAST
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CAST,CAST
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CAST,CAST ASSM
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CI,CAST
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CI,CAST ASSM
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CAST,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CAST,COPP ASSM
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CI,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CI,COPP ASSM
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CAST,DUCTL
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CI,DUCTL
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CAST,PE
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CAST,POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CI,POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,brass
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,CAST
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP (PVC CRBX TOP SECTION),COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP (TOP SECTION PVC),COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP ASSM,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP ASSM,COPP ASSM
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,COPP ASSM
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,K COPPER
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPPER,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPPER,COPP ASSM
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPPR,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: CU,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: Copper - partial lead abatement - 4-6-2016,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: Copper 9-9-2015,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: Copper,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COP,DUCTL
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,DUCTL
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP (PVC TOP SECTION),POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP (TOP SECTION PVC),POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP to PEX,POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,BLUE POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,OTHR- plastic
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,PE
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,PEX
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPP,PVC
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPPER,PE
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPPER,PEX
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: COPPER,POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: Copper to PE,PE
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: Copper,PE
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: Copper,PEX
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: Copper,POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: Cu,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: Cu,POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DI,CAST
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCT,CAST
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCTL,CAST
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCT,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCTL,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCTL,COPP ASSM
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DI,DUCTL
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DI,DUCTL ASSM
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCT IRON,DUCTL
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCT,DUCT
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCT,DUCTL
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCT,DUCTL ASSM
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCTILE,DUCTL
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCTL,DUCTL
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: DUCTL,POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: POLY,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: PVC,COPP
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: POLY,POLY
Label: No Action Required, Service Material Up to Code
Description:
Symbol:
-
Value: PVC,PVC
Label: No Action Required, Service Material Up to Code
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
)
-
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
)
-
SETDT
(
type: esriFieldTypeString, alias: Meter Set Date, length: 8
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata