Name: CLCSD Inspections

Display Field: OCDPW.DPW_CLCSD_Manholes_Inspections.MH_ID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: bcdfc8a7c20f4eba883a3181a5893f69

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OCDPW.DPW_CLCSD_Manholes_Inspections.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• OCDPW.DPW_CLCSD_Manholes_Inspections.MH_ID ( type: esriFieldTypeString, alias: Manhole ID, length: 10 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.Inspector ( type: esriFieldTypeString, alias: Inspector (initials), length: 15 , Coded Values: [CHC: CHC] , [RDK: RDK] , [GBP: GBP] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes_Inspections.MHC_I_I ( type: esriFieldTypeString, alias: Manhole Cover: Evidence of I/I?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes_Inspections.MHC_Fit ( type: esriFieldTypeString, alias: Manhole Cover: Fit, length: 15 , Coded Values: [Loose: Loose] , [Tight: Tight] )
• OCDPW.DPW_CLCSD_Manholes_Inspections.MHF_I_I ( type: esriFieldTypeString, alias: Manhole Frame: Evidence of I/I?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes_Inspections.MHF_Cond ( type: esriFieldTypeString, alias: Manhole Frame: Condition, length: 15 , Coded Values: [Fail: Fail] , [Poor: Poor] , [Fair: Fair] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes_Inspections.RISER_I_I ( type: esriFieldTypeString, alias: Riser: Evidence of I/I?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes_Inspections.RISER_Cond ( type: esriFieldTypeString, alias: Riser: Condition, length: 15 , Coded Values: [Fail: Fail] , [Poor: Poor] , [Fair: Fair] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes_Inspections.WALLS_I_I ( type: esriFieldTypeString, alias: Walls: Evidence of I/I?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes_Inspections.WALLS_Cond ( type: esriFieldTypeString, alias: Walls: Condition, length: 15 , Coded Values: [Fail: Fail] , [Poor: Poor] , [Fair: Fair] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes_Inspections.BENWALL_Dep_YN ( type: esriFieldTypeString, alias: Bench Walls: Deposits?, length: 8 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes_Inspections.BENWALL_Dep ( type: esriFieldTypeString, alias: Bench Wall Deposits, length: 25 , Coded Values: [Mud: Mud] , [Debris: Debris] , [Sludge: Sludge] )
• OCDPW.DPW_CLCSD_Manholes_Inspections.BENWALL_Cond ( type: esriFieldTypeString, alias: Bench Walls: Condition, length: 15 , Coded Values: [Fail: Fail] , [Poor: Poor] , [Fair: Fair] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes_Inspections.TROUGH_I_I ( type: esriFieldTypeString, alias: Trough: Evidence of I/I?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes_Inspections.TROUGH_Cond ( type: esriFieldTypeString, alias: Trough: Condition, length: 15 , Coded Values: [Fail: Fail] , [Poor: Poor] , [Fair: Fair] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes_Inspections.STEP_Cond ( type: esriFieldTypeString, alias: Steps: Condition, length: 15 , Coded Values: [Fail: Fail] , [Poor: Poor] , [Fair: Fair] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes_Inspections.SUR_Evid ( type: esriFieldTypeString, alias: Surcharge: Evidence?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes_Inspections.WATER_Depth ( type: esriFieldTypeDouble, alias: Depth to Watermark )
• OCDPW.DPW_CLCSD_Manholes_Inspections.FLOWRATE ( type: esriFieldTypeString, alias: Flow Rate: Estimated (gpm), length: 10 , Coded Values: [No Flow: No Flow] , [< 1: < 1] , [1-3: 1-3] , ...1 more... )
• OCDPW.DPW_CLCSD_Manholes_Inspections.COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 150 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.Created_By ( type: esriFieldTypeString, alias: Created By, length: 255 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.Date_Created ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.Last_Edited_By ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.Date_Last_Edited ( type: esriFieldTypeDate, alias: Date Last Edited, length: 8 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.GEN_COND ( type: esriFieldTypeString, alias: General Condition, length: 15 , Coded Values: [Fail: Fail] , [Poor: Poor] , [Fair: Fair] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes_Inspections.MHC_Bolt ( type: esriFieldTypeString, alias: Manhole Cover Bolted?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes_Inspections.MHC_Rec ( type: esriFieldTypeString, alias: Manhole Cover Recommendations, length: 150 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.MHF_Rec ( type: esriFieldTypeString, alias: Manhole Frame Recommendations, length: 150 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.RISER_Rec ( type: esriFieldTypeString, alias: Riser Recommendations, length: 150 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.WALLS_Rec ( type: esriFieldTypeString, alias: Walls Recommendations, length: 150 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.BENWALL_Rec ( type: esriFieldTypeString, alias: Bench Walls Recommendations, length: 150 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.TROUGH_Rec ( type: esriFieldTypeString, alias: Trough Recommendations, length: 150 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.STEP_Rec ( type: esriFieldTypeString, alias: Steps Recommendations, length: 150 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.SUR_Rec ( type: esriFieldTypeString, alias: Surcharge Recommendations, length: 150 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.PS_ID ( type: esriFieldTypeString, alias: Pump Station ID, length: 25 )
• OCDPW.DPW_CLCSD_Manholes_Inspections.MH_ID_NEW ( type: esriFieldTypeString, alias: Manhole ID (New), length: 15 )
• OCDPW.DPW_CLCSD_Manholes.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• OCDPW.DPW_CLCSD_Manholes.ADDRESS ( type: esriFieldTypeString, alias: Address, length: 100 )
• OCDPW.DPW_CLCSD_Manholes.STREET_NAM ( type: esriFieldTypeString, alias: Street Name, length: 35 )
• OCDPW.DPW_CLCSD_Manholes.MH_ID ( type: esriFieldTypeString, alias: New MH ID, length: 50 )
• OCDPW.DPW_CLCSD_Manholes.CURRENT_MH_ID ( type: esriFieldTypeString, alias: Current MH ID, length: 10 )
• OCDPW.DPW_CLCSD_Manholes.PS_ID ( type: esriFieldTypeString, alias: Pump Station ID, length: 25 , Coded Values: [01E: 01E] , [02E: 02E] , [03E: 03E] , ...37 more... )
• OCDPW.DPW_CLCSD_Manholes.INST_Date ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• OCDPW.DPW_CLCSD_Manholes.INLETS ( type: esriFieldTypeString, alias: Inlets, length: 5 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes.OUTLETS ( type: esriFieldTypeString, alias: Outlets, length: 5 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes.MATERIAL ( type: esriFieldTypeString, alias: Material, length: 25 , Coded Values: [Concrete: Concrete] , [Brick: Brick] , [Fiberglass: Fiberglass] , ...1 more... )
• OCDPW.DPW_CLCSD_Manholes.MATERIAL_OTH ( type: esriFieldTypeString, alias: Material (Other), length: 25 )
• OCDPW.DPW_CLCSD_Manholes.RIM ( type: esriFieldTypeDouble, alias: Rim Elevation )
• OCDPW.DPW_CLCSD_Manholes.INV_N_PRES ( type: esriFieldTypeString, alias: Invert: North?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes.INV_N ( type: esriFieldTypeDouble, alias: Invert North Elevation )
• OCDPW.DPW_CLCSD_Manholes.INV_S_PRES ( type: esriFieldTypeString, alias: Invert: South?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes.INV_S ( type: esriFieldTypeDouble, alias: Invert South Elevation )
• OCDPW.DPW_CLCSD_Manholes.INV_E_PRES ( type: esriFieldTypeString, alias: Invert: East?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes.INV_E ( type: esriFieldTypeDouble, alias: Invert East Elevation )
• OCDPW.DPW_CLCSD_Manholes.INV_W_PRES ( type: esriFieldTypeString, alias: Invert: West?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes.INV_W ( type: esriFieldTypeDouble, alias: Invert West Elevation )
• OCDPW.DPW_CLCSD_Manholes.INV_NE_PRES ( type: esriFieldTypeString, alias: Invert: Northeast?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes.INV_NE ( type: esriFieldTypeDouble, alias: Invert Northeast Elevation )
• OCDPW.DPW_CLCSD_Manholes.INV_NW_PRES ( type: esriFieldTypeString, alias: Invert: Northwest?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes.INV_NW ( type: esriFieldTypeDouble, alias: Invert Northwest Elevation )
• OCDPW.DPW_CLCSD_Manholes.INV_SE_PRES ( type: esriFieldTypeString, alias: Invert: Southeast?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes.INV_SE ( type: esriFieldTypeDouble, alias: Invert Southeast Elevation )
• OCDPW.DPW_CLCSD_Manholes.INV_SW_PRES ( type: esriFieldTypeString, alias: Invert: Southwest?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes.INV_SW ( type: esriFieldTypeDouble, alias: Invert Southwest Elevation )
• OCDPW.DPW_CLCSD_Manholes.INV_OTH_PRES ( type: esriFieldTypeString, alias: Invert (Other)?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes.INV_OTH_DIR ( type: esriFieldTypeString, alias: Invert (Other) Direction, length: 5 , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• OCDPW.DPW_CLCSD_Manholes.INV_OTH ( type: esriFieldTypeInteger, alias: Invert (Other) Elevation )
• OCDPW.DPW_CLCSD_Manholes.DROP_INV ( type: esriFieldTypeString, alias: Drop Invert?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes.DROP_INV_IN_OUT ( type: esriFieldTypeString, alias: Drop Invert: Inside or Outside, length: 15 , Coded Values: [Inside: Inside] , [Outside: Outside] )
• OCDPW.DPW_CLCSD_Manholes.DROP_INV_DIR ( type: esriFieldTypeString, alias: Drop Invert: Direction, length: 3 , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• OCDPW.DPW_CLCSD_Manholes.STR_TOP_CONF ( type: esriFieldTypeString, alias: Structure Top Configuration, length: 10 , Coded Values: [Taper: Taper] , [Flat: Flat] )
• OCDPW.DPW_CLCSD_Manholes.DIAMETER ( type: esriFieldTypeDouble, alias: Diameter (ft) , Coded Values: [4: 4] , [5: 5] , [6: 6] , ...1 more... )
• OCDPW.DPW_CLCSD_Manholes.MHC_DIA ( type: esriFieldTypeDouble, alias: Manhole Cover Diameter (in) )
• OCDPW.DPW_CLCSD_Manholes.COVER_TYPE ( type: esriFieldTypeString, alias: Cover Type, length: 15 , Coded Values: [Regular: Regular] , [Water-Tight: Water-Tight] )
• OCDPW.DPW_CLCSD_Manholes.WATER_TIGHT ( type: esriFieldTypeString, alias: Water-Tight Type, length: 15 , Coded Values: [Parsons: Parsons] , [Mechanical: Mechanical] , [Other: Other] )
• OCDPW.DPW_CLCSD_Manholes.WATER_TIGHT_OTH ( type: esriFieldTypeString, alias: Water-Tight Type (Other), length: 30 )
• OCDPW.DPW_CLCSD_Manholes.DEPTH_1ST_STEP ( type: esriFieldTypeDouble, alias: Depth to 1st Step (in) )
• OCDPW.DPW_CLCSD_Manholes.RISER_CON ( type: esriFieldTypeString, alias: Riser Construction Style, length: 20 , Coded Values: [Cast-in-place: Cast-in-place] , [Steel: Steel] , [Plastic: Plastic] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes.RISER_CON_OTH ( type: esriFieldTypeString, alias: Riser Construction Style (Other), length: 30 )
• OCDPW.DPW_CLCSD_Manholes.RISER_HEIGHT ( type: esriFieldTypeDouble, alias: Riser Height (in) )
• OCDPW.DPW_CLCSD_Manholes.STEPS ( type: esriFieldTypeDouble, alias: # of Steps , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...19 more... )
• OCDPW.DPW_CLCSD_Manholes.PUB_PRIV ( type: esriFieldTypeString, alias: Private or Public, length: 10 , Coded Values: [Public: Public] , [Private: Private] , [Unsure: Unsure] )
• OCDPW.DPW_CLCSD_Manholes.COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 100 )
• OCDPW.DPW_CLCSD_Manholes.WEBDISP ( type: esriFieldTypeString, alias: Web Display, length: 15 )
• OCDPW.DPW_CLCSD_Manholes.Dataset ( type: esriFieldTypeString, alias: Dataset, length: 3 )
• OCDPW.DPW_CLCSD_Manholes.PRIM_ATT ( type: esriFieldTypeString, alias: Primary Attribution, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Partial: Partial] )
• OCDPW.DPW_CLCSD_Manholes.GPS_VER ( type: esriFieldTypeString, alias: DPW GPS Verified, length: 20 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• OCDPW.DPW_CLCSD_Manholes.STATUS ( type: esriFieldTypeString, alias: Status, length: 40 , Coded Values: [Verified: Verified] , [Verification Needed: Verification Needed] , [Error: Error] , ...1 more... )
• OCDPW.DPW_CLCSD_Manholes.DATA_SOURC ( type: esriFieldTypeString, alias: Data Source, length: 75 , Coded Values: [Record Drawing: Record Drawing] , [Record Drawing & Aerial: Record Drawing & Aerial] , [Aerial Only: Aerial Only] , ...3 more... )
• OCDPW.DPW_CLCSD_Manholes.FULL_LINK ( type: esriFieldTypeString, alias: Full Hyperlink, length: 150 )
• OCDPW.DPW_CLCSD_Manholes.MUN_PAR_CODE ( type: esriFieldTypeString, alias: MUNIS: Parent Code, length: 35 )
• OCDPW.DPW_CLCSD_Manholes.MUN_ASSET_CODE ( type: esriFieldTypeString, alias: MUNIS: Asset Code, length: 40 )
• OCDPW.DPW_CLCSD_Manholes.MUN_ASSET_TYPE ( type: esriFieldTypeString, alias: MUNIS: Asset Type, length: 20 )
• OCDPW.DPW_CLCSD_Manholes.MUN_SERV_DEPT ( type: esriFieldTypeString, alias: MUNIS: Servicing Department, length: 10 )
• OCDPW.DPW_CLCSD_Manholes.MUN_DESCR ( type: esriFieldTypeString, alias: MUNIS: Description, length: 75 )
• OCDPW.DPW_CLCSD_Manholes.MUN_PAR_DEPT ( type: esriFieldTypeString, alias: MUNIS: Parent Department, length: 10 )
• OCDPW.DPW_CLCSD_Manholes.MUN_CAT ( type: esriFieldTypeString, alias: MUNIS: Category, length: 3 )
• OCDPW.DPW_CLCSD_Manholes.MUN_ADM_DEPT ( type: esriFieldTypeString, alias: MUNIS: Administrative Department, length: 10 )
• OCDPW.DPW_CLCSD_Manholes.MUN_GIS_LINK ( type: esriFieldTypeString, alias: MUNIS: GIS Link, length: 35 )
• OCDPW.DPW_CLCSD_Manholes.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• OCDPW.DPW_CLCSD_Manholes.Created_By ( type: esriFieldTypeString, alias: Created_By, length: 255 )
• OCDPW.DPW_CLCSD_Manholes.Date_Created ( type: esriFieldTypeDate, alias: Date_Created, length: 8 )
• OCDPW.DPW_CLCSD_Manholes.Last_Edited_By ( type: esriFieldTypeString, alias: Last_Edited_By, length: 255 )
• OCDPW.DPW_CLCSD_Manholes.Date_Last_Edited ( type: esriFieldTypeDate, alias: Date_Last_Edited, length: 8 )
• OCDPW.DPW_CLCSD_Manholes.RISER_PRES ( type: esriFieldTypeString, alias: Riser Present?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• OCDPW.DPW_CLCSD_Manholes.Jack_Review ( type: esriFieldTypeString, alias: Pub/Priv status reviewed by Jack, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OCDPW.DPW_CLCSD_Manholes.I_I_Complete ( type: esriFieldTypeString, alias: I&I Complete (2023-2024), length: 5 , Coded Values: [Yes: Yes] , [No: No] )

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

  Iteminfo   Thumbnail   Metadata