Parent Layer: 2022 Sanitary Manhole Cleaning

Name: November

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 0

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: 1.3272968729658797E7
YMin: 367694.1240157485
XMax: 1.3285447467847764E7
YMax: 382720.06889763474
Spatial Reference: 2253  (2253)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString , alias: Facility ID , length: 20 )
• Wall_Material_S ( type: esriFieldTypeSmallInteger , alias: Wall Material , Coded Values: [1: Concrete] , [2: Liner Material] , [3: Plastic] , ...15 more... )
• INSTALLDATE ( type: esriFieldTypeDate , alias: Install Date , length: 8 )
• HIGHELEV ( type: esriFieldTypeDouble , alias: High Pipe Elevation )
• INVERT ( type: esriFieldTypeDouble , alias: Invert )
• INVERTELEV ( type: esriFieldTypeDouble , alias: Invert Elevation )
• RIMELEV ( type: esriFieldTypeDouble , alias: Rim Elevation )
• MHTYPE ( type: esriFieldTypeString , alias: Manhole Type , length: 15 , Coded Values: [Drop: Drop] , [Junction: Junction] , [FM Discharge: FM Discharge] , ...1 more... )
• CONDITION ( type: esriFieldTypeString , alias: Manhole Condition , length: 10 , Coded Values: [Excellent: Excellent] , [Fair: Fair] , [Good: Good] , ...5 more... )
• CUTDEPTH ( type: esriFieldTypeDouble , alias: Pavement Cut Depth )
• FLOWDIR ( type: esriFieldTypeString , alias: Flow Direction , length: 25 , Coded Values: [East: East] , [North: North] , [South: South] , ...9 more... )
• LINED ( type: esriFieldTypeString , alias: Lined , length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• GPSDATE ( type: esriFieldTypeDate , alias: GPS Date , length: 8 )
• WATERTYPE ( type: esriFieldTypeString , alias: Water Type , length: 30 , Coded Values: [Combined: Combined Waste Water] , [Effluent: Waste Water Effluent] , [0: N/A] , ...7 more... )
• LOCDESC ( type: esriFieldTypeString , alias: Location Description , length: 200 )
• ENABLED ( type: esriFieldTypeSmallInteger , alias: Enabled , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger , alias: Active Flag , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger , alias: Owned By , Coded Values: [-2: Other] , [-1: Private] , [1: City of Brighton] , ...1 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger , alias: Managed By , Coded Values: [-1: Private] , [-2: Other] , [1: City of Brighton] )
• SUMFLOW ( type: esriFieldTypeDouble , alias: Flow Summary )
• CCTV_ID ( type: esriFieldTypeString , alias: CCTV_ID , length: 20 )
• Status ( type: esriFieldTypeString , alias: Status , length: 20 , Coded Values: [Complete: Complete] , [Not Found: Not Found] , [Unable to Open: Unable to Open] , ...2 more... )
• Visit_Date ( type: esriFieldTypeDate , alias: Visit_Date , length: 8 )
• Barrel_Dia ( type: esriFieldTypeDouble , alias: Barrel_Dia )
• Flow_Depth ( type: esriFieldTypeString , alias: Flow_Depth , length: 10 )
• Potential_Runoff ( type: esriFieldTypeString , alias: Potential_Runoff , length: 20 , Coded Values: [None: None] , [Sheeting: Sheeting] , [Ponding: Ponding] , ...1 more... )
• Comment ( type: esriFieldTypeString , alias: Comment , length: 200 )
• Surf_Type ( type: esriFieldTypeString , alias: Surf_Cover_Type , length: 20 , Coded Values: [Asphalt: Asphalt] , [Concrete: Concrete] , [GrassDirt: Grass/Dirt] , ...1 more... )
• Cover_Matl ( type: esriFieldTypeString , alias: Cover_Matl , length: 25 , Coded Values: [Precast Concrete: Precast Concrete] , [Concrete: Concrete] , [Brick: Brick] , ...11 more... )
• Cover_Type_S ( type: esriFieldTypeSmallInteger , alias: Cover Type , Coded Values: [1: Bolt Down] , [2: Other] , [3: Solid] , ...5 more... )
• Cover_Size_D ( type: esriFieldTypeSmallInteger , alias: Cover Size )
• Cover_Defect_1 ( type: esriFieldTypeString , alias: Cover_Defect_1 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Cover_Defect_2 ( type: esriFieldTypeString , alias: Cover_Defect_2 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Cover_D_Severity ( type: esriFieldTypeString , alias: Cover_D_Severity , length: 25 , Coded Values: [Small/Light: Small/Light] , [Medium/Moderate: Medium/Moderate] , [Large/Heavy: Large/Heavy] , ...2 more... )
• CovFrameFit ( type: esriFieldTypeString , alias: CovFrameFit , length: 25 )
• CovInsertType ( type: esriFieldTypeString , alias: CovInsertType , length: 25 )
• CovInstCond ( type: esriFieldTypeString , alias: CovInstCond , length: 25 )
• Frame_Matl ( type: esriFieldTypeString , alias: Frame_Matl , length: 25 , Coded Values: [Precast Concrete: Precast Concrete] , [Concrete: Concrete] , [Brick: Brick] , ...11 more... )
• Frame_Defect_1 ( type: esriFieldTypeString , alias: Frame_Defect_1 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Frame_Defect_2 ( type: esriFieldTypeString , alias: Frame_Defect_2 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Frame_D_Severity ( type: esriFieldTypeString , alias: Frame_D_Severity , length: 25 , Coded Values: [Small/Light: Small/Light] , [Medium/Moderate: Medium/Moderate] , [Large/Heavy: Large/Heavy] , ...2 more... )
• Ring_Type ( type: esriFieldTypeString , alias: Ring_Type , length: 20 , Coded Values: [Solid: Solid] , [Adjustable: Adjustable] , [None: None] )
• Ring_Matl ( type: esriFieldTypeString , alias: Ring_Matl , length: 25 , Coded Values: [Precast Concrete: Precast Concrete] , [Concrete: Concrete] , [Brick: Brick] , ...11 more... )
• FrameSeal_Maint_Defect_1 ( type: esriFieldTypeString , alias: Ring_Defect_1 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• FrameSeal_Maint_Defect_2 ( type: esriFieldTypeString , alias: Ring_Defect_2 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• FrameSeal_Maint_D_Severity ( type: esriFieldTypeString , alias: Ring_D_Severity , length: 25 , Coded Values: [Small/Light: Small/Light] , [Medium/Moderate: Medium/Moderate] , [Large/Heavy: Large/Heavy] , ...2 more... )
• Chimney_Depth ( type: esriFieldTypeInteger , alias: Chimney_Depth )
• Chimney_Matl ( type: esriFieldTypeString , alias: Chimney_Matl , length: 25 , Coded Values: [Precast Concrete: Precast Concrete] , [Concrete: Concrete] , [Brick: Brick] , ...11 more... )
• Chimney_Defect_1 ( type: esriFieldTypeString , alias: Chimney_Defect_1 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Chimney_Defect_2 ( type: esriFieldTypeString , alias: Chimney_Defect_2 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Chimney_D_Severity ( type: esriFieldTypeString , alias: Chimney_D_Severity , length: 25 , Coded Values: [Small/Light: Small/Light] , [Medium/Moderate: Medium/Moderate] , [Large/Heavy: Large/Heavy] , ...2 more... )
• Chimney_Seal ( type: esriFieldTypeString , alias: Chimney_Seal , length: 15 , Coded Values: [Chemical: Chemical] , [Mechanical: Mechanical] , [Other: Other] , ...1 more... )
• Cone_Material_S ( type: esriFieldTypeSmallInteger , alias: Cone Material , Coded Values: [1: Concrete] , [2: Liner Material] , [3: Plastic] , ...15 more... )
• Cone_Type_S ( type: esriFieldTypeSmallInteger , alias: Cone Type , Coded Values: [1: Bolt Down] , [2: Other] , [3: Solid] , ...5 more... )
• Cone_Defect_1 ( type: esriFieldTypeString , alias: Cone_Defect_1 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Cone_Defect_2 ( type: esriFieldTypeString , alias: Cone_Defect_2 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Cone_D_Severity ( type: esriFieldTypeString , alias: Cone_D_Severity , length: 25 , Coded Values: [Small/Light: Small/Light] , [Medium/Moderate: Medium/Moderate] , [Large/Heavy: Large/Heavy] , ...2 more... )
• Wall_Defect_1 ( type: esriFieldTypeString , alias: Wall_Defect_1 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Wall_Defect_2 ( type: esriFieldTypeString , alias: Wall_Defect_2 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Wall_D_Severity ( type: esriFieldTypeString , alias: Wall_D_Severity , length: 25 , Coded Values: [Small/Light: Small/Light] , [Medium/Moderate: Medium/Moderate] , [Large/Heavy: Large/Heavy] , ...2 more... )
• Steps_Material_S ( type: esriFieldTypeSmallInteger , alias: Steps Material , Coded Values: [1: Concrete] , [2: Liner Material] , [3: Plastic] , ...15 more... )
• Bench_Material_S ( type: esriFieldTypeSmallInteger , alias: Bench Material , Coded Values: [1: Concrete] , [2: Liner Material] , [3: Plastic] , ...15 more... )
• Bench_Defect_1 ( type: esriFieldTypeString , alias: Bench_Defect_1 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Bench_Defect_2 ( type: esriFieldTypeString , alias: Bench_Defect_2 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Bench_D_Severity ( type: esriFieldTypeString , alias: Bench_D_Severity , length: 25 , Coded Values: [Small/Light: Small/Light] , [Medium/Moderate: Medium/Moderate] , [Large/Heavy: Large/Heavy] , ...2 more... )
• Channel_Matl_S ( type: esriFieldTypeSmallInteger , alias: Channel_S , Coded Values: [1: Concrete] , [2: Liner Material] , [3: Plastic] , ...15 more... )
• Channel_Defect_1 ( type: esriFieldTypeString , alias: Channel_Defect_1 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Channel_Defect_2 ( type: esriFieldTypeString , alias: Channel_Defect_2 , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• Channel_D_Severity ( type: esriFieldTypeString , alias: Channel_D_Severity , length: 25 , Coded Values: [Small/Light: Small/Light] , [Medium/Moderate: Medium/Moderate] , [Large/Heavy: Large/Heavy] , ...2 more... )
• O_Surf_Cond ( type: esriFieldTypeString , alias: O_Surf_Cond , length: 20 )
• O_Int_Cond ( type: esriFieldTypeString , alias: O_Int_Cond , length: 20 )
• Work_Orders ( type: esriFieldTypeSmallInteger , alias: Work Orders )
• WO_Last_Date ( type: esriFieldTypeDate , alias: WO Last Date , length: 8 )
• WO_Reason ( type: esriFieldTypeString , alias: WO_Reason , length: 100 )
• Photo_Surface ( type: esriFieldTypeString , alias: Photo_Surface , length: 100 )
• Photo_Interior ( type: esriFieldTypeString , alias: Photo_Interior , length: 100 )
• Photo_Defect_1 ( type: esriFieldTypeString , alias: Photo_Defect_1 , length: 100 )
• Photo_Defect_2 ( type: esriFieldTypeString , alias: Photo_Defect_2 , length: 100 )
• Defect_Fig1 ( type: esriFieldTypeString , alias: Defect_Fig1 , length: 30 )
• Defect_Fig2 ( type: esriFieldTypeString , alias: Defect_Fig2 , length: 50 )
• Weather ( type: esriFieldTypeString , alias: Weather , length: 20 )
• Crew ( type: esriFieldTypeString , alias: Crew , length: 20 , Coded Values: [Crew 1: Crew 1] , [Crew 2: Crew 2] , [Crew 3: Crew 3] )
• Dye_Test ( type: esriFieldTypeString , alias: Dye_Test , length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Surcharge_Evidence ( type: esriFieldTypeString , alias: Surcharge_Evidence , length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Surcharge_Depth ( type: esriFieldTypeString , alias: Surcharge_Depth , length: 10 )
• US_DS_ID ( type: esriFieldTypeString , alias: US_DS_ID , length: 50 )
• Coord_Qual ( type: esriFieldTypeDouble , alias: Coord_Qual )
• Cover_IQ ( type: esriFieldTypeString , alias: Cover_IQ , length: 25 , Coded Values: [< 0.25 GPM: < 0.25 GPM] , [.25 - 1 GPM: .25 - 1 GPM] , [1 - 10 GPM: 1 - 10 GPM] , ...3 more... )
• Frame_IQ ( type: esriFieldTypeString , alias: Frame_IQ , length: 25 , Coded Values: [< 0.25 GPM: < 0.25 GPM] , [.25 - 1 GPM: .25 - 1 GPM] , [1 - 10 GPM: 1 - 10 GPM] , ...3 more... )
• FrameSeal_IQ ( type: esriFieldTypeString , alias: Ring_IQ , length: 25 , Coded Values: [< 0.25 GPM: < 0.25 GPM] , [.25 - 1 GPM: .25 - 1 GPM] , [1 - 10 GPM: 1 - 10 GPM] , ...3 more... )
• Chimney_IQ ( type: esriFieldTypeString , alias: Chimney_IQ , length: 25 , Coded Values: [< 0.25 GPM: < 0.25 GPM] , [.25 - 1 GPM: .25 - 1 GPM] , [1 - 10 GPM: 1 - 10 GPM] , ...3 more... )
• Cone_IQ ( type: esriFieldTypeString , alias: Cone_IQ , length: 25 , Coded Values: [< 0.25 GPM: < 0.25 GPM] , [.25 - 1 GPM: .25 - 1 GPM] , [1 - 10 GPM: 1 - 10 GPM] , ...3 more... )
• Wall_IQ ( type: esriFieldTypeString , alias: Wall_IQ , length: 25 , Coded Values: [< 0.25 GPM: < 0.25 GPM] , [.25 - 1 GPM: .25 - 1 GPM] , [1 - 10 GPM: 1 - 10 GPM] , ...3 more... )
• Bench_IQ ( type: esriFieldTypeString , alias: Bench_IQ , length: 25 , Coded Values: [< 0.25 GPM: < 0.25 GPM] , [.25 - 1 GPM: .25 - 1 GPM] , [1 - 10 GPM: 1 - 10 GPM] , ...3 more... )
• Channel_IQ ( type: esriFieldTypeString , alias: Channel_IQ , length: 25 , Coded Values: [< 0.25 GPM: < 0.25 GPM] , [.25 - 1 GPM: .25 - 1 GPM] , [1 - 10 GPM: 1 - 10 GPM] , ...3 more... )
• Rehab_Date ( type: esriFieldTypeString , alias: Rehab_Date , length: 30 )
• 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 )
• XCoord ( type: esriFieldTypeDouble , alias: XCoord )
• YCoord ( type: esriFieldTypeDouble , alias: YCoord )
• XYCoord ( type: esriFieldTypeString , alias: XYCoord , length: 100 )
• Oper_Status ( type: esriFieldTypeString , alias: Oper_Status , length: 30 )
• Lowest_Outbound_Pipe ( type: esriFieldTypeDouble , alias: Lowest_Outbound_Pipe )
• Remaining_Useful_Life_Per ( type: esriFieldTypeDouble , alias: Remaining Useful Life % )
• Install_Year_D ( type: esriFieldTypeDouble , alias: Install Year )
• EEL ( type: esriFieldTypeSmallInteger , alias: EEL )
• POF_Age ( type: esriFieldTypeSmallInteger , alias: POF_Age , Coded Values: [0: NA] , [1: > 50% RUL] , [2: 10% - 50% RUL] , ...1 more... )
• POF_Material ( type: esriFieldTypeSmallInteger , alias: POF_Material , Coded Values: [2: Block] , [3: Brick] , [0: Concrete] , ...1 more... )
• POF_WO ( type: esriFieldTypeSmallInteger , alias: POF_WO , Coded Values: [0: None] , [1: Previous Work Order] )
• POF_Condition ( type: esriFieldTypeSmallInteger , alias: POF_Condition , Coded Values: [0: No Data or CA 1/CA2] , [1: CA 3] , [2: CA 4] , ...1 more... )
• COF_Size ( type: esriFieldTypeSmallInteger , alias: COF_Size , Coded Values: [0: NA] , [1: Diameter = 48"] , [2: Diameter > 48"] )
• COF_Property ( type: esriFieldTypeSmallInteger , alias: COF_Property , Coded Values: [2: < 20' of building] , [0: > 20' of building] )
• COF_Surface_Water ( type: esriFieldTypeSmallInteger , alias: COF_Surface_Water , Coded Values: [2: < 50' of water body/100 year floodplain] , [0: > 50' of water body/100 year floodplain] )
• COF_Trans ( type: esriFieldTypeSmallInteger , alias: COF_Trans , Coded Values: [0: Not under pavement] , [1: Under pavement] , [2: In commercial roadway] )
• COF_Repair_Diff ( type: esriFieldTypeSmallInteger , alias: COF_Repair_Diff , Coded Values: [0: Depth < 10'] , [1: Depth = 10'-15'] , [2: Depth > 15'] )
• POF ( type: esriFieldTypeDouble , alias: POF )
• COF ( type: esriFieldTypeDouble , alias: COF )
• BRE ( type: esriFieldTypeDouble , alias: BRE )
• LucityAutoID ( type: esriFieldTypeInteger , alias: LucityAutoID )
• LucitySyncDate ( type: esriFieldTypeDate , alias: LucitySyncDate , length: 8 )
• InLucityFlag ( type: esriFieldTypeSmallInteger , alias: In Lucity Flag )
• LastModBy ( type: esriFieldTypeString , alias: Last Modified By , length: 50 )
• LastModDate ( type: esriFieldTypeDate , alias: Last Modified Date , length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• SHAPE ( type: esriFieldTypeGeometry , alias: SHAPE )
• JET_CLEAN_DATE ( type: esriFieldTypeDate , alias: JET_CLEAN_DATE , length: 8 )

Supported Operations:   Query   Generate Renderer   Return Updates