{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 37,
"name": "Illicit Discharge Detection and Elimination",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "InspectorName",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "MDE_GDB_ID",
"type": "esriFieldTypeString",
"alias": "MDE GDB ID",
"length": 13,
"domain": null
},
{
"name": "MDE_GDB_ID_Outfall",
"type": "esriFieldTypeString",
"alias": "MDE_GDB_ID of Outfall",
"length": 13,
"domain": null
},
{
"name": "Str_ID",
"type": "esriFieldTypeInteger",
"alias": "Structure ID",
"domain": null
},
{
"name": "SCREEN_DATE",
"type": "esriFieldTypeDate",
"alias": "Screen Date",
"length": 8,
"domain": null
},
{
"name": "TEST_NUM",
"type": "esriFieldTypeSmallInteger",
"alias": "Inspection Type",
"domain": {
"type": "codedValue",
"name": "dIDDEInspType",
"description": "IDDE Inspection Type",
"codedValues": [
{
"name": "Initial Screening",
"code": 1
},
{
"name": "Follow Up Test",
"code": 2
},
{
"name": "3rd Test",
"code": 3
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "LAST_RAIN",
"type": "esriFieldTypeDate",
"alias": "Date of last rain",
"length": 8,
"domain": null
},
{
"name": "SCREEN_TIME",
"type": "esriFieldTypeString",
"alias": "Screen Time",
"length": 8,
"domain": null
},
{
"name": "OBSERV_FLOW",
"type": "esriFieldTypeString",
"alias": "Was flow observed",
"length": 1,
"domain": {
"type": "codedValue",
"name": "dBoolean",
"description": "Yes or No",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "CFS_FLOW",
"type": "esriFieldTypeDouble",
"alias": "Flow rate in cubic feet per second (CFS)",
"domain": null
},
{
"name": "WATER_TEMP",
"type": "esriFieldTypeDouble",
"alias": "Water Temperature",
"domain": null
},
{
"name": "AIR_TEMP",
"type": "esriFieldTypeDouble",
"alias": "Air Temperature",
"domain": null
},
{
"name": "CHEM_TEST",
"type": "esriFieldTypeString",
"alias": "Chemical test",
"length": 1,
"domain": {
"type": "codedValue",
"name": "dBoolean",
"description": "Yes or No",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "pH",
"type": "esriFieldTypeDouble",
"alias": "pH",
"domain": null
},
{
"name": "PHENOL",
"type": "esriFieldTypeDouble",
"alias": "Phenol",
"domain": null
},
{
"name": "CHLORINE",
"type": "esriFieldTypeDouble",
"alias": "Chlorine",
"domain": null
},
{
"name": "DETERGENTS",
"type": "esriFieldTypeDouble",
"alias": "Detergents",
"domain": null
},
{
"name": "COPPER",
"type": "esriFieldTypeDouble",
"alias": "Copper",
"domain": null
},
{
"name": "ALGAEGROW",
"type": "esriFieldTypeString",
"alias": "Algae Growth Observed",
"length": 1,
"domain": {
"type": "codedValue",
"name": "dBoolean",
"description": "Yes or No",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ODOR",
"type": "esriFieldTypeString",
"alias": "Describe odor",
"length": 3,
"domain": {
"type": "codedValue",
"name": "dOdor",
"description": "Type of Odor",
"codedValues": [
{
"name": "Gas",
"code": "G"
},
{
"name": "None",
"code": "N"
},
{
"name": "Oil",
"code": "OL"
},
{
"name": "Rancid-Sour",
"code": "RS"
},
{
"name": "Sewage",
"code": "SE"
},
{
"name": "Sulfur",
"code": "S"
},
{
"name": "Other",
"code": "OTH"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "COLOR",
"type": "esriFieldTypeString",
"alias": "Color",
"length": 3,
"domain": {
"type": "codedValue",
"name": "dColor",
"description": "Color of Discharge",
"codedValues": [
{
"name": "Brown",
"code": "B"
},
{
"name": "Clear",
"code": "C"
},
{
"name": "Gray",
"code": "G"
},
{
"name": "Green",
"code": "GR"
},
{
"name": "Red",
"code": "R"
},
{
"name": "Yellow",
"code": "Y"
},
{
"name": "Other",
"code": "OTH"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "CLARITY",
"type": "esriFieldTypeString",
"alias": "Clarity",
"length": 3,
"domain": {
"type": "codedValue",
"name": "dClarity",
"description": "Discharge Clarity",
"codedValues": [
{
"name": "Clear",
"code": "C"
},
{
"name": "Cloudy",
"code": "CD"
},
{
"name": "Opaque",
"code": "OP"
},
{
"name": "Other",
"code": "OTH"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "FLOATABLES",
"type": "esriFieldTypeString",
"alias": "Floatables present in discharge",
"length": 3,
"domain": {
"type": "codedValue",
"name": "dFloatables",
"description": "Type of Floatables",
"codedValues": [
{
"name": "None",
"code": "N"
},
{
"name": "Oil Sheen",
"code": "OS"
},
{
"name": "Sewage",
"code": "SE"
},
{
"name": "Trash",
"code": "T"
},
{
"name": "Other",
"code": "OTH"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DEPOSITS",
"type": "esriFieldTypeString",
"alias": "Deposits in outfall area",
"length": 3,
"domain": {
"type": "codedValue",
"name": "dDeposits",
"description": "Deposits in outfall area",
"codedValues": [
{
"name": "Oil",
"code": "OL"
},
{
"name": "None",
"code": "N"
},
{
"name": "Sediment",
"code": "S"
},
{
"name": "Other",
"code": "OTH"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VEG_COND",
"type": "esriFieldTypeString",
"alias": "Vegetative condition in outfall area",
"length": 3,
"domain": {
"type": "codedValue",
"name": "dVegCond",
"description": "Vegetative Condition of Outfall",
"codedValues": [
{
"name": "Excessive Growth",
"code": "EG"
},
{
"name": "Inhibited Growth",
"code": "IG"
},
{
"name": "Normal",
"code": "N"
},
{
"name": "Other",
"code": "OTH"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "STRUCT_COND",
"type": "esriFieldTypeString",
"alias": "Structure Condition",
"length": 3,
"domain": {
"type": "codedValue",
"name": "dStructCond",
"description": "Structural Condition of Outfall",
"codedValues": [
{
"name": "Concrete Cracking",
"code": "CC"
},
{
"name": "Concrete Spalling",
"code": "SP"
},
{
"name": "Normal",
"code": "N"
},
{
"name": "Other",
"code": "OTH"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "EROSION",
"type": "esriFieldTypeString",
"alias": "Erosion",
"length": 1,
"domain": {
"type": "codedValue",
"name": "dErosion",
"description": "Erosion in Outfall Area",
"codedValues": [
{
"name": "Moderate",
"code": "M"
},
{
"name": "None",
"code": "N"
},
{
"name": "Severe",
"code": "S"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "COMPLA_NUM",
"type": "esriFieldTypeString",
"alias": "Is screening complaint driven?",
"length": 1,
"domain": {
"type": "codedValue",
"name": "dBoolean",
"description": "Yes or No",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DISCHARGE_SOURCE",
"type": "esriFieldTypeString",
"alias": "Discharge Source",
"length": 3,
"domain": {
"type": "codedValue",
"name": "dSource",
"description": "Source of the Illicit Discharge",
"codedValues": [
{
"name": "Commercial and Mobile Vehicle Washing",
"code": "V"
},
{
"name": "Drinking Water Transmission Loss",
"code": "D"
},
{
"name": "Dry Weather Sanitary Sewer Overflows",
"code": "S"
},
{
"name": "Floor Drains",
"code": "F"
},
{
"name": "Laundry Washwater",
"code": "L"
},
{
"name": "Non-Illicit Discharge",
"code": "N"
},
{
"name": "Sanitary Direct Connection",
"code": "C"
},
{
"name": "Sewer Pipe Exfiltration",
"code": "E"
},
{
"name": "Other Illicit Discharge",
"code": "OTH"
},
{
"name": "Unknown",
"code": "U"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ILLICIT_Q",
"type": "esriFieldTypeString",
"alias": "Was the discharge illicit",
"length": 1,
"domain": {
"type": "codedValue",
"name": "dBoolean",
"description": "Yes or No",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ILLICIT_ELIM",
"type": "esriFieldTypeString",
"alias": "Status of the illicit discharge",
"length": 1,
"domain": {
"type": "codedValue",
"name": "dIDDEStatus",
"description": "Status of the Illicit Discharge",
"codedValues": [
{
"name": "Eliminated",
"code": "E"
},
{
"name": "Source Under Investigation",
"code": "I"
},
{
"name": "In Process of Correction",
"code": "C"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "YEAR_ELIM",
"type": "esriFieldTypeString",
"alias": "Year illicit discharge was eliminated",
"length": 4,
"domain": null
},
{
"name": "REPORTING_YEAR",
"type": "esriFieldTypeString",
"alias": "Reporting Year",
"length": 4,
"domain": null
},
{
"name": "InspectorName",
"type": "esriFieldTypeString",
"alias": "Inspector Name",
"length": 2,
"domain": {
"type": "codedValue",
"name": "dIDDE_Inspectors",
"description": "Idde Inspectors",
"codedValues": [
{
"name": "Steven Coyle",
"code": "SC"
},
{
"name": "Paul DeSousa",
"code": "PD"
},
{
"name": "Stanley Johnson",
"code": "SJ"
},
{
"name": "Ken Krantz",
"code": "KK"
},
{
"name": "Satinder Sachdeva",
"code": "SS"
},
{
"name": "Yaguba Jalloh",
"code": "YJ"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "Access",
"type": "esriFieldTypeString",
"alias": "Access",
"length": 1,
"domain": {
"type": "codedValue",
"name": "dBoolean",
"description": "Yes or No",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GEN_COMMENTS",
"type": "esriFieldTypeString",
"alias": "General comments",
"length": 255,
"domain": null
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "Created by",
"length": 255,
"domain": null
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "Date created",
"length": 8,
"domain": null
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "Last edited by",
"length": 255,
"domain": null
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "Last edited date",
"length": 8,
"domain": null
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38,
"domain": null
}
],
"indexes": [
{
"name": "R497_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_497",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 12,
"name": "ESMGDB.PGCSW.StormDrainStructures",
"relatedTableId": 6,
"role": "esriRelRoleDestination",
"keyField": "MDE_GDB_ID_Outfall",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false,
"catalogID": "{E3366A35-452C-47AB-9865-6AE6DE4BC895}"
}
],
"capabilities": "Map,Query,Data",
"maxRecordCount": 100000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, PBF",
"isDataVersioned": false,
"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": null,
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
}
}