Name: Grease Trap Inspections

Display Field: BUS_NAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: Grease Trap Inspections
  Description:
  Prototype:
  FIELD_AUX_1: N
  TYPE: null
  UNITID: null
  BUS_NAME: null
  BUS_ADDRESS: null
  BUS_CONTACT: null
  BUS_PHONE: null
  TRAP_LOC: null
  INSPECTOR: null
  INSPECT_DT: null
  INSPECT_REASON: null
  TANK_LEVEL: null
  RESULT: null
  FAIL_REASON: null
  DISCREP: null
  REINSP_DT: null
  ADDL_COMNT: null
  FIELD_AUX_2: N
  GIS_GUID: null
  REL_GLOBALID: null
  REL_GIS_GUID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

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

Sync Can Return Changes: true

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: CREATE_DATE
• Creator Field: CREATOR
• Edit Date Field: EDIT_DATE
• Editor Field: EDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

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