Name: SWPPP Monthly Inspection

Display Field: start_time

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• date ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date )
• start_time ( type: esriFieldTypeString, alias: Start Time, editable: true, nullable: true, length: 10, defaultValue: null, modelName: start_time )
• end_time ( type: esriFieldTypeString, alias: End Time, editable: true, nullable: true, length: 10, defaultValue: null, modelName: end_time )
• weather ( type: esriFieldTypeString, alias: Weather, editable: true, nullable: true, length: 50, defaultValue: null, modelName: weather , Coded Values: [Sunny: Sunny] , [Cloudy: Cloudy] , [Raining: Raining] , ...1 more... )
• date_of_last_rain_fall ( type: esriFieldTypeDate, alias: Date of last rainfall, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date_of_last_rain_fall )
• duration ( type: esriFieldTypeString, alias: Duration, editable: true, nullable: true, length: 25, defaultValue: null, modelName: duration )
• approx_rainfall ( type: esriFieldTypeDouble, alias: Approx Rainfall, editable: true, nullable: true, defaultValue: null, modelName: approx_rainfall )
• inspection_reason ( type: esriFieldTypeString, alias: Inspection Reason, editable: true, nullable: true, length: 50, defaultValue: null, modelName: inspection_reason , Coded Values: [Scheduled: Scheduled] , [Random: Random] , [Complaint: Complaint] )
• question_1 ( type: esriFieldTypeString, alias: question_1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_1 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_2 ( type: esriFieldTypeString, alias: question_2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_2 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_3 ( type: esriFieldTypeString, alias: question_3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_3 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_4 ( type: esriFieldTypeString, alias: question_4, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_4 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_5 ( type: esriFieldTypeString, alias: question_5, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_5 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_6 ( type: esriFieldTypeString, alias: question_6, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_6 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_7 ( type: esriFieldTypeString, alias: question_7, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_7 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_8 ( type: esriFieldTypeString, alias: question_8, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_8 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_9 ( type: esriFieldTypeString, alias: question_9, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_9 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_10 ( type: esriFieldTypeString, alias: question_10, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_10 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_11 ( type: esriFieldTypeString, alias: question_11, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_11 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_12 ( type: esriFieldTypeString, alias: question_12, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_12 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_13 ( type: esriFieldTypeString, alias: question_13, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_13 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• question_14 ( type: esriFieldTypeString, alias: question_14, editable: true, nullable: true, length: 50, defaultValue: null, modelName: question_14 , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• comments_corrective_actions ( type: esriFieldTypeString, alias: Comments or Corrective Actions, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: comments_corrective_actions )
• correction_due_by ( type: esriFieldTypeDate, alias: Corrections Due Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: correction_due_by )
• sev_codes ( type: esriFieldTypeString, alias: SEV Codes, editable: true, nullable: true, length: 25, defaultValue: null, modelName: sev_codes , Coded Values: [DOR11: DOR11] , [DOR18: DOR18] , [BOR12: BOR12] , ...10 more... )
• 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 )
• guid ( type: esriFieldTypeGUID, alias: guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: guid )

Templates:

• Name: SWPPP Monthly Inspection
  Description:
  Prototype:
  sev_codes: null
  guid: null
  date: null
  start_time: null
  end_time: null
  weather: null
  date_of_last_rain_fall: null
  duration: null
  approx_rainfall: null
  inspection_reason: null
  question_1: null
  question_2: null
  question_3: null
  question_4: null
  question_5: null
  question_6: null
  question_7: null
  question_8: null
  question_9: null
  question_10: null
  question_11: null
  question_12: null
  question_13: null
  question_14: null
  comments_corrective_actions: null
  correction_due_by: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• construction_SWPPP_sites (1) -- Related To: UPDES Inspection Form (5)

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

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