Name: FOG Inspections

Display Field: InspectorName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:

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

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata