Name: FOG Inspections

Display Field: InspectorName

Type: Table

Geometry Type: N/A

Description:

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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• InspectionID ( type: esriFieldTypeInteger, alias: Inspection ID, editable: true, nullable: true, defaultValue: null, modelName: InspectionID )
• FOGID ( type: esriFieldTypeInteger, alias: FOG ID, editable: true, nullable: true, defaultValue: null, modelName: FOGID )
• DateOfInspection ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateOfInspection )
• TimeOfInspection ( type: esriFieldTypeInteger, alias: Time of Inspection, editable: true, nullable: true, defaultValue: null, modelName: TimeOfInspection )
• InspectorName ( type: esriFieldTypeString, alias: Inspector Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: InspectorName )
• HoursSpentOnSite ( type: esriFieldTypeDouble, alias: Hours on Site, editable: true, nullable: true, defaultValue: null, modelName: HoursSpentOnSite )
• VehicleNumber ( type: esriFieldTypeString, alias: Vehicle Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VehicleNumber )
• DateOfLastService ( type: esriFieldTypeDate, alias: Date of Last Service, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateOfLastService )
• GreaseHauler ( type: esriFieldTypeString, alias: Grease Hauler, editable: true, nullable: true, length: 30, defaultValue: null, modelName: GreaseHauler )
• FirstChamberTop ( type: esriFieldTypeDouble, alias: 1st Chamber Top, editable: true, nullable: true, defaultValue: null, modelName: FirstChamberTop )
• FirstChamberBottom ( type: esriFieldTypeDouble, alias: 1st Chamber Bottom, editable: true, nullable: true, defaultValue: null, modelName: FirstChamberBottom )
• FirstChamberTotalFOGSolids ( type: esriFieldTypeDouble, alias: 1st Chamber Total FOG/Solids, editable: true, nullable: true, defaultValue: null, modelName: FirstChamberTotalFOGSolids )
• FirstChamberTotalHydroDepth ( type: esriFieldTypeDouble, alias: 1st Chamber Total Hydro Depth, editable: true, nullable: true, defaultValue: null, modelName: FirstChamberTotalHydroDepth )
• FirstChamberTotalPercentageFS ( type: esriFieldTypeDouble, alias: 1st Chamber Total % of FS, editable: true, nullable: true, defaultValue: null, modelName: FirstChamberTotalPercentageFS )
• SecondChamberTop ( type: esriFieldTypeDouble, alias: 2nd Chamber Top, editable: true, nullable: true, defaultValue: null, modelName: SecondChamberTop )
• SecondChamberBottom ( type: esriFieldTypeDouble, alias: 2nd Chamber Bottom, editable: true, nullable: true, defaultValue: null, modelName: SecondChamberBottom )
• SecondChamberTotalFOGSolids ( type: esriFieldTypeDouble, alias: 2nd Chamber Total FOG/Solids, editable: true, nullable: true, defaultValue: null, modelName: SecondChamberTotalFOGSolids )
• SecondChamberTotalHydroDepth ( type: esriFieldTypeDouble, alias: 2nd Chamber Total Hydro Depth, editable: true, nullable: true, defaultValue: null, modelName: SecondChamberTotalHydroDepth )
• SecondChamberTotalPercentageFS ( type: esriFieldTypeDouble, alias: 2nd Chamber Total % FS, editable: true, nullable: true, defaultValue: null, modelName: SecondChamberTotalPercentageFS )
• SampleBoxTop ( type: esriFieldTypeDouble, alias: Sample Box Top, editable: true, nullable: true, defaultValue: null, modelName: SampleBoxTop )
• SampleBoxBottom ( type: esriFieldTypeDouble, alias: Sample Bottom, editable: true, nullable: true, defaultValue: null, modelName: SampleBoxBottom )
• SampleBoxTotalFOGSolids ( type: esriFieldTypeDouble, alias: Sample Total FOG Solids, editable: true, nullable: true, defaultValue: null, modelName: SampleBoxTotalFOGSolids )
• SampleBoxTotalHydroDepth ( type: esriFieldTypeDouble, alias: Sample Total Hydro Depth, editable: true, nullable: true, defaultValue: null, modelName: SampleBoxTotalHydroDepth )
• SampleBoxTotalPercentageFS ( type: esriFieldTypeDouble, alias: Sample Total % FS, editable: true, nullable: true, defaultValue: null, modelName: SampleBoxTotalPercentageFS )
• IllicitDischargeEvidence ( type: esriFieldTypeString, alias: ID Evidence?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IllicitDischargeEvidence , Coded Values: [No: No] , [Yes: Yes] )
• IllicitDischargeEvidenceDescrip ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 400, defaultValue: null, modelName: IllicitDischargeEvidenceDescription )
• IllicitDischargeActionTaken ( type: esriFieldTypeString, alias: Action Taken, editable: true, nullable: true, length: 30, defaultValue: null, modelName: IllicitDischargeActionTaken , Coded Values: [Verbal Notice: Verbal Notice] , [BMPs: BMPs] , [Referred to Source Control: Referred to Source Control] )
• IllicitDischargePastEvidence ( type: esriFieldTypeString, alias: Past Evidence?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IllicitDischargePastEvidence )
• IllicitDischargePastDescription ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 400, defaultValue: null, modelName: IllicitDischargePastDescription )
• ReferredToSourceControl ( type: esriFieldTypeString, alias: Referred to Source Control?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ReferredToSourceControl )
• InterceptorCondition ( type: esriFieldTypeString, alias: Interceptor Condition, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InterceptorCondition )
• InterceptorExceeds25Percent ( type: esriFieldTypeString, alias: Exceeds 25% Rule?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: InterceptorExceeds25Percent )
• Complaint ( type: esriFieldTypeString, alias: Complaint, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Complaint )
• Activity ( type: esriFieldTypeString, alias: Activity, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Activity )
• Problem ( type: esriFieldTypeString, alias: Problem, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Problem )
• BusinessContactedDate ( type: esriFieldTypeDate, alias: Contact Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BusinessContactedDate )
• BusinessContactName ( type: esriFieldTypeString, alias: Contact Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: BusinessContactName )
• InterceptorServiceDate ( type: esriFieldTypeDate, alias: Interceptor Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InterceptorServiceDate )
• DateCompletedIDRForm ( type: esriFieldTypeDate, alias: IDR form Completion Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateCompletedIDRForm )
• EnforcementAction ( type: esriFieldTypeString, alias: Enforcement Action, editable: true, nullable: true, length: 35, defaultValue: null, modelName: EnforcementAction , Coded Values: [None: None] , [Verbal Notice: Verbal Notice] , [Warning Notice: Warning Notice] , ...2 more... )
• AdditionalNotes ( type: esriFieldTypeString, alias: Additional Notes, editable: true, nullable: true, length: 400, defaultValue: null, modelName: AdditionalNotes )
• CreatedDate ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CreateBy )
• LastUpdated ( type: esriFieldTypeDate, alias: Last Updated, editable: false, nullable: true, length: 8, defaultValue: null, modelName: RevDate )
• LastEditor ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 20, defaultValue: null, modelName: RevBy )
• RevisionNotes ( type: esriFieldTypeString, alias: Revision Notes, editable: true, nullable: true, length: 256, defaultValue: null, modelName: RevComments )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: FOG Inspections
  Description:
  Prototype:
  RevisionNotes: null
  AdditionalNotes: null
  InspectionID: null
  FOGID: null
  DateOfInspection: null
  TimeOfInspection: null
  InspectorName: null
  HoursSpentOnSite: null
  VehicleNumber: null
  DateOfLastService: null
  GreaseHauler: null
  FirstChamberTop: null
  FirstChamberBottom: null
  FirstChamberTotalFOGSolids: null
  FirstChamberTotalHydroDepth: null
  FirstChamberTotalPercentageFS: null
  SecondChamberTop: null
  SecondChamberBottom: null
  SecondChamberTotalFOGSolids: null
  SecondChamberTotalHydroDepth: null
  SecondChamberTotalPercentageFS: null
  SampleBoxTop: null
  SampleBoxBottom: null
  SampleBoxTotalFOGSolids: null
  SampleBoxTotalHydroDepth: null
  SampleBoxTotalPercentageFS: null
  IllicitDischargeEvidence: null
  IllicitDischargeEvidenceDescrip: null
  IllicitDischargeActionTaken: null
  IllicitDischargePastEvidence: null
  IllicitDischargePastDescription: null
  ReferredToSourceControl: null
  InterceptorCondition: null
  InterceptorExceeds25Percent: null
  Complaint: null
  Activity: null
  Problem: null
  BusinessContactedDate: null
  BusinessContactName: null
  InterceptorServiceDate: null
  DateCompletedIDRForm: null
  EnforcementAction: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ssPermittedFacilities (0) -- Related To: Dental Facility Permit (0)

Capabilities: Query,Sync,Extract

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: CreatedDate
• Creator Field: CreatedBy
• Edit Date Field: LastUpdated
• Editor Field: LastEditor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata