{
 "currentVersion": 10.81,
 "id": 3,
 "name": "sw.SW.BRWWTP_Inspections",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Inspector",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "globalid",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "Inspector",
   "type": "esriFieldTypeString",
   "alias": "Inspector",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_Inspector",
    "description": "",
    "codedValues": [
     {
      "name": "Patrick Johnson",
      "code": "Patrick Johnson"
     },
     {
      "name": "John McComas",
      "code": "John McComas"
     },
     {
      "name": "Kris Carter",
      "code": "Kris Carter"
     },
     {
      "name": "Michael Hicks",
      "code": "Michael Hicks"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "StructureStatus",
   "type": "esriFieldTypeString",
   "alias": "Structure Status",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_StructureStatus",
    "description": "",
    "codedValues": [
     {
      "name": "Active",
      "code": "AC"
     },
     {
      "name": "Abandoned",
      "code": "AB"
     },
     {
      "name": "Under Construction",
      "code": "UC"
     },
     {
      "name": "Could Not Access",
      "code": "CAN"
     },
     {
      "name": "Could Not Locate",
      "code": "CNL"
     },
     {
      "name": "Other (insert comment)",
      "code": "OTH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Structure_Status_Comment",
   "type": "esriFieldTypeString",
   "alias": "Structure Status Comment",
   "length": 255,
   "domain": null
  },
  {
   "name": "StructureType",
   "type": "esriFieldTypeString",
   "alias": "Structure Type",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_StructureType",
    "description": "",
    "codedValues": [
     {
      "name": "Inlet/storm drain (point of where storm water enters underground system)",
      "code": "SD"
     },
     {
      "name": "Outfall (last point of storm water discharge)",
      "code": "OF"
     },
     {
      "name": "Culvert (concrete channel to convey runoff)",
      "code": "CV"
     },
     {
      "name": "Swale (grass channel to convey runoff)",
      "code": "SW"
     },
     {
      "name": "Manhole (flow observation point of underground storm pipes)",
      "code": "MH"
     },
     {
      "name": "Wetlands (small pond with planted vegetation)",
      "code": "WT"
     },
     {
      "name": "Check dam (small dam to decrease flow velocity)",
      "code": "CD"
     },
     {
      "name": "Detention pond (pond to detain water temporarily - discharge above ground)",
      "code": "DP"
     },
     {
      "name": "Infiltration pond (pond holding water to filter below ground - discharge below ground)",
      "code": "IP"
     },
     {
      "name": "Retention pond (pond to treat water before discharge)",
      "code": "RP"
     },
     {
      "name": "Forebay (structure to remove sediment)",
      "code": "FB"
     },
     {
      "name": "Oil/water separator (structure to separator oil & grit)",
      "code": "OW"
     },
     {
      "name": "Gabion (wire box of rocks)",
      "code": "GA"
     },
     {
      "name": "Rip Rap (stone channel)",
      "code": "RR"
     },
     {
      "name": "Other (insert comment)",
      "code": "OTH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Structure_Type_Comment",
   "type": "esriFieldTypeString",
   "alias": "Structure Type Comment",
   "length": 255,
   "domain": null
  },
  {
   "name": "Structure_Condition",
   "type": "esriFieldTypeString",
   "alias": "Structure Condition",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_Structure_Condition",
    "description": "",
    "codedValues": [
     {
      "name": "Excellent",
      "code": "E"
     },
     {
      "name": "Good",
      "code": "G"
     },
     {
      "name": "Fair",
      "code": "F"
     },
     {
      "name": "Poor",
      "code": "P"
     },
     {
      "name": "Other (insert comment)",
      "code": "OTH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Structure_Condition_Comment",
   "type": "esriFieldTypeString",
   "alias": "Structure Condition Comment",
   "length": 255,
   "domain": null
  },
  {
   "name": "Structure_Maint",
   "type": "esriFieldTypeString",
   "alias": "Structure Maintenance",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_Structure_Maint",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Structure_Maint_Comment",
   "type": "esriFieldTypeString",
   "alias": "Structure Maintenance Comment",
   "length": 255,
   "domain": null
  },
  {
   "name": "Structure_Length",
   "type": "esriFieldTypeDouble",
   "alias": "Structure Length (in.)",
   "domain": null
  },
  {
   "name": "Structure_Width",
   "type": "esriFieldTypeDouble",
   "alias": "Structure Width (in.)",
   "domain": null
  },
  {
   "name": "Structure_Height",
   "type": "esriFieldTypeDouble",
   "alias": "Structure Height (in.)",
   "domain": null
  },
  {
   "name": "Structure_Depth",
   "type": "esriFieldTypeDouble",
   "alias": "Structure Depth (in.)",
   "domain": null
  },
  {
   "name": "Structure_Material",
   "type": "esriFieldTypeString",
   "alias": "Structure Material",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_Structure_Material",
    "description": "",
    "codedValues": [
     {
      "name": "Concrete",
      "code": "CON"
     },
     {
      "name": "Brick",
      "code": "BRK"
     },
     {
      "name": "Metal",
      "code": "MTL"
     },
     {
      "name": "Rock/Stone",
      "code": "STN"
     },
     {
      "name": "PVC/Plastic",
      "code": "PVE"
     },
     {
      "name": "Terra Cotta",
      "code": "TC"
     },
     {
      "name": "Grass",
      "code": "GRS"
     },
     {
      "name": "Other",
      "code": "OTH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Other_Structure_Material",
   "type": "esriFieldTypeString",
   "alias": "Additional Structure Material Types",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_Other_Structure_Material",
    "description": "",
    "codedValues": [
     {
      "name": "Aluminum",
      "code": "ALU"
     },
     {
      "name": "Aluminized Steel Type 2",
      "code": "ALUS2"
     },
     {
      "name": "Brick and Concrete",
      "code": "BCO"
     },
     {
      "name": "Brick and Precast Concrete",
      "code": "BPC"
     },
     {
      "name": "Brick and Reinforced Concrete",
      "code": "BRC"
     },
     {
      "name": "Brick and Stone",
      "code": "BST"
     },
     {
      "name": "Corrugated Aluminum",
      "code": "CAL"
     },
     {
      "name": "Cast Iron",
      "code": "CIP"
     },
     {
      "name": "Corruated Metal W/Grate",
      "code": "CMG"
     },
     {
      "name": "Corrugated Metal",
      "code": "CMT"
     },
     {
      "name": "Concrete and Stone",
      "code": "CST"
     },
     {
      "name": "Ductile Iron",
      "code": "DIP"
     },
     {
      "name": "Extra Strength Clay Pipe",
      "code": "ESC"
     },
     {
      "name": "Fiberglass",
      "code": "FGR"
     },
     {
      "name": "High Density Polyethylene",
      "code": "HDE"
     },
     {
      "name": "Prestressed Conc Press Pipe",
      "code": "PCC"
     },
     {
      "name": "Precast Concrete",
      "code": "PCO"
     },
     {
      "name": "Polycrete",
      "code": "PRC"
     },
     {
      "name": "Reinforced Concrete Culvert",
      "code": "RCC"
     },
     {
      "name": "Reinforced Concrete",
      "code": "RCO"
     },
     {
      "name": "Reinforced Concrete Pipe",
      "code": "RCP"
     },
     {
      "name": "Structural Aluminum Plate Pipe",
      "code": "SAP"
     },
     {
      "name": "Precast Conc. W/Grate",
      "code": "SCG"
     },
     {
      "name": "Structural Plate Pipe",
      "code": "SPP"
     },
     {
      "name": "Tile and Concrete",
      "code": "TCO"
     },
     {
      "name": "Unknown",
      "code": "UNK"
     },
     {
      "name": "Vitrified Clay",
      "code": "VC"
     },
     {
      "name": "Vitrified Clay Block",
      "code": "VCB"
     },
     {
      "name": "Wood",
      "code": "WOD"
     },
     {
      "name": "Extra Heavy Cast Iron Soil Pipe",
      "code": "XCI"
     },
     {
      "name": "Other (insert comment)",
      "code": "OTH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Structure_Material_Comment",
   "type": "esriFieldTypeString",
   "alias": "Structure Material Comment",
   "length": 255,
   "domain": null
  },
  {
   "name": "Vegetation_Status",
   "type": "esriFieldTypeString",
   "alias": "Vegetation Status",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_Vegetation_Status",
    "description": "",
    "codedValues": [
     {
      "name": "None Present",
      "code": "NONE"
     },
     {
      "name": "Less than 25%",
      "code": "25"
     },
     {
      "name": "25%-50%",
      "code": "50"
     },
     {
      "name": "Greater 50%",
      "code": ">50"
     },
     {
      "name": "Other (insert comment)",
      "code": "OTH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Vegetation_Status_Comment",
   "type": "esriFieldTypeString",
   "alias": "Vegetation Status Comment",
   "length": 255,
   "domain": null
  },
  {
   "name": "Trash_Debris_Present",
   "type": "esriFieldTypeString",
   "alias": "Trash/Debris Present",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_Trash_Debris_Present",
    "description": "",
    "codedValues": [
     {
      "name": "None Present",
      "code": "NONE"
     },
     {
      "name": "Less than 25%",
      "code": "25"
     },
     {
      "name": "25%-50%",
      "code": "50"
     },
     {
      "name": "Greater 50%",
      "code": ">50"
     },
     {
      "name": "Other (insert comment)",
      "code": "OTH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Trash_Debris_Present_Comment",
   "type": "esriFieldTypeString",
   "alias": "Trash/Debris Comment",
   "length": 255,
   "domain": null
  },
  {
   "name": "Sediment_Status",
   "type": "esriFieldTypeString",
   "alias": "Sediment Status",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_Sediment_Status",
    "description": "",
    "codedValues": [
     {
      "name": "None Present",
      "code": "NONE"
     },
     {
      "name": "Less than 25%",
      "code": "25"
     },
     {
      "name": "25%-50%",
      "code": "50"
     },
     {
      "name": "Greater 50%",
      "code": ">50"
     },
     {
      "name": "Other (insert comment)",
      "code": "OTH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Sediment_Status_Comment",
   "type": "esriFieldTypeString",
   "alias": "Sediment Status Comment",
   "length": 255,
   "domain": null
  },
  {
   "name": "Structural_Cleaning",
   "type": "esriFieldTypeString",
   "alias": "Structural Cleaning Required",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_Structural_Cleaning",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Structural_Cleaning_Comment",
   "type": "esriFieldTypeString",
   "alias": "Structural Cleaning Description",
   "length": 255,
   "domain": null
  },
  {
   "name": "Feature_Shape",
   "type": "esriFieldTypeString",
   "alias": "Feature Shape",
   "length": 255,
   "domain": null
  },
  {
   "name": "Asset_GlobalID",
   "type": "esriFieldTypeString",
   "alias": "Asset GlobalID",
   "length": 255,
   "domain": null
  },
  {
   "name": "CreationDate",
   "type": "esriFieldTypeDate",
   "alias": "CreationDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "Creator",
   "type": "esriFieldTypeString",
   "alias": "Creator",
   "length": 128,
   "domain": null
  },
  {
   "name": "EditDate",
   "type": "esriFieldTypeDate",
   "alias": "EditDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "Editor",
   "type": "esriFieldTypeString",
   "alias": "Editor",
   "length": 128,
   "domain": null
  },
  {
   "name": "Status",
   "type": "esriFieldTypeString",
   "alias": "Status",
   "length": 25,
   "domain": null
  },
  {
   "name": "Orig_GlobalID",
   "type": "esriFieldTypeString",
   "alias": "Orig_GlobalID",
   "length": 50,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R513_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_513",
   "fields": "globalid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "I6529Orig_Global",
   "fields": "Orig_GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G6529Asset_Globa",
   "fields": "Asset_GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "Structure_Points",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "Asset_GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 1,
   "name": "Structure_Line",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "Asset_GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 2,
   "name": "Structure_Area",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "Asset_GlobalID",
   "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
}