Name: Facility Inspection

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: c27fc7a4e8dc43cb9bfcc8583b92946d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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

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

• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AssetID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• InspDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• Inspector ( type: esriFieldTypeString, alias: Inspector, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Inspector )
• TimeRain ( type: esriFieldTypeString, alias: Time of Last Rainfall, editable: true, nullable: true, length: 10, defaultValue: Unknown, modelName: TimeRain , Coded Values: [Unknown: Unknown] , [<12 Hrs: <12 Hrs] , [12 Hrs: 12 Hrs] , ...4 more... )
• RainMM ( type: esriFieldTypeSmallInteger, alias: Rain Amount, editable: true, nullable: true, defaultValue: null, modelName: RainMM )
• WaterLevel ( type: esriFieldTypeString, alias: WaterLevel, editable: true, nullable: true, length: 3, defaultValue: N/A, modelName: WaterLevel )
• InletWater ( type: esriFieldTypeString, alias: Inlet Standing Water, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: InletWater , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• InletStructure ( type: esriFieldTypeString, alias: Inlet Structure, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: InletStructure , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• InletErosion ( type: esriFieldTypeString, alias: Inlet Erosion, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: InletErosion , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• InletSediment ( type: esriFieldTypeString, alias: Inlet Sediment, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: InletSediment , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• InletVeg ( type: esriFieldTypeString, alias: Inlet Vegetation, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: InletVeg , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• InletNotes ( type: esriFieldTypeString, alias: Inlet Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InletNotes )
• FbayWater ( type: esriFieldTypeString, alias: Forebay Water Level, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: FbayWater , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• FbayAlgae ( type: esriFieldTypeString, alias: Forebay Algae, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: FbayAlgae , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• FbaySediment ( type: esriFieldTypeString, alias: Forebay Sediment/Debris, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: FbaySediment , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• FbayVeg ( type: esriFieldTypeString, alias: Forebay Vegetation, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: FbayVeg , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• FbayNotes ( type: esriFieldTypeString, alias: Forebay Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FbayNotes )
• WeirStructure ( type: esriFieldTypeString, alias: Weir Structure, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: WeirStructure , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• WeirErosion ( type: esriFieldTypeString, alias: Weir Erosion, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: WeirErosion , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• WeirSediment ( type: esriFieldTypeString, alias: Weir Sediment/Debris, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: WeirSediment , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• WeirVeg ( type: esriFieldTypeString, alias: Weir Vegetation, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: WeirVeg , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• WeirNotes ( type: esriFieldTypeString, alias: Weir Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WeirNotes )
• McellWater ( type: esriFieldTypeString, alias: Main Cell Water Level, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: McellWater , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• McellAlgae ( type: esriFieldTypeString, alias: Main Cell Algae, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: McellAlgae , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• McellErosion ( type: esriFieldTypeString, alias: Main Cell Erosion, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: McellErosion , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• McellSediment ( type: esriFieldTypeString, alias: Main Cell Sediment/Debris, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: McellSediment , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• McellContaminants ( type: esriFieldTypeString, alias: Main Cell Contaminants, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: McellContaminants , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• McellVeg ( type: esriFieldTypeString, alias: Main Cell Vegetation, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: McellVeg , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• McellNotes ( type: esriFieldTypeString, alias: Main Cell Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: McellNotes )
• OutletWater ( type: esriFieldTypeString, alias: Outlet Standing Water, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: OutletWater , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutletErosion ( type: esriFieldTypeString, alias: OutletErosion, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: OutletErosion , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutletSediment ( type: esriFieldTypeString, alias: Outlet Sediment/Debris, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: OutletSediment , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutletVeg ( type: esriFieldTypeString, alias: Outlet Vegetation, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: OutletVeg , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutletNotes ( type: esriFieldTypeString, alias: Outlet Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OutletNotes )
• SpillStructure ( type: esriFieldTypeString, alias: Overflow Structure, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: SpillStructure , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• SpillErosion ( type: esriFieldTypeString, alias: Overflow Erosion, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: SpillErosion , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• SpillSediment ( type: esriFieldTypeString, alias: Overflow Sediment/Debris, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: SpillSediment , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• SpillVeg ( type: esriFieldTypeString, alias: Overflow Vegetation, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: SpillVeg , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• SpillNotes ( type: esriFieldTypeString, alias: Overflow Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SpillNotes )
• OutfallWater ( type: esriFieldTypeString, alias: Outfall Standing Water , editable: true, nullable: true, length: 15, defaultValue: 000, modelName: OutfallWater , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutfallStructure ( type: esriFieldTypeString, alias: Outfall Structure, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: OutfallStructure , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutfallErosion ( type: esriFieldTypeString, alias: Outfall Erosion, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: OutfallErosion , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutfallSediment ( type: esriFieldTypeString, alias: Outfall Sediment/Debris, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: OutfallSediment , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutfallVeg ( type: esriFieldTypeString, alias: Outfall Vegetation, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: OutfallVeg , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutfallNotes ( type: esriFieldTypeString, alias: Outfall Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OutfallNotes )
• DitchCulvert ( type: esriFieldTypeString, alias: Ditches/Culverts, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: DitchCulvert , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• FenceGateLock ( type: esriFieldTypeString, alias: Fence/Gate/Lock, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: FenceGateLock , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• Signage ( type: esriFieldTypeString, alias: Signage, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: Signage , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• Burrows ( type: esriFieldTypeString, alias: Animal Burrows, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: Burrows , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• Garbage ( type: esriFieldTypeString, alias: Garbage, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: Garbage , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• Encroachment ( type: esriFieldTypeString, alias: Encroachment, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: Encroachment , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• MissingVeg ( type: esriFieldTypeString, alias: Missing/Unhealthy vegetation, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: MissingVeg , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• InvasiSpecies ( type: esriFieldTypeString, alias: Invasive Species, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: InvasiSpecies , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• InvasiVeg ( type: esriFieldTypeString, alias: Invasive Vegetation, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: InvasiVeg , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• Road ( type: esriFieldTypeString, alias: Access Road, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: Road , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• SideSlope ( type: esriFieldTypeString, alias: Side Slope, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: SideSlope , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• InletCatchBasin ( type: esriFieldTypeString, alias: Inlet Catch Basin, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: InletCatchBasin , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• InletManhole ( type: esriFieldTypeString, alias: Inlet Manhole, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: InletManhole , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutletManhole ( type: esriFieldTypeString, alias: Outlet Manhole, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: OutletManhole , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• InletOGS ( type: esriFieldTypeString, alias: Inlet OGS, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: InletOGS , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• FbayContaminant ( type: esriFieldTypeString, alias: Forebay Contaminants, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: FbayContaminants , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutletStruc ( type: esriFieldTypeString, alias: Outlet Structure, editable: true, nullable: true, length: 15, defaultValue: 000, modelName: OutletStructure , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• OutletCB ( type: esriFieldTypeString, alias: Outlet Catch Basin, editable: true, nullable: true, length: 15, defaultValue: 00, modelName: OutletCB , Coded Values: [00: N/A] , [000: Not Inspected] , [1: Good] , ...4 more... )
• InletTotal ( type: esriFieldTypeString, alias: Inlet Total, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InletTotal )
• ForebayTotal ( type: esriFieldTypeString, alias: Forebay Total, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ForebayTotal )
• WeirTotal ( type: esriFieldTypeString, alias: Weir Total, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WeirTotal )
• MainCellTotal ( type: esriFieldTypeString, alias: Main Cell Total, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MainCellTotal )
• OutletTotal ( type: esriFieldTypeString, alias: Outlet Total, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OutletTotal )
• OverflowTotal ( type: esriFieldTypeString, alias: Overflow Total, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OverflowTotal )
• OutfallTotal ( type: esriFieldTypeString, alias: Outfall Total, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OutfallTotal )
• GeneralTotal ( type: esriFieldTypeString, alias: General Total, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GeneralTotal )
• InletWeighted ( type: esriFieldTypeString, alias: InletWeighted, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InletWeighted )
• ForebayWeighted ( type: esriFieldTypeString, alias: ForebayWeighted, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ForebayWeighted )
• WeirWeighted ( type: esriFieldTypeString, alias: WeirWeighted, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WeirWeighted )
• McellWeighted ( type: esriFieldTypeString, alias: McellWeighted, editable: true, nullable: true, length: 255, defaultValue: null, modelName: McellWeighted )
• OutletWeighted ( type: esriFieldTypeString, alias: OutletWeighted, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OutletWeighted )
• OverflowWeighted ( type: esriFieldTypeString, alias: OverflowWeighted, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OverflowWeighted )
• OutfallWeighted ( type: esriFieldTypeString, alias: OutfallWeighted, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OutfallWeighted )
• GeneralWeighted ( type: esriFieldTypeString, alias: GeneralWeighted, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GeneralWeighted )
• OverallTotal ( type: esriFieldTypeString, alias: OverallTotal, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OverallTotal )

Templates:

• Name: Facility Inspection
  Description:
  Prototype:
  GeneralWeighted: null
  AssetID: null
  OutfallWeighted: null
  OverflowWeighted: null
  TimeRain: Unknown
  RainMM: null
  WaterLevel: N/A
  InletWater: 000
  InletStructure: 000
  InletErosion: 000
  InletSediment: 000
  InletVeg: 000
  InletNotes: null
  FbayWater: 00
  FbayAlgae: 00
  FbaySediment: 00
  FbayVeg: 00
  FbayNotes: null
  WeirStructure: 00
  WeirErosion: 00
  WeirSediment: 00
  WeirVeg: 00
  WeirNotes: null
  McellWater: 000
  McellAlgae: 000
  McellErosion: 000
  McellSediment: 000
  McellContaminants: 000
  McellVeg: 000
  McellNotes: null
  OutletWater: 000
  OutletErosion: 000
  OutletSediment: 000
  OutletVeg: 000
  OutletNotes: null
  SpillStructure: 000
  SpillErosion: 000
  SpillSediment: 000
  SpillVeg: 000
  SpillNotes: null
  OutfallWater: 000
  OutfallStructure: 000
  OutfallErosion: 000
  OutfallSediment: 000
  OutfallVeg: 000
  OutfallNotes: null
  DitchCulvert: 000
  FenceGateLock: 000
  Signage: 000
  Burrows: 000
  Garbage: 000
  Encroachment: 000
  MissingVeg: 000
  InvasiSpecies: 000
  InvasiVeg: 000
  Road: 000
  SideSlope: 000
  Notes: null
  OverallTotal: null
  created_user: null
  InletCatchBasin: 00
  InletManhole: 00
  OutletManhole: 00
  InletOGS: 00
  FbayContaminant: 00
  OutletStruc: 000
  OutletCB: 00
  InletTotal: null
  ForebayTotal: null
  WeirTotal: null
  MainCellTotal: null
  OutletTotal: null
  OverflowTotal: null
  OutfallTotal: null
  GeneralTotal: null
  InletWeighted: null
  ForebayWeighted: null
  WeirWeighted: null
  McellWeighted: null
  OutletWeighted: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Inspection to Facility (1) -- Related To: Management Facilities (BMP) (513)

Capabilities: Query,Create,Update,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: InspDate
• Creator Field: Inspector
• Edit Date Field:
• Editor Field:

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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