Name: Stormwater Pond Inspections

Display Field: Location

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 371f5271d2a74bdfa02ab21ae31d9f9f

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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• Location ( type: esriFieldTypeString, alias: Location, length: 150 )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 25 )
• EMB_1 ( type: esriFieldTypeString, alias: Vegetation and Ground Cover Adequate, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_1_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_2 ( type: esriFieldTypeString, alias: Embankment Erosion, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_2_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_3 ( type: esriFieldTypeString, alias: Animal Burrows, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_3_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_4 ( type: esriFieldTypeString, alias: Unauthorized Planting, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_4_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_5 ( type: esriFieldTypeString, alias: Cracking/Bulging/Sliding of Dam, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_5_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_5a ( type: esriFieldTypeString, alias: Cracking/Bulging/Sliding of Upstream Face, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_5a_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_5b ( type: esriFieldTypeString, alias: Cracking/Bulging/Sliding of Downstream Face, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_5b_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_5c1 ( type: esriFieldTypeString, alias: Cracking/Bulging/Sliding of Downstream Toe, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_5c1_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_5c2 ( type: esriFieldTypeString, alias: Cracking/Bulging/Sliding of Upstream Toe, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_5c2_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_5d ( type: esriFieldTypeString, alias: Cracking/Bulging/Sliding of Emergency Spillway, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_5d_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_6 ( type: esriFieldTypeString, alias: Pond, Toes & Chimney Drains Clear & Functioning, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_6_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_7 ( type: esriFieldTypeString, alias: Seeps/Leaks on Downstream Face, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_7_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_8 ( type: esriFieldTypeString, alias: Slope Protection or Riprap Failure, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_8_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_9 ( type: esriFieldTypeString, alias: Vertical/Horizontal Alignment of Top of Dam [double_quote]As-Built[double_quote], length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_9_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_10 ( type: esriFieldTypeString, alias: Emergency Spillway Clear of Obstruction and Debris, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• EMB_10_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• EMB_Other ( type: esriFieldTypeString, alias: Other (specify), length: 100 )
• EMB_11_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• Riser_Type ( type: esriFieldTypeString, alias: Riser Type, length: 20 , Coded Values: [Reinforced Concrete: Reinforced Concrete] , [Corrugated Pipe: Corrugated Pipe] , [Masonry: Masonry] )
• RISER_1 ( type: esriFieldTypeString, alias: Low Flow Orifice Obstructed, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_1_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_2a ( type: esriFieldTypeString, alias: Low Flow Trash Rack Debris Removal Necessary, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_2a_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_2b ( type: esriFieldTypeString, alias: Low Flow Trash Rack Corrosion Control, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_2b_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_3a ( type: esriFieldTypeString, alias: Weir Trash Rack Maintenance Debris Removal Necessary, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_3a_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_3b ( type: esriFieldTypeString, alias: Weird Trash Rack Maintenance Corrosion Control, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_3b_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_4 ( type: esriFieldTypeString, alias: Excessive Sediment Accumulation Insider Rise, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_4_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_5a ( type: esriFieldTypeString, alias: Concrete/Masonry Condition Riser & Barrels Cracks or Displacement, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_5a_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_5b ( type: esriFieldTypeString, alias: Concrete/Masonry Condition Riser & Barrels Minor Spalling (1[double_quote]), length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_5b_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_5c ( type: esriFieldTypeString, alias: Concrete/Masonry Condition Riser & Barrels Major Spalling (rebars exposed), length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_5c_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_5d ( type: esriFieldTypeString, alias: Concrete/Masonry Condition Riser & Barrels Joint Failures, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_5d_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_5e ( type: esriFieldTypeString, alias: Concrete/Masonry Condition Riser & Barrels Water Tightness, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_5e_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_6 ( type: esriFieldTypeString, alias: Metal Pipe Condition, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_6_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_7a ( type: esriFieldTypeString, alias: Control Valve Operational/Exercised, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_7a_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_7b ( type: esriFieldTypeString, alias: Control Valve Chained & Locked, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_7b_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_8a ( type: esriFieldTypeString, alias: Pond Drain Valve Operational/Exercised, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_8a_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_8b ( type: esriFieldTypeString, alias: Pond Drain Valve Chained & Locked, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_8b_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_9 ( type: esriFieldTypeString, alias: Outfall Channels Functioning, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• RISER_9_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• RISER_Other ( type: esriFieldTypeString, alias: Other (specify), length: 100 )
• RISER_10_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• POOL_1 ( type: esriFieldTypeString, alias: Undesirable Vegetative Growth, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• POOL_1_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• POOL_2 ( type: esriFieldTypeString, alias: Floating or Floatable Debris Removal Required, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• POOL_2_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• POOL_3 ( type: esriFieldTypeString, alias: Visible Pollution, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• POOL_3_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• POOL_4 ( type: esriFieldTypeString, alias: Shoreline Problem, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• POOL_4_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• POOL_Other ( type: esriFieldTypeString, alias: Other (specify), length: 100 )
• POOL_5_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• SEDIMENT_1 ( type: esriFieldTypeString, alias: Sedimentation Noted, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• SEDIMENT_1_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• SEDIMENT_2 ( type: esriFieldTypeString, alias: Sediment Cleanout When Depth <50% Design Depth, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• SEDIMENT_2_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• DRYPOND_1 ( type: esriFieldTypeString, alias: Vegetation Adequate, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• DRYPOND_1_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• DRYPOND_2 ( type: esriFieldTypeString, alias: Undesirable Vegetative Growth, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• DRYPOND_2_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• DRYPOND_3 ( type: esriFieldTypeString, alias: Undesirable Woody Vegetation, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• DRYPOND_3_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• DRYPOND_4 ( type: esriFieldTypeString, alias: Low Flow Channels Clear of Obstructions, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• DRYPOND_4_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• DRYPOND_5 ( type: esriFieldTypeString, alias: Standing Water or Wet Spots, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• DRYPOND_5_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• DRYPOND_6 ( type: esriFieldTypeString, alias: Sediment and/or Trash Accumulation, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• DRYPOND_6_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• DRYPOND_Other ( type: esriFieldTypeString, alias: Other (specify), length: 100 )
• DRYPOND_7_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OUTFALLS_1 ( type: esriFieldTypeString, alias: Riprap Failures, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OUTFALLS_1_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OUTFALLS_2 ( type: esriFieldTypeString, alias: Slope Erosion, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OUTFALLS_2_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OUTFALLS_3 ( type: esriFieldTypeString, alias: Storm Drain Pipes, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OUTFALLS_3_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OUTFALLS_4 ( type: esriFieldTypeString, alias: Endwalls/Headwalls, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OUTFALLS_4_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OUTFALLS_Other ( type: esriFieldTypeString, alias: Other (specify), length: 100 )
• OUTFALLS_5_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OTHER_1 ( type: esriFieldTypeString, alias: Encroachment on Pond, Wetland or Easement Area, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OTHER_1_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OTHER_2 ( type: esriFieldTypeString, alias: Complaints from Residents, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OTHER_2_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OTHER_3a ( type: esriFieldTypeString, alias: Aesthetics - Grass Growing Required, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OTHER_3a_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OTHER_3b ( type: esriFieldTypeString, alias: Aesthetics - Graffiti Removal Needed, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OTHER_3b_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OTHER_3c ( type: esriFieldTypeString, alias: Aesthetics - Other (specify), length: 100 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OTHER_3c_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OTHERS_4 ( type: esriFieldTypeString, alias: Conditions of Maintenance Access Routes, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OTHER_4_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OTHERS_5 ( type: esriFieldTypeString, alias: Signs of Hydrocarbon Buildup, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OTHER_5_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• OTHERS_6 ( type: esriFieldTypeString, alias: Any Public Hazards (specify), length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• OTHER_6_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• WETVEG_1 ( type: esriFieldTypeString, alias: Vegetation Healthy & Growing (wetland maintaining 50% surface area coverage of wetland plants after the second growing season), length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• WETVEG_1_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• WETVEG_2 ( type: esriFieldTypeString, alias: Dominant Wetland Plants (survival of desired wetland plant species distribution according to landscaping plan), length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• WETVEG_2_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• WETVEG_3 ( type: esriFieldTypeString, alias: Evidence of Invasive Species, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• WETVEG_3_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• WETVEG_4 ( type: esriFieldTypeString, alias: Maintenance of Adequate Water Depths for Desired Wetland Plant Species, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• WETVEG_4_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• WETVEG_5 ( type: esriFieldTypeString, alias: Harvesting of Emergent Plantings Needed, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• WETVEG_5_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• WETVEG_6 ( type: esriFieldTypeString, alias: Have Sediment Accumulations Reduced Pool Volume Significantly or are Plants [double_quote]Choked[double_quote] with Sediment, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• WETVEG_6_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• WETVEG_7 ( type: esriFieldTypeString, alias: Eutrophication Level of the Wetland, length: 3 , Coded Values: [S: S] , [U: U] , [N/A: N/A] )
• WETVEG_7_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• WETVEG_Other ( type: esriFieldTypeString, alias: Other (specify), length: 100 )
• WETVEG_8_COM ( type: esriFieldTypeString, alias: Comments, length: 75 )
• COMMENTS ( type: esriFieldTypeString, alias: Overall Comments, length: 150 )
• ACTIONS ( type: esriFieldTypeString, alias: Actions to be Taken, length: 200 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )

Relationships:

• OCGIS.DPW_STM_Dryswale_Structures (0) -- Related To: Dryswale Structures (2)

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

  Iteminfo   Thumbnail   Metadata