Name: Pond Inspections

Display Field: InspectionDate

Type: Table

Geometry Type: N/A

Description:

Service Item Id: df120fb5b9e5452890b4938eaaa1b3ca

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
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: false
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:

Fields:

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

Templates:

• Name: Pond Inspections
  Description:
  Prototype:
  Rel_GlobalID: null
  Recommendations: null
  InspectionDate: -2209161600000
  Inspector: null
  DrainName: null
  LocationAddress: null
  GovernmentUnit: null
  Temperature: null
  CloudCover: null
  PondType: null
  WetOrDry: null
  PondBottomSediment: null
  PondBottomTrashDebris: null
  PondBottomGrading: null
  PondBottomGradingDesc: null
  PondBottomWaterPockets: null
  BankSignsOfErosion: null
  BankSignsOfErosionDesc: null
  BankSlopeRatio: null
  OutletConditionDesc: null
  OutletDesignApproved: null
  OutletDesignApprovedDesc: null
  OutletVisible: null
  OutletSediment: null
  OutletSedimentInches: null
  OutletStandingWater: null
  OutletStandingWaterInches: null
  OutletFunctionsImpaired: null
  OutletFunctionsImpairedDesc: null
  PrimarySpillwayProvided: null
  PrimarySpillwayDesc: null
  PrimarySpillwayImpaired: null
  PrimarySpillwayImpairedDesc: null
  EmergencySpillwayProvided: null
  EmergencySpillwayImpaired: null
  EmergencySpillwayImpairedDesc: null
  EmergencySpillwayMaterial: null
  StormPipeInlets: null
  StormPipeInletsDesc: null
  StormPipeInletSediment: null
  StormPipeInletSedimentForebay: null
  DownstreamSediment: null
  DownstreamObstruction: null
  DownstreamErosion: null
  DownstreamRipRap: null
  EncroachmentBasinEasement: null
  EncroachmentBasinEasementDesc: null
  Comments: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata