{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Illicit Discharge Inspection", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OutfallID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "OutfallID", "type": "esriFieldTypeString", "alias": "Outfall ID", "length": 255, "domain": null }, { "name": "Subwtrshd", "type": "esriFieldTypeString", "alias": "Subwatershed", "length": 255, "domain": null }, { "name": "Invest", "type": "esriFieldTypeString", "alias": "Investigators", "length": 255, "domain": null }, { "name": "FormBy", "type": "esriFieldTypeString", "alias": "Form Completed By", "length": 255, "domain": null }, { "name": "Temp", "type": "esriFieldTypeDouble", "alias": "Temperature", "domain": null }, { "name": "Rainfall24", "type": "esriFieldTypeDouble", "alias": "Rainfall (in.) Last 24 Hours", "domain": null }, { "name": "Rainfall48", "type": "esriFieldTypeDouble", "alias": "Rainfall (in.) Last 48 Hours", "domain": null }, { "name": "Intersection", "type": "esriFieldTypeString", "alias": "Nearest Intersection / Location", "length": 255, "domain": null }, { "name": "LandUse", "type": "esriFieldTypeString", "alias": "Land use in drainage area", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Notes (e.g., origin of outfall, if known)", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 255, "domain": null }, { "name": "PipeShape", "type": "esriFieldTypeString", "alias": "Shape", "length": 255, "domain": null }, { "name": "Dimensions", "type": "esriFieldTypeDouble", "alias": "Dimensions (in.)", "domain": null }, { "name": "Submerged", "type": "esriFieldTypeString", "alias": "Submerged", "length": 255, "domain": null }, { "name": "FlowPresent", "type": "esriFieldTypeString", "alias": "Flow Present?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FlowDesc", "type": "esriFieldTypeString", "alias": "Flow Description", "length": 255, "domain": { "type": "codedValue", "name": "OutfallFlowDesc", "description": "Flow description", "codedValues": [ { "name": "Trickle", "code": "Trickle" }, { "name": "Moderate", "code": "Moderate" }, { "name": "Substantial", "code": "Substantial" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FlowDepth", "type": "esriFieldTypeDouble", "alias": "Flow Depth", "domain": null }, { "name": "FlowWidth", "type": "esriFieldTypeDouble", "alias": "Flow Width", "domain": null }, { "name": "MeasLength", "type": "esriFieldTypeDouble", "alias": "Measured Length", "domain": null }, { "name": "TimeOTravel", "type": "esriFieldTypeDouble", "alias": "Time of travel", "domain": null }, { "name": "Vol", "type": "esriFieldTypeDouble", "alias": "Volume", "domain": null }, { "name": "TimeTFill", "type": "esriFieldTypeDouble", "alias": "Time to Fill", "domain": null }, { "name": "Temp2", "type": "esriFieldTypeDouble", "alias": "Temp. (F)", "domain": null }, { "name": "Phenol", "type": "esriFieldTypeDouble", "alias": "Phenol (mg/L)", "domain": null }, { "name": "Copper", "type": "esriFieldTypeDouble", "alias": "Copper (mg/L)", "domain": null }, { "name": "pH", "type": "esriFieldTypeDouble", "alias": "pH", "domain": null }, { "name": "Ammonia", "type": "esriFieldTypeDouble", "alias": "Ammonia (mg/L)", "domain": null }, { "name": "Detergent", "type": "esriFieldTypeDouble", "alias": "Detergent (mg/L)", "domain": null }, { "name": "Chlorine", "type": "esriFieldTypeDouble", "alias": "Chlorine (mg/L)", "domain": null }, { "name": "Indicator", "type": "esriFieldTypeString", "alias": "Indicatior Y/N?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IndicatorOdor", "type": "esriFieldTypeString", "alias": "Indicator Odor Y/N", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OdorType", "type": "esriFieldTypeString", "alias": "Odor Description", "length": 255, "domain": { "type": "codedValue", "name": "OutfallOdor", "description": "Odor description", "codedValues": [ { "name": "Sewage", "code": "Sewage" }, { "name": "Rancid/Sour", "code": "Rancid/Sour" }, { "name": "Petroleum/Gas", "code": "Petroleum/Gas" }, { "name": "Sulfide", "code": "Sulfide" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IndicatorColor", "type": "esriFieldTypeString", "alias": "Indicator Color Y/N", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ColorType", "type": "esriFieldTypeString", "alias": "Color Description", "length": 255, "domain": { "type": "codedValue", "name": "OutfallColor", "description": "Color description", "codedValues": [ { "name": "Clear", "code": "Clear" }, { "name": "Brown", "code": "Brown" }, { "name": "Gray", "code": "Gray" }, { "name": "Yellow", "code": "Yellow" }, { "name": "Green", "code": "Green" }, { "name": "Orange", "code": "Orange" }, { "name": "Red", "code": "Red" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IndicatorTurb", "type": "esriFieldTypeString", "alias": "Indicator Turbidity Y/N", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TurbType", "type": "esriFieldTypeString", "alias": "Turbidity Description", "length": 255, "domain": { "type": "codedValue", "name": "OutfallTurb", "description": "Turbidity description", "codedValues": [ { "name": "1 - Slight Cloudiness", "code": "1 - Slight Cloudiness" }, { "name": "2 - Cloudy", "code": "2 - Cloudy" }, { "name": "3 - Opaque", "code": "3 - Opaque" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IndicatorFloat", "type": "esriFieldTypeString", "alias": "Indicator Floatables Y/N", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FloatType", "type": "esriFieldTypeString", "alias": "Floatables Description", "length": 255, "domain": { "type": "codedValue", "name": "OutfallFloat", "description": "Floatables description", "codedValues": [ { "name": "Sewage (Toilet Paper, Etc.)", "code": "Sewage (Toilet Paper, Etc.)" }, { "name": "Suds", "code": "Suds" }, { "name": "Petroleum (Oil Sheen)", "code": "Petroleum (Oil Sheen)" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NonIndicator", "type": "esriFieldTypeString", "alias": "Not Related Flow Indicator Y/N?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IndicatorDam", "type": "esriFieldTypeString", "alias": "Indicator Damage Y/N", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DamType", "type": "esriFieldTypeString", "alias": "Damage Description", "length": 255, "domain": { "type": "codedValue", "name": "OutfallDamage", "description": "Damage description", "codedValues": [ { "name": "Spalling, Cracking or Chipping", "code": "Spalling, Cracking or Chipping" }, { "name": "Corrosion", "code": "Corrosion" }, { "name": "Peeling Paint", "code": "Peeling Paint" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IndicatorDep", "type": "esriFieldTypeString", "alias": "Indicator Deposits/Stains Y/N", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DepType", "type": "esriFieldTypeString", "alias": "Deposit/Stain Description", "length": 255, "domain": { "type": "codedValue", "name": "OutfallDeposits", "description": "Deposits & Stains description", "codedValues": [ { "name": "Oily", "code": "Oily" }, { "name": "Flow Line", "code": "Flow Line" }, { "name": "Paint", "code": "Paint" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IndicatorAbn", "type": "esriFieldTypeString", "alias": "Indicator Abnormal Vegetation Y/N", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AbnType", "type": "esriFieldTypeString", "alias": "Abnormal Vegetation Description ", "length": 255, "domain": { "type": "codedValue", "name": "OutfallAbn", "description": "Abnormal Vegetation decription", "codedValues": [ { "name": "Excessive", "code": "Excessive" }, { "name": "Inhibited", "code": "Inhibited" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IndicatorPool", "type": "esriFieldTypeString", "alias": "Indicator Poor Pool Quality Y/N", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoolType", "type": "esriFieldTypeString", "alias": "Poor Pool Quality Description", "length": 255, "domain": { "type": "codedValue", "name": "OutfallPool", "description": "Poor Pool Quality description", "codedValues": [ { "name": "Odors", "code": "Odors" }, { "name": "Suds", "code": "Suds" }, { "name": "Floatables", "code": "Floatables" }, { "name": "Yellow", "code": "Yellow" }, { "name": "Oil Sheen", "code": "Oil Sheen" }, { "name": "Excessive Algae", "code": "Excessive Algae" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sample", "type": "esriFieldTypeString", "alias": "Sample for the lab?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleYes", "type": "esriFieldTypeString", "alias": "If yes, collected from:", "length": 255, "domain": { "type": "codedValue", "name": "OutfallSample", "description": "Collected From description", "codedValues": [ { "name": "Flow", "code": "Flow" }, { "name": "Pool", "code": "Pool" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OverallComments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "OdorOther", "type": "esriFieldTypeString", "alias": "Odor Other", "length": 255, "domain": null }, { "name": "ColorOther", "type": "esriFieldTypeString", "alias": "Color Other", "length": 255, "domain": null }, { "name": "FloatableOther", "type": "esriFieldTypeString", "alias": "Floatables Other", "length": 255, "domain": null }, { "name": "DamageOther", "type": "esriFieldTypeString", "alias": "Damage Other", "length": 255, "domain": null }, { "name": "DepositOther", "type": "esriFieldTypeString", "alias": "Deposit/Stain Other", "length": 255, "domain": null }, { "name": "PoolOther", "type": "esriFieldTypeString", "alias": "Poor Pool Quality Other", "length": 255, "domain": null }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Today's Date & Time", "length": 8, "domain": null } ], "indexes": [ { "name": "R480_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5892_Outfall", "fields": "OutfallID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "SDE.Stormwater_Features", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "OutfallID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5AB2067F-C54A-4671-903E-1F84D419E47A}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }