{
 "currentVersion": 10.71,
 "id": 5,
 "name": "Sewer.DBO.TV_Surveys",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Street_Name",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "San_Pipe_ID",
   "type": "esriFieldTypeInteger",
   "alias": "Sanitary Sewer Line Object ID",
   "domain": null
  },
  {
   "name": "SMVCONTDTG_OID",
   "type": "esriFieldTypeInteger",
   "alias": "Storm Conduit Object ID",
   "domain": null
  },
  {
   "name": "Sewer_Type",
   "type": "esriFieldTypeString",
   "alias": "Sewer_Type",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Sewer_Type",
    "description": "Sanitary or storm.",
    "codedValues": [
     {
      "name": "Storm",
      "code": "Storm"
     },
     {
      "name": "Sanitary",
      "code": "Sanitary"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DVD_Number",
   "type": "esriFieldTypeString",
   "alias": "DVD_Number",
   "length": 10,
   "domain": null
  },
  {
   "name": "Survey_Number",
   "type": "esriFieldTypeString",
   "alias": "Survey_Number",
   "length": 6,
   "domain": null
  },
  {
   "name": "House",
   "type": "esriFieldTypeString",
   "alias": "House",
   "length": 10,
   "domain": null
  },
  {
   "name": "Street_Name",
   "type": "esriFieldTypeString",
   "alias": "Street_Name",
   "length": 30,
   "domain": null
  },
  {
   "name": "Street_Type",
   "type": "esriFieldTypeString",
   "alias": "Street_Type",
   "length": 10,
   "domain": null
  },
  {
   "name": "Quad",
   "type": "esriFieldTypeString",
   "alias": "Quad",
   "length": 5,
   "domain": null
  },
  {
   "name": "USMAN",
   "type": "esriFieldTypeString",
   "alias": "USMAN",
   "length": 20,
   "domain": null
  },
  {
   "name": "DSMAN",
   "type": "esriFieldTypeString",
   "alias": "DSMAN",
   "length": 20,
   "domain": null
  },
  {
   "name": "Survey_Date",
   "type": "esriFieldTypeDate",
   "alias": "Survey_Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "DVD_Unit",
   "type": "esriFieldTypeString",
   "alias": "DVD_Unit",
   "length": 5,
   "domain": null
  },
  {
   "name": "Operator",
   "type": "esriFieldTypeString",
   "alias": "Operator",
   "length": 30,
   "domain": null
  },
  {
   "name": "Notes",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "length": 250,
   "domain": null
  },
  {
   "name": "Roots",
   "type": "esriFieldTypeString",
   "alias": "Roots",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Amount",
    "description": "Amount of detritus or inflow.",
    "codedValues": [
     {
      "name": "Trace",
      "code": "Trace"
     },
     {
      "name": "Light",
      "code": "Light"
     },
     {
      "name": "Medium",
      "code": "Medium"
     },
     {
      "name": "Heavy",
      "code": "Heavy"
     },
     {
      "name": "Clear",
      "code": "Clear"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Root_Location",
   "type": "esriFieldTypeString",
   "alias": "Root_Location",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "Pipe_Location",
    "description": "Location on pipe or conduit.",
    "codedValues": [
     {
      "name": "Joints",
      "code": "Joints"
     },
     {
      "name": "Services",
      "code": "Services"
     },
     {
      "name": "Joints and Services",
      "code": "Joints and Services"
     },
     {
      "name": "Manhole",
      "code": "Manhole"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Affected_Svcs",
   "type": "esriFieldTypeString",
   "alias": "Affected_Svcs",
   "length": 5,
   "domain": null
  },
  {
   "name": "Debris",
   "type": "esriFieldTypeString",
   "alias": "Debris",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Amount",
    "description": "Amount of detritus or inflow.",
    "codedValues": [
     {
      "name": "Trace",
      "code": "Trace"
     },
     {
      "name": "Light",
      "code": "Light"
     },
     {
      "name": "Medium",
      "code": "Medium"
     },
     {
      "name": "Heavy",
      "code": "Heavy"
     },
     {
      "name": "Clear",
      "code": "Clear"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Grease",
   "type": "esriFieldTypeString",
   "alias": "Grease",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Amount",
    "description": "Amount of detritus or inflow.",
    "codedValues": [
     {
      "name": "Trace",
      "code": "Trace"
     },
     {
      "name": "Light",
      "code": "Light"
     },
     {
      "name": "Medium",
      "code": "Medium"
     },
     {
      "name": "Heavy",
      "code": "Heavy"
     },
     {
      "name": "Clear",
      "code": "Clear"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Minerals",
   "type": "esriFieldTypeString",
   "alias": "Minerals",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Amount",
    "description": "Amount of detritus or inflow.",
    "codedValues": [
     {
      "name": "Trace",
      "code": "Trace"
     },
     {
      "name": "Light",
      "code": "Light"
     },
     {
      "name": "Medium",
      "code": "Medium"
     },
     {
      "name": "Heavy",
      "code": "Heavy"
     },
     {
      "name": "Clear",
      "code": "Clear"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Needs_Slip_Lined",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Needs_Slip_Lined",
   "domain": {
    "type": "codedValue",
    "name": "Common_Boolean",
    "description": "GBA Boolean Domain",
    "codedValues": [
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "Damage_or_Defect",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Damage_or_Defect",
   "domain": {
    "type": "codedValue",
    "name": "Common_Boolean",
    "description": "GBA Boolean Domain",
    "codedValues": [
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "Hyperlink",
   "type": "esriFieldTypeString",
   "alias": "Hyperlink",
   "length": 100,
   "domain": null
  },
  {
   "name": "Offset",
   "type": "esriFieldTypeString",
   "alias": "Offset",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Severity",
    "description": "Severity of damage or defect.",
    "codedValues": [
     {
      "name": "Minor",
      "code": "Minor"
     },
     {
      "name": "Moderate",
      "code": "Moderate"
     },
     {
      "name": "Major",
      "code": "Major"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Crack",
   "type": "esriFieldTypeString",
   "alias": "Crack",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Severity",
    "description": "Severity of damage or defect.",
    "codedValues": [
     {
      "name": "Minor",
      "code": "Minor"
     },
     {
      "name": "Moderate",
      "code": "Moderate"
     },
     {
      "name": "Major",
      "code": "Major"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Break_",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Break",
   "domain": {
    "type": "codedValue",
    "name": "Common_Boolean",
    "description": "GBA Boolean Domain",
    "codedValues": [
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "I_I",
   "type": "esriFieldTypeString",
   "alias": "I_I",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Amount",
    "description": "Amount of detritus or inflow.",
    "codedValues": [
     {
      "name": "Trace",
      "code": "Trace"
     },
     {
      "name": "Light",
      "code": "Light"
     },
     {
      "name": "Medium",
      "code": "Medium"
     },
     {
      "name": "Heavy",
      "code": "Heavy"
     },
     {
      "name": "Clear",
      "code": "Clear"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "I_I_Location",
   "type": "esriFieldTypeString",
   "alias": "I_I_Location",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "Pipe_Location",
    "description": "Location on pipe or conduit.",
    "codedValues": [
     {
      "name": "Joints",
      "code": "Joints"
     },
     {
      "name": "Services",
      "code": "Services"
     },
     {
      "name": "Joints and Services",
      "code": "Joints and Services"
     },
     {
      "name": "Manhole",
      "code": "Manhole"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Hole",
   "type": "esriFieldTypeString",
   "alias": "Hole",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Severity",
    "description": "Severity of damage or defect.",
    "codedValues": [
     {
      "name": "Minor",
      "code": "Minor"
     },
     {
      "name": "Moderate",
      "code": "Moderate"
     },
     {
      "name": "Major",
      "code": "Major"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Hole_Location",
   "type": "esriFieldTypeString",
   "alias": "Hole_Location",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Defect_Location",
    "description": "Location of damage or defect. ",
    "codedValues": [
     {
      "name": "Crown",
      "code": "Crown"
     },
     {
      "name": "Side(s)",
      "code": "Side(s)"
     },
     {
      "name": "Trough",
      "code": "Trough"
     },
     {
      "name": "Multiple",
      "code": "Multiple"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Sag",
   "type": "esriFieldTypeString",
   "alias": "Sag",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "Sag_Degree",
    "description": "Degree of sag.",
    "codedValues": [
     {
      "name": "<1/4",
      "code": "<1/4"
     },
     {
      "name": "1/4",
      "code": "1/4"
     },
     {
      "name": "1/2",
      "code": "1/2"
     },
     {
      "name": "3/4",
      "code": "3/4"
     },
     {
      "name": "Full",
      "code": "Full"
     },
     {
      "name": "Unkown",
      "code": "Unk"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Repair_Status",
   "type": "esriFieldTypeString",
   "alias": "Repair_Status",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "Repair_Status",
    "description": "Status of repair.",
    "codedValues": [
     {
      "name": "Needs Repair",
      "code": "Needs Repair"
     },
     {
      "name": "Repair in Progress",
      "code": "Repair in Progress"
     },
     {
      "name": "Repair Complete",
      "code": "Repair Complete"
     },
     {
      "name": "Repair Scheduled",
      "code": "Repair Scheduled"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Repair_Comments",
   "type": "esriFieldTypeString",
   "alias": "Repair_Comments",
   "length": 250,
   "domain": null
  },
  {
   "name": "TV_Survey_ID",
   "type": "esriFieldTypeInteger",
   "alias": "TV_Survey_ID",
   "domain": null
  },
  {
   "name": "weblink",
   "type": "esriFieldTypeString",
   "alias": "weblink",
   "length": 500,
   "domain": null
  },
  {
   "name": "OldTVID",
   "type": "esriFieldTypeInteger",
   "alias": "OldTVID",
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "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
  },
  {
   "name": "Project_Number",
   "type": "esriFieldTypeString",
   "alias": "Project_Number",
   "length": 30,
   "domain": null
  },
  {
   "name": "Survey_Completed",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Survey_Completed",
   "domain": {
    "type": "codedValue",
    "name": "Common_Boolean",
    "description": "GBA Boolean Domain",
    "codedValues": [
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "Flow_Direction",
   "type": "esriFieldTypeString",
   "alias": "Flow_Direction",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "San_Flow_Direction",
    "description": "Sanitary Flow Direction",
    "codedValues": [
     {
      "name": "With",
      "code": "With"
     },
     {
      "name": "Against",
      "code": "Against"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Low_or_Obstructed_Flow",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Low_or_Obstructed_Flow",
   "domain": {
    "type": "codedValue",
    "name": "Common_Boolean",
    "description": "GBA Boolean Domain",
    "codedValues": [
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "GISTemp",
   "type": "esriFieldTypeString",
   "alias": "GISTemp",
   "length": 25,
   "domain": null
  },
  {
   "name": "Root_Letter_Created",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Root_Letter_Created",
   "domain": {
    "type": "codedValue",
    "name": "Y/N",
    "description": "Yes No short integer",
    "codedValues": [
     {
      "name": "No",
      "code": 0
     },
     {
      "name": "Yes",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "AssetID",
   "type": "esriFieldTypeString",
   "alias": "AssetID",
   "length": 10,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R2579_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_2579",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "I7995TV_Survey_I",
   "fields": "TV_Survey_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_2579",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "Sewer.DBO.Storm_Pipes",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "AssetID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON",
 "isDataVersioned": true,
 "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
}