Name: pubcofgis.DBO.PWCWaterMains

Display Field: CREATIONUSER

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 100000

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: 1973443.9035938084
YMin: 422484.5561427325
XMax: 2103400.472748384
YMax: 527978.8464660645
Spatial Reference: 102719  (2264)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 92, 230, 255]
Width: 1
Label:
Description:
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: SubtypeCD

Fields:

• ENABLED ( type: esriFieldTypeInteger, alias: ENABLED , Coded Values: [0: False] , [1: True] )
• LASTUSER ( type: esriFieldTypeString, alias: LASTUSER, length: 20 )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 20 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 25 )
• LEGACYID ( type: esriFieldTypeString, alias: LEGACYID, length: 20 )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, length: 20 )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SUBTYPECD )
• WATERTYPE ( type: esriFieldTypeString, alias: WATERTYPE, length: 5 , Coded Values: [POT: Potable Water] , [NOP: Non-Potable] )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 5 , Coded Values: [DI: Ductile Iron] , [CI: Cast Iron] , [PVC: Poly Vinyl Chloride] , ...24 more... )
• ENGINEER ( type: esriFieldTypeString, alias: ENGINEER, length: 20 )
• CONTRACTOR ( type: esriFieldTypeString, alias: CONTRACTOR, length: 20 )
• FLUSHZONE ( type: esriFieldTypeInteger, alias: FLUSHZONE )
• FLUSHLOOP ( type: esriFieldTypeInteger, alias: FLUSHLOOP )
• FLUSHZONE2 ( type: esriFieldTypeInteger, alias: FLUSHZONE2 )
• FLUSHLOOP2 ( type: esriFieldTypeInteger, alias: FLUSHLOOP2 )
• EXPOSED ( type: esriFieldTypeInteger, alias: EXPOSED )
• LININGTYPE ( type: esriFieldTypeString, alias: LININGTYPE, length: 20 )
• PIPECLASS ( type: esriFieldTypeString, alias: PIPECLASS, length: 20 )
• ROUGHNESS ( type: esriFieldTypeDouble, alias: ROUGHNESS )
• CFACTOR ( type: esriFieldTypeString, alias: CFACTOR, length: 20 )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION )
• DEPTH ( type: esriFieldTypeInteger, alias: DEPTH )
• DIAMETER ( type: esriFieldTypeDouble, alias: DIAMETER , Coded Values: [0.75: 3/4 inch] , [1: 1 inch] , [1.5: 1.5 inch] , ...25 more... )
• SLOPE ( type: esriFieldTypeDouble, alias: SLOPE )
• DESIGNID ( type: esriFieldTypeString, alias: DESIGNID, length: 20 )
• JOINID ( type: esriFieldTypeString, alias: JOINID, length: 20 )
• PIPETYPE ( type: esriFieldTypeString, alias: PIPETYPE, length: 5 , Coded Values: [P: Pinchable] , [NP: Non-Pinchable] )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 5 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 30 )
• MAINDEPTH ( type: esriFieldTypeDouble, alias: MAINDEPTH )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 20 , Coded Values: [PWC: PWC] , [HOKE CO.: HOKE CO.] , [STEDMAN: STEDMAN] , ...5 more... )
• REHABYEAR ( type: esriFieldTypeDouble, alias: REHABYEAR )
• SYNERGENID ( type: esriFieldTypeString, alias: SYNERGENID, length: 50 )
• WAM_ID ( type: esriFieldTypeString, alias: WAM_ID, length: 255 )
• WAM_ID2 ( type: esriFieldTypeString, alias: WAM_ID2, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CREATIONUSER ( type: esriFieldTypeString, alias: Creation User, length: 20 )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: WARRANTYDATE, length: 8 )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: CONDITIONDATE, length: 8 )
• ADMINISTRATIVEAREA ( type: esriFieldTypeString, alias: Administrative Area, length: 5 , Coded Values: [N: North] , [S: South] , [E: East] , ...3 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Lifecycle Status, length: 5 , Coded Values: [PROP: Proposed] , [ACT: Active] , [ABN: Abandoned] , ...1 more... )
• WORKORDERID ( type: esriFieldTypeString, alias: Work Order ID, length: 20 )
• DRAWINGNUMBER ( type: esriFieldTypeString, alias: DRAWINGNUMBER, length: 20 )
• PROJECTNUMBER ( type: esriFieldTypeString, alias: PROJECTNUMBER, length: 20 )
• EXTERIORCOATING ( type: esriFieldTypeString, alias: Exterior Coating, length: 20 )
• GROUNDSURFACETYPE ( type: esriFieldTypeString, alias: Ground Surface Type, length: 20 )
• PRESSURERATING ( type: esriFieldTypeString, alias: Pressure Rating, length: 20 )
• WORKREQUESTID ( type: esriFieldTypeString, alias: Work Request ID, length: 20 )
• WORKLOCATIONID ( type: esriFieldTypeString, alias: Work Location ID, length: 20 )
• WORKFLOWSTATUS ( type: esriFieldTypeInteger, alias: Work Flow Status , Coded Values: [0: None] , [1: Design] , [2: Approval] , ...5 more... )
• WORKFUNCTION ( type: esriFieldTypeInteger, alias: Work Function , Coded Values: [0: None] , [1: Install] , [-10: Replace] , ...5 more... )
• BONDEDINDICATOR ( type: esriFieldTypeString, alias: BondedIndicator, length: 5 , Coded Values: [Y: Yes] , [N: No] )
• CPSYSTEMOBJECTID ( type: esriFieldTypeInteger, alias: CPSYSTEMOBJECTID )
• CPSYSTEMSTATUS ( type: esriFieldTypeInteger, alias: CPSystemStatus , Coded Values: [0: Closed] , [1: Open] )
• MEASUREDLENGTH ( type: esriFieldTypeDouble, alias: MEASUREDLENGTH )
• PIPESTATUSINDICATOR ( type: esriFieldTypeInteger, alias: PipeStatusIndicator , Coded Values: [0: Closed] , [1: Open] )
• WATERTRACEWEIGHT ( type: esriFieldTypeInteger, alias: WATERTRACEWEIGHT )
• OPERATIONALAREA ( type: esriFieldTypeString, alias: Operational Area, length: 5 )
• OUTERDIAMETER ( type: esriFieldTypeDouble, alias: OUTERDIAMETER )
• PRESSUREZONE ( type: esriFieldTypeString, alias: PRESSURE ZONE, length: 50 , Coded Values: [High: High Zone] , [Low: Low Zone] , [Cypress Lakes: Cypress Lakes Zone] , ...4 more... )
• APRXINSTALLDATE ( type: esriFieldTypeDate, alias: APRXINSTALLDATE, length: 8 )
• PRESPLITWAM_ID ( type: esriFieldTypeString, alias: PRESPLITWAM_ID, length: 255 )

Types:

ID: 7
Name: pRawWater
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• WATERTYPE:
  Inherited
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• BONDEDINDICATOR:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• PIPESTATUSINDICATOR:
  Inherited
• PIPETYPE:
  Inherited
• OWNER:
  Inherited
• PRESSUREZONE:
  Inherited

---

ID: 6
Name: pAerialPipe
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• WATERTYPE:
  Inherited
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• BONDEDINDICATOR:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• PIPESTATUSINDICATOR:
  Inherited
• PIPETYPE:
  Inherited
• OWNER:
  Inherited
• PRESSUREZONE:
  Inherited

---

ID: 5
Name: pExposed Pipe
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• WATERTYPE:
  Inherited
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• BONDEDINDICATOR:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• PIPESTATUSINDICATOR:
  Inherited
• PIPETYPE:
  Inherited
• OWNER:
  Inherited
• PRESSUREZONE:
  Inherited

---

ID: 2
Name: pTransmission Main
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• WATERTYPE:
  Inherited
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• BONDEDINDICATOR:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• PIPESTATUSINDICATOR:
  Inherited
• PIPETYPE:
  Inherited
• OWNER:
  Inherited
• PRESSUREZONE:
  Inherited

---

ID: 4
Name: pInterconnect
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• WATERTYPE:
  Inherited
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• BONDEDINDICATOR:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• PIPESTATUSINDICATOR:
  Inherited
• PIPETYPE:
  Inherited
• OWNER:
  Inherited
• PRESSUREZONE:
  Inherited

---

ID: 3
Name: pDistribution Main
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• WATERTYPE:
  Inherited
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• BONDEDINDICATOR:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• PIPESTATUSINDICATOR:
  Inherited
• PIPETYPE:
  Inherited
• OWNER:
  Inherited
• PRESSUREZONE:
  Inherited

---

ID: 1
Name: pBypass
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• WATERTYPE:
  Inherited
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• BONDEDINDICATOR:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• PIPESTATUSINDICATOR:
  Inherited
• PIPETYPE:
  Inherited
• OWNER:
  Inherited
• PRESSUREZONE:
  Inherited

---

ID: 8
Name: Abandon
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• WATERTYPE:
  Inherited
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• BONDEDINDICATOR:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• PIPESTATUSINDICATOR:
  Inherited
• PIPETYPE:
  Inherited
• OWNER:
  Inherited
• PRESSUREZONE:
  Inherited

---

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata