{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 7,
 "name": "GIS.GISADMIN.dOutfallInspection",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SUBWATERSHED",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "SUBWATERSHED",
   "type": "esriFieldTypeString",
   "alias": "Subwatershed",
   "length": 50,
   "domain": null
  },
  {
   "name": "OUTFALLID",
   "type": "esriFieldTypeString",
   "alias": "Outfall ID",
   "length": 20,
   "domain": null
  },
  {
   "name": "INSPDATE",
   "type": "esriFieldTypeDate",
   "alias": "Inspection Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "INSPTIME",
   "type": "esriFieldTypeDate",
   "alias": "Inspection Time",
   "length": 8,
   "domain": null
  },
  {
   "name": "INSPBY",
   "type": "esriFieldTypeString",
   "alias": "Investigators",
   "length": 50,
   "domain": null
  },
  {
   "name": "AIRTEMP_F_",
   "type": "esriFieldTypeString",
   "alias": "Air Temp (F)",
   "length": 10,
   "domain": null
  },
  {
   "name": "RAINFALL_24_IN",
   "type": "esriFieldTypeString",
   "alias": "Rainfall Last 24 hrs (in)",
   "length": 10,
   "domain": null
  },
  {
   "name": "RAINFALL_48_IN",
   "type": "esriFieldTypeString",
   "alias": "Rainfall Last 48 (in)",
   "length": 10,
   "domain": null
  },
  {
   "name": "LANDUSE",
   "type": "esriFieldTypeString",
   "alias": "Land Use",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "d_dOutfallLUDA",
    "description": "Outfall Land Use Drainage Area",
    "codedValues": [
     {
      "name": "Industrial",
      "code": "INDUSTRIAL"
     },
     {
      "name": "Urban Residential",
      "code": "URBAN"
     },
     {
      "name": "Suburban Residential",
      "code": "SUBURBAN"
     },
     {
      "name": "Commercial",
      "code": "COMMERCIAL"
     },
     {
      "name": "Open Space",
      "code": "OPEN"
     },
     {
      "name": "Institutional",
      "code": "INSTITUTIONAL"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LU_OTH_DESC",
   "type": "esriFieldTypeString",
   "alias": "Land Use Other Desc",
   "length": 50,
   "domain": null
  },
  {
   "name": "KNOW_IND",
   "type": "esriFieldTypeString",
   "alias": "Know Industries",
   "length": 50,
   "domain": null
  },
  {
   "name": "NOTES",
   "type": "esriFieldTypeString",
   "alias": "Background data notes",
   "length": 50,
   "domain": null
  },
  {
   "name": "OF_CP",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Outfall Location Closed Pipe",
   "domain": {
    "type": "codedValue",
    "name": "BooleanSymbolValue",
    "description": "Valid values are Yes and No.",
    "codedValues": [
     {
      "name": "Yes",
      "code": 1
     },
     {
      "name": "No",
      "code": 0
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "OF_CP_MAT",
   "type": "esriFieldTypeString",
   "alias": "Outfall Closed Pipe Material",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "d_dStormMainMat",
    "description": "Storm Main Material",
    "codedValues": [
     {
      "name": "Aluminized Corrugated Metal Pipe",
      "code": "ACMP"
     },
     {
      "name": "Cast Iron Connector",
      "code": "CIC"
     },
     {
      "name": "Cast Iron Pipe",
      "code": "CIP"
     },
     {
      "name": "Concrete Pipe",
      "code": "CP"
     },
     {
      "name": "Corrugated Plastic Pipe",
      "code": "CPP"
     },
     {
      "name": "Corrugated Metal Pipe",
      "code": "CMP"
     },
     {
      "name": "Ductile Iron Pipe",
      "code": "DIP"
     },
     {
      "name": "High Density Polyethylene",
      "code": "HDPE"
     },
     {
      "name": "Metal Pipe",
      "code": "MP"
     },
     {
      "name": "Plastic Pipe",
      "code": "PL"
     },
     {
      "name": "Polyvinyl Chloride",
      "code": "PVC"
     },
     {
      "name": "Reinforced Concrete Pipe",
      "code": "RCP"
     },
     {
      "name": "Steel Pipe",
      "code": "ST"
     },
     {
      "name": "Type B",
      "code": "TB"
     },
     {
      "name": "Type C",
      "code": "TC"
     },
     {
      "name": "Vitrified Clay Pipe",
      "code": "VCP"
     },
     {
      "name": "Other",
      "code": "OTH"
     },
     {
      "name": "Unknown",
      "code": "UNK"
     },
     {
      "name": "PVC SDR 35",
      "code": "SDR35"
     },
     {
      "name": "PVC SDR 26",
      "code": "SDR26"
     },
     {
      "name": "PVC SDR 21",
      "code": "SDR21"
     },
     {
      "name": "Corrugated Plastic Smooth Lined (ADS)",
      "code": "CPSL"
     },
     {
      "name": "Lebanon Standard",
      "code": "LEBSTAND"
     },
     {
      "name": "As Per Plan",
      "code": "APP"
     },
     {
      "name": "Sanitite",
      "code": "SANITITE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "OF_CP_SHAPE",
   "type": "esriFieldTypeString",
   "alias": "Outfall Closed Pipe Shape",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "d_dBarrellShape",
    "description": "Stormwater Barrel Shape",
    "codedValues": [
     {
      "name": "Circular",
      "code": "CIRC"
     },
     {
      "name": "Trapezoidal",
      "code": "TRAP"
     },
     {
      "name": "Other",
      "code": "OTH"
     },
     {
      "name": "Oval (Eliptical)",
      "code": "OVAL"
     },
     {
      "name": "Rectangular (Box)",
      "code": "RECT"
     },
     {
      "name": "Parabolic",
      "code": "PARABOLIC"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "OF_CP_SHAPE2",
   "type": "esriFieldTypeString",
   "alias": "Outfall Closed Pipe Shape2",
   "length": 15,
   "domain": null
  },
  {
   "name": "OF_CP_DIA",
   "type": "esriFieldTypeString",
   "alias": "Outfall Closed Pipe Diameter",
   "length": 10,
   "domain": null
  },
  {
   "name": "OF_CP_SUB_IW",
   "type": "esriFieldTypeString",
   "alias": "Outfall Closed Pipe Submerged In Water",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Y"
     },
     {
      "name": "No",
      "code": "N"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OF_CP_SUB_WS",
   "type": "esriFieldTypeString",
   "alias": "Outfall Closed Pipe Submerged With Sediment",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Y"
     },
     {
      "name": "No",
      "code": "N"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OF_OD",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Outfall Location Open Drainage",
   "domain": {
    "type": "codedValue",
    "name": "BooleanSymbolValue",
    "description": "Valid values are Yes and No.",
    "codedValues": [
     {
      "name": "Yes",
      "code": 1
     },
     {
      "name": "No",
      "code": 0
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "OF_OD_MAT",
   "type": "esriFieldTypeString",
   "alias": "Outfall Open Drain Material",
   "length": 20,
   "domain": null
  },
  {
   "name": "OF_OD_SHAPE",
   "type": "esriFieldTypeString",
   "alias": "Outfall Open Drian Shape",
   "length": 15,
   "domain": null
  },
  {
   "name": "OF_OD_DEPTH",
   "type": "esriFieldTypeString",
   "alias": "Outfall Open Drian Depth",
   "length": 10,
   "domain": null
  },
  {
   "name": "OF_OD_TOP",
   "type": "esriFieldTypeString",
   "alias": "Outfall Open Drian Top",
   "length": 10,
   "domain": null
  },
  {
   "name": "OF_OD_BOTTOM",
   "type": "esriFieldTypeString",
   "alias": "Outfall Open Drain Bottom",
   "length": 10,
   "domain": null
  },
  {
   "name": "OF_IN_STREAM",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Outfall In Stream",
   "domain": {
    "type": "codedValue",
    "name": "BooleanSymbolValue",
    "description": "Valid values are Yes and No.",
    "codedValues": [
     {
      "name": "Yes",
      "code": 1
     },
     {
      "name": "No",
      "code": 0
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "OF_FLOW_PRESENT",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Outfall Flow Present",
   "domain": {
    "type": "codedValue",
    "name": "BooleanSymbolValue",
    "description": "Valid values are Yes and No.",
    "codedValues": [
     {
      "name": "Yes",
      "code": 1
     },
     {
      "name": "No",
      "code": 0
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "OF_FLOW_DESC",
   "type": "esriFieldTypeString",
   "alias": "Outfall Flow Desc",
   "length": 50,
   "domain": null
  },
  {
   "name": "FLOW_ODOR",
   "type": "esriFieldTypeString",
   "alias": "Flow Odor",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "d_dOutfallOdor",
    "description": "Outfall Physical Indicator for Flowing Odor",
    "codedValues": [
     {
      "name": "Sewage",
      "code": "SEWAGE"
     },
     {
      "name": "Sulfide",
      "code": "SULFIDE"
     },
     {
      "name": "Rancid/Sour",
      "code": "RANCID"
     },
     {
      "name": "Petroleum/Gas",
      "code": "PETROLEUM"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FLOW_COLOR",
   "type": "esriFieldTypeString",
   "alias": "Flow Color",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "d_dOutfallColor",
    "description": "Outfall Physical Indicator for Flowing Color",
    "codedValues": [
     {
      "name": "Clear",
      "code": "CLEAR"
     },
     {
      "name": "Brown",
      "code": "BROWN"
     },
     {
      "name": "Gray",
      "code": "GRAY"
     },
     {
      "name": "Green",
      "code": "GREEN"
     },
     {
      "name": "Orange",
      "code": "ORANGE"
     },
     {
      "name": "Red",
      "code": "RED"
     },
     {
      "name": "Yellow",
      "code": "YELLOW"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FLOW_TURBIDITY",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Flowing Turbidity",
   "domain": {
    "type": "codedValue",
    "name": "BooleanSymbolValue",
    "description": "Valid values are Yes and No.",
    "codedValues": [
     {
      "name": "Yes",
      "code": 1
     },
     {
      "name": "No",
      "code": 0
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "FLOW_FLOATABLES",
   "type": "esriFieldTypeString",
   "alias": "Flow Floatables",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "d_dOutfallFloat",
    "description": "Outfall Physical Indicator for Flowing Floatable",
    "codedValues": [
     {
      "name": "Sewage (toilet paper, etc)",
      "code": "SEWAGE"
     },
     {
      "name": "Petroleum (oil sheen)",
      "code": "PETROLEUM"
     },
     {
      "name": "Other",
      "code": "OTHER"
     },
     {
      "name": "Suds",
      "code": "SUDS"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OF_DAMAGE_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Outfall Damage Type",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "d_dOutfallDamage",
    "description": "Outfall Physical Indicator Damage",
    "codedValues": [
     {
      "name": "Peeling Paint",
      "code": "PEELING"
     },
     {
      "name": "Spalling, cracking, or chipping (CREATE WO)",
      "code": "SCC"
     },
     {
      "name": "Other",
      "code": "OTHER"
     },
     {
      "name": "None",
      "code": "NONE"
     },
     {
      "name": "Broken",
      "code": "BROKEN"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OF_DEPOSIT_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Outfall Deposit Type",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "d_dOutfallDeposits",
    "description": "Outfall Physical Indicator Deposits",
    "codedValues": [
     {
      "name": "Oily",
      "code": "OILY"
     },
     {
      "name": "Flow Line",
      "code": "LINE"
     },
     {
      "name": "Paint",
      "code": "PAINT"
     },
     {
      "name": "Other",
      "code": "OTHER"
     },
     {
      "name": "None",
      "code": "NONE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OF_AB_VEG_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Outfall Abnormal Veg Type",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "d_dOutfallVegetation",
    "description": "Outfall Physical Indicator Abnormal Vegetation",
    "codedValues": [
     {
      "name": "Excessive",
      "code": "EXCESSIVE"
     },
     {
      "name": "Inhibited",
      "code": "INHIBITED"
     },
     {
      "name": "Clear",
      "code": "CLEAR"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OF_POOL_QUALITY",
   "type": "esriFieldTypeString",
   "alias": "Outfall Poor Pool Quality",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "d_dOutfallPooling",
    "description": "Outfall Physical Indicator Poor Pooling Quality",
    "codedValues": [
     {
      "name": "Colors",
      "code": "COLORS"
     },
     {
      "name": "Excessive Algea",
      "code": "ALGEA"
     },
     {
      "name": "Floatables",
      "code": "FLOATABLES"
     },
     {
      "name": "Odors",
      "code": "ODORS"
     },
     {
      "name": "Oil Sheen",
      "code": "OIL"
     },
     {
      "name": "Suds",
      "code": "SUDS"
     },
     {
      "name": "Other",
      "code": "OTHER"
     },
     {
      "name": "Clear",
      "code": "CLEAR"
     },
     {
      "name": "Multi-Faults",
      "code": "MULTI"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OF_BENTHIC_GROWTH",
   "type": "esriFieldTypeString",
   "alias": "Outfall Benthic Growth",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "d_dOutfallBenthic",
    "description": "Outfall Physical Indicator Pipe Benthic Growth",
    "codedValues": [
     {
      "name": "Brown",
      "code": "BROWN"
     },
     {
      "name": "Green",
      "code": "GREEN"
     },
     {
      "name": "Orange",
      "code": "ORANGE"
     },
     {
      "name": "Other",
      "code": "OTHER"
     },
     {
      "name": "None",
      "code": "NONE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OVERALL_CHARAC",
   "type": "esriFieldTypeString",
   "alias": "Overall Outfall Characterization",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "d_dOutfallOverall",
    "description": "Outfall Overall Characterization",
    "codedValues": [
     {
      "name": "Unlikely - No indication of illicit discharges",
      "code": "NONE"
     },
     {
      "name": "Potential - Some likelihood of illicit discharge (i.e., presence of 2 or more indicators)",
      "code": "SOME"
     },
     {
      "name": "Suspect - Almost certain a discharge exists (i.e., 1 or more indicator with a severity of 3)",
      "code": "EXISTS"
     },
     {
      "name": "Obvious",
      "code": "OBVIOUS"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "AssetID",
   "type": "esriFieldTypeString",
   "alias": "Asset ID",
   "length": 20,
   "domain": null
  },
  {
   "name": "FeatureID",
   "type": "esriFieldTypeString",
   "alias": "Feature ID",
   "length": 20,
   "domain": null
  },
  {
   "name": "OIDKEY",
   "type": "esriFieldTypeInteger",
   "alias": "Outfall OID",
   "domain": null
  },
  {
   "name": "CREATIONUSER",
   "type": "esriFieldTypeString",
   "alias": "Created By",
   "length": 20,
   "domain": null
  },
  {
   "name": "DATECREATED",
   "type": "esriFieldTypeDate",
   "alias": "Date Created",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATEMODIFIED",
   "type": "esriFieldTypeDate",
   "alias": "Last Update",
   "length": 8,
   "domain": null
  },
  {
   "name": "LASTUSER",
   "type": "esriFieldTypeString",
   "alias": "Editor Name",
   "length": 20,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "Image",
   "type": "esriFieldTypeString",
   "alias": "Image",
   "length": 250,
   "domain": null
  },
  {
   "name": "FLOWTURB",
   "type": "esriFieldTypeString",
   "alias": "FLOWTURB",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "d_YN",
    "description": "Yes or No Response",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Y"
     },
     {
      "name": "No",
      "code": "N"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OF_FLOWPRES",
   "type": "esriFieldTypeString",
   "alias": "OF_FLOWPRES",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "d_YN",
    "description": "Yes or No Response",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Y"
     },
     {
      "name": "No",
      "code": "N"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "REL_GLOBALID",
   "type": "esriFieldTypeGUID",
   "alias": "REL_GLOBALID",
   "length": 38,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R413_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_413",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G2249OIDKEY",
   "fields": "OIDKEY",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_413",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_2249_REL_GLO",
   "fields": "REL_GLOBALID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "dOutfall",
   "relatedTableId": 4,
   "role": "esriRelRoleDestination",
   "keyField": "REL_GLOBALID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 10000,
 "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,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": false,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}