{ "currentVersion": 10.41, "id": 23, "name": "IDDE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "IDDE_ID", "typeIdField": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "IDDE_ID", "type": "esriFieldTypeString", "alias": "IDDE_ID", "length": 13, "domain": null }, { "name": "MDE_OUTFALL_ID", "type": "esriFieldTypeString", "alias": "MDE_OUTFALL_ID", "length": 13, "domain": null }, { "name": "LOCAL_OUTFALL_ID", "type": "esriFieldTypeString", "alias": "LOCAL_OUTFALL_ID", "length": 20, "domain": null }, { "name": "SCREEN_DATE", "type": "esriFieldTypeDate", "alias": "SCREEN_DATE", "length": 8, "domain": null }, { "name": "TEST_NUM", "type": "esriFieldTypeSmallInteger", "alias": "TEST_NUM", "domain": null }, { "name": "LAST_RAIN", "type": "esriFieldTypeDate", "alias": "LAST_RAIN", "length": 8, "domain": null }, { "name": "SCREEN_TIME", "type": "esriFieldTypeString", "alias": "SCREEN_TIME", "length": 8, "domain": null }, { "name": "OBSERV_FLOW", "type": "esriFieldTypeString", "alias": "OBSERV_FLOW", "length": 1, "domain": { "type": "codedValue", "name": "dBoolean", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ] } }, { "name": "CFS_FLOW", "type": "esriFieldTypeDouble", "alias": "CFS_FLOW", "domain": null }, { "name": "WATER_TEMP", "type": "esriFieldTypeDouble", "alias": "WATER_TEMP", "domain": null }, { "name": "AIR_TEMP", "type": "esriFieldTypeDouble", "alias": "AIR_TEMP", "domain": null }, { "name": "CHEM_TEST", "type": "esriFieldTypeString", "alias": "CHEM_TEST", "length": 1, "domain": { "type": "codedValue", "name": "dBoolean", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ] } }, { "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": "ALGAEGROW", "length": 1, "domain": { "type": "codedValue", "name": "dBoolean", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ] } }, { "name": "ODOR", "type": "esriFieldTypeString", "alias": "ODOR", "length": 3, "domain": { "type": "codedValue", "name": "dOdor", "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" } ] } }, { "name": "COLOR", "type": "esriFieldTypeString", "alias": "COLOR", "length": 3, "domain": { "type": "codedValue", "name": "dColor", "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" } ] } }, { "name": "CLARITY", "type": "esriFieldTypeString", "alias": "CLARITY", "length": 3, "domain": { "type": "codedValue", "name": "dClarity", "codedValues": [ { "name": "Clear", "code": "C" }, { "name": "Cloudy", "code": "CD" }, { "name": "Opaque", "code": "OP" }, { "name": "Other", "code": "OTH" } ] } }, { "name": "FLOATABLES", "type": "esriFieldTypeString", "alias": "FLOATABLES", "length": 3, "domain": { "type": "codedValue", "name": "dFloatables", "codedValues": [ { "name": "None", "code": "N" }, { "name": "Oil Sheen", "code": "OS" }, { "name": "Sewage", "code": "SE" }, { "name": "Trash", "code": "T" }, { "name": "Other", "code": "OTH" } ] } }, { "name": "DEPOSITS", "type": "esriFieldTypeString", "alias": "DEPOSITS", "length": 3, "domain": { "type": "codedValue", "name": "dDeposits", "codedValues": [ { "name": "Oil", "code": "OL" }, { "name": "None", "code": "N" }, { "name": "Sediment", "code": "S" }, { "name": "Other", "code": "OTH" } ] } }, { "name": "VEG_COND", "type": "esriFieldTypeString", "alias": "VEG_COND", "length": 3, "domain": { "type": "codedValue", "name": "dVegCond", "codedValues": [ { "name": "Excessive Growth", "code": "EG" }, { "name": "Inhibited Growth", "code": "IG" }, { "name": "Normal", "code": "N" }, { "name": "Other", "code": "OTH" } ] } }, { "name": "STRUCT_COND", "type": "esriFieldTypeString", "alias": "STRUCT_COND", "length": 3, "domain": { "type": "codedValue", "name": "dStructCond", "codedValues": [ { "name": "Concrete Cracking", "code": "CC" }, { "name": "Concrete Spalling", "code": "SP" }, { "name": "Normal", "code": "N" }, { "name": "Other", "code": "OTH" } ] } }, { "name": "EROSION", "type": "esriFieldTypeString", "alias": "EROSION", "length": 1, "domain": { "type": "codedValue", "name": "dErosion", "codedValues": [ { "name": "Moderate", "code": "M" }, { "name": "None", "code": "N" }, { "name": "Severe", "code": "S" } ] } }, { "name": "COMPLA_NUM", "type": "esriFieldTypeString", "alias": "COMPLA_NUM", "length": 1, "domain": { "type": "codedValue", "name": "dBoolean", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ] } }, { "name": "DISCHARGE_SOURCE", "type": "esriFieldTypeString", "alias": "DISCHARGE_SOURCE", "length": 3, "domain": { "type": "codedValue", "name": "dSource", "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" } ] } }, { "name": "ILLICIT_Q", "type": "esriFieldTypeString", "alias": "ILLICIT_Q", "length": 1, "domain": { "type": "codedValue", "name": "dBoolean", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ] } }, { "name": "ILLICIT_ELIM", "type": "esriFieldTypeString", "alias": "ILLICIT_ELIM", "length": 1, "domain": { "type": "codedValue", "name": "dIDDEStatus", "codedValues": [ { "name": "Eliminated", "code": "E" }, { "name": "Source Under Investigation", "code": "I" }, { "name": "In Process of Correction", "code": "C" } ] } }, { "name": "YEAR_ELIM", "type": "esriFieldTypeString", "alias": "YEAR_ELIM", "length": 4, "domain": null }, { "name": "ILLICIT_CREDIT", "type": "esriFieldTypeString", "alias": "ILLICIT_CREDIT", "length": 1, "domain": { "type": "codedValue", "name": "dBoolean", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ] } }, { "name": "IDDE_PROTOCOL", "type": "esriFieldTypeString", "alias": "IDDE_PROTOCOL", "length": 7, "domain": { "type": "codedValue", "name": "dIDDEProtocol", "codedValues": [ { "name": "IDDE Protocol 1", "code": "IDDE P1" }, { "name": "IDDE Protocol 2", "code": "IDDE P2" }, { "name": "IDDE Protocol 3", "code": "IDDE P3" } ] } }, { "name": "CB_SEG_SHED", "type": "esriFieldTypeString", "alias": "CB_SEG_SHED", "length": 8, "domain": { "type": "codedValue", "name": "dCBSegShed", "codedValues": [ { "name": "Anacostia River Tidal Fresh DC", "code": "ANATF_DC" }, { "name": "Anacostia River Tidal Fresh Maryland", "code": "ANATF_MD" }, { "name": "Back River Oligohaline", "code": "BACOH" }, { "name": "Big Annemessex River Mesohaline", "code": "BIGMH" }, { "name": "Bohemia River Oligohaline", "code": "BOHOH" }, { "name": "Bush River Oligohaline", "code": "BSHOH" }, { "name": "C&D Canal Oligohaline Delaware", "code": "C&DOH_DE" }, { "name": "C&D Canal Oligohaline Maryland", "code": "C&DOH_MD" }, { "name": "Choptank River Mesohaline 2", "code": "CHOMH2" }, { "name": "Choptank River Mesohaline Mouth 1", "code": "CHOMH1" }, { "name": "Choptank River Oligohaline", "code": "CHOOH" }, { "name": "Eastern Bay Mesohaline", "code": "EASMH" }, { "name": "Elk River Oligohaline", "code": "ELKOH" }, { "name": "Fishing Bay Mesohaline", "code": "FSBMH" }, { "name": "Gunpowder River Oligohaline", "code": "GUNOH" }, { "name": "Honga River Mesohaline", "code": "HNGMH" }, { "name": "Little Choptank River Mesohaline", "code": "LCHMH" }, { "name": "Lower Chesapeake Bay Mesohaline Maryland", "code": "CB5MH_MD" }, { "name": "Lower Chester River Mesohaline", "code": "CHSMH" }, { "name": "Lower Nanticoke River Mesohaline", "code": "NANMH" }, { "name": "Lower Patuxent River Mesohaline", "code": "PAXMH" }, { "name": "Lower Pocomoke River Mesohaline Maryland", "code": "POCMH_MD" }, { "name": "Lower Potomac River Mesohaline Maryland", "code": "POTMH_MD" }, { "name": "Lower Potomac River Oligohaline Maryland", "code": "POTOH1_MD" }, { "name": "Magothy River Mesohaline", "code": "MAGMH" }, { "name": "Manokin River Mesohaline", "code": "MANMH" }, { "name": "Mattawoman Creek Tidal Fresh", "code": "MATTF" }, { "name": "Middle Chesapeake Bay Mesohaline", "code": "CB4MH" }, { "name": "Middle Chester River Oligohaline", "code": "CHSOH" }, { "name": "Middle Patuxent River Oligohaline", "code": "PAXOH" }, { "name": "Middle Pocomoke River Oligohaline Maryland", "code": "POCOH_MD" }, { "name": "Middle Pocomoke River Oligohaline Virginia", "code": "POCOH_VA" }, { "name": "Middle River Oligohaline", "code": "MIDOH" }, { "name": "Nanjemoy Creek Oligohaline Maryland", "code": "POTOH3_MD" }, { "name": "North East River Tidal Fresh", "code": "NORTF" }, { "name": "Northern Chesapeake Bay Oligohaline", "code": "CB2OH" }, { "name": "Northern Chesapeake Bay Tidal Fresh", "code": "CB1TF" }, { "name": "Patapsco River Mesohaline", "code": "PATMH" }, { "name": "Piscataway Creek Tidal Fresh", "code": "PISTF" }, { "name": "Port Tobacco River Oligohaline Maryland", "code": "POTOH2_MD" }, { "name": "Rhode River Mesohaline", "code": "RHDMH" }, { "name": "Sassafras River Oligohaline", "code": "SASOH" }, { "name": "Severn River Mesohaline", "code": "SEVMH" }, { "name": "South River Mesohaline", "code": "SOUMH" }, { "name": "Tangier Sound Mesohaline Maryland", "code": "TANMH_MD" }, { "name": "Upper Chesapeake Bay Mesohaline", "code": "CB3MH" }, { "name": "Upper Chester River Tidal Fresh", "code": "CHSTF" }, { "name": "Upper Choptank River Tidal Fresh", "code": "CHOTF" }, { "name": "Upper Nanticoke River Oligohaline", "code": "NANOH" }, { "name": "Upper Nanticoke River Tidal Fresh Delaware", "code": "NANTF_DE" }, { "name": "Upper Nanticoke River Tidal Fresh Maryland", "code": "NANTF_MD" }, { "name": "Upper Patuxent River Tidal Fresh", "code": "PAXTF" }, { "name": "Upper Pocomoke River Tidal Fresh", "code": "POCTF" }, { "name": "Upper Potomac River Tidal Fresh DC", "code": "POTTF_DC" }, { "name": "Upper Potomac River Tidal Fresh Maryland", "code": "POTTF_MD" }, { "name": "West River Mesohaline", "code": "WSTMH" }, { "name": "Western Branch Patuxent River Tidal Fresh", "code": "WBRTF" }, { "name": "Wicomico River Mesohaline", "code": "WICMH" } ] } }, { "name": "FLOW_VOL", "type": "esriFieldTypeDouble", "alias": "FLOW_VOL", "domain": null }, { "name": "FLOW_VALUE", "type": "esriFieldTypeString", "alias": "FLOW_VALUE", "length": 1, "domain": { "type": "codedValue", "name": "dFlowValue", "codedValues": [ { "name": "Estimate", "code": "E" }, { "name": "Direct Measurement", "code": "M" } ] } }, { "name": "FLOW_DURATION", "type": "esriFieldTypeDouble", "alias": "FLOW_DURATION", "domain": null }, { "name": "PRE_TN", "type": "esriFieldTypeDouble", "alias": "PRE_TN", "domain": null }, { "name": "POST_TN", "type": "esriFieldTypeDouble", "alias": "POST_TN", "domain": null }, { "name": "TN_VALUE", "type": "esriFieldTypeString", "alias": "TN_VALUE", "length": 1, "domain": { "type": "codedValue", "name": "dNutrValue", "codedValues": [ { "name": "Default", "code": "D" }, { "name": "Direct Measurement", "code": "M" } ] } }, { "name": "PRE_TP", "type": "esriFieldTypeDouble", "alias": "PRE_TP", "domain": null }, { "name": "POST_TP", "type": "esriFieldTypeDouble", "alias": "POST_TP", "domain": null }, { "name": "TP_VALUE", "type": "esriFieldTypeString", "alias": "TP_VALUE", "length": 1, "domain": { "type": "codedValue", "name": "dNutrValue", "codedValues": [ { "name": "Default", "code": "D" }, { "name": "Direct Measurement", "code": "M" } ] } }, { "name": "TN_REDUCTION", "type": "esriFieldTypeDouble", "alias": "TN_REDUCTION", "domain": null }, { "name": "TP_REDUCTION", "type": "esriFieldTypeDouble", "alias": "TP_REDUCTION", "domain": null }, { "name": "REPORTING_YEAR", "type": "esriFieldTypeString", "alias": "REPORTING_YEAR", "length": 4, "domain": null }, { "name": "PERMIT_NUM", "type": "esriFieldTypeString", "alias": "PERMIT_NUM", "length": 11, "domain": null }, { "name": "GEN_COMMENTS", "type": "esriFieldTypeString", "alias": "GEN_COMMENTS", "length": 255, "domain": null } ], "indexes": [ { "name": "R4741_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G17343PERMIT_NUM", "fields": "PERMIT_NUM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G17343MDE_OUTFAL", "fields": "MDE_OUTFALL_ID", "isAscending": true, "isUnique": false, "description": "" } ], "relationships": [ { "id": 23, "name": "Outfall", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "MDE_OUTFALL_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 41, "name": "PermitInfo", "relatedTableId": 28, "role": "esriRelRoleDestination", "keyField": "PERMIT_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 10000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true }, "dateFieldsTimeReference": null }