{ "currentVersion": 10.71, "id": 103, "name": "sedaFOGHistory", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "assetkey", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "Asset Key", "length": 20, "domain": null }, { "name": "workorderid", "type": "esriFieldTypeString", "alias": "Workorder Key", "length": 50, "domain": null }, { "name": "attachmentid1", "type": "esriFieldTypeInteger", "alias": "AttachmentID1", "domain": null }, { "name": "attachmentid2", "type": "esriFieldTypeInteger", "alias": "AttachmentID2", "domain": null }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "WorkDate", "length": 8, "domain": null }, { "name": "workby", "type": "esriFieldTypeString", "alias": "WorkBy", "length": 50, "domain": null }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "worktype", "length": 50, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 1000, "domain": null }, { "name": "facility", "type": "esriFieldTypeString", "alias": "facility", "length": 50, "domain": null }, { "name": "address", "type": "esriFieldTypeString", "alias": "address", "length": 100, "domain": null }, { "name": "contact", "type": "esriFieldTypeString", "alias": "contact", "length": 50, "domain": null }, { "name": "contactphone", "type": "esriFieldTypeString", "alias": "contactphone", "length": 20, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "inspector", "length": 50, "domain": { "type": "codedValue", "name": "sedaSewerEmployees", "description": "", "codedValues": [ { "name": "Maurice Fortier", "code": "Maurice Fortier" }, { "name": "Ken Ferreira", "code": "Ken Ferreira" }, { "name": "Mark Giglio", "code": "Mark Giglio" }, { "name": "Joe Texeira", "code": "Joe Texeira" }, { "name": "Kevin Semanoff", "code": "Kevin Semanoff" }, { "name": "Antonio Cavallo", "code": "Antonio Cavallo" }, { "name": "Rick Racine", "code": "Rick Racine" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspectorphone", "type": "esriFieldTypeString", "alias": "inspectorphone", "length": 20, "domain": null }, { "name": "lastinspected", "type": "esriFieldTypeDate", "alias": "lastinspected", "length": 8, "domain": null }, { "name": "trapph", "type": "esriFieldTypeDouble", "alias": "trapph", "domain": null }, { "name": "foodwasteintrap", "type": "esriFieldTypeString", "alias": "foodwasteintrap", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "deviceaccessible", "type": "esriFieldTypeString", "alias": "deviceaccessible", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "notes", "type": "esriFieldTypeString", "alias": "notes", "length": 250, "domain": null }, { "name": "maintlog", "type": "esriFieldTypeString", "alias": "maintlog", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNoNA", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "trapcleanedregularly", "type": "esriFieldTypeString", "alias": "trapcleanedregularly", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cleaningdocumented", "type": "esriFieldTypeString", "alias": "cleaningdocumented", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "datecleaned", "type": "esriFieldTypeDate", "alias": "datecleaned", "length": 8, "domain": null }, { "name": "cleaningcompany", "type": "esriFieldTypeString", "alias": "cleaningcompany", "length": 50, "domain": { "type": "codedValue", "name": "sedaCleaningCompany", "description": "", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "effectivevolume", "type": "esriFieldTypeDouble", "alias": "effectivevolume", "domain": null }, { "name": "galspumped", "type": "esriFieldTypeDouble", "alias": "galspumped", "domain": null }, { "name": "logentrysigned", "type": "esriFieldTypeString", "alias": "logentrysigned", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "fogdepthreported", "type": "esriFieldTypeString", "alias": "fogdepthreported", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNoNA", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "stafftrainedbmps", "type": "esriFieldTypeString", "alias": "stafftrainedbmps", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "greasesignsposted", "type": "esriFieldTypeString", "alias": "greasesignsposted", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "recyclerecords", "type": "esriFieldTypeString", "alias": "recyclerecords", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNoNA", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "foodwastedisposal", "type": "esriFieldTypeString", "alias": "foodwastedisposal", "length": 20, "domain": { "type": "codedValue", "name": "sedaFoodWasteRemoval", "description": "", "codedValues": [ { "name": "Recycled", "code": "Recycled" }, { "name": "Solid Waste Removal", "code": "Solid Waste Removal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "fogsystemcovered", "type": "esriFieldTypeString", "alias": "fogsystemcovered", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNoNA", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "stormdrainprotection", "type": "esriFieldTypeString", "alias": "stormdrainprotection", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNoNA", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sppavailable", "type": "esriFieldTypeString", "alias": "sppavailable", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNoNA", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "exhaustunitsclean", "type": "esriFieldTypeString", "alias": "exhaustunitsclean", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNoNA", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "fogdepthintrap", "type": "esriFieldTypeDouble", "alias": "fogdepthintrap", "domain": null }, { "name": "comliant", "type": "esriFieldTypeString", "alias": "comliant", "length": 30, "domain": { "type": "codedValue", "name": "sedaCompliant", "description": "", "codedValues": [ { "name": "Compliant", "code": "Compliant" }, { "name": "Not Compliant", "code": "Not Compliant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "insideoutside", "type": "esriFieldTypeString", "alias": "insideoutside", "length": 10, "domain": { "type": "codedValue", "name": "sedaInsideOutside", "description": "", "codedValues": [ { "name": "Inside", "code": "Inside" }, { "name": "Outside", "code": "Outside" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "compliant", "type": "esriFieldTypeString", "alias": "compliant", "length": 50, "domain": null }, { "name": "typeoftrap", "type": "esriFieldTypeString", "alias": "typeoftrap", "length": 30, "domain": null }, { "name": "cleanfreqvalue", "type": "esriFieldTypeDouble", "alias": "cleanfreqvalue", "domain": null }, { "name": "cleanfrequnit", "type": "esriFieldTypeString", "alias": "cleanfrequnit", "length": 30, "domain": null }, { "name": "wocomments", "type": "esriFieldTypeString", "alias": "wocomments", "length": 1073741822, "domain": null }, { "name": "wodescription", "type": "esriFieldTypeString", "alias": "wodescription", "length": 1000, "domain": null }, { "name": "inspection_date", "type": "esriFieldTypeDate", "alias": "inspection_date", "length": 8, "domain": null }, { "name": "fog_device_present", "type": "esriFieldTypeString", "alias": "fog_device_present", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNAUnknown", "description": "YesNoNAUnknown", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "primary_fog_device", "type": "esriFieldTypeString", "alias": "primary_fog_device", "length": 50, "domain": { "type": "codedValue", "name": "FOG Device", "description": "FOG Device", "codedValues": [ { "name": "AGRU", "code": "AGRU" }, { "name": "PASSIVE - INSIDE", "code": "PASSIVE - INSIDE" }, { "name": "PASSIVE - INSIDE, ABOVEGROUND", "code": "PASSIVE - INSIDE, ABOVEGROUND" }, { "name": "PASSIVE - OUTSIDE", "code": "PASSIVE - OUTSIDE" }, { "name": "OTHER", "code": "OTHER" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Additional_Fog_Devices", "type": "esriFieldTypeString", "alias": "Additional_Fog_Devices", "length": 50, "domain": null }, { "name": "devicesubtypeoeffectivevolume", "type": "esriFieldTypeString", "alias": "device_subtype_or_effective_volume", "length": 50, "domain": null }, { "name": "fog_device_capacity", "type": "esriFieldTypeString", "alias": "fog_device_capacity", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNAUnknown", "description": "YesNoNAUnknown", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "fog_device_maintained", "type": "esriFieldTypeString", "alias": "fog_device_maintained", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNAUnknown", "description": "YesNoNAUnknown", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "fog_device", "type": "esriFieldTypeString", "alias": "fog_device", "length": 50, "domain": null }, { "name": "online_operational", "type": "esriFieldTypeString", "alias": "online_operational", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNAUnknown", "description": "YesNoNAUnknown", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "food_waste_filter_present", "type": "esriFieldTypeString", "alias": "food_waste_filter_present", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNAUnknown", "description": "YesNoNAUnknown", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "fog_device_online_operational", "type": "esriFieldTypeString", "alias": "fog_device_online_operational", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNAUnknown", "description": "YesNoNAUnknown", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "fog_storage_containers_labeled", "type": "esriFieldTypeString", "alias": "fog_storage_containers_labeled", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNAUnknown", "description": "YesNoNAUnknown", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "follow_up_required", "type": "esriFieldTypeString", "alias": "follow_up_required", "length": 50, "domain": null }, { "name": "maintenance_log_present", "type": "esriFieldTypeString", "alias": "maintenance_log_present", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNAUnknown", "description": "YesNoNAUnknown", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "self_inspections_documented", "type": "esriFieldTypeString", "alias": "self_inspections_documented", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNAUnknown", "description": "YesNoNAUnknown", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cleaning_frequency", "type": "esriFieldTypeString", "alias": "cleaning_frequency", "length": 50, "domain": { "type": "codedValue", "name": "Frequency", "description": "Frequency", "codedValues": [ { "name": "Daily", "code": "Daily" }, { "name": "Weekly", "code": "Weekly" }, { "name": "Bi-Monthly", "code": "Bi-Monthly" }, { "name": "Monthly", "code": "Monthly" }, { "name": "Quarterly", "code": "Quarterly" }, { "name": "Semi-Annually", "code": "Semi-Annually" }, { "name": "Annually", "code": "Annually" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "spill_control_materials_present", "type": "esriFieldTypeString", "alias": "spill_control_materials_present", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNAUnknown", "description": "YesNoNAUnknown", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "outdoorfogprotectfromstormwater", "type": "esriFieldTypeString", "alias": "outdoor_fog_storage_protected_from_discharge_to_storm_water", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNAUnknown", "description": "YesNoNAUnknown", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ImageName", "type": "esriFieldTypeString", "alias": "ImageName", "length": 250, "domain": null }, { "name": "ImagePath", "type": "esriFieldTypeString", "alias": "ImagePath", "length": 255, "domain": null }, { "name": "ImageDate", "type": "esriFieldTypeDate", "alias": "ImageDate", "length": 8, "domain": null }, { "name": "INSPECTION_ID", "type": "esriFieldTypeInteger", "alias": "INSPECTION_ID", "domain": null } ], "indexes": [ { "name": "R196_SDE_ROWID_UK", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 3000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }