Name: sedaFOGHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

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

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: System-maintained ObjectID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, editable: true, nullable: true, length: 20, defaultValue: null, modelName: assetkey )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, editable: true, nullable: true, length: 50, defaultValue: null, modelName: workorderid )
• attachmentid1 ( type: esriFieldTypeInteger, alias: AttachmentID1, editable: true, nullable: true, defaultValue: null, modelName: attachmentid1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2, editable: true, nullable: true, defaultValue: null, modelName: attachmentid2 )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: workdate )
• workby ( type: esriFieldTypeString, alias: WorkBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: workby )
• worktype ( type: esriFieldTypeString, alias: worktype, editable: true, nullable: true, length: 50, defaultValue: null, modelName: worktype )
• comments ( type: esriFieldTypeString, alias: comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: comments )
• facility ( type: esriFieldTypeString, alias: facility, editable: true, nullable: true, length: 50, defaultValue: null, modelName: facility )
• address ( type: esriFieldTypeString, alias: address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: address )
• contact ( type: esriFieldTypeString, alias: contact, editable: true, nullable: true, length: 50, defaultValue: null, modelName: contact )
• contactphone ( type: esriFieldTypeString, alias: contactphone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: contactphone )
• inspector ( type: esriFieldTypeString, alias: inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: inspector , Coded Values: [Maurice Fortier: Maurice Fortier] , [Ken Ferreira: Ken Ferreira] , [Mark Giglio: Mark Giglio] , ...4 more... )
• inspectorphone ( type: esriFieldTypeString, alias: inspectorphone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: inspectorphone )
• lastinspected ( type: esriFieldTypeDate, alias: lastinspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lastinspected )
• trapph ( type: esriFieldTypeDouble, alias: trapph, editable: true, nullable: true, defaultValue: null, modelName: trapph )
• foodwasteintrap ( type: esriFieldTypeString, alias: foodwasteintrap, editable: true, nullable: true, length: 10, defaultValue: null, modelName: foodwasteintrap , Coded Values: [Yes: Yes] , [No: No] )
• deviceaccessible ( type: esriFieldTypeString, alias: deviceaccessible, editable: true, nullable: true, length: 10, defaultValue: null, modelName: deviceaccessible , Coded Values: [Yes: Yes] , [No: No] )
• notes ( type: esriFieldTypeString, alias: notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: notes )
• maintlog ( type: esriFieldTypeString, alias: maintlog, editable: true, nullable: true, length: 10, defaultValue: null, modelName: maintlog , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• trapcleanedregularly ( type: esriFieldTypeString, alias: trapcleanedregularly, editable: true, nullable: true, length: 10, defaultValue: null, modelName: trapcleanedregularly , Coded Values: [Yes: Yes] , [No: No] )
• cleaningdocumented ( type: esriFieldTypeString, alias: cleaningdocumented, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cleaningdocumented , Coded Values: [Yes: Yes] , [No: No] )
• datecleaned ( type: esriFieldTypeDate, alias: datecleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: datecleaned )
• cleaningcompany ( type: esriFieldTypeString, alias: cleaningcompany, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cleaningcompany , Coded Values: )
• effectivevolume ( type: esriFieldTypeDouble, alias: effectivevolume, editable: true, nullable: true, defaultValue: null, modelName: effectivevolume )
• galspumped ( type: esriFieldTypeDouble, alias: galspumped, editable: true, nullable: true, defaultValue: null, modelName: galspumped )
• logentrysigned ( type: esriFieldTypeString, alias: logentrysigned, editable: true, nullable: true, length: 10, defaultValue: null, modelName: logentrysigned , Coded Values: [Yes: Yes] , [No: No] )
• fogdepthreported ( type: esriFieldTypeString, alias: fogdepthreported, editable: true, nullable: true, length: 10, defaultValue: null, modelName: fogdepthreported , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• stafftrainedbmps ( type: esriFieldTypeString, alias: stafftrainedbmps, editable: true, nullable: true, length: 10, defaultValue: null, modelName: stafftrainedbmps , Coded Values: [Yes: Yes] , [No: No] )
• greasesignsposted ( type: esriFieldTypeString, alias: greasesignsposted, editable: true, nullable: true, length: 10, defaultValue: null, modelName: greasesignsposted , Coded Values: [Yes: Yes] , [No: No] )
• recyclerecords ( type: esriFieldTypeString, alias: recyclerecords, editable: true, nullable: true, length: 10, defaultValue: null, modelName: recyclerecords , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• foodwastedisposal ( type: esriFieldTypeString, alias: foodwastedisposal, editable: true, nullable: true, length: 20, defaultValue: null, modelName: foodwastedisposal , Coded Values: [Recycled: Recycled] , [Solid Waste Removal: Solid Waste Removal] )
• fogsystemcovered ( type: esriFieldTypeString, alias: fogsystemcovered, editable: true, nullable: true, length: 10, defaultValue: null, modelName: fogsystemcovered , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• stormdrainprotection ( type: esriFieldTypeString, alias: stormdrainprotection, editable: true, nullable: true, length: 10, defaultValue: null, modelName: stormdrainprotection , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• sppavailable ( type: esriFieldTypeString, alias: sppavailable, editable: true, nullable: true, length: 10, defaultValue: null, modelName: sppavailable , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• exhaustunitsclean ( type: esriFieldTypeString, alias: exhaustunitsclean, editable: true, nullable: true, length: 10, defaultValue: null, modelName: exhaustunitsclean , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• fogdepthintrap ( type: esriFieldTypeDouble, alias: fogdepthintrap, editable: true, nullable: true, defaultValue: null, modelName: fogdepthintrap )
• comliant ( type: esriFieldTypeString, alias: comliant, editable: true, nullable: true, length: 30, defaultValue: null, modelName: comliant , Coded Values: [Compliant: Compliant] , [Not Compliant: Not Compliant] )
• insideoutside ( type: esriFieldTypeString, alias: insideoutside, editable: true, nullable: true, length: 10, defaultValue: null, modelName: insideoutside , Coded Values: [Inside: Inside] , [Outside: Outside] )
• compliant ( type: esriFieldTypeString, alias: compliant, editable: true, nullable: true, length: 50, defaultValue: null, modelName: compliant )
• typeoftrap ( type: esriFieldTypeString, alias: typeoftrap, editable: true, nullable: true, length: 30, defaultValue: null, modelName: typeoftrap )
• cleanfreqvalue ( type: esriFieldTypeDouble, alias: cleanfreqvalue, editable: true, nullable: true, defaultValue: null, modelName: cleanfreqvalue )
• cleanfrequnit ( type: esriFieldTypeString, alias: cleanfrequnit, editable: true, nullable: true, length: 30, defaultValue: null, modelName: cleanfrequnit )
• wocomments ( type: esriFieldTypeString, alias: wocomments, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: wocomments )
• wodescription ( type: esriFieldTypeString, alias: wodescription, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: wodescription )
• inspection_date ( type: esriFieldTypeDate, alias: inspection_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspection_date )
• fog_device_present ( type: esriFieldTypeString, alias: fog_device_present, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fog_device_present , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• primary_fog_device ( type: esriFieldTypeString, alias: primary_fog_device, editable: true, nullable: true, length: 50, defaultValue: null, modelName: primary_fog_device , Coded Values: [AGRU: AGRU] , [PASSIVE - INSIDE: PASSIVE - INSIDE] , [PASSIVE - INSIDE, ABOVEGROUND: PASSIVE - INSIDE, ABOVEGROUND] , ...3 more... )
• Additional_Fog_Devices ( type: esriFieldTypeString, alias: Additional_Fog_Devices, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Additional_Fog_Devices )
• devicesubtypeoeffectivevolume ( type: esriFieldTypeString, alias: device_subtype_or_effective_volume, editable: true, nullable: true, length: 50, defaultValue: null, modelName: devicesubtypeoeffectivevolume )
• fog_device_capacity ( type: esriFieldTypeString, alias: fog_device_capacity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fog_device_capacity , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• fog_device_maintained ( type: esriFieldTypeString, alias: fog_device_maintained, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fog_device_maintained , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• fog_device ( type: esriFieldTypeString, alias: fog_device, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fog_device )
• online_operational ( type: esriFieldTypeString, alias: online_operational, editable: true, nullable: true, length: 50, defaultValue: null, modelName: online_operational , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• food_waste_filter_present ( type: esriFieldTypeString, alias: food_waste_filter_present, editable: true, nullable: true, length: 50, defaultValue: null, modelName: food_waste_filter_present , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• fog_device_online_operational ( type: esriFieldTypeString, alias: fog_device_online_operational, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fog_device_online_operational , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• fog_storage_containers_labeled ( type: esriFieldTypeString, alias: fog_storage_containers_labeled, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fog_storage_containers_labeled , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• follow_up_required ( type: esriFieldTypeString, alias: follow_up_required, editable: true, nullable: true, length: 50, defaultValue: null, modelName: follow_up_required )
• maintenance_log_present ( type: esriFieldTypeString, alias: maintenance_log_present, editable: true, nullable: true, length: 50, defaultValue: null, modelName: maintenance_log_present , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• self_inspections_documented ( type: esriFieldTypeString, alias: self_inspections_documented, editable: true, nullable: true, length: 50, defaultValue: null, modelName: self_inspections_documented , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• cleaning_frequency ( type: esriFieldTypeString, alias: cleaning_frequency, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cleaning_frequency , Coded Values: [Daily: Daily] , [Weekly: Weekly] , [Bi-Monthly: Bi-Monthly] , ...4 more... )
• spill_control_materials_present ( type: esriFieldTypeString, alias: spill_control_materials_present, editable: true, nullable: true, length: 50, defaultValue: null, modelName: spill_control_materials_present , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• outdoorfogprotectfromstormwater ( type: esriFieldTypeString, alias: outdoor_fog_storage_protected_from_discharge_to_storm_water, editable: true, nullable: true, length: 50, defaultValue: null, modelName: outdoorfogprotectfromstormwater , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ImageName ( type: esriFieldTypeString, alias: ImageName, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ImageName )
• ImagePath ( type: esriFieldTypeString, alias: ImagePath, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ImagePath )
• ImageDate ( type: esriFieldTypeDate, alias: ImageDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ImageDate )
• INSPECTION_ID ( type: esriFieldTypeInteger, alias: INSPECTION_ID, editable: true, nullable: true, defaultValue: null, modelName: INSPECTION_ID )

Templates:

• Name: sedaFOGHistory
  Description:
  Prototype:
  ImageDate: null
  INSPECTION_ID: null
  assetkey: null
  workorderid: null
  attachmentid1: null
  attachmentid2: null
  workdate: null
  workby: null
  worktype: null
  comments: null
  facility: null
  address: null
  contact: null
  contactphone: null
  inspector: null
  inspectorphone: null
  lastinspected: null
  trapph: null
  foodwasteintrap: null
  deviceaccessible: null
  notes: null
  maintlog: null
  trapcleanedregularly: null
  cleaningdocumented: null
  datecleaned: null
  cleaningcompany: null
  effectivevolume: null
  galspumped: null
  logentrysigned: null
  fogdepthreported: null
  stafftrainedbmps: null
  greasesignsposted: null
  recyclerecords: null
  foodwastedisposal: null
  fogsystemcovered: null
  stormdrainprotection: null
  sppavailable: null
  exhaustunitsclean: null
  fogdepthintrap: null
  comliant: null
  insideoutside: null
  compliant: null
  typeoftrap: null
  cleanfreqvalue: null
  cleanfrequnit: null
  wocomments: null
  wodescription: null
  inspection_date: null
  fog_device_present: null
  primary_fog_device: null
  Additional_Fog_Devices: null
  devicesubtypeoeffectivevolume: null
  fog_device_capacity: null
  fog_device_maintained: null
  fog_device: null
  online_operational: null
  food_waste_filter_present: null
  fog_device_online_operational: null
  fog_storage_containers_labeled: null
  follow_up_required: null
  maintenance_log_present: null
  self_inspections_documented: null
  cleaning_frequency: null
  spill_control_materials_present: null
  outdoorfogprotectfromstormwater: null
  ImageName: null
  ImagePath: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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