{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 21,
 "name": "SSC MHI Report",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "globalid",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "globalid",
   "type": "esriFieldTypeString",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "date",
   "type": "esriFieldTypeDate",
   "alias": "Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "crew",
   "type": "esriFieldTypeString",
   "alias": "Submitted By",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_crew",
    "description": "",
    "codedValues": [
     {
      "name": "Aaron Nova",
      "code": "Aaron Nova"
     },
     {
      "name": "Anita Daigneault",
      "code": "Anita Daigneault"
     },
     {
      "name": "Ben Renea",
      "code": "Ben Renea"
     },
     {
      "name": "Brandon Dickman",
      "code": "Brandon Dickman"
     },
     {
      "name": "Dave Smith",
      "code": "Dave Smith"
     },
     {
      "name": "Ed Jacobs",
      "code": "Ed Jacobs"
     },
     {
      "name": "Gordon Schultz",
      "code": "Gordon Schultz"
     },
     {
      "name": "Greg Glowczewski",
      "code": "Greg Glowczewski"
     },
     {
      "name": "Jason Rayford",
      "code": "Jason Rayford"
     },
     {
      "name": "Jeff Gensler",
      "code": "Jeff Gensler"
     },
     {
      "name": "John Adamski",
      "code": "John Adamski"
     },
     {
      "name": "John Griss",
      "code": "John Griss"
     },
     {
      "name": "John Krontz",
      "code": "John Krontz"
     },
     {
      "name": "Ken Schwartz",
      "code": "Ken Schwartz"
     },
     {
      "name": "Kevin Keller",
      "code": "Kevin Keller"
     },
     {
      "name": "Lydia Kokensparger",
      "code": "Lydia Kokensparger"
     },
     {
      "name": "Mike Keating",
      "code": "Mike Keating"
     },
     {
      "name": "Mike Snavely",
      "code": "Mike Snavely"
     },
     {
      "name": "Nate Dickman",
      "code": "Nate Dickman"
     },
     {
      "name": "Rick Cajka",
      "code": "Rick Cajka"
     },
     {
      "name": "Robert Johnson",
      "code": "Robert Johnson"
     },
     {
      "name": "Robert Lawson",
      "code": "Robert Lawson"
     },
     {
      "name": "Ryan Kowalski",
      "code": "Ryan Kowalski"
     },
     {
      "name": "Sara Jensen",
      "code": "Sara Jensen"
     },
     {
      "name": "Steve Riegle",
      "code": "Steve Riegle"
     },
     {
      "name": "Todd Melnyk",
      "code": "Todd Melnyk"
     },
     {
      "name": "Tom Kralovic",
      "code": "Tom Kralovic"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "crewleaders",
   "type": "esriFieldTypeString",
   "alias": "Crew Leader",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_crewleaders",
    "description": "",
    "codedValues": [
     {
      "name": "Dave Smith",
      "code": "Dave Smith"
     },
     {
      "name": "Ed Jacobs",
      "code": "Ed Jacobs"
     },
     {
      "name": "Todd Melnyk",
      "code": "Todd Melnyk"
     },
     {
      "name": "Tim Farrell",
      "code": "Tim Farrell"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "facilityid",
   "type": "esriFieldTypeString",
   "alias": "MH ID / PIPE ID",
   "length": 255,
   "domain": null
  },
  {
   "name": "sewerlocation",
   "type": "esriFieldTypeString",
   "alias": "Street Name",
   "length": 255,
   "domain": null
  },
  {
   "name": "pipesize",
   "type": "esriFieldTypeString",
   "alias": "Pipe Size",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_pipesize",
    "description": "",
    "codedValues": [
     {
      "name": "6\"",
      "code": "6"
     },
     {
      "name": "8\"",
      "code": "8"
     },
     {
      "name": "10\"",
      "code": "10"
     },
     {
      "name": "12\"",
      "code": "12"
     },
     {
      "name": "14\"",
      "code": "14"
     },
     {
      "name": "15\"",
      "code": "15"
     },
     {
      "name": "16\"",
      "code": "16"
     },
     {
      "name": "18\"",
      "code": "18"
     },
     {
      "name": "20\"",
      "code": "20"
     },
     {
      "name": "21\"",
      "code": "21"
     },
     {
      "name": "24\"",
      "code": "24"
     },
     {
      "name": "30\"",
      "code": "30"
     },
     {
      "name": "36\"",
      "code": "36"
     },
     {
      "name": "40\"",
      "code": "40"
     },
     {
      "name": "42\"",
      "code": "42"
     },
     {
      "name": "48\"",
      "code": "48"
     },
     {
      "name": "54\"",
      "code": "54"
     },
     {
      "name": "60\"",
      "code": "60"
     },
     {
      "name": "66\"",
      "code": "66"
     },
     {
      "name": "72\"",
      "code": "72"
     },
     {
      "name": "75\"",
      "code": "75"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "length",
   "type": "esriFieldTypeString",
   "alias": "Total Lineal Feet",
   "length": 255,
   "domain": null
  },
  {
   "name": "location",
   "type": "esriFieldTypeString",
   "alias": "Location",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_location",
    "description": "",
    "codedValues": [
     {
      "name": "Street",
      "code": "street"
     },
     {
      "name": "CUL DE SAC",
      "code": "cul_de_sac"
     },
     {
      "name": "Front Yard",
      "code": "front_yard"
     },
     {
      "name": "Easement",
      "code": "easement"
     },
     {
      "name": "Other",
      "code": "other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "type",
   "type": "esriFieldTypeString",
   "alias": "SSC USC MHI",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_type",
    "description": "",
    "codedValues": [
     {
      "name": "SSC",
      "code": "SSC"
     },
     {
      "name": "USC",
      "code": "USC"
     },
     {
      "name": "MHI",
      "code": "MHI"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "clean",
   "type": "esriFieldTypeString",
   "alias": "FLUSH or JET",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_clean",
    "description": "",
    "codedValues": [
     {
      "name": "Flush",
      "code": "Flush"
     },
     {
      "name": "Jet",
      "code": "Jet"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "mhcondition",
   "type": "esriFieldTypeString",
   "alias": "MH Condition",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "cvd_mhcondition",
    "description": "",
    "codedValues": [
     {
      "name": "Dry",
      "code": "dry"
     },
     {
      "name": "Wet",
      "code": "wet"
     },
     {
      "name": "Standing",
      "code": "standing"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Issue_Found",
   "type": "esriFieldTypeString",
   "alias": "Issue Found",
   "length": 255,
   "domain": null
  },
  {
   "name": "Indication",
   "type": "esriFieldTypeString",
   "alias": "Manhole defects",
   "length": 255,
   "domain": null
  },
  {
   "name": "comment",
   "type": "esriFieldTypeString",
   "alias": "Commnets on Finding",
   "length": 255,
   "domain": null
  },
  {
   "name": "email",
   "type": "esriFieldTypeString",
   "alias": "email",
   "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
  }
 ],
 "indexes": [
  {
   "name": "R420_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_17108_facili",
   "fields": "facilityid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "GISENG.\"REAL_ESTATE\\SJAYAWARDHANA\".ssManholes",
   "relatedTableId": 3,
   "role": "esriRelRoleDestination",
   "keyField": "facilityid",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "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,
  "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
 },
 "serviceItemId": "fc7bf0cb23d5473b923f7587eb8b6713"
}