{
 "currentVersion": 10.81,
 "id": 1,
 "name": "sw.DBO.SDInlet_Inspection",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "TAG",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "INLET_ID",
   "type": "esriFieldTypeString",
   "alias": "INLET_ID",
   "length": 255,
   "domain": null
  },
  {
   "name": "INSPECTOR",
   "type": "esriFieldTypeString",
   "alias": "INSPECTOR",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_Inspector",
    "description": "Inspector for SW projects",
    "codedValues": [
     {
      "name": "John McComas",
      "code": "JM"
     },
     {
      "name": "David Lauman",
      "code": "DL"
     },
     {
      "name": "Milton Carroll",
      "code": "MC"
     },
     {
      "name": "Keith Garner",
      "code": "KG"
     },
     {
      "name": "Kris Carter",
      "code": "KC"
     },
     {
      "name": "Patrick Johnson",
      "code": "PJ"
     },
     {
      "name": "Guy Youmbi",
      "code": "GY"
     },
     {
      "name": "Inspector",
      "code": "INS"
     },
     {
      "name": "Russell Page",
      "code": "RP"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "EDIT_DATE",
   "type": "esriFieldTypeDate",
   "alias": "INSPECTION DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "CONDITION",
   "type": "esriFieldTypeString",
   "alias": "CONDITION OF INLET",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "CONDITION",
    "description": "CONDITION",
    "codedValues": [
     {
      "name": "EXCELLENT",
      "code": "1"
     },
     {
      "name": "GOOD",
      "code": "2"
     },
     {
      "name": "FAIR",
      "code": "3"
     },
     {
      "name": "POOR",
      "code": "4"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DEBRIS_BASIN",
   "type": "esriFieldTypeString",
   "alias": "AMOUNT OF DEBRIS IN BASIN",
   "length": 12,
   "domain": {
    "type": "codedValue",
    "name": "DEBRIS",
    "description": "DEBRIS_DESC",
    "codedValues": [
     {
      "name": "LT 50 PCT",
      "code": "LS DIA PIPE"
     },
     {
      "name": "GR 50 PCT",
      "code": "GR DIA PIPE"
     },
     {
      "name": "EQ 50 PCT",
      "code": "EQ DIA PIPE"
     },
     {
      "name": "CLEAN",
      "code": "CLEAN"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DEBRIS_INSERT",
   "type": "esriFieldTypeString",
   "alias": "AMOUNT OF DEBRIS IN INSERT",
   "length": 12,
   "domain": {
    "type": "codedValue",
    "name": "DEBRIS",
    "description": "DEBRIS_DESC",
    "codedValues": [
     {
      "name": "LT 50 PCT",
      "code": "LS DIA PIPE"
     },
     {
      "name": "GR 50 PCT",
      "code": "GR DIA PIPE"
     },
     {
      "name": "EQ 50 PCT",
      "code": "EQ DIA PIPE"
     },
     {
      "name": "CLEAN",
      "code": "CLEAN"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DEBRIS_SURFACE",
   "type": "esriFieldTypeString",
   "alias": "AMOUNT OF DEBRIS ON GRATE OR SCREEN",
   "length": 12,
   "domain": {
    "type": "codedValue",
    "name": "DEBRIS",
    "description": "DEBRIS_DESC",
    "codedValues": [
     {
      "name": "LT 50 PCT",
      "code": "LS DIA PIPE"
     },
     {
      "name": "GR 50 PCT",
      "code": "GR DIA PIPE"
     },
     {
      "name": "EQ 50 PCT",
      "code": "EQ DIA PIPE"
     },
     {
      "name": "CLEAN",
      "code": "CLEAN"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "MAINT_REQ_STRUCT",
   "type": "esriFieldTypeString",
   "alias": "MAINTENANCE REQUIRED - STRUCTURAL",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_Inlet_MaintREQ",
    "description": "MAINT TYPE",
    "codedValues": [
     {
      "name": "NONE",
      "code": "NONE"
     },
     {
      "name": "UMD - STRUCTURAL MAINT",
      "code": "UMD-SM"
     },
     {
      "name": "CONTRACTOR - STRUCTURAL MAINT",
      "code": "SWC-SM"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CLEANING_REQ",
   "type": "esriFieldTypeString",
   "alias": "CLEANING REQUIRED",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_Inlet_CLREQ",
    "description": "Cleaning Required",
    "codedValues": [
     {
      "name": "NO",
      "code": "NONE"
     },
     {
      "name": "YES",
      "code": "CONT-CL"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "INSPECTION_COMPLETE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "INSPECTION COMPLETE",
   "domain": {
    "type": "codedValue",
    "name": "YesNo_Code",
    "description": "YesNo_Desc",
    "codedValues": [
     {
      "name": "Yes",
      "code": 1
     },
     {
      "name": "No",
      "code": 0
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "COMMENTS_1",
   "type": "esriFieldTypeString",
   "alias": "COMMENTS",
   "length": 255,
   "domain": null
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "GDB_1533_INLET_I",
   "fields": "INLET_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "sw.DBO.SDInletCleaning",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "INLET_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 3000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON",
 "isDataVersioned": false,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": false,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null
}