{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 6,
 "name": "BFPDevices",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "ASSETID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "ASSETID",
   "type": "esriFieldTypeString",
   "alias": "ASSETID",
   "length": 50,
   "domain": null
  },
  {
   "name": "MANUFACTURER",
   "type": "esriFieldTypeString",
   "alias": "MANUFACTURER",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wBackflowManufacturer",
    "description": "Backflow device manufacturer",
    "codedValues": [
     {
      "name": "Ameco",
      "code": "Ameco"
     },
     {
      "name": "Ames",
      "code": "Ames"
     },
     {
      "name": "Apollo",
      "code": "Apollo"
     },
     {
      "name": "Apollo Conbraco",
      "code": "Apollo Conbraco"
     },
     {
      "name": "Colt",
      "code": "Colt"
     },
     {
      "name": "Conbraco",
      "code": "Conbraco"
     },
     {
      "name": "Febco",
      "code": "Febco"
     },
     {
      "name": "Hershey",
      "code": "Hershey"
     },
     {
      "name": "Hershey Beeco",
      "code": "Hershey Beeco"
     },
     {
      "name": "Kennedy",
      "code": "Kennedy"
     },
     {
      "name": "Nibco",
      "code": "Nibco"
     },
     {
      "name": "Viking",
      "code": "Viking"
     },
     {
      "name": "Watts",
      "code": "Watts"
     },
     {
      "name": "Wilkins",
      "code": "Wilkins"
     },
     {
      "name": "Wilkins Zurn",
      "code": "Wilkins Zurn"
     },
     {
      "name": "Zurn",
      "code": "Zurn"
     },
     {
      "name": "Flomatic",
      "code": "Flomatic"
     },
     {
      "name": "AMRS",
      "code": "AMRS"
     },
     {
      "name": "Toro",
      "code": "Toro"
     },
     {
      "name": "Derringer",
      "code": "Derringer"
     },
     {
      "name": "ARI",
      "code": "ARI"
     },
     {
      "name": "Globe",
      "code": "Globe"
     },
     {
      "name": "Cash Acme",
      "code": "Cash Acme"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Kennedy Beeco",
      "code": "Kennedy Beeco"
     },
     {
      "name": "Liberty Pumps",
      "code": "Liberty Pumps"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "TYPE",
   "type": "esriFieldTypeString",
   "alias": "TYPE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wBackflowType",
    "description": "Backflow prevention device type",
    "codedValues": [
     {
      "name": "AVB",
      "code": "AVB"
     },
     {
      "name": "CV",
      "code": "CV"
     },
     {
      "name": "DBC",
      "code": "DBC"
     },
     {
      "name": "DBCV",
      "code": "DBCV"
     },
     {
      "name": "DC",
      "code": "DC"
     },
     {
      "name": "DCA",
      "code": "DCA"
     },
     {
      "name": "DCDA",
      "code": "DCDA"
     },
     {
      "name": "DCU",
      "code": "DCU"
     },
     {
      "name": "DCV",
      "code": "DCV"
     },
     {
      "name": "DCVA",
      "code": "DCVA"
     },
     {
      "name": "DDCV",
      "code": "DDCV"
     },
     {
      "name": "DetChk",
      "code": "DetChk"
     },
     {
      "name": "PVB",
      "code": "PVB"
     },
     {
      "name": "RP",
      "code": "RP"
     },
     {
      "name": "PR2",
      "code": "RP2"
     },
     {
      "name": "RP4A",
      "code": "RP4A"
     },
     {
      "name": "RPBA",
      "code": "RPBA"
     },
     {
      "name": "RPBP",
      "code": "RPBP"
     },
     {
      "name": "RPDA",
      "code": "RPDA"
     },
     {
      "name": "RPP",
      "code": "RPP"
     },
     {
      "name": "RPZ",
      "code": "RPZ"
     },
     {
      "name": "SCV",
      "code": "SCV"
     },
     {
      "name": "SVB",
      "code": "SVB"
     },
     {
      "name": "VB",
      "code": "VB"
     },
     {
      "name": "Double Check",
      "code": "DbCk"
     },
     {
      "name": "RPA",
      "code": "RPA"
     },
     {
      "name": "DCDV",
      "code": "DCDV"
     },
     {
      "name": "SRVB",
      "code": "SRVB"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "MODEL",
   "type": "esriFieldTypeString",
   "alias": "MODEL",
   "length": 50,
   "domain": null
  },
  {
   "name": "SIZE",
   "type": "esriFieldTypeString",
   "alias": "SIZE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wBacflowSize",
    "description": "Backflow device size",
    "codedValues": [
     {
      "name": "0.5",
      "code": "0.5"
     },
     {
      "name": "0.75",
      "code": "0.75"
     },
     {
      "name": "1.0",
      "code": "1.0"
     },
     {
      "name": "1.25",
      "code": "1.25"
     },
     {
      "name": "1.5",
      "code": "1.5"
     },
     {
      "name": "1.75",
      "code": "1.75"
     },
     {
      "name": "2.0",
      "code": "2.0"
     },
     {
      "name": "2.5",
      "code": "2.5"
     },
     {
      "name": "3.0",
      "code": "3.0"
     },
     {
      "name": "4.0",
      "code": "4.0"
     },
     {
      "name": "5.0",
      "code": "5.0"
     },
     {
      "name": "6.0",
      "code": "6.0"
     },
     {
      "name": "8.0",
      "code": "8.0"
     },
     {
      "name": "10.0",
      "code": "10.0"
     },
     {
      "name": "7.0",
      "code": "7.0"
     },
     {
      "name": "12.0",
      "code": "12.0"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "LOCATION",
   "length": 250,
   "domain": null
  },
  {
   "name": "DEVICERISKLEVEL",
   "type": "esriFieldTypeString",
   "alias": "DEVICERISKLEVEL",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wBackflowRiskLevel",
    "description": "Risk Level of backflow device",
    "codedValues": [
     {
      "name": "Residential",
      "code": "Res"
     },
     {
      "name": "Commercial",
      "code": "Com"
     },
     {
      "name": "High",
      "code": "High"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DEVICEFUNCTION",
   "type": "esriFieldTypeString",
   "alias": "DEVICEFUNCTION",
   "length": 100,
   "domain": null
  },
  {
   "name": "STATUS",
   "type": "esriFieldTypeString",
   "alias": "STATUS",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wBackflowStatus",
    "description": "Backflow device status",
    "codedValues": [
     {
      "name": "In Service",
      "code": "In Service"
     },
     {
      "name": "Inactive",
      "code": "Inactive"
     },
     {
      "name": "Inactive/Closed",
      "code": "InactiveClosed"
     },
     {
      "name": "NonTestable",
      "code": "NonTestable"
     },
     {
      "name": "Out of Service",
      "code": "OutofService"
     },
     {
      "name": "Removed",
      "code": "Removed"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DATECREATED",
   "type": "esriFieldTypeDate",
   "alias": "DATECREATED",
   "length": 8,
   "domain": null
  },
  {
   "name": "SITEIDTEXT",
   "type": "esriFieldTypeString",
   "alias": "SITEIDTEXT",
   "length": 20,
   "domain": null
  },
  {
   "name": "DateLastInspected",
   "type": "esriFieldTypeDate",
   "alias": "DateLastInspected",
   "length": 8,
   "domain": null
  },
  {
   "name": "UMAssetTagNumber",
   "type": "esriFieldTypeString",
   "alias": "UMAssetTagNumber",
   "length": 50,
   "domain": null
  },
  {
   "name": "UMMaintenanceRegion",
   "type": "esriFieldTypeString",
   "alias": "UMMaintenanceRegion",
   "length": 50,
   "domain": null
  },
  {
   "name": "DateLastTested",
   "type": "esriFieldTypeDate",
   "alias": "DateLastTested",
   "length": 8,
   "domain": null
  },
  {
   "name": "CREATEDUSER",
   "type": "esriFieldTypeString",
   "alias": "CREATEDUSER",
   "length": 50,
   "domain": null
  },
  {
   "name": "DATEMODIFIED",
   "type": "esriFieldTypeDate",
   "alias": "DATEMODIFIED",
   "length": 8,
   "domain": null
  },
  {
   "name": "MODIFIEDUSER",
   "type": "esriFieldTypeString",
   "alias": "MODIFIEDUSER",
   "length": 50,
   "domain": null
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "COMMENTS",
   "length": 500,
   "domain": null
  },
  {
   "name": "PROTECTSTREATEDSYSTEM",
   "type": "esriFieldTypeString",
   "alias": "PROTECTSTREATEDSYSTEM",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "Yes_No_Text",
    "description": "Yes or No question",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  }
 ],
 "indexes": [
  {
   "name": "R2360_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_17726_SITEID_1",
   "fields": "SITEIDTEXT",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "BFPLocations",
   "relatedTableId": 5,
   "role": "esriRelRoleDestination",
   "keyField": "SITEIDTEXT",
   "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": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1581322161000
 }
}