Name: sedaFOGHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

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

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata