{
 "currentVersion": 10.61,
 "id": 1,
 "name": "Bridge Scupper - IDDE Inspection Form",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "INSPECTOR",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "DATEINSPECT",
   "type": "esriFieldTypeDate",
   "alias": "Inspection Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "INSPECTOR",
   "type": "esriFieldTypeString",
   "alias": "Inspector Name",
   "length": 30,
   "domain": null
  },
  {
   "name": "STRUCTUREFOUND",
   "type": "esriFieldTypeString",
   "alias": "Structure Found",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ACCESSIBLE",
   "type": "esriFieldTypeString",
   "alias": "Accessible for Sampling",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ACCESS_NOTES",
   "type": "esriFieldTypeString",
   "alias": "Accessibility Notes",
   "length": 250,
   "domain": null
  },
  {
   "name": "WEATHER",
   "type": "esriFieldTypeString",
   "alias": "Weather Conditions",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "SampleType",
    "description": "",
    "codedValues": [
     {
      "name": "Dry Weather",
      "code": "Dry Weather"
     },
     {
      "name": "Wet Weather",
      "code": "Wet Weather"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "LASTRAIN",
   "type": "esriFieldTypeDate",
   "alias": "Last Rain Event",
   "length": 8,
   "domain": null
  },
  {
   "name": "RAINDURATION",
   "type": "esriFieldTypeDouble",
   "alias": "Rain Event Duration (HRS)",
   "domain": null
  },
  {
   "name": "RAINAMOUNT",
   "type": "esriFieldTypeDouble",
   "alias": "Rain Event Amount (inches)",
   "domain": null
  },
  {
   "name": "FLOW",
   "type": "esriFieldTypeString",
   "alias": "Flow",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "CLARITY",
   "type": "esriFieldTypeString",
   "alias": "Clarity of Flow",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "FlowClarity",
    "description": "",
    "codedValues": [
     {
      "name": "Clear",
      "code": "Clear"
     },
     {
      "name": "Cloudy",
      "code": "Cloudy"
     },
     {
      "name": "Opaque",
      "code": "Opaque"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ODOR",
   "type": "esriFieldTypeString",
   "alias": "Odor",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "Odor",
    "description": "",
    "codedValues": [
     {
      "name": "Laundry",
      "code": "Laundry"
     },
     {
      "name": "None",
      "code": "None"
     },
     {
      "name": "Oil/gas",
      "code": "Oil/gas"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Rotten Eggs",
      "code": "Rotten Eggs"
     },
     {
      "name": "Sewage",
      "code": "Sewage"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "COLOR",
   "type": "esriFieldTypeString",
   "alias": "Color of Flow",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "FlowColor",
    "description": "",
    "codedValues": [
     {
      "name": "Brown",
      "code": "Brown"
     },
     {
      "name": "Green",
      "code": "Green"
     },
     {
      "name": "None",
      "code": "None"
     },
     {
      "name": "Orange",
      "code": "Orange"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Red",
      "code": "Red"
     },
     {
      "name": "Yellow",
      "code": "Yellow"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "SEDIMENT",
   "type": "esriFieldTypeString",
   "alias": "Sedimentation",
   "length": 45,
   "domain": {
    "type": "codedValue",
    "name": "Condition_2",
    "description": "",
    "codedValues": [
     {
      "name": "Failing - requires immediate action",
      "code": "Failing - requires immediate action"
     },
     {
      "name": "Poor - requires maintenance",
      "code": "Poor - requires maintenance"
     },
     {
      "name": "Good - inspect within 2 years",
      "code": "Good - inspect within 2 years"
     },
     {
      "name": "Fair - inspect within 1  year",
      "code": "Fair - inspect within 1  year"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "FLOATABLES",
   "type": "esriFieldTypeString",
   "alias": "Floatables",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "FlowFloatables",
    "description": "",
    "codedValues": [
     {
      "name": "Laundry/Soap Suds",
      "code": "Laundry/Soap Suds"
     },
     {
      "name": "None",
      "code": "None"
     },
     {
      "name": "Oil Sheen",
      "code": "Oil Sheen"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Sewage/Toilet Paper",
      "code": "Sewage/Toilet Paper"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "STAINING",
   "type": "esriFieldTypeString",
   "alias": "Staining",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Staining",
    "description": "",
    "codedValues": [
     {
      "name": "Black",
      "code": "Black"
     },
     {
      "name": "Brown",
      "code": "Brown"
     },
     {
      "name": "None",
      "code": "None"
     },
     {
      "name": "Orange",
      "code": "Orange"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "White",
      "code": "White"
     },
     {
      "name": "Yellow",
      "code": "Yellow"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "VISUALEVIDENCE",
   "type": "esriFieldTypeString",
   "alias": "Visual Evidence of Illicit Discharge",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "NOTES",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "length": 1000,
   "domain": null
  },
  {
   "name": "FIELD_DUPLICATE",
   "type": "esriFieldTypeString",
   "alias": "QA/QC Duplicate Field Sample",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "TEMP",
   "type": "esriFieldTypeDouble",
   "alias": "Temperature (C)",
   "domain": null
  },
  {
   "name": "TEMP_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "Temp abnormal ",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DUP_TEMP",
   "type": "esriFieldTypeDouble",
   "alias": "dup Temperature (C)",
   "domain": null
  },
  {
   "name": "DUP_TEMP_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "dup Temp abnormal",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "CONDUCTIVITY",
   "type": "esriFieldTypeDouble",
   "alias": "Conductivity (uS/cm)",
   "domain": null
  },
  {
   "name": "CONDUCT_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "Conductivity >1000 uS/cm",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DUP_CONDUCT",
   "type": "esriFieldTypeDouble",
   "alias": "dup Conductivity (uS/cm)",
   "domain": null
  },
  {
   "name": "DUP_CONDUCT_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "dup Conductivity >1000 uS/cm",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "PH",
   "type": "esriFieldTypeDouble",
   "alias": "pH",
   "domain": null
  },
  {
   "name": "PH_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "pH < 6 or pH > 8",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DUP_PH",
   "type": "esriFieldTypeDouble",
   "alias": "dup pH",
   "domain": null
  },
  {
   "name": "DUP_PH_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "dup pH < 6 or pH > 8",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "SALINITY",
   "type": "esriFieldTypeDouble",
   "alias": "Salinity (ppt)",
   "domain": null
  },
  {
   "name": "SALINITY_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "Salinity > 10 ppt",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DUP_SALINITY",
   "type": "esriFieldTypeDouble",
   "alias": "dup Salinity (ppt)",
   "domain": null
  },
  {
   "name": "DUP_SALINITY_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "dup Salinity > 10 ppt",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "AMMONIA",
   "type": "esriFieldTypeDouble",
   "alias": "Ammonia (mg/L)",
   "domain": null
  },
  {
   "name": "AMMONIA_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "Ammonia => 0.5 mg/L",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DUP_AMMONIA",
   "type": "esriFieldTypeDouble",
   "alias": "dup Ammonia (mg/L)",
   "domain": null
  },
  {
   "name": "DUP_AMMONIA_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "dup Ammonia => 0.5 mg/L",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "CHLORINE",
   "type": "esriFieldTypeDouble",
   "alias": "Chlorine (mg/L)",
   "domain": null
  },
  {
   "name": "CHLORINE_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "Chlorine > 0.02 mg/L",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DUP_CHLORINE",
   "type": "esriFieldTypeDouble",
   "alias": "dup Chlorine (mg/L)",
   "domain": null
  },
  {
   "name": "DUP_CHLORINE_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "dup Chlorine > 0.02 mg/L",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "SURFACTANTS",
   "type": "esriFieldTypeDouble",
   "alias": "Surfactants (mg/L)",
   "domain": null
  },
  {
   "name": "SURFACTANTS_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "Surfactants => 0.25 mg/L",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DUP_SURFACTANTS",
   "type": "esriFieldTypeDouble",
   "alias": "dup Surfactants (mg/L)",
   "domain": null
  },
  {
   "name": "DUP_SURFACTANTS_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "dup Surfactants => 0.25 mg/L",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "FIELD_NOTES",
   "type": "esriFieldTypeString",
   "alias": "Field Sampling Notes",
   "length": 250,
   "domain": null
  },
  {
   "name": "BACTERIA_SAMPLE",
   "type": "esriFieldTypeString",
   "alias": "Bacteria Sample Collected",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "BACTERIA_SAMPLE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Bacteria Sample Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "LAB_DUPLICATE",
   "type": "esriFieldTypeString",
   "alias": "QA/QC Duplicate Lab Sample",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "LAB_SAMPLE_NO",
   "type": "esriFieldTypeString",
   "alias": "Lab Sample No.",
   "length": 20,
   "domain": null
  },
  {
   "name": "DUP_LAB_SAMPLE_NO",
   "type": "esriFieldTypeString",
   "alias": "dup Lab Sample No.",
   "length": 20,
   "domain": null
  },
  {
   "name": "FECAL_COLIFORM",
   "type": "esriFieldTypeDouble",
   "alias": "Fecal Coliform (CFU/100mL)",
   "domain": null
  },
  {
   "name": "FC_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "FC Results > 400 CFU/100 mL",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DUP_FC",
   "type": "esriFieldTypeDouble",
   "alias": "dup Fecal Coliform (CFU/100mL)",
   "domain": null
  },
  {
   "name": "DUP_FC_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "dup FC Results > 400 CFU/100 mL",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ENTERO",
   "type": "esriFieldTypeDouble",
   "alias": "Enterococci (CFU/100mL or MPN/100mL)",
   "domain": null
  },
  {
   "name": "ENTERO_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "Entero Results >61 (Fresh) or >104 (marine) CFU/100 mL or MPN/100mL",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DUP_ENTERO",
   "type": "esriFieldTypeDouble",
   "alias": "dup Enterococci (CFU/100mL or MPN/100mL)",
   "domain": null
  },
  {
   "name": "DUP_ENTERO_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "dup Entero Results >61 (Fresh) or >104 (marine) CFU/100 mL or MPN/100mL",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "COLIPHAGE",
   "type": "esriFieldTypeDouble",
   "alias": "Coliphage (PFU/100mL)",
   "domain": null
  },
  {
   "name": "COLIPHAGE_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "Coliphage Results => 50 PFU/100mL",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DUP_COLIPHAGE",
   "type": "esriFieldTypeDouble",
   "alias": "dup Coliphage (PFU/100mL)",
   "domain": null
  },
  {
   "name": "DUP_COLIPHAGE_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "dup Coliphage Results => 50 PFU/100mL",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "LAB_NOTES",
   "type": "esriFieldTypeString",
   "alias": "Analysis Notes",
   "length": 200,
   "domain": null
  },
  {
   "name": "INVESTIGATION_NEEDED",
   "type": "esriFieldTypeString",
   "alias": "Investigation NEEDED",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "YNP",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Pending",
      "code": "Pending"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "GUID",
   "type": "esriFieldTypeGUID",
   "alias": "GUID",
   "length": 38,
   "domain": null
  },
  {
   "name": "PIPEID",
   "type": "esriFieldTypeString",
   "alias": "PipeID",
   "length": 15,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "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": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "LAB",
   "type": "esriFieldTypeString",
   "alias": "Lab",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "Lab_Type",
    "description": "Lab Type",
    "codedValues": [
     {
      "name": "BAL",
      "code": "BAL"
     },
     {
      "name": "RIDOH",
      "code": "RIDOT"
     },
     {
      "name": "NETLab",
      "code": "NETLab"
     },
     {
      "name": "ESS",
      "code": "ESS"
     },
     {
      "name": "Eurofins Testing Environmental",
      "code": "Eurofins Testing Environmental"
     },
     {
      "name": "Microbac",
      "code": "Microbac"
     },
     {
      "name": "RI Analytical",
      "code": "RI Analytical"
     },
     {
      "name": "RI State Health",
      "code": "RI State Health"
     },
     {
      "name": "Out of State Lab",
      "code": "Out of State Lab"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SURFACTANT_TEST_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Surfactant Test Type",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Surfactant_Test_Type",
    "description": "Surfactant Test Type",
    "codedValues": [
     {
      "name": "Optical Method",
      "code": "Optical Method"
     },
     {
      "name": "Single Analyte Photometer",
      "code": "Singal Analyte Photometer"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CONSULTANT",
   "type": "esriFieldTypeString",
   "alias": "Consultant",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Affiliation",
    "description": "",
    "codedValues": [
     {
      "name": "Beta Group, Inc.",
      "code": "Beta Group, Inc."
     },
     {
      "name": "CDM Smith, Inc.",
      "code": "CDM Smith, Inc."
     },
     {
      "name": "Crossman Engineering, Inc.",
      "code": "Crossman Engineering, Inc."
     },
     {
      "name": "Fuss & O'Neill, Inc.",
      "code": "Fuss & O'Neill, Inc."
     },
     {
      "name": "GZA, Inc.",
      "code": "GZA, Inc."
     },
     {
      "name": "Horsley Witten Group",
      "code": "Horsley Witten Group"
     },
     {
      "name": "PARE Corporation",
      "code": "PARE Corporation"
     },
     {
      "name": "RIDOT",
      "code": "RIDOT"
     },
     {
      "name": "Stantec",
      "code": "Stantec"
     },
     {
      "name": "Tetra Tech, Inc.",
      "code": "Tetra Tech, Inc."
     },
     {
      "name": "Tetra Tech/SDE",
      "code": "Tetra Tech/SDE"
     },
     {
      "name": "The Louis Berger Group, Inc.",
      "code": "The Louis Berger Group, Inc."
     },
     {
      "name": "Vanasse Hangen Brustlin, Inc.",
      "code": "Vanasse Hangen Brustlin, Inc."
     },
     {
      "name": "VHB/SDE",
      "code": "VHB/SDE"
     },
     {
      "name": "Stantec/SDE",
      "code": "Stantec/SDE"
     },
     {
      "name": "Cataldo & Associates, Inc.",
      "code": "Cataldo & Associates, Inc."
     },
     {
      "name": "Triton Stormwater",
      "code": "Triton Stormwater"
     },
     {
      "name": "GM2, Inc.",
      "code": "GM2, Inc."
     },
     {
      "name": "WSP",
      "code": "WSP"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "STRUCTUREID",
   "type": "esriFieldTypeInteger",
   "alias": "Structure ID",
   "domain": null
  },
  {
   "name": "QAQC_OVERRIDE",
   "type": "esriFieldTypeString",
   "alias": "QAQC Override",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Y/N",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "INSPECTION_REASON",
   "type": "esriFieldTypeString",
   "alias": "Inspection Reason",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "IDDE_Inspection_Reason",
    "description": "IDDE_Inspection_Reason",
    "codedValues": [
     {
      "name": "SCP Screening/Sampling",
      "code": "SCP Screening/Sampling"
     },
     {
      "name": "IDDE Investigation",
      "code": "IDDE Investigation"
     },
     {
      "name": "Monitoring",
      "code": "Monitoring"
     },
     {
      "name": "Pre-2020 Inventory",
      "code": "Pre-2020 Inventory"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Off-Cycle Screening/Sampling",
      "code": "Off-Cycle Screening/Sampling"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "COTININE",
   "type": "esriFieldTypeDouble",
   "alias": "Cotinine (ng/L)",
   "domain": null
  },
  {
   "name": "ACETAMINOPHEN",
   "type": "esriFieldTypeDouble",
   "alias": "Acetaminophen (ng/L)",
   "domain": null
  },
  {
   "name": "PARAXANTHINE",
   "type": "esriFieldTypeDouble",
   "alias": "Paraxanthine (ng/L)",
   "domain": null
  },
  {
   "name": "ATENOLOL",
   "type": "esriFieldTypeDouble",
   "alias": "Atenolol (ng/L)",
   "domain": null
  },
  {
   "name": "CAFFEINE",
   "type": "esriFieldTypeDouble",
   "alias": "Caffeine (ng/L)",
   "domain": null
  },
  {
   "name": "METOPROLOL",
   "type": "esriFieldTypeDouble",
   "alias": "Metoprolol (ng/L)",
   "domain": null
  },
  {
   "name": "DIPHENHYDRAMINE",
   "type": "esriFieldTypeDouble",
   "alias": "Diphenhydramine (ng/L)",
   "domain": null
  },
  {
   "name": "CARBAMAZEPINE",
   "type": "esriFieldTypeDouble",
   "alias": "Carbamazepine (ng/L)",
   "domain": null
  },
  {
   "name": "PHARMA_EXCEED",
   "type": "esriFieldTypeString",
   "alias": "Pharmaceutical Exceedance?",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YNNA",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  }
 ],
 "indexes": [
  {
   "name": "UUID_126",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "gdb_ct3_126",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "GDB_4692_GUID",
   "fields": "GUID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "SWStructures",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, AMF",
 "isDataVersioned": false,
 "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
}