Name: Pond Inspections

Display Field: InspectionDate

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: a8daccbf93f54491bbdb5ede7c57885e

Copyright Text: null

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

Feature Draw Order:

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• InspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• DrainName ( type: esriFieldTypeString, alias: Drain name, length: 50 )
• LocationAddress ( type: esriFieldTypeString, alias: Location or address, length: 50 )
• GovernmentUnit ( type: esriFieldTypeString, alias: Government unit, length: 50 , Coded Values: [11: Allendale Twp] , [12: Blendon Twp] , [13: Chester Twp] , ...21 more... )
• Temperature ( type: esriFieldTypeSmallInteger, alias: Temperature )
• CloudCover ( type: esriFieldTypeString, alias: Cloud cover, length: 50 , Coded Values: [Clear: Clear] , [PartlyCloudy: Partly Cloudy] , [MostlyCloudy: Mostly Cloudy] , ...1 more... )
• PondType ( type: esriFieldTypeString, alias: Pond type, length: 50 , Coded Values: [Detention: Detention] , [Retention: Retention] )
• WetOrDry ( type: esriFieldTypeString, alias: Wet or dry pond, length: 50 , Coded Values: [Wet: Wet] , [Dry: Dry] )
• PondBottomSediment ( type: esriFieldTypeString, alias: Deposits of sediment, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• PondBottomTrashDebris ( type: esriFieldTypeString, alias: Trash and debris accumulated, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• PondBottomGrading ( type: esriFieldTypeString, alias: Grading corresponds to approved plan, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• PondBottomGradingDesc ( type: esriFieldTypeString, alias: Describe any inconsistent pond bottom grading, length: 50 )
• PondBottomWaterPockets ( type: esriFieldTypeString, alias: Pockets of water due to grading, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• BankSignsOfErosion ( type: esriFieldTypeString, alias: Do the banks show signs of erosion?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• BankSignsOfErosionDesc ( type: esriFieldTypeString, alias: If bank shows signs of erosion, where?, length: 50 )
• BankSlopeRatio ( type: esriFieldTypeString, alias: Slope of banks 1:3 or less?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• OutletConditionDesc ( type: esriFieldTypeString, alias: Brief description of outlet condition, length: 50 )
• OutletDesignApproved ( type: esriFieldTypeString, alias: Design of outlet is consistent with approved plan, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• OutletDesignApprovedDesc ( type: esriFieldTypeString, alias: Description if outlet does not match approved plan, length: 50 )
• OutletVisible ( type: esriFieldTypeString, alias: Is the outlet visible?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• OutletSediment ( type: esriFieldTypeString, alias: Sediment within the outlet?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• OutletSedimentInches ( type: esriFieldTypeSmallInteger, alias: Inches of sediment in outlet )
• OutletStandingWater ( type: esriFieldTypeString, alias: Standing water within the outlet?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• OutletStandingWaterInches ( type: esriFieldTypeSmallInteger, alias: Inches of standing water in outlet )
• OutletFunctionsImpaired ( type: esriFieldTypeString, alias: Outlet functions impaired?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• OutletFunctionsImpairedDesc ( type: esriFieldTypeString, alias: If outlet functions impaired, how?, length: 50 )
• PrimarySpillwayProvided ( type: esriFieldTypeString, alias: Is primary spillway provided?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• PrimarySpillwayDesc ( type: esriFieldTypeString, alias: Brief description of primary spillway, length: 50 )
• PrimarySpillwayImpaired ( type: esriFieldTypeString, alias: Primary spillway functions impaired?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• PrimarySpillwayImpairedDesc ( type: esriFieldTypeString, alias: If primary spillway functions impaired, how?, length: 50 )
• EmergencySpillwayProvided ( type: esriFieldTypeString, alias: Is emergency spillway provided?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• EmergencySpillwayImpaired ( type: esriFieldTypeString, alias: Emergency spillway functions impaired?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• EmergencySpillwayImpairedDesc ( type: esriFieldTypeString, alias: If emergency spillway functions impaired, how?, length: 50 )
• EmergencySpillwayMaterial ( type: esriFieldTypeString, alias: Emergency spillway material, length: 50 )
• StormPipeInlets ( type: esriFieldTypeString, alias: Are storm sewer pipe inlets visible?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• StormPipeInletsDesc ( type: esriFieldTypeString, alias: If pipe inlets visible, which ones?, length: 50 )
• StormPipeInletSediment ( type: esriFieldTypeString, alias: Deposits of sediment at pipe inlets?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• StormPipeInletSedimentForebay ( type: esriFieldTypeString, alias: Sediment forebay at pipe inlets?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• DownstreamSediment ( type: esriFieldTypeString, alias: Any accumulation of sediment?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• DownstreamObstruction ( type: esriFieldTypeString, alias: Any obstruction?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• DownstreamErosion ( type: esriFieldTypeString, alias: Downstream signs of erosion?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• DownstreamRipRap ( type: esriFieldTypeString, alias: Any rip rap?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• EncroachmentBasinEasement ( type: esriFieldTypeString, alias: Filling or occupation in basin easement?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• EncroachmentBasinEasementDesc ( type: esriFieldTypeString, alias: Describe basin easement encroachment, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Additional notes, length: 2000 )
• Recommendations ( type: esriFieldTypeString, alias: Recommended actions, length: 2000 )
• Rel_GlobalID ( type: esriFieldTypeGUID, alias: Rel_GlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )

Relationships:

• HYDROLOGY.PondPhotoLocations (1) -- Related To: Pond Photo Locations (1)
• HYDROLOGY.StormwaterDetention (0) -- Related To: Detention/Retention Ponds (0)

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

  Iteminfo   Thumbnail   Metadata