Parent Layer: Sanitary Main Cleaning Needed

Name: SSanitaryMain-Cleaning Due Later (6 to 12 Months Out)

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1.3267699585247993E7
YMin: 264227.7849942744
XMax: 1.3313959122281447E7
YMax: 300811.0511390567
Spatial Reference: 2253  (2253)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [255, 255, 115, 255]
Width: 2
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [DIAMETER]
Use Coded Values: true
Symbol:
Color: [115, 76, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 3000.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [FACILITYID]
Use Coded Values: true
Symbol:
Color: [115, 76, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 1200.0
Max. Scale: 0.0

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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SubType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 20 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 100 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• SUBTYPE ( type: esriFieldTypeInteger, alias: SubType )
• RECORDEDLENGTH ( type: esriFieldTypeDouble, alias: RECORDEDLENGTH )
• INSTALLCONTRACTOR ( type: esriFieldTypeString, alias: InstallContractor, length: 10 , Coded Values: [3S: 3-S Construction] , [AA: City of Ann Arbor Engineering] , [AAE: AAE] , ...328 more... )
• ASBUILTNUMBER ( type: esriFieldTypeString, alias: ASBUILTNUMBER, length: 200 )
• DATAORIGIN ( type: esriFieldTypeString, alias: DataOrigin, length: 10 , Coded Values: [UNK: Unknown] , [OTH: Other] , [ASB: As-built] , ...16 more... )
• OWNER ( type: esriFieldTypeString, alias: Owner, length: 10 , Coded Values: [UNK: Unknown] , [UM: University of Michigan] , [AA: Ann Arbor] , ...6 more... )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 100 )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 20 )
• GROUNDTYPE ( type: esriFieldTypeString, alias: GroundType, length: 20 , Coded Values: [UNK: Unknown] , [OTH: Other] , [D: Dirt] , ...3 more... )
• EXTERIORCOATING ( type: esriFieldTypeString, alias: ExteriorCoating, length: 20 , Coded Values: [UNK: Unknown] , [OTH: Other] , [ERES: Epoxy Resin] , ...3 more... )
• LININGTYPE ( type: esriFieldTypeString, alias: LiningType, length: 20 , Coded Values: [OTH: Other] , [PBHDPE: Pipe Burst - HDPE] , [SLIP: Slip Liner] , ...9 more... )
• PIPECLASS ( type: esriFieldTypeString, alias: PipeClass, length: 20 , Coded Values: [AB1: SDR 23.50] , [AC1: C-2400] , [AC2: C-3300] , ...34 more... )
• CROSSSECTIONSHAPE ( type: esriFieldTypeString, alias: CrossSectionShape, length: 20 , Coded Values: [RND: Round] , [HSH: Horseshoe] , [OBL: Oblong] , ...1 more... )
• UPSTREAMINVERT ( type: esriFieldTypeDouble, alias: UPSTREAMINVERT )
• DOWNSTREAMINVERT ( type: esriFieldTypeDouble, alias: DOWNSTREAMINVERT )
• MEASUREMENT1 ( type: esriFieldTypeInteger, alias: Measurement1 )
• MEASUREMENT2 ( type: esriFieldTypeInteger, alias: Measurement2 )
• DIAMETER ( type: esriFieldTypeInteger, alias: Diameter , Coded Values: [-1: Other] , [0: Unknown] , [2: 2"] , ...18 more... )
• SLOPE ( type: esriFieldTypeDouble, alias: SLOPE )
• DEPTHUPSTREAM ( type: esriFieldTypeDouble, alias: DEPTHUPSTREAM )
• DEPTHDOWNSTREAM ( type: esriFieldTypeDouble, alias: DEPTHDOWNSTREAM )
• USNODEID ( type: esriFieldTypeString, alias: USNODEID, length: 50 )
• DSNODEID ( type: esriFieldTypeString, alias: DSNODEID, length: 50 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 10 , Coded Values: [AB: Abandoned] , [IS: InService] , [PR: Proposed] , ...1 more... )
• CreatedUser ( type: esriFieldTypeString, alias: CreatedUser, length: 40 )
• DateCreated ( type: esriFieldTypeDate, alias: DateCreated, length: 8 )
• DateModified ( type: esriFieldTypeDate, alias: DateModified, length: 8 )
• ModifiedUser ( type: esriFieldTypeString, alias: ModifiedUser, length: 40 )
• LiningDate ( type: esriFieldTypeDate, alias: LiningDate, length: 8 )
• LiningContractor ( type: esriFieldTypeString, alias: LiningContractor, length: 50 , Coded Values: [3S: 3-S Construction] , [AA: City of Ann Arbor Engineering] , [AAE: AAE] , ...328 more... )
• LiningAsbuiltNumber ( type: esriFieldTypeString, alias: LiningAsbuiltNumber, length: 50 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• XLot ( type: esriFieldTypeString, alias: XLot, length: 10 , Coded Values: [Y: Yes] , [N: No] )
• AccesstoCleanXLot ( type: esriFieldTypeString, alias: AccesstoCleanXLot, length: 50 , Coded Values: [No: No] , [Yes: Yes] , [Partial: Partial] , ...8 more... )
• ProjectFunding ( type: esriFieldTypeString, alias: ProjectFunding, length: 50 , Coded Values: [City: City] , [Grant: Grant] , [Develop: Developer Donatated Infrastructure] , ...2 more... )
• JetPM ( type: esriFieldTypeString, alias: JetPM, length: 25 )
• RodPM ( type: esriFieldTypeString, alias: RodPM, length: 25 )
• DateLastJetted ( type: esriFieldTypeDate, alias: DateLastJetted, length: 8 )
• DateLastRodded ( type: esriFieldTypeDate, alias: DateLastRodded, length: 8 )
• DateLastTvd ( type: esriFieldTypeDate, alias: DateLastTvd, length: 8 )
• SpotRepairType ( type: esriFieldTypeString, alias: SpotRepairType, length: 50 , Coded Values: [CIPPMM: Cured in place (CIPP), manhole to manhole] , [CIPPS: Cured in place (CIPP), spot repair] , [LINK: Link pipe] , ...1 more... )
• JetLowPressure ( type: esriFieldTypeString, alias: JetLowPressure, length: 50 , Coded Values: [No: No] , [Yes: Yes] )
• DoNotRod ( type: esriFieldTypeString, alias: DoNotRod, length: 50 , Coded Values: [No: No] , [Yes: Yes] )
• AverageDepth ( type: esriFieldTypeDouble, alias: AverageDepth )
• Districts ( type: esriFieldTypeString, alias: Districts, length: 20 )
• JointUse ( type: esriFieldTypeString, alias: JointUse, length: 50 , Coded Values: [UNK: Unknown] , [UM: University of Michigan] , [AA: Ann Arbor] , ...6 more... )
• DoNotJet ( type: esriFieldTypeString, alias: DoNotJet, length: 10 , Coded Values: [Y: Yes] , [N: No] )
• DropConnection ( type: esriFieldTypeString, alias: DropConnection, length: 10 , Coded Values: [Y: Yes] , [N: No] )
• DateLastSLRatted ( type: esriFieldTypeDate, alias: DateLastSLRatted, length: 8 )
• SLRatScore ( type: esriFieldTypeSmallInteger, alias: SLRatScore )
• Encased ( type: esriFieldTypeString, alias: Encase, length: 10 , Coded Values: [Y: Yes] , [N: No] )
• PMDistrict ( type: esriFieldTypeString, alias: PMDistrict, length: 150 )
• PW_RevBy ( type: esriFieldTypeString, alias: PW_RevBy, length: 30 )
• PW_RevDate ( type: esriFieldTypeDate, alias: PW_RevDate, length: 8 )
• PW_RecommendedAction ( type: esriFieldTypeString, alias: PW_RecommendedAction, length: 50 , Coded Values: [Replacement: Replacement] , [NoActionNeeded: No Action Needed] , [PropLining: Prop Lining] , ...5 more... )
• PW_Notes ( type: esriFieldTypeString, alias: PW_Notes, length: 255 )
• PW_ACOneedReporting ( type: esriFieldTypeString, alias: PW_ACOneedReporting, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• PW_ACOreportDate ( type: esriFieldTypeDate, alias: PW_ACOreportDate, length: 8 )
• DateLastInspected ( type: esriFieldTypeDate, alias: DateLastInspected, length: 8 )
• PW_RecommendedActionYear ( type: esriFieldTypeString, alias: PW_RecommendedActionYear, length: 50 , Coded Values: [2022-Eng: 2022-Eng] , [2022-PW: 2022-PW] , [2023-Eng: 2023-Eng] , ...11 more... )
• DateLastJetScanned ( type: esriFieldTypeDate, alias: DateLastJetScanned, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ReplacementExtension ( type: esriFieldTypeString, alias: ReplacementExtension, length: 255 , Coded Values: [Replacement: Replacement] , [Extension: Extension] , [Consolidation: Consolidation] )
• SpotRepairDate ( type: esriFieldTypeDate, alias: SpotRepairDate, length: 8 )
• argNextStep_NextTaskSchedDate ( type: esriFieldTypeDate, alias: argNextStep_NextTaskSchedDate, length: 8 )
• argNextStep_NextTask ( type: esriFieldTypeString, alias: argNextStep_NextTask, length: 255 )
• argCCTVDominantDefect_Maint ( type: esriFieldTypeString, alias: argCCTVDominantDefect_Maint, length: 255 )
• argNextStep_NextTaskSchedTxt ( type: esriFieldTypeString, alias: argNextStep_NextTaskSchedTxt, length: 12 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Types:

ID: 2
Name: SInterceptorST
Domains:
• ENABLED:
  Inherited
• INSTALLCONTRACTOR:
  Inherited
• DATAORIGIN:
  Inherited
• OWNER:
  Inherited
• MATERIAL:
  Coded Values: [RC: Reinforced Concrete] , [PVC: Poly Vinyl Chloride] , [STL: Steel] , ...4 more...
• GROUNDTYPE:
  Inherited
• EXTERIORCOATING:
  Inherited
• LININGTYPE:
  Inherited
• PIPECLASS:
  Inherited
• CROSSSECTIONSHAPE:
  Inherited
• MEASUREMENT1:
  Coded Values: [18: 18"] , [20: 20"] , [24: 24"] , ...6 more...
• MEASUREMENT2:
  Coded Values: [18: 18"] , [20: 20"] , [24: 24"] , ...6 more...
• DIAMETER:
  Coded Values: [18: 18"] , [20: 20"] , [24: 24"] , ...6 more...
• STATUS:
  Inherited
• LiningContractor:
  Inherited
• XLot:
  Inherited
• AccesstoCleanXLot:
  Inherited
• ProjectFunding:
  Inherited
• SpotRepairType:
  Inherited
• JetLowPressure:
  Coded Values: [Y: Yes] , [N: No]
• DoNotRod:
  Coded Values: [Y: Yes] , [N: No]
• Districts:
  Coded Values: [HLI: High Level Interceptor] , [HWP: Huron West Park] , [HWPN: Huron West Park North] , ...18 more...
• JointUse:
  Inherited
• DoNotJet:
  Inherited
• DropConnection:
  Inherited
• Encased:
  Inherited
• PW_RecommendedAction:
  Inherited
• PW_ACOneedReporting:
  Inherited
• PW_RecommendedActionYear:
  Inherited
• ReplacementExtension:
  Inherited

---

ID: 3
Name: SForceMainST
Domains:
• ENABLED:
  Inherited
• INSTALLCONTRACTOR:
  Inherited
• DATAORIGIN:
  Inherited
• OWNER:
  Inherited
• MATERIAL:
  Coded Values: [DI: Ductile Iron] , [HDPE: HDPE] , [OTH: Other] , ...4 more...
• GROUNDTYPE:
  Inherited
• EXTERIORCOATING:
  Inherited
• LININGTYPE:
  Inherited
• PIPECLASS:
  Inherited
• CROSSSECTIONSHAPE:
  Inherited
• MEASUREMENT1:
  Coded Values: [4: 4"] , [6: 6"] , [8: 8"] , ...5 more...
• MEASUREMENT2:
  Coded Values: [4: 4"] , [6: 6"] , [8: 8"] , ...5 more...
• DIAMETER:
  Coded Values: [4: 4"] , [6: 6"] , [8: 8"] , ...5 more...
• STATUS:
  Inherited
• LiningContractor:
  Inherited
• XLot:
  Inherited
• AccesstoCleanXLot:
  Inherited
• ProjectFunding:
  Inherited
• SpotRepairType:
  Inherited
• JetLowPressure:
  Coded Values: [Y: Yes] , [N: No]
• DoNotRod:
  Coded Values: [Y: Yes] , [N: No]
• Districts:
  Coded Values: [HLI: High Level Interceptor] , [HWP: Huron West Park] , [HWPN: Huron West Park North] , ...18 more...
• JointUse:
  Inherited
• DoNotJet:
  Inherited
• DropConnection:
  Inherited
• Encased:
  Inherited
• PW_RecommendedAction:
  Inherited
• PW_ACOneedReporting:
  Inherited
• PW_RecommendedActionYear:
  Inherited
• ReplacementExtension:
  Inherited

---

ID: 1
Name: SCollectorST
Domains:
• ENABLED:
  Inherited
• INSTALLCONTRACTOR:
  Inherited
• DATAORIGIN:
  Inherited
• OWNER:
  Inherited
• MATERIAL:
  Coded Values: [CI: Cast Iron Pipe] , [CMP: Corrigated Metal Pipe] , [DI: Ductile Iron Pipe] , ...8 more...
• GROUNDTYPE:
  Inherited
• EXTERIORCOATING:
  Inherited
• LININGTYPE:
  Inherited
• PIPECLASS:
  Inherited
• CROSSSECTIONSHAPE:
  Inherited
• MEASUREMENT1:
  Coded Values: [0: Unknown] , [-1: Other] , [1: 1"] , ...80 more...
• MEASUREMENT2:
  Coded Values: [0: Unknown] , [-1: Other] , [1: 1"] , ...80 more...
• DIAMETER:
  Coded Values: [0: Unknown] , [-1: Other] , [1: 1"] , ...80 more...
• STATUS:
  Inherited
• LiningContractor:
  Inherited
• XLot:
  Inherited
• AccesstoCleanXLot:
  Inherited
• ProjectFunding:
  Inherited
• SpotRepairType:
  Inherited
• JetLowPressure:
  Coded Values: [Y: Yes] , [N: No]
• DoNotRod:
  Coded Values: [Y: Yes] , [N: No]
• Districts:
  Coded Values: [HLI: High Level Interceptor] , [HWP: Huron West Park] , [HWPN: Huron West Park North] , ...18 more...
• JointUse:
  Inherited
• DoNotJet:
  Inherited
• DropConnection:
  Inherited
• Encased:
  Inherited
• PW_RecommendedAction:
  Inherited
• PW_ACOneedReporting:
  Inherited
• PW_RecommendedActionYear:
  Inherited
• ReplacementExtension:
  Inherited

---

ID: 4
Name: STrunkST
Domains:
• ENABLED:
  Inherited
• INSTALLCONTRACTOR:
  Inherited
• DATAORIGIN:
  Inherited
• OWNER:
  Inherited
• MATERIAL:
  Coded Values: [CI: Cast Iron Pipe] , [CMP: Corrigated Metal Pipe] , [DI: Ductile Iron Pipe] , ...8 more...
• GROUNDTYPE:
  Inherited
• EXTERIORCOATING:
  Inherited
• LININGTYPE:
  Inherited
• PIPECLASS:
  Inherited
• CROSSSECTIONSHAPE:
  Inherited
• MEASUREMENT1:
  Coded Values: [0: Unknown] , [-1: Other] , [1: 1"] , ...80 more...
• MEASUREMENT2:
  Coded Values: [0: Unknown] , [-1: Other] , [1: 1"] , ...80 more...
• DIAMETER:
  Coded Values: [0: Unknown] , [-1: Other] , [1: 1"] , ...80 more...
• STATUS:
  Inherited
• LiningContractor:
  Inherited
• XLot:
  Inherited
• AccesstoCleanXLot:
  Inherited
• ProjectFunding:
  Inherited
• SpotRepairType:
  Inherited
• JetLowPressure:
  Coded Values: [Y: Yes] , [N: No]
• DoNotRod:
  Coded Values: [Y: Yes] , [N: No]
• Districts:
  Coded Values: [HLI: High Level Interceptor] , [HWP: Huron West Park] , [HWPN: Huron West Park North] , ...18 more...
• JointUse:
  Inherited
• DoNotJet:
  Inherited
• DropConnection:
  Inherited
• Encased:
  Inherited
• PW_RecommendedAction:
  Inherited
• PW_ACOneedReporting:
  Inherited
• PW_RecommendedActionYear:
  Inherited
• ReplacementExtension:
  Inherited

---

ID: 5
Name: SStorageReliefST
Domains:
• ENABLED:
  Inherited
• INSTALLCONTRACTOR:
  Inherited
• DATAORIGIN:
  Inherited
• OWNER:
  Inherited
• MATERIAL:
  Coded Values: [CI: Cast Iron Pipe] , [CMP: Corrigated Metal Pipe] , [DI: Ductile Iron Pipe] , ...8 more...
• GROUNDTYPE:
  Inherited
• EXTERIORCOATING:
  Inherited
• LININGTYPE:
  Inherited
• PIPECLASS:
  Inherited
• CROSSSECTIONSHAPE:
  Inherited
• DIAMETER:
  Inherited
• STATUS:
  Inherited
• LiningContractor:
  Inherited
• XLot:
  Inherited
• AccesstoCleanXLot:
  Inherited
• ProjectFunding:
  Inherited
• SpotRepairType:
  Inherited
• JetLowPressure:
  Coded Values: [Y: Yes] , [N: No]
• DoNotRod:
  Coded Values: [Y: Yes] , [N: No]
• Districts:
  Coded Values: [HLI: High Level Interceptor] , [HWP: Huron West Park] , [HWPN: Huron West Park North] , ...18 more...
• JointUse:
  Inherited
• DoNotJet:
  Inherited
• DropConnection:
  Inherited
• Encased:
  Inherited
• PW_RecommendedAction:
  Inherited
• PW_ACOneedReporting:
  Inherited
• PW_RecommendedActionYear:
  Inherited
• ReplacementExtension:
  Inherited

---

ID: 6
Name: SSiphonST
Domains:
• ENABLED:
  Inherited
• INSTALLCONTRACTOR:
  Inherited
• DATAORIGIN:
  Inherited
• OWNER:
  Inherited
• MATERIAL:
  Coded Values: [CI: Cast Iron Pipe] , [CMP: Corrigated Metal Pipe] , [DI: Ductile Iron Pipe] , ...8 more...
• GROUNDTYPE:
  Inherited
• EXTERIORCOATING:
  Inherited
• LININGTYPE:
  Inherited
• PIPECLASS:
  Inherited
• CROSSSECTIONSHAPE:
  Inherited
• DIAMETER:
  Inherited
• STATUS:
  Inherited
• LiningContractor:
  Inherited
• XLot:
  Inherited
• AccesstoCleanXLot:
  Inherited
• ProjectFunding:
  Inherited
• SpotRepairType:
  Inherited
• JetLowPressure:
  Coded Values: [Y: Yes] , [N: No]
• DoNotRod:
  Coded Values: [Y: Yes] , [N: No]
• Districts:
  Coded Values: [HLI: High Level Interceptor] , [HWP: Huron West Park] , [HWPN: Huron West Park North] , ...18 more...
• JointUse:
  Inherited
• DoNotJet:
  Inherited
• DropConnection:
  Inherited
• Encased:
  Inherited
• PW_RecommendedAction:
  Inherited
• PW_ACOneedReporting:
  Inherited
• PW_RecommendedActionYear:
  Inherited
• ReplacementExtension:
  Inherited

---

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

  Iteminfo   Thumbnail   Metadata