{ "currentVersion": 10.81, "id": 2, "name": "OWWSB_GDB.DBO.GreaseControlInspections", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "INSPECTIONDT", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": null }, { "name": "FACILITYREP", "type": "esriFieldTypeString", "alias": "Facility Representative", "length": 100, "domain": null }, { "name": "REPTITLE", "type": "esriFieldTypeString", "alias": "Representative Title", "length": 50, "domain": null }, { "name": "PHONE", "type": "esriFieldTypeString", "alias": "Phone Number", "length": 10, "domain": null }, { "name": "OWNERNAME", "type": "esriFieldTypeString", "alias": "Owner/Regional Manager Name", "length": 50, "domain": null }, { "name": "FACILITYADDR", "type": "esriFieldTypeString", "alias": "Facility Address", "length": 100, "domain": null }, { "name": "GPSID", "type": "esriFieldTypeString", "alias": "GPS ID", "length": 50, "domain": null }, { "name": "LASTGREASEPUMP", "type": "esriFieldTypeDate", "alias": "Last time Grease Pumped", "length": 8, "domain": null }, { "name": "PUMPER", "type": "esriFieldTypeString", "alias": "Name of Pumper", "length": 50, "domain": { "type": "codedValue", "name": "TankPumpingCompanies", "description": "Septic Tank Pumping Companies", "codedValues": [ { "name": "Advance Septic", "code": "Advance Septic" }, { "name": "Anniston Septic Tank Service", "code": "Anniston Septic Tank Service" }, { "name": "Economy Septic Tank Service", "code": "Economy Septic Tank Service" }, { "name": "JD's Septic", "code": "JD's Septic" }, { "name": "Macs Vacs", "code": "Macs Vacs" }, { "name": "Mr. Dan's Plumbing", "code": "Mr. Dan's Plumbing" }, { "name": "NPL Construction - Eric Brown", "code": "NPL Construction - Eric Brown" }, { "name": "On Site Solutions", "code": "On Site Solutions" }, { "name": "Sam Mellon", "code": "Sam Mellon" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PUMPERPREFFERED", "type": "esriFieldTypeString", "alias": "Is Pumper a _Preferred Pumper_ with Oxford WWSB", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GREASEINTERCEPTOR", "type": "esriFieldTypeString", "alias": "Grease Interceptor", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INTERCEPTORSIZE", "type": "esriFieldTypeSmallInteger", "alias": "Interceptor Size", "domain": { "type": "codedValue", "name": "InterceptorSize", "description": "InterceptorSize", "codedValues": [ { "name": "500 gallons", "code": 500 }, { "name": "750 gallons", "code": 750 }, { "name": "1000 gallons", "code": 1000 }, { "name": "1500 gallons", "code": 1500 }, { "name": "2000 gallons", "code": 2000 }, { "name": "3000 gallons", "code": 3000 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OTHERSIZE", "type": "esriFieldTypeSmallInteger", "alias": "Other Size", "domain": { "type": "range", "name": "InterceptorSizeOther", "description": "Interceptor Size Range", "range": [ 0, 0 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TWOINTERCEPTORS", "type": "esriFieldTypeString", "alias": "Two Interceptors in Series", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANHOLEACCESS", "type": "esriFieldTypeSmallInteger", "alias": "Manhole Access to Interceptor", "domain": { "type": "codedValue", "name": "ManholeAccess", "description": "Manhole Access to Interceptor", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ESTGREASEDEPTH", "type": "esriFieldTypeSmallInteger", "alias": "Estimated Grease Layer Depth", "domain": null }, { "name": "EFFLUENTTVISIBLE", "type": "esriFieldTypeString", "alias": "Effluent T visible", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EFFLUENTTGOOD", "type": "esriFieldTypeString", "alias": "Effluent T attached and in good condition", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INTERCEPTORHAULER", "type": "esriFieldTypeString", "alias": "Grease Interceptor Hauler Used", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BACTERIAENZYMESUSED", "type": "esriFieldTypeString", "alias": "Bacteria/Enzymes used", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BACENZPRODNAME", "type": "esriFieldTypeString", "alias": "Product Name", "length": 100, "domain": null }, { "name": "FREQINTERCEPTORUSED", "type": "esriFieldTypeString", "alias": "Frequency Interceptor Cleaned", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMPCONTENTSPUMPED", "type": "esriFieldTypeString", "alias": "Complete Contents Pumped", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RECMAINTCLEANAVAIL", "type": "esriFieldTypeString", "alias": "Records of Maintenance/Cleaning Available", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTDATECLEANED", "type": "esriFieldTypeDate", "alias": "Last Date Cleaned", "length": 8, "domain": null }, { "name": "ISGREASETRAP", "type": "esriFieldTypeString", "alias": "Is Grease Trap", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GTLOCATION", "type": "esriFieldTypeString", "alias": "Grease Trap Location", "length": 20, "domain": { "type": "codedValue", "name": "GTLocation", "description": "Grease Trap Location", "codedValues": [ { "name": "Under sink trap", "code": "Under sink trap" }, { "name": "Floor trap", "code": "Floor trap" }, { "name": "Outisde floor trap", "code": "Outside floor trap" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GTFLOWRAT", "type": "esriFieldTypeString", "alias": "Grease Trap flow-thru rating/grease capacity estimate", "length": 50, "domain": { "type": "codedValue", "name": "GTFlowThru", "description": "Grease Trap Flow-thru", "codedValues": [ { "name": "5 gpm/10 lb", "code": "5 gpm/10 lb" }, { "name": "10 gpm/20 lb", "code": "10 gpm/20 lb" }, { "name": "15 gpm/30 lb", "code": "15 gpm/30 lb" }, { "name": "20 gpm/40 lb", "code": "20 gpm/40 lb" }, { "name": "35 gpm/70 lb", "code": "35 gpm/70 lb" }, { "name": "50 gpm/100 lb", "code": "50 gpm/100 lb" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GTFLOWRATOTHER", "type": "esriFieldTypeString", "alias": "Flow-thru/Capacity Other Estimate", "length": 15, "domain": null }, { "name": "FREQTRAPCLEANED", "type": "esriFieldTypeString", "alias": "Frequency Trap is cleaned", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GTRECMAINTCLEANAVAIL", "type": "esriFieldTypeString", "alias": "Grease Trap Records of Maintenance/Cleaning Available", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GTCOMMENTS", "type": "esriFieldTypeString", "alias": "Grease Trap comments/", "length": 255, "domain": null }, { "name": "BESTMANPRACIMPLEMENTED", "type": "esriFieldTypeString", "alias": "Best Management Practices Implemented", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GREASERECYCLEBIN", "type": "esriFieldTypeString", "alias": "Grease Recycle Bin", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CLEANOUTCOVMISSING", "type": "esriFieldTypeString", "alias": "Cleanout Covers missing or Damaged", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NUMMISSING", "type": "esriFieldTypeSmallInteger", "alias": "Number Missing", "domain": { "type": "range", "name": "MissingCount", "description": "Missing Count", "range": [ 0, 10 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NUMDAMAGED", "type": "esriFieldTypeSmallInteger", "alias": "Number Damaged", "domain": { "type": "range", "name": "MissingCount", "description": "Missing Count", "range": [ 0, 10 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FOGIMPACT", "type": "esriFieldTypeString", "alias": "FOG impact at dumpster or around recycle bin", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FOGCOMMENT", "type": "esriFieldTypeString", "alias": "If Yes, please explain", "length": 255, "domain": null }, { "name": "DSMANHOLENAME", "type": "esriFieldTypeString", "alias": "Downstream Manhole (GIS Name)", "length": 50, "domain": null }, { "name": "DSMANHOLELOC", "type": "esriFieldTypeString", "alias": "Downstream Manhole Location", "length": 100, "domain": null }, { "name": "EVGREASEMANHOLE", "type": "esriFieldTypeString", "alias": "Evidence of Grease in Manhole", "length": 10, "domain": { "type": "codedValue", "name": "GreaseEvidenceMH", "description": "Evidence of Grease in Manhole", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Slight", "code": "Slight" }, { "name": "Moderate", "code": "Moderate" }, { "name": "Heavy", "code": "Heavy" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EVGREASEMANCOMMENT", "type": "esriFieldTypeString", "alias": "Grease Evidence Comment", "length": 255, "domain": null }, { "name": "SAMPLEPOINTACCESS", "type": "esriFieldTypeString", "alias": "Sample Point Access", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EFFLUENTTEMP", "type": "esriFieldTypeDouble", "alias": "Effluent Temperature (F)", "domain": null }, { "name": "EFFLUENTPH", "type": "esriFieldTypeDouble", "alias": "Effluent pH", "domain": null }, { "name": "SAMPLEPOINTLOC", "type": "esriFieldTypeString", "alias": "Sample Point Location", "length": 50, "domain": { "type": "codedValue", "name": "SamplePointLoc", "description": "Sample Point Location", "codedValues": [ { "name": "Interceptor Effluent T", "code": "Interceptor Effluent T" }, { "name": "Downstream MH", "code": "Downstream MH" }, { "name": "Cleanout", "code": "Cleanout" }, { "name": "Sample Drop Box", "code": "Sample Drop Box" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INTERCEPTORPHOTOS", "type": "esriFieldTypeString", "alias": "Interceptor Photos", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DSMANHOLEPHOTOS", "type": "esriFieldTypeString", "alias": "Downstream MH Photos", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OTHERPHOTOS", "type": "esriFieldTypeString", "alias": "Other Photos", "length": 3, "domain": { "type": "codedValue", "name": "YesNoUnk", "description": "Yes, No, Unk", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PHOTOOTHERCOMMENT", "type": "esriFieldTypeString", "alias": "Other Photos COmment", "length": 255, "domain": null }, { "name": "VISUALINSPCOMMENT", "type": "esriFieldTypeString", "alias": "Visual Inspection Results and Comments", "length": 255, "domain": null }, { "name": "INSPECTORNAME", "type": "esriFieldTypeString", "alias": "Inspector Name", "length": 100, "domain": null }, { "name": "REL_ID", "type": "esriFieldTypeString", "alias": "REL_ID", "length": 50, "domain": null } ], "indexes": [ { "name": "R1172_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3443_REL_ID", "fields": "REL_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "ssGreaseSeparator", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REL_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }