{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 24,
 "name": "Water Backflow Prevention Device",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": true,
 "relationships": [
  {
   "id": 1,
   "name": "Addresses",
   "relatedTableId": 2,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "ADDRESSFACID",
   "composite": false
  }
 ],
 "isDataVersioned": true,
 "isDataArchived": false,
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsQueryAttachments": true,
  "supportsQueryAttachmentsWithReturnUrl": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true
 },
 "hasMetadata": true,
 "hasAttachments": true,
 "supportsAttachmentsByUploadId": true,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "GlobalID",
 "displayField": "ASSETID",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "ASSETID",
   "type": "esriFieldTypeString",
   "alias": "ASSETID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "ASSETID"
  },
  {
   "name": "BACKFLOWID",
   "type": "esriFieldTypeString",
   "alias": "BACKFLOWID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "BACKFLOWID"
  },
  {
   "name": "MANUFACTURER",
   "type": "esriFieldTypeString",
   "alias": "MANUFACTURER",
   "domain": {
    "type": "codedValue",
    "name": "wBackflowManu",
    "description": "",
    "codedValues": [
     {
      "name": "Ames",
      "code": "Ames"
     },
     {
      "name": "Buckner",
      "code": "Buckner"
     },
     {
      "name": "Cla-Val",
      "code": "Cla-Val"
     },
     {
      "name": "Conbraco",
      "code": "Conbraco"
     },
     {
      "name": "Febco",
      "code": "Febco"
     },
     {
      "name": "Flomatic",
      "code": "Flomatic"
     },
     {
      "name": "Hersey",
      "code": "Hersey"
     },
     {
      "name": "Kennedy",
      "code": "Kennedy"
     },
     {
      "name": "Mueller",
      "code": "Mueller"
     },
     {
      "name": "Orion",
      "code": "Orion"
     },
     {
      "name": "PVB",
      "code": "PVB"
     },
     {
      "name": "Rainbird",
      "code": "Rainbird"
     },
     {
      "name": "Toro",
      "code": "Toro"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     },
     {
      "name": "Viking",
      "code": "Viking"
     },
     {
      "name": "Watts",
      "code": "Watts"
     },
     {
      "name": "Wilkins",
      "code": "Wilkins"
     },
     {
      "name": "Maxim",
      "code": "Maxim"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "MANUFACTURER"
  },
  {
   "name": "INSTALLDATE",
   "type": "esriFieldTypeDate",
   "alias": "INSTALLDATE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "INSTALLDATE"
  },
  {
   "name": "MODEL_NO",
   "type": "esriFieldTypeString",
   "alias": "MODEL_NO",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "MODEL_NO"
  },
  {
   "name": "SERIAL_NO",
   "type": "esriFieldTypeString",
   "alias": "SERIAL_NO",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "SERIAL_NO"
  },
  {
   "name": "DEVICE_TYPE",
   "type": "esriFieldTypeString",
   "alias": "DEVICE_TYPE",
   "domain": {
    "type": "codedValue",
    "name": "wBackflowDeviceType",
    "description": "",
    "codedValues": [
     {
      "name": "DCDA",
      "code": "DCDA"
     },
     {
      "name": "DCV",
      "code": "DCV"
     },
     {
      "name": "PVB",
      "code": "PVB"
     },
     {
      "name": "RPA",
      "code": "RPA"
     },
     {
      "name": "RPDA",
      "code": "RPDA"
     },
     {
      "name": "SVB",
      "code": "SVB"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 25,
   "defaultValue": null,
   "modelName": "DEVICE_TYPE"
  },
  {
   "name": "SIZE_INCHES",
   "type": "esriFieldTypeString",
   "alias": "SIZE_INCHES",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "SIZE_INCHES"
  },
  {
   "name": "NEXT_TEST",
   "type": "esriFieldTypeDate",
   "alias": "NEXT_TEST",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "NEXT_TEST"
  },
  {
   "name": "STATUS",
   "type": "esriFieldTypeString",
   "alias": "STATUS",
   "domain": {
    "type": "codedValue",
    "name": "wBackflowStatus",
    "description": "",
    "codedValues": [
     {
      "name": "New Device",
      "code": "New Device"
     },
     {
      "name": "Device Tested",
      "code": "Device Tested"
     },
     {
      "name": "Device Rebuilt",
      "code": "Device Rebuilt"
     },
     {
      "name": "First Notification Sent",
      "code": "First Notification"
     },
     {
      "name": "Second Notification Sent",
      "code": "Second Notification"
     },
     {
      "name": "Third Notification Sent",
      "code": "Third Notification"
     },
     {
      "name": "Disconnect",
      "code": "Disconnect"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 25,
   "defaultValue": null,
   "modelName": "STATUS"
  },
  {
   "name": "INSTALLATION_TYPE",
   "type": "esriFieldTypeString",
   "alias": "INSTALLATION_TYPE",
   "domain": {
    "type": "codedValue",
    "name": "wBackflowInstType",
    "description": "",
    "codedValues": [
     {
      "name": "Construction Water",
      "code": "Construction Water"
     },
     {
      "name": "Domestic",
      "code": "Domestic"
     },
     {
      "name": "Fire Service",
      "code": "Fire Service"
     },
     {
      "name": "Irrigation",
      "code": "Irrigation"
     },
     {
      "name": "Private Loop",
      "code": "Private Loop"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "INSTALLATION_TYPE"
  },
  {
   "name": "ADDRESSFACID",
   "type": "esriFieldTypeString",
   "alias": "ADDRESSFACID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ADDRESSFACID"
  },
  {
   "name": "LEVELOFHAZARD",
   "type": "esriFieldTypeString",
   "alias": "LEVELOFHAZARD",
   "domain": {
    "type": "codedValue",
    "name": "wHazardLevel",
    "description": "Level of Hazard/Risk for Backflow",
    "codedValues": [
     {
      "name": "High Hazard",
      "code": "High"
     },
     {
      "name": "Medium Hazard",
      "code": "Medium"
     },
     {
      "name": "Low Hazard",
      "code": "Low"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "LEVELOFHAZARD"
  },
  {
   "name": "OWNER",
   "type": "esriFieldTypeString",
   "alias": "OWNER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "OWNER"
  },
  {
   "name": "MAILING_ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "MAILING_ADDRESS",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 75,
   "defaultValue": null,
   "modelName": "MAILING_ADDRESS"
  },
  {
   "name": "TESTING_FREQUENCY",
   "type": "esriFieldTypeString",
   "alias": "TESTING_FREQUENCY",
   "domain": {
    "type": "codedValue",
    "name": "wTestingFrequency",
    "description": "",
    "codedValues": [
     {
      "name": "Annually",
      "code": "Annual"
     },
     {
      "name": "Quarterly",
      "code": "Quarter"
     },
     {
      "name": "Monthly",
      "code": "Month"
     },
     {
      "name": "Weekly",
      "code": "Week"
     },
     {
      "name": "Biannually",
      "code": "BiAnnual"
     },
     {
      "name": "Every Two Years",
      "code": "Two Year"
     },
     {
      "name": "Every Three Years",
      "code": "Three Year"
     },
     {
      "name": "Every Four Years",
      "code": "Four Year"
     },
     {
      "name": "Every Five Years",
      "code": "Five Year"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "TESTING_FREQUENCY"
  },
  {
   "name": "InspCondition",
   "type": "esriFieldTypeSmallInteger",
   "alias": "InspCondition",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "InspCondition"
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "length": 38,
   "defaultValue": null,
   "modelName": "GlobalID"
  }
 ],
 "indexes": [
  {
   "name": "R41_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_41",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G344ADDRESSFACID",
   "fields": "ADDRESSFACID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_41",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "Water Backflow Prevention Device",
   "description": "",
   "prototype": {
    "attributes": {
     "InspCondition": null,
     "TESTING_FREQUENCY": null,
     "ASSETID": null,
     "BACKFLOWID": null,
     "MANUFACTURER": null,
     "INSTALLDATE": null,
     "MODEL_NO": null,
     "SERIAL_NO": null,
     "DEVICE_TYPE": null,
     "SIZE_INCHES": null,
     "NEXT_TEST": null,
     "STATUS": null,
     "INSTALLATION_TYPE": null,
     "ADDRESSFACID": null,
     "LEVELOFHAZARD": null,
     "OWNER": null,
     "MAILING_ADDRESS": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb",
 "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
 "useStandardizedQueries": true,
 "attachmentProperties": [
  {
   "name": "id",
   "fieldName": "ATTACHMENTID",
   "isEnabled": true
  },
  {
   "name": "globalId",
   "fieldName": "GlobalID",
   "isEnabled": true
  },
  {
   "name": "name",
   "fieldName": "ATT_NAME",
   "isEnabled": true
  },
  {
   "name": "size",
   "fieldName": "DATA_SIZE",
   "isEnabled": true
  },
  {
   "name": "contentType",
   "fieldName": "CONTENT_TYPE",
   "isEnabled": true
  },
  {
   "name": "keywords",
   "fieldName": "KEYWORDS",
   "isEnabled": false
  },
  {
   "name": "exifInfo",
   "fieldName": "EXIFINFO",
   "isEnabled": false
  }
 ],
 "attachmentFields": [
  {
   "name": "ATTACHMENTID",
   "type": "esriFieldTypeOID",
   "alias": "ATTACHMENTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "length": 38,
   "defaultValue": null
  },
  {
   "name": "ATT_NAME",
   "type": "esriFieldTypeString",
   "alias": "ATT_NAME",
   "domain": null,
   "editable": true,
   "nullable": false,
   "length": 250,
   "defaultValue": null
  },
  {
   "name": "DATA_SIZE",
   "type": "esriFieldTypeInteger",
   "alias": "DATA_SIZE",
   "domain": null,
   "editable": true,
   "nullable": false,
   "defaultValue": null
  },
  {
   "name": "CONTENT_TYPE",
   "type": "esriFieldTypeString",
   "alias": "CONTENT_TYPE",
   "domain": null,
   "editable": true,
   "nullable": false,
   "length": 150,
   "defaultValue": null
  }
 ],
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "af808476e3cc4bd3b8e6fa163939039e"
}