{
 "currentVersion": 10.91,
 "id": 9,
 "name": "Drop Inlet Inspection",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "DI_ID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "DI_ID",
   "type": "esriFieldTypeInteger",
   "alias": "DI_ID",
   "domain": null
  },
  {
   "name": "RESPONSIBILITY",
   "type": "esriFieldTypeString",
   "alias": "RESPONSIBILITY",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "Responsibility",
    "description": "SCI responsiblity",
    "codedValues": [
     {
      "name": "PRIVATE",
      "code": "PRIVATE"
     },
     {
      "name": "TOWN",
      "code": "TOWN"
     },
     {
      "name": "STATE",
      "code": "STATE"
     },
     {
      "name": "UNKNOWN",
      "code": "UNKNW"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DI_TYPE",
   "type": "esriFieldTypeString",
   "alias": "DI TYPE",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "DI_Type_1",
    "description": "Drop Inlet Type",
    "codedValues": [
     {
      "name": "Drop Inlet",
      "code": "DI"
     },
     {
      "name": "Stand Pipe",
      "code": "SP"
     },
     {
      "name": "Junction Box",
      "code": "JCTBX"
     },
     {
      "name": "Unknown",
      "code": "UNKNW"
     },
     {
      "name": "Dry Sump",
      "code": "DS"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GRATE_TYPE",
   "type": "esriFieldTypeString",
   "alias": "GRATE TYPE",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "Grate_Type",
    "description": "",
    "codedValues": [
     {
      "name": "A",
      "code": "A"
     },
     {
      "name": "B",
      "code": "B"
     },
     {
      "name": "C",
      "code": "C"
     },
     {
      "name": "D",
      "code": "D"
     },
     {
      "name": "E",
      "code": "E"
     },
     {
      "name": "HalfB",
      "code": "HALFB"
     },
     {
      "name": "Steel Grate",
      "code": "STEEL"
     },
     {
      "name": "Throated",
      "code": "THRT"
     },
     {
      "name": "Other",
      "code": "OTHER"
     },
     {
      "name": "Unknown",
      "code": "UNKNW"
     },
     {
      "name": "No Grate",
      "code": "NONE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "NUM_GRATES",
   "type": "esriFieldTypeSmallInteger",
   "alias": "NUMBER OF GRATES",
   "domain": null
  },
  {
   "name": "CONDITION",
   "type": "esriFieldTypeString",
   "alias": "CONDITION",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "General_Condition_9",
    "description": "General Condition scale",
    "codedValues": [
     {
      "name": "GOOD",
      "code": "GOOD"
     },
     {
      "name": "FAIR",
      "code": "FAIR"
     },
     {
      "name": "POOR",
      "code": "POOR"
     },
     {
      "name": "CRITICAL",
      "code": "CRIT"
     },
     {
      "name": "UNKNOWN",
      "code": "UNKNW"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "COND_COMMENT",
   "type": "esriFieldTypeString",
   "alias": "CONDITION COMMENT",
   "length": 230,
   "domain": null
  },
  {
   "name": "BRICK_COLLAR",
   "type": "esriFieldTypeString",
   "alias": "BRICK COLLAR",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "SCI_BrickCollar_1",
    "description": "Brick Collar",
    "codedValues": [
     {
      "name": "EXCELLENT",
      "code": "EXCEL"
     },
     {
      "name": "NONE",
      "code": "NONE"
     },
     {
      "name": "GOOD",
      "code": "GOOD"
     },
     {
      "name": "FAIR",
      "code": "FAIR"
     },
     {
      "name": "POOR",
      "code": "POOR"
     },
     {
      "name": "CRITICAL",
      "code": "CRIT"
     },
     {
      "name": "UNKNOWN",
      "code": "UNKNW"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SEDIMENT",
   "type": "esriFieldTypeString",
   "alias": "SEDIMENT",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "Sediment_11",
    "description": "SCI Sediment Level",
    "codedValues": [
     {
      "name": "NONE",
      "code": "NONE"
     },
     {
      "name": "LIGHT",
      "code": "LIGHT"
     },
     {
      "name": "MODERATE",
      "code": "MOD"
     },
     {
      "name": "HEAVY",
      "code": "HEAVY"
     },
     {
      "name": "PLUGGED",
      "code": "PLUG"
     },
     {
      "name": "UNKNOWN",
      "code": "UNKNW"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "EROSION",
   "type": "esriFieldTypeString",
   "alias": "EROSION",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "Erosion_11",
    "description": "SCI Erosion Level",
    "codedValues": [
     {
      "name": "NONE",
      "code": "NONE"
     },
     {
      "name": "LIGHT",
      "code": "LIGHT"
     },
     {
      "name": "MODERATE",
      "code": "MOD"
     },
     {
      "name": "SEVERE",
      "code": "SEVERE"
     },
     {
      "name": "UNKNOWN",
      "code": "UNKNW"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "COLLAR_INFILTRATION",
   "type": "esriFieldTypeString",
   "alias": "COLLAR INFILTRATION",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "YesNoInspection",
    "description": "Yes/No for SCI inspection",
    "codedValues": [
     {
      "name": "YES",
      "code": "YES"
     },
     {
      "name": "NO",
      "code": "NO"
     },
     {
      "name": "UNKNOWN",
      "code": "UNKNW"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GEN_COMMENT",
   "type": "esriFieldTypeString",
   "alias": "GENERAL COMMENT",
   "length": 230,
   "domain": null
  },
  {
   "name": "FUNCTIONAL_STATUS",
   "type": "esriFieldTypeString",
   "alias": "FUNCTIONAL STATUS",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "SCI_FunctionalStatus_12",
    "description": "Functional Status Change of Feature",
    "codedValues": [
     {
      "name": "ABANDONED",
      "code": "ABANDONED"
     },
     {
      "name": "DISCONTINUED",
      "code": "DISCONTINUED"
     },
     {
      "name": "FILLED",
      "code": "FILLED"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "NEW_DATA_TYPE",
   "type": "esriFieldTypeString",
   "alias": "NEW DATA TYPE",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "SCI_NEW_DATA_TYPE_19",
    "description": "If an installation is new construction or replacement",
    "codedValues": [
     {
      "name": "Replacement",
      "code": "Replacement"
     },
     {
      "name": "New Construction",
      "code": "New Construction"
     },
     {
      "name": "Discovered",
      "code": "Discovered"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "INSPECTOR",
   "type": "esriFieldTypeString",
   "alias": "INSPECTOR",
   "length": 30,
   "domain": null
  },
  {
   "name": "INSPECTION_DATE",
   "type": "esriFieldTypeDate",
   "alias": "INSPECTION DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "DI_PHOTO",
   "type": "esriFieldTypeString",
   "alias": "DI_PHOTO",
   "length": 230,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "G117099DI_ID",
   "fields": "DI_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "DropInlet",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "BASE_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON",
 "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
}