Name: Pipes

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Polyline file representing all known sewer pipes in the City. Subtype Code defines Type.Sewer Pipe Subtype Codes0 Assumed Sanitary Pipe1 Assumed Storm Pipe2 Assumed Relief Pipe3 Assumed Combined Pipe4 Assumed Sanitary F/M5 Abandoned Sanitary6 Abandoned Storm7 Sanitary Overflow Pipe8 Storm Overflow Pipe9 Private Sanitary Pipe10 Private Storm Pipe11 Private Sanitary F/M12 Unassumed Sanitary Pipe13 Unassumed Storm Pipe14 Unassumed Sanitary F/M

Copyright Text: Jim House, X5594

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 468977.2681999998
YMin: 4745913.312100001
XMax: 490185.3364000004
YMax: 4767193.9494
Spatial Reference: 26917  (26917)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Subtype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [67, 0, 156, 255]
Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: 5
  Label: Abandoned Sanitary
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [153, 0, 153, 255]
  Width: 1
• Value: 6
  Label: Abandoned Storm
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 176, 41, 255]
  Width: 1
• Value: 3
  Label: CombinedPipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [138, 0, 83, 255]
  Width: 1
• Value: 11
  Label: PrivSanFM
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [168, 56, 0, 255]
  Width: 1
• Value: 9
  Label: PrivSanPipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [158, 58, 0, 255]
  Width: 1
• Value: 10
  Label: PrivStmPipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [117, 171, 0, 255]
  Width: 1
• Value: 2
  Label: ReliefPipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [156, 78, 0, 255]
  Width: 1
• Value: 7
  Label: San Overflow
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [138, 5, 0, 255]
  Width: 1
• Value: 4
  Label: SanFM
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 141, 145, 255]
  Width: 1
• Value: 0
  Label: SanPipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 29, 133, 255]
  Width: 1
• Value: 8
  Label: Stm Overflow
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [140, 0, 77, 255]
  Width: 1
