{
 "currentVersion": 11.1,
 "cimVersion": "3.1.0",
 "id": 10,
 "name": "Storm_Gravity_Main_Inspections_Conditions",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "OBJECTID",
 "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": "DISTANCE",
   "type": "esriFieldTypeDouble",
   "alias": "Distance",
   "domain": null
  },
  {
   "name": "COUNTER",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Counter",
   "domain": null
  },
  {
   "name": "PACP_CODE",
   "type": "esriFieldTypeString",
   "alias": "PACP_Code",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "swPACPConditions",
    "description": "",
    "codedValues": [
     {
      "name": "Access Point Catch Basin",
      "code": "ACB"
     },
     {
      "name": "Access Point Cleanout House",
      "code": "ACOH"
     },
     {
      "name": "Access Point Cleanout Mainline",
      "code": "ACOM"
     },
     {
      "name": "Access Point Cleanout Propertyline",
      "code": "ACOP"
     },
     {
      "name": "Access Point Discharge Point",
      "code": "ADP"
     },
     {
      "name": "Access Point End of Pipe",
      "code": "AEP"
     },
     {
      "name": "Access Point Junction Box",
      "code": "AJB"
     },
     {
      "name": "Access Point Meter",
      "code": "AM"
     },
     {
      "name": "Access Point Manhole",
      "code": "AMH"
     },
     {
      "name": "Access Point Special Chamber",
      "code": "AOC"
     },
     {
      "name": "Access Point Tee Connection",
      "code": "ATC"
     },
     {
      "name": "Access Point Wastewater Access Device",
      "code": "AWA"
     },
     {
      "name": "Access Point Wet Well",
      "code": "AWW"
     },
     {
      "name": "Access Point Other",
      "code": "AZ"
     },
     {
      "name": "Broken",
      "code": "B"
     },
     {
      "name": "Broken Soil Visible",
      "code": "BSV"
     },
     {
      "name": "Broken Void Visible",
      "code": "BVV"
     },
     {
      "name": "Crack Circumferential",
      "code": "CC"
     },
     {
      "name": "Crack Longitudinal Hinge, 2",
      "code": "CH2"
     },
     {
      "name": "Crack Longitudinal Hinge, 3",
      "code": "CH3"
     },
     {
      "name": "Crack Longitudinal Hinge, 4",
      "code": "CH4"
     },
     {
      "name": "Crack Longitudinal",
      "code": "CL"
     },
     {
      "name": "Crack Multiple",
      "code": "CM"
     },
     {
      "name": "Crack Spiral",
      "code": "CS"
     },
     {
      "name": "Deposits Attached Encrustation",
      "code": "DAE"
     },
     {
      "name": "Deposits Attached Grease",
      "code": "DAGS"
     },
     {
      "name": "Deposits Attached Ragging",
      "code": "DAR"
     },
     {
      "name": "Deposits Attached Other",
      "code": "DAZ"
     },
     {
      "name": "Displaced Brick",
      "code": "DB"
     },
     {
      "name": "Deformed Flexible Bulging Inverse Curvature",
      "code": "DFBI"
     },
     {
      "name": "Deformed Flexible Bulging Round",
      "code": "DFBR"
     },
     {
      "name": "Deformed Flexible Creasing",
      "code": "DFC"
     },
     {
      "name": "Deformed Flexible Elliptical",
      "code": "DFE"
     },
     {
      "name": "Brickwork Dropped Invert",
      "code": "DI"
     },
     {
      "name": "Deposits Ingress Fine",
      "code": "DNF"
     },
     {
      "name": "Deposits Ingress Gravel",
      "code": "DNGV"
     },
     {
      "name": "Deposits Ingress Other",
      "code": "DNZ"
     },
     {
      "name": "Deformed Rigid",
      "code": "DR"
     },
     {
      "name": "Deposits Settled Hard/Compacted",
      "code": "DSC"
     },
     {
      "name": "Deposits Settled Fine",
      "code": "DSF"
     },
     {
      "name": "Deposits Settled Gravel",
      "code": "DSGV"
     },
     {
      "name": "Deposits Settled Other",
      "code": "DSZ"
     },
     {
      "name": "Deformed Brick Bulging Inverse Curvature",
      "code": "DTBI"
     },
     {
      "name": "Deformed Brick Bulging Round",
      "code": "DTBR"
     },
     {
      "name": "Fracture Circumferential",
      "code": "FC"
     },
     {
      "name": "Fracture Longitudinal Hinge, 2",
      "code": "FH2"
     },
     {
      "name": "Fracture Longitudinal Hinge, 3",
      "code": "FH3"
     },
     {
      "name": "Fracture Longitudinal Hinge, 4",
      "code": "FH4"
     },
     {
      "name": "Fracture Longitudinal",
      "code": "FL"
     },
     {
      "name": "Fracture Multiple",
      "code": "FM"
     },
     {
      "name": "Fracture Spiral",
      "code": "FS"
     },
     {
      "name": "Grout at a Location",
      "code": "GRT"
     },
     {
      "name": "Grout Test Fail Joint",
      "code": "GTFJ"
     },
     {
      "name": "Grout Test Fail Lateral",
      "code": "GTFL"
     },
     {
      "name": "Grout Test Pass Joint",
      "code": "GTPJ"
     },
     {
      "name": "Grout  Test Pass Lateral",
      "code": "GTPL"
     },
     {
      "name": "Grout Test Unable to Test Joint",
      "code": "GTUJ"
     },
     {
      "name": "Grout Test Unable to Test Lateral",
      "code": "GTUL"
     },
     {
      "name": "Hole",
      "code": "H"
     },
     {
      "name": "Hole Soil Visible",
      "code": "HSV"
     },
     {
      "name": "Hole Void Visible",
      "code": "HVV"
     },
     {
      "name": "Infiltration Dripper",
      "code": "ID"
     },
     {
      "name": "Infiltration Dripper Barrel",
      "code": "IDB"
     },
     {
      "name": "Infiltration Dripper Connection",
      "code": "IDC"
     },
     {
      "name": "Infiltration Dripper Joint",
      "code": "IDJ"
     },
     {
      "name": "Infiltration Dripper Lateral",
      "code": "IDL"
     },
     {
      "name": "Infiltration Gusher",
      "code": "IG"
     },
     {
      "name": "Infiltration Gusher Barrel",
      "code": "IGB"
     },
     {
      "name": "Infiltration Gusher Connection",
      "code": "IGC"
     },
     {
      "name": "Infiltration Gusher Joint",
      "code": "IGJ"
     },
     {
      "name": "Infiltration Gusher Lateral",
      "code": "IGL"
     },
     {
      "name": "Infiltration Runner",
      "code": "IR"
     },
     {
      "name": "Infiltration Runner Barrel",
      "code": "IRB"
     },
     {
      "name": "Infiltration Runner Connection",
      "code": "IRC"
     },
     {
      "name": "Infiltration Runner Joint",
      "code": "IRJ"
     },
     {
      "name": "Infiltration Runner Lateral",
      "code": "IRL"
     },
     {
      "name": "Infiltration Stain",
      "code": "IS"
     },
     {
      "name": "Infiltration Stain Barrel",
      "code": "ISB"
     },
     {
      "name": "Infiltration Stain Connection",
      "code": "ISC"
     },
     {
      "name": "Intruding Sealing Material Grout",
      "code": "ISGT"
     },
     {
      "name": "Infiltration Stain Joint",
      "code": "ISJ"
     },
     {
      "name": "Infiltration Stain Lateral",
      "code": "ISL"
     },
     {
      "name": "Intruding Sealing Material Sealing Ring",
      "code": "ISSR"
     },
     {
      "name": "Intruding Sealing Material Sealing Ring Broken",
      "code": "ISSRB"
     },
     {
      "name": "Intruding Sealing Material Sealing Ring Hanging",
      "code": "ISSRH"
     },
     {
      "name": "Intruding Sealing Material Sealing Ring Loose/Poorly Fitting",
      "code": "ISSRL"
     },
     {
      "name": "Intruding Sealing Material Other",
      "code": "ISZ"
     },
     {
      "name": "Infiltration Weeper",
      "code": "IW"
     },
     {
      "name": "Infiltration Weeper Barrel",
      "code": "IWB"
     },
     {
      "name": "Infiltration Weeper Connection",
      "code": "IWC"
     },
     {
      "name": "Infiltration Weeper Joint",
      "code": "IWJ"
     },
     {
      "name": "Infiltration Weeper Lateral",
      "code": "IWL"
     },
     {
      "name": "Joint Angular Large",
      "code": "JAL"
     },
     {
      "name": "Joint Angular Medium",
      "code": "JAM"
     },
     {
      "name": "Joint Angular Small",
      "code": "JAS"
     },
     {
      "name": "Joint Offset Large",
      "code": "JOL"
     },
     {
      "name": "Joint Offset Large Defective",
      "code": "JOLD"
     },
     {
      "name": "Joint Offset Medium",
      "code": "JOM"
     },
     {
      "name": "Joint Offset Medium Defective",
      "code": "JOMD"
     },
     {
      "name": "Joint Offset Small",
      "code": "JOS"
     },
     {
      "name": "Joint Offset Small Defective",
      "code": "JOSD"
     },
     {
      "name": "Joint Separated Large",
      "code": "JSL"
     },
     {
      "name": "Joint Separated Medium",
      "code": "JSM"
     },
     {
      "name": "Joint Separated Small",
      "code": "JSS"
     },
     {
      "name": "Line Down",
      "code": "LD"
     },
     {
      "name": "Lining Feature Abandoned Connection",
      "code": "LFAC"
     },
     {
      "name": "Lining Feature Annular Space",
      "code": "LFAS"
     },
     {
      "name": "Lining Feature Blistered",
      "code": "LFB"
     },
     {
      "name": "Lining Feature Service Cut Shifted",
      "code": "LFCS"
     },
     {
      "name": "Lining Feature Detached",
      "code": "LFD"
     },
     {
      "name": "Lining Feature Discoloration",
      "code": "LFDC"
     },
     {
      "name": "Lining Feature Defective End",
      "code": "LFDE"
     },
     {
      "name": "Lining Feature Delaminating",
      "code": "LFDL"
     },
     {
      "name": "Lining Feature Overcut Service",
      "code": "LFOC"
     },
     {
      "name": "Lining Feature Resin Slug",
      "code": "LFRS"
     },
     {
      "name": "Lining Feature Undercut Service",
      "code": "LFUC"
     },
     {
      "name": "Lining Feature Wrinkled",
      "code": "LFW"
     },
     {
      "name": "Lining Feature Other",
      "code": "LFZ"
     },
     {
      "name": "Line Left",
      "code": "LL"
     },
     {
      "name": "Line Left Down",
      "code": "LLD"
     },
     {
      "name": "Line Left Up",
      "code": "LLU"
     },
     {
      "name": "Line Right",
      "code": "LR"
     },
     {
      "name": "Line Right Down",
      "code": "LRD"
     },
     {
      "name": "Line Right Up",
      "code": "LRU"
     },
     {
      "name": "Line Up",
      "code": "LU"
     },
     {
      "name": "Missing Brick",
      "code": "MB"
     },
     {
      "name": "Miscellaneous Camera Underwater",
      "code": "MCU"
     },
     {
      "name": "Miscellaneous General Observation",
      "code": "MGO"
     },
     {
      "name": "Miscellaneous General Photo",
      "code": "MGP"
     },
     {
      "name": "Miscellaneous Pipe Joint Length Change",
      "code": "MJL"
     },
     {
      "name": "Miscellaneous Lining Change",
      "code": "MLC"
     },
     {
      "name": "Miscellaneous Material Change",
      "code": "MMC"
     },
     {
      "name": "Missing Mortar Large",
      "code": "MML"
     },
     {
      "name": "Missing Mortar Medium",
      "code": "MMM"
     },
     {
      "name": "Missing Mortar Small",
      "code": "MMS"
     },
     {
      "name": "Miscellaneous Abandoned Survey",
      "code": "MSA"
     },
     {
      "name": "Miscellaneous Shape/Size Change",
      "code": "MSC"
     },
     {
      "name": "Miscellaneous Water Level",
      "code": "MWL"
     },
     {
      "name": "Miscellaneous Water Level Sag",
      "code": "MWLS"
     },
     {
      "name": "Miscellaneous Water Mark",
      "code": "MWM"
     },
     {
      "name": "Miscellaneous Dye Test Not Visible",
      "code": "MYN"
     },
     {
      "name": "Miscellaneous Dye Test Visible",
      "code": "MYV"
     },
     {
      "name": "Obstruction Brick or Masonry",
      "code": "OBB"
     },
     {
      "name": "Obstruction Thru Connection",
      "code": "OBC"
     },
     {
      "name": "Obstruction Intruding Through Wall",
      "code": "OBI"
     },
     {
      "name": "Obstruction Wedged In The Joint",
      "code": "OBJ"
     },
     {
      "name": "Obstruction Pipe Material in Invert",
      "code": "OBM"
     },
     {
      "name": "Obstruction Construction Debris",
      "code": "OBN"
     },
     {
      "name": "Obstruction External Pipe or Cable",
      "code": "OBP"
     },
     {
      "name": "Obstruction Rocks",
      "code": "OBR"
     },
     {
      "name": "Obstruction Built Into Structure",
      "code": "OBS"
     },
     {
      "name": "Obstruction Other",
      "code": "OBZ"
     },
     {
      "name": "Roots Ball Barrel",
      "code": "RBB"
     },
     {
      "name": "Roots Ball Connection",
      "code": "RBC"
     },
     {
      "name": "Roots Ball Joint",
      "code": "RBJ"
     },
     {
      "name": "Roots Ball Lateral",
      "code": "RBL"
     },
     {
      "name": "Roots Fine Barrel",
      "code": "RFB"
     },
     {
      "name": "Roots Fine Connection",
      "code": "RFC"
     },
     {
      "name": "Roots Fine Joint",
      "code": "RFJ"
     },
     {
      "name": "Roots Fine Lateral",
      "code": "RFL"
     },
     {
      "name": "Roots Medium Barrel",
      "code": "RMB"
     },
     {
      "name": "Roots Medium Connection",
      "code": "RMC"
     },
     {
      "name": "Roots Medium Joint",
      "code": "RMJ"
     },
     {
      "name": "Roots Medium Lateral",
      "code": "RML"
     },
     {
      "name": "Point Repair Liner",
      "code": "RPL"
     },
     {
      "name": "Point Repair Liner Defective",
      "code": "RPLD"
     },
     {
      "name": "Point Repair Patch",
      "code": "RPP"
     },
     {
      "name": "Point Repair Patch Patch Defective",
      "code": "RPPD"
     },
     {
      "name": "Point Repair Replacement",
      "code": "RPR"
     },
     {
      "name": "Point Repair Replacement Defective",
      "code": "RPRD"
     },
     {
      "name": "Point Repair Other",
      "code": "RPZ"
     },
     {
      "name": "Point Repair Other Defective",
      "code": "RPZD"
     },
     {
      "name": "Roots Tap Barrel",
      "code": "RTB"
     },
     {
      "name": "Roots Tap Connection",
      "code": "RTC"
     },
     {
      "name": "Roots Tap Joint",
      "code": "RTJ"
     },
     {
      "name": "Roots Tap Lateral",
      "code": "RTL"
     },
     {
      "name": "Surface Damage Aggregate Missing",
      "code": "SAM"
     },
     {
      "name": "Surface Damage Aggregate Projecting",
      "code": "SAP"
     },
     {
      "name": "Surface Damage Aggregate Visible",
      "code": "SAV"
     },
     {
      "name": "Surface Damage Corrosion",
      "code": "SCP"
     },
     {
      "name": "Surface Damage Missing Wall",
      "code": "SMW"
     },
     {
      "name": "Surface Damage Reinforcement Corroded",
      "code": "SRC"
     },
     {
      "name": "Surface Damage Roughness Increased",
      "code": "SRI"
     },
     {
      "name": "Surface Damage Reinforcement Projecting",
      "code": "SRP"
     },
     {
      "name": "Surface Damage Reinforcement Visible",
      "code": "SRV"
     },
     {
      "name": "Surface Spalling of Damage Coating",
      "code": "SSC"
     },
     {
      "name": "Surface Damage Surface Spalling",
      "code": "SSS"
     },
     {
      "name": "Surface Damage Other",
      "code": "SZ"
     },
     {
      "name": "Tap Break-in/Hammer",
      "code": "TB"
     },
     {
      "name": "Tap Break-in Activity",
      "code": "TBA"
     },
     {
      "name": "Tap Break-in Abandoned",
      "code": "TBB"
     },
     {
      "name": "Tap Break-in Capped",
      "code": "TBC"
     },
     {
      "name": "Tap Break-in/Hammer Defective",
      "code": "TBD"
     },
     {
      "name": "Tap Break-in Intruding",
      "code": "TBI"
     },
     {
      "name": "Tap Factory",
      "code": "TF"
     },
     {
      "name": "Tap Factory Activity",
      "code": "TFA"
     },
     {
      "name": "Tap Factory Abandoned",
      "code": "TFB"
     },
     {
      "name": "Tap Factory Capped",
      "code": "TFC"
     },
     {
      "name": "Tap Factory Defective",
      "code": "TFD"
     },
     {
      "name": "Tap Factory Intruding",
      "code": "TFI"
     },
     {
      "name": "Tap Rehabilitated",
      "code": "TR"
     },
     {
      "name": "Tap Rehabilitated Activity",
      "code": "TRA"
     },
     {
      "name": "Tap Rehabilitated Abandoned",
      "code": "TRB"
     },
     {
      "name": "Tap Rehabilitated Capped",
      "code": "TRC"
     },
     {
      "name": "Tap Rehabilitated Defective",
      "code": "TRD"
     },
     {
      "name": "Tap Rehabilitated Intruding",
      "code": "TRI"
     },
     {
      "name": "Tap Saddle",
      "code": "TS"
     },
     {
      "name": "Tap Saddle Activity",
      "code": "TSA"
     },
     {
      "name": "Tap Saddle Abandoned",
      "code": "TSB"
     },
     {
      "name": "Tap Saddle Capped",
      "code": "TSC"
     },
     {
      "name": "Tap Saddle Defective",
      "code": "TSD"
     },
     {
      "name": "Tap Saddle Intruding",
      "code": "TSI"
     },
     {
      "name": "Vermin Cockroach",
      "code": "VC"
     },
     {
      "name": "Vermin Rat",
      "code": "VR"
     },
     {
      "name": "Vermin Other",
      "code": "VZ"
     },
     {
      "name": "Weld Feature Circumferential",
      "code": "WFC"
     },
     {
      "name": "Weld Feature Longitudinal",
      "code": "WFL"
     },
     {
      "name": "Weld Feature Multiple",
      "code": "WFM"
     },
     {
      "name": "Weld Feature Spiral",
      "code": "WFS"
     },
     {
      "name": "Weld Feature Other",
      "code": "WFZ"
     },
     {
      "name": "Collapse",
      "code": "X"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "VALUE_1ST_DIMENSION",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Value_1st_Dimension",
   "domain": null
  },
  {
   "name": "VALUE_PERCENT",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Value_Percent",
   "domain": null
  },
  {
   "name": "REMARKS",
   "type": "esriFieldTypeString",
   "alias": "Remarks",
   "length": 100,
   "domain": null
  },
  {
   "name": "VCR_TIME",
   "type": "esriFieldTypeSmallInteger",
   "alias": "VCR_Time",
   "domain": null
  },
  {
   "name": "INSPECTIONID",
   "type": "esriFieldTypeString",
   "alias": "InspectionID",
   "length": 20,
   "domain": null
  },
  {
   "name": "CREATED_USER",
   "type": "esriFieldTypeString",
   "alias": "CREATED_USER",
   "length": 255,
   "domain": null
  },
  {
   "name": "CREATED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "CREATED_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "LAST_EDITED_USER",
   "type": "esriFieldTypeString",
   "alias": "LAST_EDITED_USER",
   "length": 255,
   "domain": null
  },
  {
   "name": "LAST_EDITED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "LAST_EDITED_DATE",
   "length": 8,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "GDB_196114_INSPE",
   "fields": "INSPECTIONID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "R454177_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_454177",
   "fields": "GLOBALID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_OID_454177",
   "fields": "GLOBALID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 3,
   "name": "Inspection",
   "relatedTableId": 9,
   "role": "esriRelRoleDestination",
   "keyField": "INSPECTIONID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{98B91C9D-9844-4439-A084-2E2EA480172A}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 20000,
 "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": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}