Name: Pressure Main

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

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 389878.737
YMin: 126903.59
XMax: 407838.326
YMax: 147484.335
Spatial Reference: 26985 (26985)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[140,140,140,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

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

Templates:

Name: Pressure Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SUBTYPE: 1
• ENABLED: 1
• RELTVVERTCPOSTN: Normal
• INCASNG: N
• BRIDGCROSN: N

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/4/2026 2:08:29 PM

Schema Last Edit Date: 6/4/2026 2:08:29 PM

Data Last Edit Date: 6/4/2026 2:08:29 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat