{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 8, "name": "Outlet_Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspectdt", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "inspectdt", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "DRYWEATHER", "type": "esriFieldTypeString", "alias": "Dry Weather Condition", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "discharge", "type": "esriFieldTypeString", "alias": "Evidence of Discharge?", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "oilsheen", "type": "esriFieldTypeString", "alias": "Oil Sheen", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "color", "type": "esriFieldTypeString", "alias": "Color", "length": 20, "domain": { "type": "codedValue", "name": "Color", "description": "Color of discharge", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Clear", "code": "Clear" }, { "name": "White", "code": "White" }, { "name": "Gray", "code": "Gray" }, { "name": "Orange/Rust", "code": "Orange/Rust" }, { "name": "Red", "code": "Red" }, { "name": "Yellow", "code": "Yellow" }, { "name": "Green", "code": "Green" }, { "name": "Brown/Black", "code": "Brown/Black" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "turbidity", "type": "esriFieldTypeString", "alias": "Turbidity", "length": 20, "domain": { "type": "codedValue", "name": "Turbidity", "description": "Turbidity descriptions", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Cloudy", "code": "Cloudy" }, { "name": "Opaque", "code": "Opaque" }, { "name": "Silty", "code": "Silty" }, { "name": "Muddy", "code": "Muddy" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "odor", "type": "esriFieldTypeString", "alias": "Odor", "length": 20, "domain": { "type": "codedValue", "name": "Odor", "description": "Odor of discharge", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Chlorine", "code": "Chlorine" }, { "name": "Other", "code": "Other" }, { "name": "Petroleum/Gas", "code": "Petroleum/Gas" }, { "name": "Rancid", "code": "Rancid" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Sulfide", "code": "Sulfide" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "fieldtest", "type": "esriFieldTypeString", "alias": "Field Test", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "residue", "type": "esriFieldTypeString", "alias": "Residue Found", "length": 10, "domain": { "type": "codedValue", "name": "Residue", "description": "Type of residue", "codedValues": [ { "name": "Oil", "code": "Oil" }, { "name": "Petroleum", "code": "Petroleum" }, { "name": "Siltation", "code": "Siltation" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 20, "domain": null }, { "name": "PASSFAIL", "type": "esriFieldTypeString", "alias": "Inspection Passed?", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "status", "type": "esriFieldTypeString", "alias": "Inspection Status", "length": 20, "domain": { "type": "codedValue", "name": "InspectStatus", "description": "The status of the inspection", "codedValues": [ { "name": "Unassigned", "code": "Unassigned" }, { "name": "Assigned", "code": "Assigned" }, { "name": "In Progress", "code": "In Progress" }, { "name": "Completed", "code": "Completed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "notes", "type": "esriFieldTypeString", "alias": "NOTES", "length": 255, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "Rel_GLOBALID", "type": "esriFieldTypeGUID", "alias": "Rel_GLOBALID", "length": 38, "domain": null }, { "name": "severity", "type": "esriFieldTypeString", "alias": "Severity", "length": 10, "domain": { "type": "codedValue", "name": "Severity", "description": "", "codedValues": [ { "name": "1 (Severe)", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5 (Minor)", "code": "5" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "correctability", "type": "esriFieldTypeString", "alias": "Correctability", "length": 10, "domain": { "type": "codedValue", "name": "AccessibilityCorrectability", "description": "Accessibility and Correctability domain values", "codedValues": [ { "name": "1 (Best)", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5 (Worst)", "code": "5" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "accessibility", "type": "esriFieldTypeString", "alias": "Access", "length": 10, "domain": { "type": "codedValue", "name": "AccessibilityCorrectability", "description": "Accessibility and Correctability domain values", "codedValues": [ { "name": "1 (Best)", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5 (Worst)", "code": "5" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "StreamOutfall", "type": "esriFieldTypeString", "alias": "Stream Outfall", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R1473_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9017_Rel_GLO", "fields": "Rel_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1473", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1473", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "LG_Base.DBO.Outlet", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Rel_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "8ff84cc3da73409aa888a0935b0f8302" }