{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 5,
 "name": "Hydrant Flushing",
 "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": "INSPECTOR",
   "type": "esriFieldTypeString",
   "alias": "Inspected By",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "Employee",
    "description": "List of Employees",
    "codedValues": [
     {
      "name": "Aaron Zaccone",
      "code": "Aaron Zaccone"
     },
     {
      "name": "Alexander Karalokian",
      "code": "Alexander Karalokian"
     },
     {
      "name": "Alma Burgos",
      "code": "Alma Burgos"
     },
     {
      "name": "Antonio Martinez",
      "code": "Antonio Martinez"
     },
     {
      "name": "Brandon Riker",
      "code": "Brandon Riker"
     },
     {
      "name": "Brandon Rodgers",
      "code": "Brandon Rodgers"
     },
     {
      "name": "Brian McMahon",
      "code": "Brian McMahon"
     },
     {
      "name": "Brian Ten Hoeve",
      "code": "Brian Ten Hoeve"
     },
     {
      "name": "Bryan Guevara",
      "code": "Bryan Guevara"
     },
     {
      "name": "Carl Grayson",
      "code": "Carl Grayson"
     },
     {
      "name": "Carmine Baione",
      "code": "Carmine Baione"
     },
     {
      "name": "Chris Scimeca",
      "code": "Chris Scimeca"
     },
     {
      "name": "Dan Labita",
      "code": "Dan Labita"
     },
     {
      "name": "Hugo Gonzalez",
      "code": "Hugo Gonzalez"
     },
     {
      "name": "James Tecchio",
      "code": "James Tecchio"
     },
     {
      "name": "Jarret Robinson",
      "code": "Jarret Robinson"
     },
     {
      "name": "Jill Fasano",
      "code": "Jill Fasano"
     },
     {
      "name": "Joe Cofrancesco",
      "code": "Joe Cofrancesco"
     },
     {
      "name": "Josh Conlon",
      "code": "Josh Conlon"
     },
     {
      "name": "Justin Popek",
      "code": "Justin Popek"
     },
     {
      "name": "Justin Scognamiglio",
      "code": "Justin Scognamiglio"
     },
     {
      "name": "Justin Zaccone",
      "code": "Justin Zaccone"
     },
     {
      "name": "Kelly Rodgers",
      "code": "Kelly Rodgers"
     },
     {
      "name": "Kevin Niosi",
      "code": "Kevin Niosi"
     },
     {
      "name": "Kristina Necovska",
      "code": "Kristina Necovska"
     },
     {
      "name": "Matt Duemmer",
      "code": "Matt Duemmer"
     },
     {
      "name": "Matt Nicholson",
      "code": "Matt Nicholson"
     },
     {
      "name": "Matt Ortandl",
      "code": "Matt Ortandl"
     },
     {
      "name": "Michael Cohrs",
      "code": "Michael Cohrs"
     },
     {
      "name": "Michael Youmatzo",
      "code": "Michael Youmatzo"
     },
     {
      "name": "Mirella Hernandez",
      "code": "Mirella Hernandez"
     },
     {
      "name": "Nate Amos",
      "code": "Nate Amos"
     },
     {
      "name": "Neil Gallone",
      "code": "Neil Gallone"
     },
     {
      "name": "New Employee",
      "code": "New Employee"
     },
     {
      "name": "Ralph Ruggiero",
      "code": "Ralph Ruggiero"
     },
     {
      "name": "Richard Calbi, Jr.",
      "code": "Richard Calbi, Jr."
     },
     {
      "name": "Rob Cahoon",
      "code": "Rob Cahoon"
     },
     {
      "name": "Sarah Bielen",
      "code": "Sarah Bielen"
     },
     {
      "name": "Steve Wilson",
      "code": "Steve Wilson"
     },
     {
      "name": "Tyler Aronne",
      "code": "Tyler Aronne"
     },
     {
      "name": "Willam Bierwas",
      "code": "William Bierwas"
     },
     {
      "name": "Xiaying Huang",
      "code": "Xiaying Huang"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "INSPECTDATE",
   "type": "esriFieldTypeDate",
   "alias": "Inspection Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ASSETGUID",
   "type": "esriFieldTypeGUID",
   "alias": "Asset GUID",
   "length": 38,
   "domain": null
  },
  {
   "name": "TIMEOPENED",
   "type": "esriFieldTypeDate",
   "alias": "Time Opened",
   "length": 8,
   "domain": null
  },
  {
   "name": "TIMECLOSED",
   "type": "esriFieldTypeDate",
   "alias": "Closed Color",
   "length": 8,
   "domain": null
  },
  {
   "name": "TIMETOCLEAR",
   "type": "esriFieldTypeInteger",
   "alias": "Time to Clear",
   "domain": null
  },
  {
   "name": "REMARKS",
   "type": "esriFieldTypeString",
   "alias": "Remarks",
   "length": 255,
   "domain": null
  },
  {
   "name": "INSPECTNUM",
   "type": "esriFieldTypeString",
   "alias": "Inspection Number",
   "length": 255,
   "domain": null
  },
  {
   "name": "FLUSHYEAR",
   "type": "esriFieldTypeString",
   "alias": "Flushing Year",
   "length": 255,
   "domain": null
  },
  {
   "name": "ACTIONREQUIRED",
   "type": "esriFieldTypeString",
   "alias": "Maintenance Action Required",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "RECOMMENDEDACTION",
   "type": "esriFieldTypeString",
   "alias": "Recommended Action",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "FlushRecommendedAction",
    "description": "Recommended Action",
    "codedValues": [
     {
      "name": "Paved Over",
      "code": "Paved Over"
     },
     {
      "name": "Under Vehicle",
      "code": "Under Vehicle"
     },
     {
      "name": "Under Leaf Pile",
      "code": "Under Leaf Pile"
     },
     {
      "name": "Repair",
      "code": "Repair"
     },
     {
      "name": "Replace",
      "code": "Replace"
     },
     {
      "name": "Maintenance",
      "code": "Maintenance"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ROUTENUM",
   "type": "esriFieldTypeString",
   "alias": "Route #",
   "length": 255,
   "domain": null
  },
  {
   "name": "CLOSEDCOLOR",
   "type": "esriFieldTypeString",
   "alias": "Closed Color",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "wColor",
    "description": "Color of Water during and after flush",
    "codedValues": [
     {
      "name": "CLEAR",
      "code": "CLEAR"
     },
     {
      "name": "YELLOW",
      "code": "YELLOW"
     },
     {
      "name": "BROWN",
      "code": "BROWN"
     },
     {
      "name": "RED",
      "code": "RED"
     },
     {
      "name": "BLACK",
      "code": "BLACK"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "OPENEDCOLOR",
   "type": "esriFieldTypeString",
   "alias": "Opened Color",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "wColor",
    "description": "Color of Water during and after flush",
    "codedValues": [
     {
      "name": "CLEAR",
      "code": "CLEAR"
     },
     {
      "name": "YELLOW",
      "code": "YELLOW"
     },
     {
      "name": "BROWN",
      "code": "BROWN"
     },
     {
      "name": "RED",
      "code": "RED"
     },
     {
      "name": "BLACK",
      "code": "BLACK"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "GALLONSUSED",
   "type": "esriFieldTypeInteger",
   "alias": "Gallons Used",
   "domain": null
  },
  {
   "name": "HYDASSETID",
   "type": "esriFieldTypeInteger",
   "alias": "Hydrant Asset ID",
   "domain": null
  },
  {
   "name": "FLUSHCOMPLETE",
   "type": "esriFieldTypeString",
   "alias": "Flushing Complete",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  }
 ],
 "indexes": [
  {
   "name": "R149_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_149",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_725_ASSETGUI",
   "fields": "ASSETGUID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_149",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "RVGIS01.RVGIS_OWNER.wHydrant",
   "relatedTableId": 4,
   "role": "esriRelRoleDestination",
   "keyField": "ASSETGUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "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
 },
 "serviceItemId": "59bcbf9ac12c482aaa598cb1159187fc"
}