Name: Water Main (16" & Larger)

Display Field: CREATNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This water feature class contains information gathered from DCWater's counter map system, as-built and as-lay sketches, and as-built CAD drawings for pressure mains within the water system. Pressurized Mains are the most common type of water main that will be captured. They convey water that has been pressurized. The geographic area covered by this dataset is Washington, D.C. The data set is updated on a daily basis.

Copyright Text: DC Water, Department of Engineering and Technical Services, GIS Asset Mapping Group, gisedits@dcwater.com

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0.0

Max Scale: 0.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: 136188.472
YMin: 126903.59
XMax: 407838.326
YMax: 149426.937
Spatial Reference: 26985  (26985)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PRESRZON
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Low
  Label: Low
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Value: Ana-1st
  Label: Ana-1st
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 85, 0, 255]
  Width: 2
• Value: Ana-2nd
  Label: Ana-2nd
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 2
• Value: Ana-3rd
  Label: Ana-3rd
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [168, 168, 0, 255]
  Width: 2
• Value: 1st
  Label: 1st
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [168, 0, 0, 255]
  Width: 2
• Value: 2nd
  Label: 2nd
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [51, 161, 122, 255]
  Width: 2
• Value: 3rd
  Label: 3rd
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [168, 168, 0, 255]
  Width: 2
