Name: Water Curb Stop Valves
Display Field: FACILITYID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: Water network valves that control flow to a laterial and service connection.
Service Item Id: fdedbfa0356140f38a0292995099ab3a
Copyright Text:
Default Visibility: true
MaxRecordCount: 2000
MaxSelectionCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.0
Max Scale: 0.0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: true
Can Modify Layer: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 1629185.1292420886
YMin: 615521.5606565103
XMax: 1667766.923141338
YMax: 661752.4501499236
Spatial Reference: 102722
(3734)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: utilstatus
Field 2: custstatus
Field 3: N/A
Field Delimiter: ,
Default Symbol: Style: esriSMSCircle
Color: [255, 255, 255, 255]
Size: 12.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
Default Label: Other
UniqueValueInfos:
-
Value: 1,1
Label: Lead | Lead
Description: N/A
Symbol:
-
Value: 1,3
Label: Lead | Galvanized Requiring Replacement
Description: N/A
Symbol:
-
Value: 1,2
Label: Lead | Non-Lead
Description: N/A
Symbol:
-
Value: 1,0
Label: Lead | Unknown
Description: N/A
Symbol:
-
Value: 3,1
Label: Galvanized Requiring Replacement | Lead
Description: N/A
Symbol:
-
Value: 3,3
Label: Galvanized Requiring Replacement | Galvanized Requiring Replacement
Description: N/A
Symbol:
-
Value: 3,2
Label: Galvanized Requiring Replacement | Non-Lead
Description: N/A
Symbol:
-
Value: 3,0
Label: Galvanized Requiring Replacement | Unknown
Description: N/A
Symbol:
-
Value: 2,1
Label: Non-Lead | Lead
Description: N/A
Symbol:
-
Value: 2,3
Label: Non-Lead | Galvanized Requiring Replacement
Description: N/A
Symbol:
-
Value: 2,2
Label: Non-Lead | Non-Lead
Description: N/A
Symbol:
-
Value: 2,0
Label: Non-Lead | Unknown
Description: N/A
Symbol:
-
Value: 0,1
Label: Unknown | Lead
Description: N/A
Symbol:
-
Value: 0,3
Label: Unknown | Galvanized Requiring Replacement
Description: N/A
Symbol:
-
Value: 0,2
Label: Unknown | Non-Lead
Description: N/A
Symbol:
-
Value: 0,0
Label: Unknown | Unknown
Description: N/A
Symbol:
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [255, 255, 255, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: -2
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none
Min. Scale: 5000.0
Max. Scale: 0.0
Feature Draw Order:
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
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: true
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: N/A
Fields:
-
OBJECTID
(
nullable: false, alias: OBJECTID, type: esriFieldTypeOID
)
-
FACILITYID
(
nullable: true, length: 20, alias: Facility Identifier, type: esriFieldTypeString
)
-
INSTALLDATE
(
nullable: true, length: 8, alias: Install Date, type: esriFieldTypeDate
)
-
LOCDESC
(
nullable: true, length: 200, alias: Location Description, type: esriFieldTypeString
)
-
ROTATION
(
nullable: true, alias: Rotation, type: esriFieldTypeDouble
)
-
DIAMETER
(
nullable: true, alias: Diameter, type: esriFieldTypeDouble
, Coded Values:
[0.75: 3/4"]
, [1: 1"]
, [1.25: 1 1/4"]
, ...27 more...
)
-
VALVETYPE
(
nullable: true, length: 30, alias: Valve Type, type: esriFieldTypeString
, Coded Values:
[Ball: Ball]
, [Butterfly: Butterfly]
, [Cone: Cone]
, ...9 more...
)
-
NORMALLYOPEN
(
nullable: true, alias: Normally Open, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
, [3: Closed due to Project]
, ...2 more...
)
-
TURNSTOCLOSE
(
nullable: true, alias: Turns To Close, type: esriFieldTypeInteger
)
-
OPERABLE
(
nullable: true, alias: Operable, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
, [3: Closed due to Project]
, ...2 more...
)
-
CURROPEN
(
nullable: true, alias: Currently Open, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
, [3: Closed due to Project]
, ...2 more...
)
-
ACTIVEFLAG
(
nullable: true, alias: Active Flag, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
, [3: Closed due to Project]
, ...2 more...
)
-
OWNEDBY
(
nullable: true, alias: Owned By, type: esriFieldTypeSmallInteger
, Coded Values:
[-1: Private]
, [-2: Other]
, [1: City]
, ...8 more...
)
-
MAINTBY
(
nullable: true, alias: Managed By, type: esriFieldTypeSmallInteger
, Coded Values:
[-1: Private]
, [-2: Other]
, [1: City]
, ...6 more...
)
-
LASTUPDATE
(
nullable: true, length: 8, alias: Last Update Date, type: esriFieldTypeDate
)
-
LASTEDITOR
(
nullable: true, length: 50, alias: Last Editor, type: esriFieldTypeString
, Coded Values:
[BG: BG]
, [Landmark: Landmark]
)
-
NOTES
(
nullable: true, length: 150, alias: NOTES, type: esriFieldTypeString
)
-
HYPERLINK_1
(
nullable: true, length: 150, alias: HYPERLINK_1, type: esriFieldTypeString
)
-
HYPERLINK_2
(
nullable: true, length: 150, alias: HYPERLINK_2, type: esriFieldTypeString
)
-
GlobalID
(
nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID
)
-
CollectionType
(
nullable: true, length: 50, alias: CollectionType, type: esriFieldTypeString
, Coded Values:
[GPS: GPS]
, [FieldBook: FieldBook]
, [AsBuiltCAD: AsBuiltCAD]
, ...5 more...
)
-
created_user
(
nullable: true, length: 255, alias: created_user, type: esriFieldTypeString
)
-
created_date
(
nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate
)
-
last_edited_user
(
nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString
)
-
last_edited_date
(
nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate
)
-
ID_added
(
nullable: true, length: 50, alias: ID_added, type: esriFieldTypeString
, Coded Values:
[YES: YES]
, [NO: NO]
, [REPAIR: REPAIR]
, ...1 more...
)
-
GISREFcomplete
(
nullable: true, length: 5, alias: GISREFcomplete, type: esriFieldTypeString
, Coded Values:
[YES: YES]
, [NO: NO]
, [REPAIR: REPAIR]
, ...1 more...
)
-
valvestatus
(
nullable: true, length: 50, alias: valvestatus, type: esriFieldTypeString
, Coded Values:
[OPEN: OPEN]
, [CLOSED: CLOSED]
, [2INOPEN: 2IN OPEN]
, ...3 more...
)
-
valvereason
(
nullable: true, length: 50, alias: valvereason, type: esriFieldTypeString
, Coded Values:
[NON-PAYMENT: NON-PAYMENT]
, [LEAK IN HOME: LEAK IN HOME]
, [REPLUMBING: REPLUMBING]
, ...2 more...
)
-
valveshutemp
(
nullable: true, length: 50, alias: valveshutemp, type: esriFieldTypeString
, Coded Values:
[JOSH AMOS: JOSH AMOS]
, [KURT JOSEPH: KURT JOSEPH]
, [BRETT ABKE: BRETT ABKE]
, ...16 more...
)
-
servicetomain
(
nullable: true, length: 30, alias: pipetomain, type: esriFieldTypeString
, Coded Values:
[COPPER: COPPER]
, [IRON: IRON]
, [GALVANIZED: GALVANIZED]
, ...3 more...
)
-
servicetohouse
(
nullable: true, length: 30, alias: servicetohouse, type: esriFieldTypeString
, Coded Values:
[COPPER: COPPER]
, [IRON: IRON]
, [GALVANIZED: GALVANIZED]
, ...3 more...
)
-
as_built_link
(
nullable: true, length: 250, alias: as_built_link, type: esriFieldTypeString
)
-
LOCKED
(
nullable: true, length: 50, alias: LOCKED, type: esriFieldTypeString
, Coded Values:
[Locked By BG: Locked By BG]
, [Locked By Landmark: Locked By Landmark]
)
-
Hyperlink_4
(
nullable: true, length: 150, alias: Hyperlink_4, type: esriFieldTypeString
)
-
Hyperlink_5
(
nullable: true, length: 150, alias: Hyperlink_5, type: esriFieldTypeString
)
-
Enabled
(
nullable: true, alias: Enabled, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
)
-
SHUTDATE
(
nullable: true, length: 8, alias: SHUTDATE, type: esriFieldTypeDate
)
-
SHUTEMP
(
nullable: true, length: 50, alias: SHUTEMP, type: esriFieldTypeString
, Coded Values:
[JOSH AMOS: JOSH AMOS]
, [KURT JOSEPH: KURT JOSEPH]
, [BRETT ABKE: BRETT ABKE]
, ...16 more...
)
-
SHUTCOMM
(
nullable: true, length: 150, alias: SHUTCOMM, type: esriFieldTypeString
)
-
ALT_STATUS
(
nullable: true, length: 50, alias: ALT_STATUS, type: esriFieldTypeString
, Coded Values:
[CLEAN: CLEAN]
, [NOT CLEAN: NOT CLEAN]
, [BROKEN: BROKEN]
)
-
ALT_CREW
(
nullable: true, length: 50, alias: ALT_CREW, type: esriFieldTypeString
, Coded Values:
[JOSH AMOS: JOSH AMOS]
, [KURT JOSEPH: KURT JOSEPH]
, [BRETT ABKE: BRETT ABKE]
, ...16 more...
)
-
ALT_DATE
(
nullable: true, length: 8, alias: ALT_DATE, type: esriFieldTypeDate
)
-
ALT_NOTES
(
nullable: true, length: 150, alias: ALT_NOTES, type: esriFieldTypeString
)
-
LEAD
(
nullable: true, length: 150, alias: LEAD, type: esriFieldTypeString
)
-
VALVENEAR
(
nullable: true, length: 50, alias: VALVENEAR, type: esriFieldTypeString
, Coded Values:
[GRASS: GRASS]
, [CONCRETE: CONCRETE]
, [ASPHALT: ASPHALT]
)
-
elementsGUID
(
nullable: true, length: 38, alias: elementsGUID, type: esriFieldTypeGUID
)
-
SHAPE
(
nullable: true, alias: SHAPE, type: esriFieldTypeGeometry
)
-
accountid
(
nullable: true, length: 50, alias: accountid, type: esriFieldTypeString
)
-
address
(
nullable: true, length: 50, alias: address, type: esriFieldTypeString
)
-
location
(
nullable: true, length: 50, alias: location, type: esriFieldTypeString
)
-
utilassetid
(
nullable: true, length: 50, alias: utilassetid, type: esriFieldTypeString
)
-
utilnotes
(
nullable: true, length: 50, alias: utilnotes, type: esriFieldTypeString
)
-
custassetid
(
nullable: true, length: 50, alias: custassetid, type: esriFieldTypeString
)
-
custnotes
(
nullable: true, length: 50, alias: custnotes, type: esriFieldTypeString
)
-
otherfittings
(
nullable: true, length: 50, alias: otherfittings, type: esriFieldTypeString
)
-
sensitivepop
(
nullable: true, length: 50, alias: sensitivepop, type: esriFieldTypeString
, Coded Values:
[Yes - School: Yes - School]
, [Yes - Day Care: Yes - Day Care]
, [Yes - Other: Yes - Other]
, ...1 more...
)
-
disadvantaged
(
nullable: true, length: 50, alias: disadvantaged, type: esriFieldTypeString
, Coded Values:
[Yes: Yes]
, [No: No]
, [Unknown: Unknown]
)
-
utilmaterial
(
nullable: true, length: 50, alias: utilmaterial, type: esriFieldTypeString
, Coded Values:
[Unknown - Material Unknown: Unknown - Material Unknown]
, [Unknown - Likely Lead: Unknown - Likely Lead]
, [Unknown - Unlikely Lead: Unknown - Unlikely Lead]
, ...6 more...
)
-
everlead
(
nullable: true, length: 50, alias: everlead, type: esriFieldTypeString
, Coded Values:
[Yes: Yes]
, [No: No]
, [Unknown: Unknown]
)
-
utildiameter
(
nullable: true, length: 50, alias: utildiameter, type: esriFieldTypeString
, Coded Values:
[0: 0]
, [0.5: 0.5]
, [0.75: 0.75]
, ...13 more...
)
-
utilsource
(
nullable: true, length: 50, alias: utilsource, type: esriFieldTypeString
, Coded Values:
[Installation record (e.g., tap card): Installation record (e.g., tap card)]
, [Water sampling only with no records: Water sampling only with no records]
, [Field inspection only with no records: Field inspection only with no records]
, ...6 more...
)
-
utilverified
(
nullable: true, length: 50, alias: utilverified, type: esriFieldTypeString
, Coded Values:
[Yes: Yes]
, [No: No]
, [Unknown: Unknown]
)
-
utilverifmethod
(
nullable: true, length: 50, alias: utilverifmethod, type: esriFieldTypeString
, Coded Values:
[Visual inspection at meter pit: Visual inspection at meter pit]
, [Customer self-identification: Customer self-identification]
, [CCTV Inspection at Curb Box - Internal: CCTV Inspection at Curb Box - Internal]
, ...7 more...
)
-
custmaterial
(
nullable: true, length: 50, alias: custmaterial, type: esriFieldTypeString
, Coded Values:
[Unknown - Material Unknown: Unknown - Material Unknown]
, [Unknown - Likely Lead: Unknown - Likely Lead]
, [Unknown - Unlikely Lead: Unknown - Unlikely Lead]
, ...6 more...
)
-
custdiameter
(
nullable: true, length: 50, alias: custdiameter, type: esriFieldTypeString
, Coded Values:
[0: 0]
, [0.5: 0.5]
, [0.75: 0.75]
, ...13 more...
)
-
custsource
(
nullable: true, length: 50, alias: custsource, type: esriFieldTypeString
, Coded Values:
[Installation record (e.g., tap card): Installation record (e.g., tap card)]
, [Water sampling only with no records: Water sampling only with no records]
, [Field inspection only with no records: Field inspection only with no records]
, ...6 more...
)
-
custverified
(
nullable: true, length: 50, alias: custverified, type: esriFieldTypeString
, Coded Values:
[Yes: Yes]
, [No: No]
, [Unknown: Unknown]
)
-
custverifmethod
(
nullable: true, length: 50, alias: custverifmethod, type: esriFieldTypeString
, Coded Values:
[Visual inspection at meter pit: Visual inspection at meter pit]
, [Customer self-identification: Customer self-identification]
, [CCTV Inspection at Curb Box - Internal: CCTV Inspection at Curb Box - Internal]
, ...7 more...
)
-
bothsidesstatus
(
nullable: true, length: 50, alias: bothsidesstatus, type: esriFieldTypeString
, Coded Values:
[Unknown: Unknown]
, [Lead: Lead]
, [Non-Lead: Non-Lead]
, ...1 more...
)
-
leadconnector
(
nullable: true, length: 50, alias: leadconnector, type: esriFieldTypeString
, Coded Values:
[Yes: Yes]
, [No: No]
, [Unknown: Unknown]
)
-
leadsolder
(
nullable: true, length: 50, alias: leadsolder, type: esriFieldTypeString
, Coded Values:
[Yes: Yes]
, [No: No]
, [Unknown: Unknown]
)
-
buildingtype
(
nullable: true, length: 50, alias: buildingtype, type: esriFieldTypeString
, Coded Values:
[Single Family Residence: Single Family Residence]
, [Multiple Family Residence: Multiple Family Residence]
, [Building: Building]
, ...1 more...
)
-
pointofentry
(
nullable: true, length: 50, alias: pointofentry, type: esriFieldTypeString
, Coded Values:
[Yes: Yes]
, [No: No]
, [Unknown: Unknown]
)
-
copperwithlead
(
nullable: true, length: 50, alias: copperwithlead, type: esriFieldTypeString
, Coded Values:
[Yes: Yes]
, [No: No]
, [Unknown: Unknown]
)
-
samplingsite
(
nullable: true, length: 50, alias: samplingsite, type: esriFieldTypeString
, Coded Values:
[Yes: Yes]
, [No: No]
, [Unknown: Unknown]
)
-
replacestatus
(
nullable: true, length: 50, alias: replacestatus, type: esriFieldTypeString
, Coded Values:
[Doesn't Need Replacement: Doesn't Need Replacement]
, [Needs Replacement: Needs Replacement]
, [Scheduled Replacement: Scheduled Replacement]
, ...1 more...
)
-
replacereason
(
nullable: true, length: 50, alias: replacereason, type: esriFieldTypeString
, Coded Values:
[Lead: Lead]
, [Other: Other]
)
-
custnotified
(
nullable: true, length: 50, alias: custnotified, type: esriFieldTypeString
, Coded Values:
[Yes: Yes]
, [No: No]
, [Unknown: Unknown]
)
-
customermaterialrandom
(
nullable: true, length: 50, alias: customermaterialrandom, type: esriFieldTypeString
, Coded Values:
[Unknown - Material Unknown: Unknown - Material Unknown]
, [Unknown - Likely Lead: Unknown - Likely Lead]
, [Unknown - Unlikely Lead: Unknown - Unlikely Lead]
, ...6 more...
)
-
utilitymaterialrandom
(
nullable: true, length: 50, alias: utilitymaterialrandom, type: esriFieldTypeString
, Coded Values:
[Unknown - Material Unknown: Unknown - Material Unknown]
, [Unknown - Likely Lead: Unknown - Likely Lead]
, [Unknown - Unlikely Lead: Unknown - Unlikely Lead]
, ...6 more...
)
-
customerstatusrandom
(
nullable: true, length: 50, alias: customerstatusrandom, type: esriFieldTypeString
, Coded Values:
[0 - Unknown: 0 - Unknown]
, [1 - Lead: 1 - Lead]
, [2 - Non-Lead: 2 - Non-Lead]
, ...1 more...
)
-
utilitystatusrandom
(
nullable: true, length: 50, alias: utilitystatusrandom, type: esriFieldTypeString
, Coded Values:
[0 - Unknown: 0 - Unknown]
, [1 - Lead: 1 - Lead]
, [2 - Non-Lead: 2 - Non-Lead]
, ...1 more...
)
-
buildplumbmaterial
(
nullable: true, length: 50, alias: buildplumbmaterial, type: esriFieldTypeString
, Coded Values:
[Unknown - Material Unknown: Unknown - Material Unknown]
, [Unknown - Likely Lead: Unknown - Likely Lead]
, [Unknown - Unlikely Lead: Unknown - Unlikely Lead]
, ...6 more...
)
-
customersphoto
(
nullable: true, length: 50, alias: customersphoto, type: esriFieldTypeString
)
-
utilityphoto
(
nullable: true, length: 50, alias: utilityphoto, type: esriFieldTypeString
)
-
buildplumbphoto
(
nullable: true, length: 50, alias: buildplumbphoto, type: esriFieldTypeString
)
-
customersrandomphoto
(
nullable: true, length: 50, alias: customersrandomphoto, type: esriFieldTypeString
)
-
utilityrandomphoto
(
nullable: true, length: 50, alias: utilityrandomphoto, type: esriFieldTypeString
)
-
utilstatus
(
nullable: true, alias: utilstatus, type: esriFieldTypeSmallInteger
, Coded Values:
[0: Unknown]
, [1: Lead]
, [2: Non-Lead]
, ...1 more...
)
-
custstatus
(
nullable: true, alias: custstatus, type: esriFieldTypeSmallInteger
, Coded Values:
[0: Unknown]
, [1: Lead]
, [2: Non-Lead]
, ...1 more...
)
-
yearstructbuilt
(
nullable: true, alias: yearstructbuilt, type: esriFieldTypeSmallInteger
)
-
randomselection
(
nullable: true, alias: randomselection, type: esriFieldTypeSmallInteger
)
-
utilinstalldate
(
nullable: true, length: 8, alias: utilinstalldate, type: esriFieldTypeDate
)
-
utilverifdate
(
nullable: true, length: 8, alias: utilverifdate, type: esriFieldTypeDate
)
-
custinstalldate
(
nullable: true, length: 8, alias: custinstalldate, type: esriFieldTypeDate
)
-
custverifdate
(
nullable: true, length: 8, alias: custverifdate, type: esriFieldTypeDate
)
-
scheddate
(
nullable: true, length: 8, alias: scheddate, type: esriFieldTypeDate
)
-
utilreplacedate
(
nullable: true, length: 8, alias: utilreplacedate, type: esriFieldTypeDate
)
-
custscheddate
(
nullable: true, length: 8, alias: custscheddate, type: esriFieldTypeDate
)
-
custreplacedate
(
nullable: true, length: 8, alias: custreplacedate, type: esriFieldTypeDate
)
-
notifydate
(
nullable: true, length: 8, alias: notifydate, type: esriFieldTypeDate
)
-
randomcollectiondate
(
nullable: true, length: 8, alias: randomcollectiondate, type: esriFieldTypeDate
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata