Name: Stream and Stormwater Issues Inspections

Display Field: site_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: c2688f50cd2345d292182a3b156f3395

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

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: false
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: false
Supports Time Relation: false
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:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• site_name ( modelName: Site_Name, nullable: true, editable: true, defaultValue: null, length: 100, alias: Site Name, type: esriFieldTypeString )
• site_id ( modelName: Site_ID, nullable: true, editable: true, defaultValue: null, length: 50, alias: Site ID, type: esriFieldTypeString )
• point_id ( modelName: Point_ID, nullable: true, editable: true, defaultValue: null, length: 50, alias: Point ID, type: esriFieldTypeString )
• inspection_id ( modelName: Inspection_ID, nullable: true, editable: true, defaultValue: null, length: 50, alias: Inspection ID, type: esriFieldTypeString )
• inspected_by ( modelName: Inspected_By, nullable: true, editable: true, defaultValue: null, length: 50, alias: Inspector, type: esriFieldTypeString )
• inspection_link ( modelName: Inspection_Link, nullable: true, editable: true, defaultValue: null, length: 150, alias: Inspection Link, type: esriFieldTypeString )
• channel_downcutting ( modelName: Channel_Downcutting, nullable: true, editable: true, defaultValue: null, alias: Channel Downcutting, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• channel_dc_notes ( modelName: Channel_DC_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Channel Downcutting Notes, type: esriFieldTypeString )
• bank_erosion ( modelName: Bank_Erosion, nullable: true, editable: true, defaultValue: null, alias: Bank Erosion / Widening, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• bank_erosion_notes ( modelName: Bank_Erosion_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Bank Erosion Notes, type: esriFieldTypeString )
• incised_side_channel ( modelName: Incised_Side_Channel, nullable: true, editable: true, defaultValue: null, alias: Incised Side Channel, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• incised_chnl_notes ( modelName: Incised_Chnl_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Incised Channel Notes, type: esriFieldTypeString )
• scour_at_pipe ( modelName: Scour_at_Pipe, nullable: true, editable: true, defaultValue: null, alias: Scour at Pipe, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• scour_at_pipe_notes ( modelName: Scour_at_Pipe_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Scour at Pipe Notes, type: esriFieldTypeString )
• gully_erosion ( modelName: Gully_Erosion, nullable: true, editable: true, defaultValue: null, alias: Gully Erosion / Upland Swale, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• gully_erosion_notes ( modelName: Gully_Erosion_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Gully Erosion Notes, type: esriFieldTypeString )
• buffer ( modelName: Buffer, nullable: true, editable: true, defaultValue: null, alias: Buffer, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• buffer_notes ( modelName: Buffer_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Buffer Notes, type: esriFieldTypeString )
• failed_grade_stb ( modelName: Failed_Grade_Stb, nullable: true, editable: true, defaultValue: null, alias: Failed Grade Stabilization, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• failed_grade_stb_notes ( modelName: Failed_Grade_Stb_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Failed Grade Stb Notes, type: esriFieldTypeString )
• failed_bank_stb ( modelName: Failed_Bank_Stb, nullable: true, editable: true, defaultValue: null, alias: Failed Bank Stabilization, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• failed_bank_stb_notes ( modelName: Failed_Bank_Stb_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Failed Bank Stb Notes, type: esriFieldTypeString )
• channel_sed ( modelName: Channel_Sed, nullable: true, editable: true, defaultValue: null, alias: Channel Sedimentation, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• channel_sed_notes ( modelName: Channel_Sed_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Channel Sed Notes, type: esriFieldTypeString )
• in_stream_obs ( modelName: In_Stream_Obs, nullable: true, editable: true, defaultValue: null, alias: In-Stream Obstruction, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• in_stream_obs_notes ( modelName: In_Stream_Obs_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: In-Stream Obstruction Notes, type: esriFieldTypeString )
• roadway_flooding ( modelName: Roadway_Flooding, nullable: true, editable: true, defaultValue: null, alias: Roadway Flooding, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• roadway_flooding_notes ( modelName: Roadway_Flooding_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Roadway Flooding Notes, type: esriFieldTypeString )
• other_issue ( modelName: Other_Issue, nullable: true, editable: true, defaultValue: null, alias: Other Issue, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] )
• other_issue_notes ( modelName: Other_Issue_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Other Issue Notes, type: esriFieldTypeString )
• additional_issue_score ( modelName: Additional_Issue_Score, nullable: true, editable: true, defaultValue: null, alias: Additional Issue Score, type: esriFieldTypeSmallInteger )
• issue_score ( modelName: Issue_Score, nullable: true, editable: true, defaultValue: null, alias: Current Issue Score, type: esriFieldTypeSmallInteger )
• issue_comments ( modelName: Issue_Comments, nullable: true, editable: true, defaultValue: null, length: 250, alias: Issue Comments, type: esriFieldTypeString )
• sanitary_sewer ( modelName: Sanitary_Sewer, nullable: true, editable: true, defaultValue: null, alias: Sanitary Sewer, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• sanitary_sewer_notes ( modelName: Sanitary_Sewer_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Sanitary Sewer Notes, type: esriFieldTypeString )
• storm_sewer ( modelName: Storm_Sewer, nullable: true, editable: true, defaultValue: null, alias: Storm Sewer, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• storm_sewer_notes ( modelName: Storm_Sewer_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Storm Sewer Notes, type: esriFieldTypeString )
• utility ( modelName: Utility, nullable: true, editable: true, defaultValue: null, alias: Utility, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• utility_notes ( modelName: Utility_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Utility Notes, type: esriFieldTypeString )
• roadway ( modelName: Roadway, nullable: true, editable: true, defaultValue: null, alias: Roadway, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• roadway_notes ( modelName: Roadway_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Roadway Notes, type: esriFieldTypeString )
• bridge_or_culvert ( modelName: Bridge_or_Culvert, nullable: true, editable: true, defaultValue: null, alias: Bridge or Culvert, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• bridge_or_culv_notes ( modelName: Bridge_or_Culv_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Bridge or Culvert Notes, type: esriFieldTypeString )
• building ( modelName: Building, nullable: true, editable: true, defaultValue: null, alias: Building, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• building_notes ( modelName: Building_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Building Notes, type: esriFieldTypeString )
• fence ( modelName: Fence, nullable: true, editable: true, defaultValue: null, alias: Fence, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• fence_notes ( modelName: Fence_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Fence Notes, type: esriFieldTypeString )
• wall ( modelName: Wall, nullable: true, editable: true, defaultValue: null, alias: Wall, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• wall_notes ( modelName: Wall_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Wall Notes, type: esriFieldTypeString )
• trail ( modelName: Trail, nullable: true, editable: true, defaultValue: null, alias: Trail, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• trail_notes ( modelName: Trail_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Trail Notes, type: esriFieldTypeString )
• sidewalk ( modelName: Sidewalk, nullable: true, editable: true, defaultValue: null, alias: Sidewalk, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• sidewalk_notes ( modelName: Sidewalk_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Sidewalk Notes, type: esriFieldTypeString )
• safety_concern ( modelName: Safety_Concern, nullable: true, editable: true, defaultValue: null, alias: Safety Concern, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• safety_concern_notes ( modelName: Safety_Concern_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Safety Concern Notes, type: esriFieldTypeString )
• parking_lot ( modelName: Parking_Lot, nullable: true, editable: true, defaultValue: null, alias: Parking Lot, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• parking_lot_notes ( modelName: Parking_Lot_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Parking Lot Notes, type: esriFieldTypeString )
• private_drive ( modelName: Private_Drive, nullable: true, editable: true, defaultValue: null, alias: Private Drive, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• private_drive_notes ( modelName: Private_Drive_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Private Drive Notes, type: esriFieldTypeString )
• private_land_loss ( modelName: Private_Land_Loss, nullable: true, editable: true, defaultValue: null, alias: Private Land Loss, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• private_land_loss_notes ( modelName: Private_Land_Loss_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Private Land Loss Notes, type: esriFieldTypeString )
• other_infrastructure ( modelName: Other_Infrastructure, nullable: true, editable: true, defaultValue: null, alias: Other Infrastructure, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• other_infras_notes ( modelName: Other_Infras_Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Other Infrastructure Notes, type: esriFieldTypeString )
• additional_infrastructure ( modelName: Additional_Infrastructure, nullable: true, editable: true, defaultValue: null, alias: Additional Infrastructure, type: esriFieldTypeSmallInteger )
• infrastructure_score ( modelName: Infrastructure_Score, nullable: true, editable: true, defaultValue: null, alias: Infrastructure Score, type: esriFieldTypeSmallInteger )
• infrastructure_comments ( modelName: Infrastructure_Comments, nullable: true, editable: true, defaultValue: null, length: 250, alias: Infrastructure Comments, type: esriFieldTypeString )
• total_score ( modelName: Total_Score, nullable: true, editable: true, defaultValue: null, alias: Total Score, type: esriFieldTypeSmallInteger )
• gen_insp_comments ( modelName: Gen_Insp_Comments, nullable: true, editable: true, defaultValue: null, length: 1000, alias: Overall Inspection Comments, type: esriFieldTypeString )
• image_link ( modelName: Image_Link, nullable: true, editable: true, defaultValue: null, length: 150, alias: Image Link, type: esriFieldTypeString )
• cityworks_inspection_id ( modelName: Cityworks_Inspection_ID, nullable: true, editable: true, defaultValue: null, length: 150, alias: Cityworks_Inspection_ID, type: esriFieldTypeString )
• related_guid ( modelName: Related_GUID, nullable: true, editable: true, defaultValue: null, length: 38, alias: Related_GUID, type: esriFieldTypeGUID )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• inspection_date ( modelName: inspection_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Inspection_Date, type: esriFieldTypeDate )

Templates:

• Name: Stream and Stormwater Issues Inspections
  Description:
  Prototype:
  infrastructure_score: null
  in_stream_obs_notes: null
  bank_erosion: null
  parking_lot_notes: null
  bridge_or_culvert: null
  issue_comments: null
  bank_erosion_notes: null
  building: null
  trail: null
  channel_dc_notes: null
  private_land_loss_notes: null
  inspection_id: null
  scour_at_pipe: null
  buffer: null
  safety_concern: null
  wall_notes: null
  other_infras_notes: null
  sidewalk: null
  roadway_flooding: null
  image_link: null
  in_stream_obs: null
  channel_downcutting: null
  failed_grade_stb: null
  related_guid: null
  site_name: null
  inspection_link: null
  additional_infrastructure: null
  site_id: null
  incised_chnl_notes: null
  roadway: null
  failed_bank_stb_notes: null
  channel_sed_notes: null
  parking_lot: null
  gully_erosion_notes: null
  gen_insp_comments: null
  sanitary_sewer: null
  safety_concern_notes: null
  buffer_notes: null
  inspection_date: null
  utility: null
  failed_bank_stb: null
  channel_sed: null
  sidewalk_notes: null
  issue_score: null
  scour_at_pipe_notes: null
  infrastructure_comments: null
  building_notes: null
  gully_erosion: null
  private_drive_notes: null
  trail_notes: null
  roadway_notes: null
  utility_notes: null
  total_score: null
  failed_grade_stb_notes: null
  other_issue: null
  incised_side_channel: null
  storm_sewer: null
  point_id: null
  additional_issue_score: null
  other_issue_notes: null
  bridge_or_culv_notes: null
  cityworks_inspection_id: null
  sanitary_sewer_notes: null
  other_infrastructure: null
  roadway_flooding_notes: null
  private_land_loss: null
  private_drive: null
  storm_sewer_notes: null
  fence_notes: null
  inspected_by: null
  fence: null
  wall: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Stream_and_Stormwater_Issues (0) -- Related To: Stream and Stormwater Issues (0)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

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

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata