{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 1,
 "name": "Outfall Observations",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "INSPECTIONDATE",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "FACILITYKEY",
   "type": "esriFieldTypeString",
   "alias": "Facility ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "STAFF",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Collection Staff",
   "domain": {
    "type": "codedValue",
    "name": "Staff",
    "description": "",
    "codedValues": [
     {
      "name": "CurryJ",
      "code": 1
     },
     {
      "name": "FortunaJ",
      "code": 2
     },
     {
      "name": "HumphreyJ",
      "code": 4
     },
     {
      "name": "LewengrubJ",
      "code": 6
     },
     {
      "name": "LiuK",
      "code": 7
     },
     {
      "name": "SharpG",
      "code": 10
     },
     {
      "name": "SimionescuG",
      "code": 11
     },
     {
      "name": "ZachK",
      "code": 12
     },
     {
      "name": "MoriM",
      "code": 13
     },
     {
      "name": "GivenS",
      "code": 14
     },
     {
      "name": "RademacherE",
      "code": 17
     },
     {
      "name": "KellyK",
      "code": 18
     },
     {
      "name": "MTep",
      "code": 24
     },
     {
      "name": "KHenry",
      "code": 26
     },
     {
      "name": "BussK",
      "code": 31
     },
     {
      "name": "CamilleA",
      "code": 32
     },
     {
      "name": "PoserN",
      "code": 34
     },
     {
      "name": "Contractor_WSP",
      "code": 35
     },
     {
      "name": "PastorT",
      "code": 36
     },
     {
      "name": "DunnK",
      "code": 37
     },
     {
      "name": "Intern_OCPW",
      "code": 38
     },
     {
      "name": "GrewalJ(NLE)",
      "code": 3
     },
     {
      "name": "IaaliaA(NLE)",
      "code": 5
     },
     {
      "name": "MagsalinJ(NLE)",
      "code": 8
     },
     {
      "name": "PastorB(NLE)",
      "code": 9
     },
     {
      "name": "HendrixT(NLE)",
      "code": 15
     },
     {
      "name": "McGuireA(NLE)",
      "code": 19
     },
     {
      "name": "DCawthorne(NLE)",
      "code": 20
     },
     {
      "name": "WStephens(NLE)",
      "code": 21
     },
     {
      "name": "EBerliner(NLE)",
      "code": 22
     },
     {
      "name": "JEvans(NLE)",
      "code": 23
     },
     {
      "name": "MAzizian(NLE)",
      "code": 25
     },
     {
      "name": "GMerino(NLE)",
      "code": 27
     },
     {
      "name": "TArthur(NLE)",
      "code": 28
     },
     {
      "name": "KClapper(NLE)",
      "code": 29
     },
     {
      "name": "TVonbitner(NLE)",
      "code": 30
     },
     {
      "name": "KayA(NLE)",
      "code": 33
     },
     {
      "name": "SedighiJ(NLE)",
      "code": 16
     },
     {
      "name": "YongC",
      "code": 39
     },
     {
      "name": "SilvaJ",
      "code": 40
     },
     {
      "name": "HidalgoA",
      "code": 41
     },
     {
      "name": "GadS",
      "code": 42
     },
     {
      "name": "Contractor_CWE",
      "code": 43
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "INSPECTIONDATE",
   "type": "esriFieldTypeDate",
   "alias": "Inspection Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ACCESSIBILITY",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Accessibility",
   "domain": {
    "type": "codedValue",
    "name": "Acessibility",
    "description": "",
    "codedValues": [
     {
      "name": "Easily accessible",
      "code": 1
     },
     {
      "name": "Difficult accessibility",
      "code": 2
     },
     {
      "name": "Unsafe accessibility",
      "code": 3
     },
     {
      "name": "Private Property",
      "code": 4
     },
     {
      "name": "Nesting",
      "code": 5
     },
     {
      "name": "Buried",
      "code": 6
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FLOWCOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Flow Condition",
   "domain": {
    "type": "codedValue",
    "name": "FlowCond",
    "description": "",
    "codedValues": [
     {
      "name": "Flowing",
      "code": 1
     },
     {
      "name": "Pooled or Ponded",
      "code": 2
     },
     {
      "name": "Dry",
      "code": 3
     },
     {
      "name": "Other - See Comments",
      "code": 4
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FLOWVELOCITY",
   "type": "esriFieldTypeDouble",
   "alias": "Flow Velocity (Sec. / 6 Feet)",
   "domain": null
  },
  {
   "name": "FLOWWIDTH",
   "type": "esriFieldTypeDouble",
   "alias": "Flow Width",
   "domain": null
  },
  {
   "name": "FLOWDEPTH",
   "type": "esriFieldTypeDouble",
   "alias": "Flow Depth",
   "domain": null
  },
  {
   "name": "BIOLOGYCOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Biological Condition",
   "domain": {
    "type": "codedValue",
    "name": "BiologyCond",
    "description": "",
    "codedValues": [
     {
      "name": "Not Present",
      "code": 1
     },
     {
      "name": "Sparse",
      "code": 2
     },
     {
      "name": "Abundant",
      "code": 3
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "VEGETATIONCOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Vegetative Condition",
   "domain": {
    "type": "codedValue",
    "name": "VegetationCond",
    "description": "",
    "codedValues": [
     {
      "name": "Not Present",
      "code": 1
     },
     {
      "name": "Moderate",
      "code": 2
     },
     {
      "name": "Overgrown",
      "code": 3
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "TRASHCOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Trash Condition",
   "domain": {
    "type": "codedValue",
    "name": "TrashCond",
    "description": "",
    "codedValues": [
     {
      "name": "Not Present (0 Items)",
      "code": 1
     },
     {
      "name": "Sparse (<10 Items)",
      "code": 2
     },
     {
      "name": "Moderate (11-50 Items)",
      "code": 4
     },
     {
      "name": "Abundant (>50 Items)",
      "code": 3
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "STRUCTURALCOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Structural Condition",
   "domain": {
    "type": "codedValue",
    "name": "EM_Outfall_Structural_Cond",
    "description": "Outfall structural cond",
    "codedValues": [
     {
      "name": "Good",
      "code": 1
     },
     {
      "name": "Poor",
      "code": 2
     },
     {
      "name": "Erosion",
      "code": 3
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "IDIC",
   "type": "esriFieldTypeSmallInteger",
   "alias": "ID / IC",
   "domain": {
    "type": "codedValue",
    "name": "IDIC",
    "description": "",
    "codedValues": [
     {
      "name": "None",
      "code": 1
     },
     {
      "name": "Paint",
      "code": 2
     },
     {
      "name": "Oil sheen",
      "code": 3
     },
     {
      "name": "Surfactants",
      "code": 4
     },
     {
      "name": "Trash",
      "code": 5
     },
     {
      "name": "Biohazard",
      "code": 6
     },
     {
      "name": "FOG",
      "code": 7
     },
     {
      "name": "Elevated discharge",
      "code": 8
     },
     {
      "name": "Other - see comments",
      "code": 9
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "MAINTENANCEISSUE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Maintenance Issues",
   "domain": {
    "type": "codedValue",
    "name": "MaintCond",
    "description": "",
    "codedValues": [
     {
      "name": "None",
      "code": 1
     },
     {
      "name": "Graffiti",
      "code": 2
     },
     {
      "name": "Clogged",
      "code": 3
     },
     {
      "name": "Sediment",
      "code": 4
     },
     {
      "name": "Overgrown",
      "code": 5
     },
     {
      "name": "Damaged",
      "code": 6
     },
     {
      "name": "Other - See Comments",
      "code": 7
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 400,
   "domain": null
  },
  {
   "name": "LASTEDITOR",
   "type": "esriFieldTypeString",
   "alias": "LASTEDITOR",
   "length": 50,
   "domain": null
  },
  {
   "name": "LASTUPDATE",
   "type": "esriFieldTypeDate",
   "alias": "LASTUPDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "MEDIALINK",
   "type": "esriFieldTypeString",
   "alias": "Media Link",
   "length": 200,
   "domain": null
  },
  {
   "name": "VISITNUMBER",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Visit Number",
   "domain": null
  },
  {
   "name": "FLOWCONNECTIVITY",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Connectivity to RW",
   "domain": {
    "type": "codedValue",
    "name": "EM_Outfall_Connection_Cond",
    "description": "Connectivity Condition",
    "codedValues": [
     {
      "name": "None - Flow Infiltrates or Outfall is Dry",
      "code": 1
     },
     {
      "name": "Partial - Significant Distance",
      "code": 2
     },
     {
      "name": "Direct Connection",
      "code": 3
     },
     {
      "name": "Undetermined",
      "code": 4
     },
     {
      "name": "Unsafe to Access",
      "code": 5
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "USRWCOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Upstream RW Condition",
   "domain": {
    "type": "codedValue",
    "name": "RWCond",
    "description": "",
    "codedValues": [
     {
      "name": "Dry",
      "code": 1
     },
     {
      "name": "Flowing",
      "code": 2
     },
     {
      "name": "Pooled or Ponded",
      "code": 3
     },
     {
      "name": "Inaccessible",
      "code": 4
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DSRWCOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Downstream RW Condition",
   "domain": {
    "type": "codedValue",
    "name": "RWCond",
    "description": "",
    "codedValues": [
     {
      "name": "Dry",
      "code": 1
     },
     {
      "name": "Flowing",
      "code": 2
     },
     {
      "name": "Pooled or Ponded",
      "code": 3
     },
     {
      "name": "Inaccessible",
      "code": 4
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FLOWCONTRIBUTION",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Relative Contribution to RW Flow",
   "domain": {
    "type": "codedValue",
    "name": "ROCtoRW",
    "description": "",
    "codedValues": [
     {
      "name": "Small Fraction (<10%)",
      "code": 1
     },
     {
      "name": "Minor Fraction (10 - 50%)",
      "code": 2
     },
     {
      "name": "Major Fraction (>50%)",
      "code": 3
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "swDischargePointGUID",
   "type": "esriFieldTypeGUID",
   "alias": "swDischargePointGUID",
   "length": 38,
   "domain": null
  },
  {
   "name": "CONDUCTIVITY",
   "type": "esriFieldTypeDouble",
   "alias": "Conductivity",
   "domain": {
    "type": "range",
    "name": "EM_ConductivityRange",
    "description": "Environmental Monitoring - Conductivity acceptable range",
    "range": [
     0,
     80000
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ALGAECOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Algae Condition",
   "domain": {
    "type": "codedValue",
    "name": "EM_Outfall_AlgaeCond",
    "description": "Environmental Monitoring - Outfall Inventory, algae conditions",
    "codedValues": [
     {
      "name": "No Macroalgae",
      "code": 1
     },
     {
      "name": "Small to Moderate Macroalgae",
      "code": 2
     },
     {
      "name": "Moderate to Abundant Macroalgae",
      "code": 3
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "TRASHLOC",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Trash Location",
   "domain": {
    "type": "codedValue",
    "name": "EM_Outfall_TrashLoc",
    "description": "Environmental Monitoring - Outfall inv, trash location",
    "codedValues": [
     {
      "name": "In flow path of outfall",
      "code": 1
     },
     {
      "name": "Within area surrounding outfall",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OBSWEATHER",
   "type": "esriFieldTypeSmallInteger",
   "alias": "OBSWEATHER",
   "domain": {
    "type": "codedValue",
    "name": "EM_WetDry_Int",
    "description": "Wet or Dry",
    "codedValues": [
     {
      "name": "Dry",
      "code": 1
     },
     {
      "name": "Wet",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "RWALGAECOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "RW Algae Conditions",
   "domain": {
    "type": "codedValue",
    "name": "EM_Outfall_AlgaeCond",
    "description": "Environmental Monitoring - Outfall Inventory, algae conditions",
    "codedValues": [
     {
      "name": "No Macroalgae",
      "code": 1
     },
     {
      "name": "Small to Moderate Macroalgae",
      "code": 2
     },
     {
      "name": "Moderate to Abundant Macroalgae",
      "code": 3
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SCOURWATERCOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Scour Pond Water Condition",
   "domain": {
    "type": "codedValue",
    "name": "EM_Outfall_Scour_Diss_Water",
    "description": "Outfall scour pond conditions",
    "codedValues": [
     {
      "name": "Not present",
      "code": 0
     },
     {
      "name": "Clear",
      "code": 1
     },
     {
      "name": "Brown \"tea\" tint",
      "code": 2
     },
     {
      "name": "Green tint",
      "code": 3
     },
     {
      "name": "Yellow tint",
      "code": 4
     },
     {
      "name": "Chocolate milk",
      "code": 5
     },
     {
      "name": "Pea soup",
      "code": 6
     },
     {
      "name": "Bright green",
      "code": 7
     },
     {
      "name": "Surface scum",
      "code": 8
     },
     {
      "name": "Green streaks",
      "code": 9
     },
     {
      "name": "Floating trash",
      "code": 10
     },
     {
      "name": "Odor",
      "code": 11
     },
     {
      "name": "No ponding",
      "code": 12
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DISSWATERCOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Dissipator Water Condition",
   "domain": {
    "type": "codedValue",
    "name": "EM_Outfall_Scour_Diss_Water",
    "description": "Outfall scour pond conditions",
    "codedValues": [
     {
      "name": "Not present",
      "code": 0
     },
     {
      "name": "Clear",
      "code": 1
     },
     {
      "name": "Brown \"tea\" tint",
      "code": 2
     },
     {
      "name": "Green tint",
      "code": 3
     },
     {
      "name": "Yellow tint",
      "code": 4
     },
     {
      "name": "Chocolate milk",
      "code": 5
     },
     {
      "name": "Pea soup",
      "code": 6
     },
     {
      "name": "Bright green",
      "code": 7
     },
     {
      "name": "Surface scum",
      "code": 8
     },
     {
      "name": "Green streaks",
      "code": 9
     },
     {
      "name": "Floating trash",
      "code": 10
     },
     {
      "name": "Odor",
      "code": 11
     },
     {
      "name": "No ponding",
      "code": 12
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "RWVEGCOND",
   "type": "esriFieldTypeSmallInteger",
   "alias": "RW Vegetation Condition",
   "domain": {
    "type": "codedValue",
    "name": "EM_Outfall_Vegetative_Cond",
    "description": "Outfall vegetative condition",
    "codedValues": [
     {
      "name": "Not Present",
      "code": 1
     },
     {
      "name": "Sparse",
      "code": 2
     },
     {
      "name": "Moderate",
      "code": 3
     },
     {
      "name": "Abundant",
      "code": 4
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FLOWDISCHARGE",
   "type": "esriFieldTypeDouble",
   "alias": "Flow Discharge",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R55_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_1304_GlobalI",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G1304FACILITYKEY",
   "fields": "FACILITYKEY",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "swDischargePoint",
   "fields": "swDischargePointGUID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "OCEnvRes.OCENVRESUSER.swDischargePoint",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "swDischargePointGUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "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,
  "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
 }
}