• Value: 4thReno
  Label: 4thReno
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [115, 38, 0, 255]
  Width: 2
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUBTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Subtype )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• FLOWTYPE ( type: esriFieldTypeString, alias: Water Type, length: 16 , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...6 more... )
• OWNER ( type: esriFieldTypeString, alias: Owner, length: 16 , Coded Values: [WSSC: WSSC] , [NPS: National Park Service] , [NRL: Naval Research Lab] , ...34 more... )
• LIFECYCLESTATS ( type: esriFieldTypeString, alias: Lifecycle Status, length: 16 , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...2 more... )
• JOBNUM ( type: esriFieldTypeString, alias: JOBNUM, length: 16 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• PRESRZON ( type: esriFieldTypeString, alias: Pressure Zone, length: 18 , Coded Values: [1st: 1st Hi/Soldiers Home/246'-249'] , [1st/2nd: 1st/2nd] , [2nd: 2nd Hi/Van Ness/325'-331'] , ...18 more... )
• FLUSHZON ( type: esriFieldTypeString, alias: Flushing Zone, length: 10 , Coded Values: [L-11: L-11] , [L-12: L-12] , [L-13: L-13] , ...260 more... )
• QUAD ( type: esriFieldTypeString, alias: Quadrant, length: 16 , Coded Values: [NW: NW] , [NE: NE] , [SW: SW] , ...3 more... )
• WARD ( type: esriFieldTypeString, alias: Ward, length: 1 , Coded Values: [1: Ward 1] , [2: Ward 2] , [3: Ward 3] , ...5 more... )
• DIAMT ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...35 more... )
• ISOUTDIA ( type: esriFieldTypeString, alias: Is Outside Diameter?, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• MAXDIA ( type: esriFieldTypeDouble, alias: Maximum Diameter , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...35 more... )
• MODELDIA ( type: esriFieldTypeDouble, alias: Model Diameter , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...35 more... )
• MATRL ( type: esriFieldTypeString, alias: Material, length: 16 , Coded Values: [DI: Ductile Iron] , [CI: Cast Iron] , [Concrete: Concrete] , ...15 more... )
• PIPECLAS ( type: esriFieldTypeString, alias: Pipe Class, length: 16 )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH )
• LENST ( type: esriFieldTypeString, alias: Length Status, length: 16 , Coded Values: [Estimated: Estimated] , [AsBuilt: Records - As-Built] , [Field: Field Verified] , ...4 more... )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH )
• RELTVVERTCPOSTN ( type: esriFieldTypeString, alias: Relative Vertical Positioning, length: 18 , Coded Values: [Normal: Normal] , [Elevated: Elevated] , [Subterranean: Subterranean] )
• ELEVT ( type: esriFieldTypeDouble, alias: Elevation )
• VERTICALDATUM ( type: esriFieldTypeString, alias: VERTICALDATUM, length: 6 , Coded Values: [NAVD88: NAVD88] , [UNK: Unknown] , [DC: DCDPW] , ...1 more... )
• ROUGHNES ( type: esriFieldTypeDouble, alias: Roughness )
• ROUGHSRC ( type: esriFieldTypeString, alias: Roughness Source, length: 16 , Coded Values: [Mfr: Pipe Manufacturer] , [FlowTest: Flow Test] , [Age: Approximate by Age] , ...2 more... )
• MINRLOSS ( type: esriFieldTypeDouble, alias: Minor Loss )
• LINRTY ( type: esriFieldTypeString, alias: Liner Type, length: 16 , Coded Values: [Unlined: Unlined] , [Epoxy: Epoxy] , [Unk: Unknown] , ...13 more... )
• LINRDT ( type: esriFieldTypeDate, alias: Liner Date, length: 8 )
• LINJOBNO ( type: esriFieldTypeString, alias: Liner Job No, length: 16 )
• OFFVALUE ( type: esriFieldTypeDouble, alias: Offset Value )
• OFFREFRC ( type: esriFieldTypeString, alias: Offset Reference, length: 16 , Coded Values: [Approx: Approximate] , [CL: CenterLine] , [ROW: Right Of Way] , ...3 more... )
• ISTOPLGARTEF ( type: esriFieldTypeString, alias: Is Topology Artefact?, length: 16 , Coded Values: [Y: Yes] , [N: No] )
• JOINTYP1 ( type: esriFieldTypeString, alias: Joint Type 1, length: 16 , Coded Values: [Flanged: Flanged] , [Solder: Solder] , [Threaded: Threaded] , ...14 more... )
• JOINTYP2 ( type: esriFieldTypeString, alias: Joint Type 2, length: 16 , Coded Values: [Flanged: Flanged] , [Solder: Solder] , [Threaded: Threaded] , ...14 more... )
• EXTCOATN ( type: esriFieldTypeString, alias: Exterior Coating, length: 16 , Coded Values: [UnCtd: Uncoated] , [Asph: Asphaltic] , [CurUrthn: Moisture-Cured Urethane Primer] , ...7 more... )
• CORCONTY ( type: esriFieldTypeString, alias: Corrosion Control Type, length: 16 , Coded Values: [None: None] , [Cath: Cathodic] , [ExtCoat: Exterior Coating] , ...2 more... )
• SOILTY ( type: esriFieldTypeString, alias: Soil Type, length: 16 , Coded Values: [GW: GW] , [GP: GP] , [SW: SW] , ...12 more... )
• SURFTY ( type: esriFieldTypeString, alias: Ground Surface Type, length: 16 , Coded Values: [Unk: Unknown] , [Concrete: Concrete] , [Asphalt: Asphalt] , ...4 more... )
• NBCUS ( type: esriFieldTypeInteger, alias: Number of customers )
• NBCRICUS ( type: esriFieldTypeInteger, alias: Number of Critical customers )
• SPECREF ( type: esriFieldTypeString, alias: Pipe Spec Reference, length: 20 )
• WIRECLAS ( type: esriFieldTypeString, alias: Wire Class, length: 20 )
• LAYSCHED ( type: esriFieldTypeString, alias: Lay Schedule Reference, length: 20 )
• FROMNODE ( type: esriFieldTypeString, alias: FROMNODE, length: 18 )
• TONODE ( type: esriFieldTypeString, alias: TONODE, length: 18 )
• COMNT ( type: esriFieldTypeString, alias: Comment, length: 100 )
• INFORSRC ( type: esriFieldTypeInteger, alias: Information Source , Coded Values: [1: Records - As Built] , [2: Records - Plans] , [3: Field] , ...8 more... )
• LOCTNPRECS ( type: esriFieldTypeInteger, alias: Location Precision , Coded Values: [1: Records - As Built] , [2: Records - Plans] , [3: Field Survey] , ...11 more... )
• SECRTCOD ( type: esriFieldTypeString, alias: Security Code, length: 10 )
• CRITCCOD ( type: esriFieldTypeString, alias: Criticality Code, length: 10 )
• VULNRCOD ( type: esriFieldTypeString, alias: Vulnerability Code, length: 10 )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 200 )
• LOCATIONDETAIL ( type: esriFieldTypeString, alias: LocationDetail, length: 254 )
• ASSETTAG ( type: esriFieldTypeString, alias: Asset Tag, length: 64 )
• LEGACYID ( type: esriFieldTypeString, alias: Old Valve ID, length: 25 )
• USNGPREFIX ( type: esriFieldTypeString, alias: USNGPREFIX, length: 5 )
• DISPLAYID ( type: esriFieldTypeString, alias: DISPLAYID, length: 15 )
• MXSITEID ( type: esriFieldTypeString, alias: MXSITEID, length: 8 )
• MXASSETNUM ( type: esriFieldTypeString, alias: MXASSETNUM, length: 18 )
• CHANGEBY ( type: esriFieldTypeString, alias: CHANGEBY, length: 18 )
• CHANGEDATE ( type: esriFieldTypeDate, alias: CHANGEDATE, length: 8 )
• CREATNAME ( type: esriFieldTypeString, alias: CREATNAME, length: 60 )
• CREATDATE ( type: esriFieldTypeDate, alias: CREATDATE, length: 8 )
• EDITNAME ( type: esriFieldTypeString, alias: EDITNAME, length: 60 )
• EDITDATE ( type: esriFieldTypeDate, alias: EDITDATE, length: 8 )
• INCASNG ( type: esriFieldTypeString, alias: In Casing?, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• BRIDGCROSN ( type: esriFieldTypeString, alias: Water Main on Bridge?, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• GEOWORXSYNCID ( type: esriFieldTypeString, alias: GEOWORXSYNCID, length: 12 )
• INTRNREPRTY ( type: esriFieldTypeString, alias: Internal Repair Type, length: 18 , Coded Values: [None: None] , [JointSeal: Internal Joint Seal] , [CFRP: Carbon Fiber Wrap (CFRP)] , ...2 more... )
• INTRNREPRJOBNO ( type: esriFieldTypeString, alias: Internal Repair Job No, length: 50 )
• INTRNREPRDT ( type: esriFieldTypeDate, alias: INTRNREPRDT, length: 8 )
• INTCORR ( type: esriFieldTypeString, alias: Internal Corrosion, length: 25 , Coded Values: [1: 1 - Clear] , [2: 2 - Some] , [3: 3 - Heavy] )
• COF_SCORE ( type: esriFieldTypeString, alias: Consequence of Failure Score, length: 25 , Coded Values: [1: Negligible] , [3: Low] , [5: Moderate] , ...2 more... )
• COF_SCORE_DATE ( type: esriFieldTypeDate, alias: Consequence of Failure Score Date, length: 8 )
• LOF_SCORE ( type: esriFieldTypeString, alias: Likelihood of Failure Score, length: 25 , Coded Values: [1: Negligible] , [3: Low] , [5: Moderate] , ...2 more... )
• LOF_SCORE_DATE ( type: esriFieldTypeDate, alias: Likelihood of Failure Score Date, length: 8 )
• ROF_SCORE ( type: esriFieldTypeString, alias: Risk of Failure Score, length: 25 )
• ROF_SCORE_DATE ( type: esriFieldTypeDate, alias: Risk of Failure Score Date, length: 8 )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, length: 8 , Coded Values: [7821: EDDINGTON INDUSTRIES LLC] , [A001: A. K. INDUSTRIES INC.] , [A002: A.M.F. CUNO DIV.] , ...1962 more... )
• LOCTNCODE ( type: esriFieldTypeString, alias: Location Code, length: 25 , Coded Values: [A: A - Primary Major Arterial Road] , [B: B - Secondary Road] , [C: C - Local/Rural Street] , ...25 more... )
• SCHEDRESTR ( type: esriFieldTypeString, alias: Scheduling Restrictions, length: 25 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• PROPREHABJOBNUM ( type: esriFieldTypeString, alias: PROPREHABJOBNUM, length: 50 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Types:

ID: 1
Name: DistributionMain
Domains:
• ENABLED:
  Inherited
• FLOWTYPE:
  Inherited
• OWNER:
  Inherited
• LIFECYCLESTATS:
  Inherited
• PRESRZON:
  Inherited
• FLUSHZON:
  Inherited
• QUAD:
  Inherited
• WARD:
  Inherited
• DIAMT:
  Inherited
• ISOUTDIA:
  Inherited
• MAXDIA:
  Inherited
• MODELDIA:
  Inherited
• MATRL:
  Inherited
• PIPECLAS:
  Coded Values: [CI_CFG: CI - Centrifigual Cast] , [CI_PIT: CI - Pit Cast] , [DI_PC150: DI - Pressure Class 150] , ...35 more...
• LENST:
  Inherited
• RELTVVERTCPOSTN:
  Inherited
• VERTICALDATUM:
  Inherited
• ROUGHSRC:
  Inherited
• LINRTY:
  Inherited
• OFFREFRC:
  Inherited
• ISTOPLGARTEF:
  Inherited
• JOINTYP1:
  Inherited
• JOINTYP2:
  Inherited
• EXTCOATN:
  Inherited
• CORCONTY:
  Inherited
• SOILTY:
  Inherited
• SURFTY:
  Inherited
• WIRECLAS:
  Coded Values: [1: Class I] , [2: Class II] , [3: Class III] , ...2 more...
• INFORSRC:
  Inherited
• LOCTNPRECS:
  Inherited
• INCASNG:
  Inherited
• BRIDGCROSN:
  Inherited
• INTRNREPRTY:
  Inherited
• INTCORR:
  Inherited
• COF_SCORE:
  Inherited
• LOF_SCORE:
  Inherited
• MANUFACTURER:
  Inherited
• LOCTNCODE:
  Inherited

---

ID: 2
Name: TransmissionMain
Domains:
• ENABLED:
  Inherited
• FLOWTYPE:
  Inherited
• OWNER:
  Inherited
• LIFECYCLESTATS:
  Inherited
• PRESRZON:
  Inherited
• FLUSHZON:
  Inherited
• QUAD:
  Inherited
• WARD:
  Inherited
• DIAMT:
  Inherited
• ISOUTDIA:
  Inherited
• MAXDIA:
  Inherited
• MODELDIA:
  Inherited
• MATRL:
  Inherited
• PIPECLAS:
  Coded Values: [CI_CFG: CI - Centrifigual Cast] , [CI_PIT: CI - Pit Cast] , [DI_PC150: DI - Pressure Class 150] , ...35 more...
• LENST:
  Inherited
• RELTVVERTCPOSTN:
  Inherited
• VERTICALDATUM:
  Inherited
• ROUGHSRC:
  Inherited
• LINRTY:
  Inherited
• OFFREFRC:
  Inherited
• ISTOPLGARTEF:
  Inherited
• JOINTYP1:
  Inherited
• JOINTYP2:
  Inherited
• EXTCOATN:
  Inherited
• CORCONTY:
  Inherited
• SOILTY:
  Inherited
• SURFTY:
  Inherited
• WIRECLAS:
  Coded Values: [1: Class I] , [2: Class II] , [3: Class III] , ...2 more...
• INFORSRC:
  Inherited
• LOCTNPRECS:
  Inherited
• INCASNG:
  Inherited
• BRIDGCROSN:
  Inherited
• INTRNREPRTY:
  Inherited
• INTCORR:
  Inherited
• COF_SCORE:
  Inherited
• LOF_SCORE:
  Inherited
• MANUFACTURER:
  Inherited
• LOCTNCODE:
  Inherited

---

ID: 3
Name: Interconnect
Domains:
• ENABLED:
  Inherited
• FLOWTYPE:
  Inherited
• OWNER:
  Inherited
• LIFECYCLESTATS:
  Inherited
• PRESRZON:
  Inherited
• FLUSHZON:
  Inherited
• QUAD:
  Inherited
• WARD:
  Inherited
• DIAMT:
  Inherited
• ISOUTDIA:
  Inherited
• MAXDIA:
  Inherited
• MODELDIA:
  Inherited
• MATRL:
  Inherited
• PIPECLAS:
  Coded Values: [CI_CFG: CI - Centrifigual Cast] , [CI_PIT: CI - Pit Cast] , [DI_PC150: DI - Pressure Class 150] , ...35 more...
• LENST:
  Inherited
• RELTVVERTCPOSTN:
  Inherited
• VERTICALDATUM:
  Inherited
• ROUGHSRC:
  Inherited
• LINRTY:
  Inherited
• OFFREFRC:
  Inherited
• ISTOPLGARTEF:
  Inherited
• JOINTYP1:
  Inherited
• JOINTYP2:
  Inherited
• EXTCOATN:
  Inherited
• CORCONTY:
  Inherited
• SOILTY:
  Inherited
• SURFTY:
  Inherited
• WIRECLAS:
  Coded Values: [1: Class I] , [2: Class II] , [3: Class III] , ...2 more...
• INFORSRC:
  Inherited
• LOCTNPRECS:
  Inherited
• INCASNG:
  Inherited
• BRIDGCROSN:
  Inherited
• INTRNREPRTY:
  Inherited
• INTCORR:
  Inherited
• COF_SCORE:
  Inherited
• LOF_SCORE:
  Inherited
• MANUFACTURER:
  Inherited
• LOCTNCODE:
  Inherited

---

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata