Name: Stream and Stormwater Issues Inspections

Display Field: site_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: a5f3726f753d4f52a99c703c24387199

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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

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