{
 "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": "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": "INLET_ID",
   "type": "esriFieldTypeString",
   "alias": "INLET_ID",
   "length": 255,
   "domain": null
  },
  {
   "name": "TYPE",
   "type": "esriFieldTypeString",
   "alias": "TYPE",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "Inlet_Type",
    "description": "InletType_SW",
    "codedValues": [
     {
      "name": "B10 Inlet",
      "code": "B10"
     },
     {
      "name": "B15",
      "code": "B15"
     },
     {
      "name": "D Combination Inlet",
      "code": "DCO"
     },
     {
      "name": "Duplex E Inlet",
      "code": "DPE"
     },
     {
      "name": "E Combination Inlet",
      "code": "ECO"
     },
     {
      "name": "H Combination Inlet",
      "code": "HCO"
     },
     {
      "name": "Special H Combination Inlet",
      "code": "HSC"
     },
     {
      "name": "Inlet Cover",
      "code": "COV"
     },
     {
      "name": "J Chute Inlet",
      "code": "JCH"
     },
     {
      "name": "B6 Inlet",
      "code": "IB6"
     },
     {
      "name": "A Inlet",
      "code": "INA"
     },
     {
      "name": "C Inlet",
      "code": "INC"
     },
     {
      "name": "D Inlet",
      "code": "IND"
     },
     {
      "name": "E Inlet",
      "code": "INE"
     },
     {
      "name": "F Inlet",
      "code": "INF"
     },
     {
      "name": "H Inlet",
      "code": "INH"
     },
     {
      "name": "K Inlet",
      "code": "INK"
     },
     {
      "name": "S Inlet",
      "code": "INS"
     },
     {
      "name": "Non-standard",
      "code": "NST"
     },
     {
      "name": "MSHA Inlet",
      "code": "SHA"
     },
     {
      "name": "Unknown",
      "code": "UNK"
     },
     {
      "name": "Triple NR Inlet",
      "code": "TNR"
     },
     {
      "name": "Modified NR Inlet",
      "code": "MNR"
     },
     {
      "name": "Single WR Inlet",
      "code": "SWR"
     },
     {
      "name": "WR Inlet Type1",
      "code": "WR1"
     },
     {
      "name": "WR Inlet Type 2",
      "code": "WR2"
     },
     {
      "name": "COG Inlet",
      "code": "COG"
     },
     {
      "name": "Siamese",
      "code": "SIM"
     },
     {
      "name": "Transverse Intake Structure",
      "code": "TIS"
     },
     {
      "name": "S Combination Inlet",
      "code": "SCO"
     },
     {
      "name": "Double S Tandem Combination Inlet",
      "code": "DSC"
     },
     {
      "name": "Double S Tandem Inlet",
      "code": "DST"
     },
     {
      "name": "G Inlet",
      "code": "ING"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "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": "ACCESSIBLE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "IS THE INLET ACCESSIBLE",
   "domain": {
    "type": "codedValue",
    "name": "YesNo_Code",
    "description": "YesNo_Desc",
    "codedValues": [
     {
      "name": "Yes",
      "code": 1
     },
     {
      "name": "No",
      "code": 0
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "REASON FOR INACCESSIBILITY",
   "length": 255,
   "domain": null
  },
  {
   "name": "DEBRIS",
   "type": "esriFieldTypeString",
   "alias": "AMOUNT OF DEBRIS IN CATCH 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": "MAINT_REQ",
   "type": "esriFieldTypeSmallInteger",
   "alias": "IS MAINTENANCE REQUIRED",
   "domain": {
    "type": "codedValue",
    "name": "YesNo_Code",
    "description": "YesNo_Desc",
    "codedValues": [
     {
      "name": "Yes",
      "code": 1
     },
     {
      "name": "No",
      "code": 0
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "MAINT_TYPE",
   "type": "esriFieldTypeString",
   "alias": "TYPE OF MAINTENANCE REQUIRED",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "SW_VVT_MAINT_TYPE",
    "description": "INLET MAINT TYPE",
    "codedValues": [
     {
      "name": "WW Storm Inlet Choke",
      "code": "WW Storm Inlet Choke"
     },
     {
      "name": "WW Storm Damaged Inlet",
      "code": "WW Storm Damaged Inlet"
     },
     {
      "name": "NONE",
      "code": "NONE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "COMMENTS_1",
   "type": "esriFieldTypeString",
   "alias": "COMMENTS",
   "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": "AssignTo",
   "type": "esriFieldTypeString",
   "alias": "AssignTo",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_VVT_InletCleaningContractor",
    "description": "",
    "codedValues": [
     {
      "name": "Stormwater Management",
      "code": "SWM"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Utility Maintenance Division",
      "code": "UMD"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "WorkOrderType",
   "type": "esriFieldTypeString",
   "alias": "WorkOrderType",
   "length": 100,
   "domain": null
  },
  {
   "name": "CleaningDate",
   "type": "esriFieldTypeDate",
   "alias": "CleaningDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "Cleaning_Priority",
   "type": "esriFieldTypeString",
   "alias": "Priority",
   "length": 16,
   "domain": {
    "type": "codedValue",
    "name": "SW_VVT_Priority",
    "description": "Schedule_Maint",
    "codedValues": [
     {
      "name": "Priority 1",
      "code": "P1"
     },
     {
      "name": "Priority 2",
      "code": "P2"
     },
     {
      "name": "Priority 3",
      "code": "P3"
     },
     {
      "name": "Priority 4",
      "code": "P4"
     },
     {
      "name": "Priority 5",
      "code": "P5"
     },
     {
      "name": "Clean Immediately",
      "code": "P0"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Comments_Contractor",
   "type": "esriFieldTypeString",
   "alias": "Comments_Contractor",
   "length": 255,
   "domain": null
  },
  {
   "name": "IC_PH2A",
   "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": "FEAT_STATUS",
   "type": "esriFieldTypeString",
   "alias": "INLET STATUS",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "SW_VVT_Feat_Status",
    "description": "",
    "codedValues": [
     {
      "name": "Active",
      "code": "ACT"
     },
     {
      "name": "Abandoned",
      "code": "ABD"
     },
     {
      "name": "Proposed",
      "code": "PRO"
     },
     {
      "name": "Under Construction",
      "code": "UC"
     },
     {
      "name": "Removed",
      "code": "REM"
     },
     {
      "name": "Under Investigation",
      "code": "UI"
     },
     {
      "name": "Could not Access in Field",
      "code": "CNA"
     },
     {
      "name": "Could not Locate",
      "code": "CNL"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "MODIFICATION",
   "type": "esriFieldTypeString",
   "alias": "INLET MODIFICATION",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "dInletModification",
    "description": "Inlet Modification",
    "codedValues": [
     {
      "name": "INSERT",
      "code": "I"
     },
     {
      "name": "SCREEN",
      "code": "S"
     },
     {
      "name": "BOTH",
      "code": "B"
     },
     {
      "name": "NONE",
      "code": "N"
     }
    ],
    "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": "HEIGHT_THROAT",
   "type": "esriFieldTypeDouble",
   "alias": "THROAT OPENING HEIGHT (in)",
   "domain": null
  },
  {
   "name": "LENGTH_THROAT",
   "type": "esriFieldTypeDouble",
   "alias": "THROAT OPENING LENGTH (in)",
   "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": 1000,
 "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
}