• Value: 1
  Label: StmPipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [103, 176, 0, 255]
  Width: 1
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
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Subtype

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GIS_ID ( type: esriFieldTypeInteger, alias: GIS_ID )
• GIS_FeatureKey ( type: esriFieldTypeString, alias: GIS_FeatureKey, length: 10 )
• FlowType ( type: esriFieldTypeString, alias: FlowType, length: 5 , Coded Values: [SAN: Sanitary] , [STM: Storm] )
• StructureType ( type: esriFieldTypeString, alias: StructureType, length: 5 , Coded Values: [CAP: End Cap] , [CB: Catchbasin] , [CBM: Catchbasin Manhole] , ...25 more... )
• StreetName ( type: esriFieldTypeString, alias: StreetName, length: 25 )
• Location ( type: esriFieldTypeString, alias: Location, length: 20 , Coded Values: [Boulevard: Boulevard] , [Bridge: On or Under Bridge] , [Easement: Easement] , ...9 more... )
• UpstreamID ( type: esriFieldTypeString, alias: UpstreamID, length: 10 )
• UpstreamInventoryType ( type: esriFieldTypeString, alias: UpstreamInventoryType, length: 5 , Coded Values: [CAP: End Cap] , [CB: Catchbasin] , [CBM: Catchbasin Manhole] , ...25 more... )
• DownstreamID ( type: esriFieldTypeString, alias: DownstreamID, length: 10 )
• DownstreamInventoryType ( type: esriFieldTypeString, alias: DownstreamInventoryType, length: 5 , Coded Values: [CAP: End Cap] , [CB: Catchbasin] , [CBM: Catchbasin Manhole] , ...25 more... )
• Length ( type: esriFieldTypeDouble, alias: Length )
• PipeShape ( type: esriFieldTypeString, alias: PipeShape, length: 5 , Coded Values: [ARC: Arch] , [EGG: Egg Shaped] , [ELH: Horizontal Eliptical] , ...4 more... )
• Diameter ( type: esriFieldTypeSmallInteger, alias: Diameter , Range: [0, 5000] )
• Height ( type: esriFieldTypeDouble, alias: Height )
• Width ( type: esriFieldTypeDouble, alias: Width )
• Material ( type: esriFieldTypeString, alias: Material, length: 20 , Coded Values: [AC: Asbestos Cement] , [BRCK: Brick] , [CONC: Concrete] , ...12 more... )
• MaterialClass ( type: esriFieldTypeString, alias: MaterialClass, length: 20 , Coded Values: [?: Unknown] , [100-D: 100-D] , [12GA: 12 Gauge] , ...42 more... )
• Bedding ( type: esriFieldTypeString, alias: Bedding, length: 5 , Coded Values: [1: Type 1 - sand or granular] , [2: Type 2 - crushed stone] , [?: Unknown] , ...9 more... )
• UpstreamInvert ( type: esriFieldTypeDouble, alias: UpstreamInvert )
• DownstreamInvert ( type: esriFieldTypeDouble, alias: DownstreamInvert )
• DropStructureInvert ( type: esriFieldTypeDouble, alias: DropStructureInvert )
• Slope ( type: esriFieldTypeDouble, alias: Slope )
• AverageDepth ( type: esriFieldTypeDouble, alias: AverageDepth )
• MaximumDepth ( type: esriFieldTypeDouble, alias: MaximumDepth )
• PDC_Count ( type: esriFieldTypeDouble, alias: PDC_Count )
• ConstructionDate ( type: esriFieldTypeDate, alias: ConstructionDate, length: 8 )
• Ownership ( type: esriFieldTypeString, alias: Ownership, length: 5 , Coded Values: [CITY: Municipally Owned] , [PRIV: Privately Owned] , [OTH: Other Municipality] )
• DrawingNumber ( type: esriFieldTypeString, alias: DrawingNumber, length: 25 )
• Assumed ( type: esriFieldTypeSmallInteger, alias: Assumed , Coded Values: [1: Yes] , [0: No] )
• Combined ( type: esriFieldTypeSmallInteger, alias: Combined , Coded Values: [1: Yes] , [0: No] )
• Relief ( type: esriFieldTypeSmallInteger, alias: Relief , Coded Values: [1: Yes] , [0: No] )
• Trunk ( type: esriFieldTypeSmallInteger, alias: Trunk , Coded Values: [1: Yes] , [0: No] )
• LocationArea ( type: esriFieldTypeString, alias: LocationArea, length: 5 )
• CleanArea ( type: esriFieldTypeString, alias: CleanArea, length: 3 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 75 )
• Subtype ( type: esriFieldTypeSmallInteger, alias: Subtype )
• LastEditDate ( type: esriFieldTypeDate, alias: LastEditDate, length: 8 )
• LastEditor ( type: esriFieldTypeString, alias: LastEditor, length: 20 )
• Grouted ( type: esriFieldTypeSmallInteger, alias: Grouted , Coded Values: [1: Yes] , [0: No] )
• MaintenanceStatus ( type: esriFieldTypeString, alias: MaintenanceStatus, length: 50 , Coded Values: [Inspected: Inspected] , [Needs Inspection: Needs Inspection] )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• InspectionDate ( type: esriFieldTypeDate, alias: InspectionDate, length: 8 )
• CamCondition ( type: esriFieldTypeSmallInteger, alias: CamCondition )
• SewerVideosObjectID ( type: esriFieldTypeInteger, alias: SewerVideosObjectID )
• RelinedYear ( type: esriFieldTypeInteger, alias: RelinedYear )
• SewerSleuthCondition ( type: esriFieldTypeString, alias: SewerSleuthCondition, length: 50 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset ID, length: 50 )
• CWCondition ( type: esriFieldTypeString, alias: CityWorks Condition, length: 255 )
• CWConditionDate ( type: esriFieldTypeDate, alias: CityWorks Condition Date, length: 8 )
• GIS_IDtxt ( type: esriFieldTypeString, alias: GIS_ID (text), length: 255 )
• ConstructedStatus ( type: esriFieldTypeString, alias: Constructed Status, length: 255 , Coded Values: [Built: Built] , [Proposed: Proposed] , [Removed: Removed] , ...1 more... )
• CWConditionScore ( type: esriFieldTypeSmallInteger, alias: CWConditionScore )
• InspectedBy ( type: esriFieldTypeString, alias: Inspected By, length: 255 )
• CamConditionDescription ( type: esriFieldTypeString, alias: CamConditionDescription, length: 50 )
• CCTVInspectionDate ( type: esriFieldTypeDate, alias: CCTV Inspection Date, length: 8 )
• RemovalDate ( type: esriFieldTypeDate, alias: Removal Date, length: 8 )
• ProjectCode ( type: esriFieldTypeString, alias: Project Code, length: 255 )

