Name: Grease Trap Inspections

Display Field: BUS_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TYPE ( type: esriFieldTypeString, alias: Type, length: 255 , Coded Values: [Grease Trap: Grease Trap] , [Sand Trap: Sand Trap] )
• UNITID ( type: esriFieldTypeString, alias: Parent Unit ID, length: 16 )
• BUS_NAME ( type: esriFieldTypeString, alias: Business Name, length: 255 )
• BUS_ADDRESS ( type: esriFieldTypeString, alias: Business Address, length: 150 )
• BUS_CONTACT ( type: esriFieldTypeString, alias: Business Contact, length: 100 )
• BUS_PHONE ( type: esriFieldTypeString, alias: Business Phone, length: 50 )
• TRAP_LOC ( type: esriFieldTypeString, alias: Trap Location, length: 255 )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector Name, length: 100 )
• INSPECT_DT ( type: esriFieldTypeDate, alias: Inspection Date/Time, length: 8 )
• INSPECT_REASON ( type: esriFieldTypeString, alias: Inspection Reason, length: 25 , Coded Values: [Inital: Initial] , [Routine: Routine] , [Re-inspection: Re-inspection for Failed Inspection] , ...3 more... )
• TANK_LEVEL ( type: esriFieldTypeString, alias: Tank Level, length: 25 , Coded Values: [Clean: Clean] , [25% Full: 25% Full] , [50% Full: 50% Full] , ...2 more... )
• RESULT ( type: esriFieldTypeString, alias: Result, length: 50 , Coded Values: [Passed: Passed] , [Failed - Initial: Failed - Initial] , [Failed - Re-inspection: Failed - Re-inspection] , ...1 more... )
• FAIL_REASON ( type: esriFieldTypeString, alias: Failed Inspection Reason, length: 50 , Coded Values: [No Caps: No Caps] , [Full Tank: Full Tank] , [Missing Tee: Missing Tee] , ...1 more... )
• DISCREP ( type: esriFieldTypeString, alias: Discrepancies Noted, length: 1000 )
• REINSP_DT ( type: esriFieldTypeDate, alias: Re-inspection Date, length: 8 )
• ADDL_COMNT ( type: esriFieldTypeString, alias: Additional Comments, length: 2000 )
• CREATOR ( type: esriFieldTypeString, alias: Creator, length: 100 )
• CREATE_DATE ( type: esriFieldTypeDate, alias: Create Date, length: 8 )
• EDITOR ( type: esriFieldTypeString, alias: Editor, length: 100 )
• EDIT_DATE ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• REL_GIS_GUID ( type: esriFieldTypeInteger, alias: Related Trap GIS GUID )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: Related Trap GlobalID, length: 38 )
• GIS_GUID ( type: esriFieldTypeInteger, alias: GIS GUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• FIELD_AUX_1 ( type: esriFieldTypeString, alias: Field Auxiliary 1, length: 20 , Coded Values: [Y: Yes] , [N: No] )
• FIELD_AUX_2 ( type: esriFieldTypeString, alias: Field Auxiliary 2, length: 20 , Coded Values: [Y: Yes] , [N: No] )

Relationships:

• Grease Trap (0) -- Related To: Grease and Sand Traps (0)

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

  Iteminfo   Thumbnail   Metadata