{ "layers": [ { "currentVersion": 10.81, "id": 0, "name": "Grease Separator", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102629, "latestWkid": 102629 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "30ebb72f47c3313919db90449b710993", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAWRJREFUOI3t071Lw0AYx/FvSSF7oaAg9E8wm5Obi2AHh2yCizgIGauDa0U0g0Nxc6lDEVoCksFVCBYHherSgjg42ekQhLZn3hySammtpuoi+MBxcAcffs+9pPnlSv+Dfwz0fX9ZuZ+xCB8hAAJouI01TdPKgDcRGGFZi0BEWBiBGtpRtVrN6rq+H60kBJU7xSIEfN7BEHgBfVrfBU6BZlIw9QYNYi7QAXoALACteOdLUMEfgPrDixLigqqqU1JKhaGzHH8pXtxuCKTiuRsnlBDnHalxoFe6KO0Ys8Y2qXil324X8pX8jS3tq+F0nyY0DOOwUCjkzEVzhSBO1YF8JX9r23YduJ4kIUDbNE1j/nK+5Ww5RXqQ28w59oNdAc6A9qRgCDw5jnOwsbde9Lou5XalDhxHWT+uJF+vc7JUmxNCrGYyGUtKORZLCiKEaKqqWhNCjDzkb4HAs5TynKFH/BOQJBjAK2NXl74RAgmsAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 15, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 5.25 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 605620.9877261706, "ymin": 1125318.48388573, "xmax": 682593.7908012532, "ymax": 1137118.329140678, "spatialReference": { "wkid": 102629, "latestWkid": 102629 } }, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 20, "domain": null }, { "name": "OPDATE", "type": "esriFieldTypeDate", "alias": "Operational Date", "length": 8, "domain": null }, { "name": "STRUCTTYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 30, "domain": { "type": "codedValue", "name": "ssNetworkStructureType", "description": "Sanitary network structure types", "codedValues": [ { "name": "Diversion Chamber", "code": "Diversion Chamber" }, { "name": "Diversion Point", "code": "Diversion Point" }, { "name": "Junction Chamber", "code": "Junction Chamber" }, { "name": "Production Well", "code": "Production Well" }, { "name": "Pump Station", "code": "Pump Station" }, { "name": "Split Manhole", "code": "Split Manhole" }, { "name": "Storage Basin", "code": "Storage Basin" }, { "name": "Tide Chamber", "code": "Tide Chamber" }, { "name": "Treatment Plant", "code": "Treatment Plant" }, { "name": "Lift Station", "code": "Lift Station" }, { "name": "Discharge Structure", "code": "Discharge Structure" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "Virtual Junction", "code": "Virtual Junction" }, { "name": "Flow Meter", "code": "Flow Meter" }, { "name": "Monitoring Well", "code": "Monitoring Well" }, { "name": "Pump", "code": "Pump" }, { "name": "Backflow Prevention", "code": "Backflow Prevention" }, { "name": "Grease Separator", "code": "Grease Separator" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": { "type": "codedValue", "name": "AncillaryRoleDomain", "description": "", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Source", "code": 1 }, { "name": "Sink", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "ELEVATION", "domain": null }, { "name": "EASTING", "type": "esriFieldTypeDouble", "alias": "Easting", "domain": null }, { "name": "NORTHING", "type": "esriFieldTypeDouble", "alias": "Northing", "domain": null }, { "name": "INVERT", "type": "esriFieldTypeDouble", "alias": "INVERT", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "MANCOMM", "type": "esriFieldTypeString", "alias": "Manager Comments", "length": 200, "domain": null }, { "name": "LIQUID", "type": "esriFieldTypeString", "alias": "Liquid", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "THIN", "type": "esriFieldTypeSmallInteger", "alias": "THIN", "domain": null }, { "name": "MEDIUM", "type": "esriFieldTypeSmallInteger", "alias": "Medium", "domain": null }, { "name": "THICK", "type": "esriFieldTypeSmallInteger", "alias": "Thick", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "PUMPCOMPANY", "type": "esriFieldTypeString", "alias": "PUMPCOMPANY", "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": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "VOLUME", "type": "esriFieldTypeSmallInteger", "alias": "VOLUME", "domain": null }, { "name": "NumTanks", "type": "esriFieldTypeSmallInteger", "alias": "NumTanks", "domain": { "type": "codedValue", "name": "NumTanks", "description": "Number of tanks for grease separator", "codedValues": [ { "name": "one", "code": 1 }, { "name": "two", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R1087_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1087", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1087", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S698_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "GreaseControlInspections", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.81, "id": 1, "name": "OWWSB_GDB.DBO.ssGreaseSeparator__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1159_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1159", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3026_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1159", "fields": "GLOBALID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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 } }, { "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 }, { "currentVersion": 10.81, "id": 3, "name": "OWWSB_GDB.DBO.GreaseControlInspections__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_OBJECTID", "type": "esriFieldTypeInteger", "alias": "REL_OBJECTID", "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null } ], "indexes": [ { "name": "R1173_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3851_REL_OBJ", "fields": "REL_OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "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 } } ] }