Types:

ID: 1
Name: StmPipe
Domains:
• FlowType:
  Inherited
• StructureType:
  Inherited
• Location:
  Inherited
• UpstreamInventoryType:
  Inherited
• DownstreamInventoryType:
  Inherited
• PipeShape:
  Inherited
• Material:
  Inherited
• MaterialClass:
  Inherited
• Bedding:
  Inherited
• Ownership:
  Inherited
• LocationArea:
  Coded Values: [KETTL: Kettle Creek] , [MEDCK: Medway Creek] , [MUDCK: Mud Creek] , ...10 more...
• CleanArea:
  Coded Values: [10D: 10D] , [10S: 10S] , [10X: 10X] , ...165 more...
• ConstructedStatus:
  Inherited

---

ID: 2
Name: ReliefPipe
Domains:
• FlowType:
  Inherited
• StructureType:
  Inherited
• Location:
  Inherited
• UpstreamInventoryType:
  Inherited
• DownstreamInventoryType:
  Inherited
• PipeShape:
  Inherited
• Material:
  Inherited
• MaterialClass:
  Inherited
• Bedding:
  Inherited
• Ownership:
  Inherited
• LocationArea:
  Coded Values: [KETTL: Kettle Creek] , [MEDCK: Medway Creek] , [MUDCK: Mud Creek] , ...10 more...
• CleanArea:
  Coded Values: [10D: 10D] , [10S: 10S] , [10X: 10X] , ...165 more...
• ConstructedStatus:
  Inherited

---

ID: 11
Name: PrivSanFM
Domains:
• FlowType:
  Inherited
• StructureType:
  Inherited
• Location:
  Inherited
• UpstreamInventoryType:
  Inherited
• DownstreamInventoryType:
  Inherited
• PipeShape:
  Inherited
• Material:
  Inherited
• MaterialClass:
  Inherited
• Bedding:
  Inherited
• Ownership:
  Inherited
• LocationArea:
  Coded Values: [ADELA: Adelaide] , [DINGM: Dingman] , [GRNWN: Greenway (North)] , ...5 more...
• CleanArea:
  Coded Values: [AD: AD] , [AL: AL] , [AS: AS] , ...40 more...
• ConstructedStatus:
  Inherited

---

ID: 7
Name: San Overflow
Domains:
• FlowType:
  Inherited
• StructureType:
  Inherited
• Location:
  Inherited
• UpstreamInventoryType:
  Inherited
• DownstreamInventoryType:
  Inherited
• PipeShape:
  Inherited
• Material:
  Inherited
• MaterialClass:
  Inherited
• Bedding:
  Inherited
• Ownership:
  Inherited
• LocationArea:
  Coded Values: [ADELA: Adelaide] , [DINGM: Dingman] , [GRNWN: Greenway (North)] , ...5 more...
• CleanArea:
  Coded Values: [AD: AD] , [AL: AL] , [AS: AS] , ...40 more...
• ConstructedStatus:
  Inherited

---

ID: 0
Name: SanPipe
Domains:
• FlowType:
  Inherited
• StructureType:
  Inherited
• Location:
  Inherited
• UpstreamInventoryType:
  Inherited
• DownstreamInventoryType:
  Inherited
• PipeShape:
  Inherited
• Material:
  Inherited
• MaterialClass:
  Inherited
• Bedding:
  Inherited
• Ownership:
  Inherited
• LocationArea:
  Coded Values: [ADELA: Adelaide] , [DINGM: Dingman] , [GRNWN: Greenway (North)] , ...5 more...
• CleanArea:
  Coded Values: [AD: AD] , [AL: AL] , [AS: AS] , ...40 more...
• ConstructedStatus:
  Inherited

---

ID: 3
Name: CombinedPipe
Domains:
• FlowType:
  Inherited
• StructureType:
  Inherited
• Location:
  Inherited
• UpstreamInventoryType:
  Inherited
• DownstreamInventoryType:
  Inherited
• PipeShape:
  Inherited
• Material:
  Inherited
• MaterialClass:
  Inherited
• Bedding:
  Inherited
• Ownership:
  Inherited
• LocationArea:
  Coded Values: [ADELA: Adelaide] , [DINGM: Dingman] , [GRNWN: Greenway (North)] , ...5 more...
• CleanArea:
  Coded Values: [AD: AD] , [AL: AL] , [AS: AS] , ...40 more...
• ConstructedStatus:
  Inherited

---

ID: 9
Name: PrivSanPipe
Domains:
• FlowType:
  Inherited
• StructureType:
  Inherited
• Location:
  Inherited
• UpstreamInventoryType:
  Inherited
• DownstreamInventoryType:
  Inherited
• PipeShape:
  Inherited
• Material:
  Inherited
• MaterialClass:
  Inherited
• Bedding:
  Inherited
• Ownership:
  Inherited
• LocationArea:
  Coded Values: [ADELA: Adelaide] , [DINGM: Dingman] , [GRNWN: Greenway (North)] , ...5 more...
• CleanArea:
  Coded Values: [AD: AD] , [AL: AL] , [AS: AS] , ...40 more...
• ConstructedStatus:
  Inherited

---

ID: 8
Name: Stm Overflow
Domains:
• FlowType:
  Inherited
• StructureType:
  Inherited
• Location:
  Inherited
• UpstreamInventoryType:
  Inherited
• DownstreamInventoryType:
  Inherited
• PipeShape:
  Inherited
• Material:
  Inherited
• MaterialClass:
  Inherited
• Bedding:
  Inherited
• Ownership:
  Inherited
• LocationArea:
  Coded Values: [KETTL: Kettle Creek] , [MEDCK: Medway Creek] , [MUDCK: Mud Creek] , ...10 more...
• CleanArea:
  Coded Values: [10D: 10D] , [10S: 10S] , [10X: 10X] , ...165 more...
• ConstructedStatus:
  Inherited

---

ID: 10
Name: PrivStmPipe
Domains:
• FlowType:
  Inherited
• StructureType:
  Inherited
• Location:
  Inherited
• UpstreamInventoryType:
  Inherited
• DownstreamInventoryType:
  Inherited
• PipeShape:
  Inherited
• Material:
  Inherited
• MaterialClass:
  Inherited
• Bedding:
  Inherited
• Ownership:
  Inherited
• LocationArea:
  Coded Values: [KETTL: Kettle Creek] , [MEDCK: Medway Creek] , [MUDCK: Mud Creek] , ...10 more...
• CleanArea:
  Coded Values: [10D: 10D] , [10S: 10S] , [10X: 10X] , ...165 more...
• ConstructedStatus:
  Inherited

---

ID: 4
Name: SanFM
Domains:
• FlowType:
  Inherited
• StructureType:
  Inherited
• Location:
  Inherited
• UpstreamInventoryType:
  Inherited
• DownstreamInventoryType:
  Inherited
• PipeShape:
  Inherited
• Material:
  Inherited
• MaterialClass:
  Inherited
• Bedding:
  Inherited
• Ownership:
  Inherited
• LocationArea:
  Coded Values: [ADELA: Adelaide] , [DINGM: Dingman] , [GRNWN: Greenway (North)] , ...5 more...
• CleanArea:
  Coded Values: [AD: AD] , [AL: AL] , [AS: AS] , ...40 more...
• ConstructedStatus:
  Inherited

---

Relationships:

• GeoDbGeomatics.SEWER.PipesSimplified (0) -- Related To: PipesSimplified (16)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata