Name: Pipe

Display Field: assettype

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 288896

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 7121868.82265855
YMin: 2090823.38691181
XMax: 7149154.71362472
YMax: 2141757.95531806
Spatial Reference: 103004 (6418)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"assettype","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,255,255],"width":2},"defaultLabel":"Other","uniqueValueGroups":[{"heading":"","classes":[{"label":"Unknown","description":"Unknown","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"values":[["0"]]},{"label":"Gravity","description":"Gravity","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,230,169,255],"width":2},"values":[["3"]]},{"label":"Force Main","description":"Force Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,168,132,255],"width":2},"values":[["4"]]},{"label":"Perforated","description":"Perforated","symbol":{"type":"esriSLS","style":"esriSLSDash","color":[0,230,169,255],"width":2},"values":[["5"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"value":"0","label":"Unknown"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,230,169,255],"width":2},"value":"3","label":"Gravity"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,168,132,255],"width":2},"value":"4","label":"Force Main"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[0,230,169,255],"width":2},"value":"5","label":"Perforated"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,209,252,255],"toColor":[204,209,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,252,182,255],"toColor":[204,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,205,179,255],"toColor":[252,205,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,247,255],"toColor":[187,252,247,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,192,221,255],"toColor":[252,192,221,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[225,182,252,255],"toColor":[225,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,246,192,255],"toColor":[252,246,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,229,252,255],"toColor":[182,229,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,252,215,255],"toColor":[215,252,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,185,255],"toColor":[252,184,185,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,218,255],"toColor":[252,215,218,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,242,255],"toColor":[252,182,242,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[233,202,252,255],"toColor":[233,202,252,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"domainName($feature, 'diameter') + \" \" + Trim(Split(domainName($feature, 'material'),'-')[-1])"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"stackSeparators":[{"separator":" "},{"separator":"-","visible":true}],"useCodedValues":true,"maxScale":0,"minScale":1500,"name":"Pipe Diameter/Type Labels","priority":-1,"symbol":{"type":"esriTS","color":[0,115,76,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ: true

HasM: true

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field: assettype

Fields:

• pwc (type: esriFieldTypeString, alias: PWC #, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• objectid (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• assettype (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [4: Force Main], [3: Gravity], ... 1 more ...)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [26: Vitrified Clay - VCP], [0: Unknown], [25: Steel - SP], ... 25 more ...)
• diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.75: 3/4"], ... 46 more ...)
• upelev (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• downelev (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 7 more ...)
• pipeshape (type: esriFieldTypeSmallInteger, alias: Pipe Shape, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Circular], [2: Horseshoe], ... 5 more ...)
• lined (type: esriFieldTypeSmallInteger, alias: Lined?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• lineryear (type: esriFieldTypeSmallInteger, alias: Liner Year, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1800 - 2060])
• linermethod (type: esriFieldTypeSmallInteger, alias: Liner Method, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Cured In Place - CIP], [2: Fold and Form or Deform/Reform - FF], ... 11 more ...)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other], ... 1 more ...)
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
• spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
• globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_date (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• created_user (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• linear_feet (type: esriFieldTypeDouble, alias: Linear Feet, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 0
Name: Unknown
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: pipeshape
  Inherited
  
• Field Name: lined
  Inherited
  
• Field Name: lineryear
  Inherited
  
• Field Name: linermethod
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
Templates:

Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 0
• lifecyclestatus: 0

---

ID: 3
Name: Gravity
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: pipeshape
  Inherited
  
• Field Name: lined
  Inherited
  
• Field Name: lineryear
  Inherited
  
• Field Name: linermethod
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
Templates:

Name: Gravity
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 3
• lifecyclestatus: 0

---

ID: 4
Name: Force Main
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: pipeshape
  Inherited
  
• Field Name: lined
  Inherited
  
• Field Name: lineryear
  Inherited
  
• Field Name: linermethod
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
Templates:

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

Attributes:

• assettype: 4
• lifecyclestatus: 0

---

ID: 5
Name: Perforated
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: pipeshape
  Inherited
  
• Field Name: lined
  Inherited
  
• Field Name: lineryear
  Inherited
  
• Field Name: linermethod
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
Templates:

Name: Perforated
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 5
• lifecyclestatus: 0

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/13/2025 5:55:28 PM

Schema Last Edit Date: 2/11/2025 4:21:06 PM

Data Last Edit Date: 2/11/2025 4:21:06 PM

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