{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 1,
 "name": "WilbrahamSewer.DBO.SewerManholeII",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Inspector",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "FrameCover",
   "type": "esriFieldTypeString",
   "alias": "Rim and Cover Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "FrameCover",
    "description": "Frame and Cover",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Broken",
      "code": "Broken"
     },
     {
      "name": "Lower",
      "code": "Lower"
     },
     {
      "name": "Raise",
      "code": "Raise"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "Date",
   "type": "esriFieldTypeDate",
   "alias": "Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Inspector",
   "type": "esriFieldTypeString",
   "alias": "Inspector",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "Inspector",
    "description": "Inspector",
    "codedValues": [
     {
      "name": "Gary B",
      "code": "GaryB"
     },
     {
      "name": "Ed J",
      "code": "EdJ"
     },
     {
      "name": "Tonya",
      "code": "Tonya"
     },
     {
      "name": "Dena",
      "code": "Dena"
     },
     {
      "name": "Bill",
      "code": "Bill"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Kevin L",
      "code": "KevinL"
     },
     {
      "name": "Tim G",
      "code": "TimG"
     },
     {
      "name": "Andy F",
      "code": "AndyF"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Weather",
   "type": "esriFieldTypeString",
   "alias": "Weather",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Weather",
    "description": "Weather",
    "codedValues": [
     {
      "name": "No Rain",
      "code": "NoRain"
     },
     {
      "name": "Recent Rain",
      "code": "RecentRain"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GroundWater",
   "type": "esriFieldTypeString",
   "alias": "GroundWater",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "GroundWater",
    "description": "Ground Water",
    "codedValues": [
     {
      "name": "Low",
      "code": "Low"
     },
     {
      "name": "Average",
      "code": "Average"
     },
     {
      "name": "High",
      "code": "High"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Location",
   "type": "esriFieldTypeString",
   "alias": "Location",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Location",
    "description": "Location",
    "codedValues": [
     {
      "name": "Pavement",
      "code": "Pavement"
     },
     {
      "name": "Cross Country",
      "code": "CrossCountry"
     },
     {
      "name": "Grass",
      "code": "Grass"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "StructuralCondition",
   "type": "esriFieldTypeString",
   "alias": "StructuralCondition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SMHStructuralCondition",
    "description": "SMH Structural Condition",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Flow",
   "type": "esriFieldTypeString",
   "alias": "Flow",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "IIFlow",
    "description": "II Flow",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Trickle",
      "code": "Trickle"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Grease",
   "type": "esriFieldTypeString",
   "alias": "Grease",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "baseBoolean",
    "description": "Yes/No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Solids",
   "type": "esriFieldTypeString",
   "alias": "Solids",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "baseBoolean",
    "description": "Yes/No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Weeping",
   "type": "esriFieldTypeString",
   "alias": "Weeping",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "baseBoolean",
    "description": "Yes/No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FlowDepth",
   "type": "esriFieldTypeString",
   "alias": "FlowDepth",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SMHFlowDepth",
    "description": "SMH Flow Depth",
    "codedValues": [
     {
      "name": "1/4 Pipe",
      "code": "1/4Pipe"
     },
     {
      "name": "1/2 Pipe",
      "code": "1/2Pipe"
     },
     {
      "name": "High",
      "code": "High"
     },
     {
      "name": "Very Low",
      "code": "VeryLow"
     },
     {
      "name": "1/8 Pipe",
      "code": "1/8Pipe"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "IIConcerns",
   "type": "esriFieldTypeString",
   "alias": "IIConcerns",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "IIConcerns",
    "description": "II Concerns",
    "codedValues": [
     {
      "name": "Sump Pump",
      "code": "SumpPump"
     },
     {
      "name": "Infiltration",
      "code": "Infiltration"
     },
     {
      "name": "None",
      "code": "None"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "HighPriorityRepair",
   "type": "esriFieldTypeString",
   "alias": "HighPriorityRepair",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "baseBoolean",
    "description": "Yes/No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Comments",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 200,
   "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": "RelGlobalID",
   "type": "esriFieldTypeGUID",
   "alias": "RelGlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "ManholeAdjustment",
   "type": "esriFieldTypeString",
   "alias": "ManholeAdjustment",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "ManholeAdjustment",
    "description": "Manhole Adjustment",
    "codedValues": [
     {
      "name": "Lower",
      "code": "Lower"
     },
     {
      "name": "Raise",
      "code": "Raise"
     },
     {
      "name": "None",
      "code": "None"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FlowRate",
   "type": "esriFieldTypeString",
   "alias": "FlowRate",
   "length": 50,
   "domain": null
  },
  {
   "name": "RepairStatus",
   "type": "esriFieldTypeString",
   "alias": "RepairStatus",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "RepairStatus",
    "description": "Repair Status",
    "codedValues": [
     {
      "name": "Needed",
      "code": "Needed"
     },
     {
      "name": "Pending",
      "code": "Pending"
     },
     {
      "name": "Completed",
      "code": "Completed"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "RepairComments",
   "type": "esriFieldTypeString",
   "alias": "RepairComments",
   "length": 100,
   "domain": null
  },
  {
   "name": "Address",
   "type": "esriFieldTypeString",
   "alias": "Address",
   "length": 100,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "UUID_35",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "gdb_ct3_35",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "GDB_7275_RelGlob",
   "fields": "RelGlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "SewerManhole",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "RelGlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{7D52122C-3B55-4016-B880-D9842E45A2E3}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "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,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": false,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1485787911000
 }
}