{
 "layers": [
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 0,
   "name": "BackflowDevice",
   "type": "Feature Layer",
   "parentLayer": null,
   "defaultVisibility": true,
   "minScale": 0,
   "maxScale": 0,
   "canScaleSymbols": false,
   "geometryType": "esriGeometryPoint",
   "description": "",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user",
    "dateFieldsTimeReference": {
     "timeZone": "UTC",
     "timeZoneIANA": "Etc/UTC",
     "respectsDaylightSaving": false
    }
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": true,
   "relationships": [
    {
     "id": 0,
     "name": "Tasks",
     "relatedTableId": 4,
     "cardinality": "esriRelCardinalityOneToMany",
     "role": "esriRelRoleOrigin",
     "keyField": "GlobalID",
     "composite": false,
     "catalogID": "{2F2ED927-7CD0-40A7-8ACE-FC33E5E77B97}"
    },
    {
     "id": 2,
     "name": "Testing",
     "relatedTableId": 3,
     "cardinality": "esriRelCardinalityOneToMany",
     "role": "esriRelRoleOrigin",
     "keyField": "GlobalID",
     "composite": false,
     "catalogID": "{90226C49-5FE5-47FE-B975-496B291D0EF0}"
    },
    {
     "id": 1,
     "name": "Inspections",
     "relatedTableId": 2,
     "cardinality": "esriRelCardinalityOneToMany",
     "role": "esriRelRoleOrigin",
     "keyField": "GlobalID",
     "composite": false,
     "catalogID": "{E49207CF-B7E8-40C0-ABBE-DE005A1B9823}"
    }
   ],
   "isDataVersioned": true,
   "isDataArchived": true,
   "infoInEstimates": [
    "extent",
    "count"
   ],
   "isDataBranchVersioned": true,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "supportsRollbackOnFailureParameter": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": true,
    "startArchivingMoment": 1786966322000
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": true,
   "supportsQuantizationEditMode": true,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "supportsDatumTransformation": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": false,
    "supportsQueryWithCacheHint": false
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "extent": {
    "xmin": 1567621.5752613842,
    "ymin": 7195327.029048473,
    "xmax": 1612308.6404146403,
    "ymax": 7238772.815516308,
    "zmin": 0,
    "zmax": 0,
    "spatialReference": {
     "wkid": 102743,
     "latestWkid": 3566,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -119796900,
     "falseY": -89212200,
     "xyUnits": 3048.0060960121928,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "spatialReference": {
    "wkid": 102743,
    "latestWkid": 3566,
    "xyTolerance": 0.003280833333333333,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -119796900,
    "falseY": -89212200,
    "xyUnits": 3048.0060960121928,
    "falseZ": -100000,
    "zUnits": 10000,
    "falseM": -100000,
    "mUnits": 10000
   },
   "sourceSpatialReference": {
    "wkid": 102743,
    "latestWkid": 3566,
    "xyTolerance": 0.003280833333333333,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -119796900,
    "falseY": -89212200,
    "xyUnits": 3048.0060960121928,
    "falseZ": -100000,
    "zUnits": 10000,
    "falseM": 0,
    "mUnits": 1
   },
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSMS",
      "style": "esriSMSCircle",
      "color": [
       150,
       131,
       45,
       255
      ],
      "size": 4,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0,
      "outline": {
       "color": [
        0,
        0,
        0,
        255
       ],
       "width": 0.7
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "hasM": false,
   "hasZ": true,
   "enableZDefaults": false,
   "supportsVCSProjection": true,
   "allowGeometryUpdates": true,
   "allowTrueCurvesUpdates": true,
   "onlyAllowTrueCurveUpdatesByTrueCurveClients": true,
   "hasAttachments": false,
   "supportsApplyEditsWithGlobalIds": true,
   "supportsOidReservation": true,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "device_type",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "parcel_id",
     "type": "esriFieldTypeGUID",
     "alias": "Parcel ID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "parcel_id"
    },
    {
     "name": "device_type",
     "type": "esriFieldTypeString",
     "alias": "Device Type",
     "domain": {
      "type": "codedValue",
      "name": "device_type",
      "description": "Type of backflow prevention device",
      "codedValues": [
       {
        "name": "RP",
        "code": "RP"
       },
       {
        "name": "DCVA",
        "code": "DCVA"
       },
       {
        "name": "PVB",
        "code": "PVB"
       },
       {
        "name": "RPDA",
        "code": "RPDA"
       },
       {
        "name": "DCDA",
        "code": "DCDA"
       },
       {
        "name": "SVB",
        "code": "SVB"
       },
       {
        "name": "AirGap",
        "code": "AirGap"
       },
       {
        "name": "DC",
        "code": "DC"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "device_type"
    },
    {
     "name": "device_size_in_inches",
     "type": "esriFieldTypeString",
     "alias": "Size (inches)",
     "domain": {
      "type": "codedValue",
      "name": "Size_in_inches",
      "description": "Device size in inches",
      "codedValues": [
       {
        "name": "0.5\"",
        "code": "0.5"
       },
       {
        "name": "0.75\"",
        "code": "0.75"
       },
       {
        "name": "1.0\"",
        "code": "1.0"
       },
       {
        "name": "1.5\"",
        "code": "1.5"
       },
       {
        "name": "1.75\"",
        "code": "1.75"
       },
       {
        "name": "2\"",
        "code": "2"
       },
       {
        "name": "3\"",
        "code": "3"
       },
       {
        "name": "4\"",
        "code": "4"
       },
       {
        "name": "6\"",
        "code": "6"
       },
       {
        "name": "8\"",
        "code": "8"
       },
       {
        "name": "10\"",
        "code": "10"
       },
       {
        "name": "12\"",
        "code": "12"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "device_size_in_inches"
    },
    {
     "name": "manufacturer",
     "type": "esriFieldTypeString",
     "alias": "Manufacturer",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "manufacturer"
    },
    {
     "name": "device_model",
     "type": "esriFieldTypeString",
     "alias": "Model",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 100,
     "defaultValue": null,
     "modelName": "device_model"
    },
    {
     "name": "serial_number",
     "type": "esriFieldTypeString",
     "alias": "Serial Number",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 100,
     "defaultValue": null,
     "modelName": "serial_number"
    },
    {
     "name": "install_date",
     "type": "esriFieldTypeDate",
     "alias": "Installation Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "install_date"
    },
    {
     "name": "status",
     "type": "esriFieldTypeString",
     "alias": "Status",
     "domain": {
      "type": "codedValue",
      "name": "Status_Device",
      "description": "BackflowDevice_status",
      "codedValues": [
       {
        "name": "Past Due",
        "code": "Past Due"
       },
       {
        "name": "Current",
        "code": "Current"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 20,
     "defaultValue": null,
     "modelName": "status"
    },
    {
     "name": "notes",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 1000,
     "defaultValue": null,
     "modelName": "notes"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user",
     "required": true
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date",
     "required": true
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user",
     "required": true
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date",
     "required": true
    },
    {
     "name": "Customer",
     "type": "esriFieldTypeString",
     "alias": "Customer",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Customer"
    },
    {
     "name": "Address",
     "type": "esriFieldTypeString",
     "alias": "Address",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Address"
    },
    {
     "name": "Hazard_Level",
     "type": "esriFieldTypeString",
     "alias": "Hazard Level",
     "domain": {
      "type": "codedValue",
      "name": "HazardLevel",
      "description": "Hazard Level for device/customer failing",
      "codedValues": [
       {
        "name": "Low",
        "code": "Low"
       },
       {
        "name": "Medium",
        "code": "Medium"
       },
       {
        "name": "High",
        "code": "High"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 100,
     "defaultValue": null,
     "modelName": "Hazard_Level"
    },
    {
     "name": "Category",
     "type": "esriFieldTypeString",
     "alias": "Category",
     "domain": {
      "type": "codedValue",
      "name": "CategoryType",
      "description": "Categories for Backflow Device",
      "codedValues": [
       {
        "name": "Boiler",
        "code": "Boiler"
       },
       {
        "name": "Chill Water",
        "code": "Chill Water"
       },
       {
        "name": "Cleaning",
        "code": "Cleaning"
       },
       {
        "name": "Cooling Tower",
        "code": "Cooling Tower"
       },
       {
        "name": "Domestic",
        "code": "Domestic"
       },
       {
        "name": "Fire Protection",
        "code": "Fire Protection"
       },
       {
        "name": "Irrigation",
        "code": "Irrigation"
       },
       {
        "name": "Other",
        "code": "Other"
       },
       {
        "name": "Process Water",
        "code": "Process Water"
       },
       {
        "name": "Unclassified Water Use",
        "code": "Unclassified Water Use"
       },
       {
        "name": "Water Softener/Purifier",
        "code": "Water Softener/Purifier"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Category"
    },
    {
     "name": "Protection_Type",
     "type": "esriFieldTypeString",
     "alias": "Protection Type",
     "domain": {
      "type": "codedValue",
      "name": "ProtectionType",
      "description": "Protection types for backflow device",
      "codedValues": [
       {
        "name": "Containment",
        "code": "Containment"
       },
       {
        "name": "Isolation",
        "code": "Isolation"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Protection_Type"
    },
    {
     "name": "Assembly_Location",
     "type": "esriFieldTypeString",
     "alias": "Assembly Location",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 1000,
     "defaultValue": null,
     "modelName": "Assembly_Location"
    },
    {
     "name": "LastTester",
     "type": "esriFieldTypeString",
     "alias": "Last Tester",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "LastTester"
    },
    {
     "name": "In_Compliance",
     "type": "esriFieldTypeString",
     "alias": "In Compliance",
     "domain": {
      "type": "codedValue",
      "name": "YesNo",
      "description": "Yes or No",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "In_Compliance"
    },
    {
     "name": "Active",
     "type": "esriFieldTypeString",
     "alias": "Active",
     "domain": {
      "type": "codedValue",
      "name": "YesNo",
      "description": "Yes or No",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "Active"
    },
    {
     "name": "GroupID",
     "type": "esriFieldTypeString",
     "alias": "Group ID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "GroupID"
    },
    {
     "name": "CustomerRGID",
     "type": "esriFieldTypeGUID",
     "alias": "CustomerRGID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "CustomerRGID"
    },
    {
     "name": "AccountNumber",
     "type": "esriFieldTypeString",
     "alias": "Account Number",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "AccountNumber"
    },
    {
     "name": "LastInspectionDate",
     "type": "esriFieldTypeDate",
     "alias": "Last Inspection Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "LastInspectionDate"
    },
    {
     "name": "LastInspectedBy",
     "type": "esriFieldTypeString",
     "alias": "Last Inspected By",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "LastInspectedBy"
    },
    {
     "name": "InspectionPassFail",
     "type": "esriFieldTypeString",
     "alias": "InspectionPassFail",
     "domain": {
      "type": "codedValue",
      "name": "PassFail",
      "description": "Test pass or fail result",
      "codedValues": [
       {
        "name": "Pass",
        "code": "Pass"
       },
       {
        "name": "Fail",
        "code": "Fail"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "InspectionPassFail"
    },
    {
     "name": "TestPassFail",
     "type": "esriFieldTypeString",
     "alias": "TestPassFail",
     "domain": {
      "type": "codedValue",
      "name": "PassFail",
      "description": "Test pass or fail result",
      "codedValues": [
       {
        "name": "Pass",
        "code": "Pass"
       },
       {
        "name": "Fail",
        "code": "Fail"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "TestPassFail"
    },
    {
     "name": "Last_Rebuild_Date",
     "type": "esriFieldTypeDate",
     "alias": "Last Rebuild Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "Last_Rebuild_Date"
    },
    {
     "name": "Recurring_Test_Due_Date",
     "type": "esriFieldTypeDate",
     "alias": "Recurring Test Due Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "Recurring_Test_Due_Date"
    },
    {
     "name": "Last_Test_Date",
     "type": "esriFieldTypeDate",
     "alias": "Last Test Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "Last_Test_Date"
    },
    {
     "name": "TaskAssignedTo",
     "type": "esriFieldTypeString",
     "alias": "TaskAssignedTo",
     "domain": {
      "type": "codedValue",
      "name": "AssignedTo",
      "description": "List of city employees to assign to tasks",
      "codedValues": [
       {
        "name": "Nick Morris",
        "code": "Nick Morris"
       },
       {
        "name": "Joseph Meza",
        "code": "Joseph Meza"
       },
       {
        "name": "John Waters",
        "code": "John Waters"
       },
       {
        "name": "Paul Taylor",
        "code": "Paul Taylor"
       },
       {
        "name": "Melissa Smith",
        "code": "Melissa Smith"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "TaskAssignedTo"
    },
    {
     "name": "Testable",
     "type": "esriFieldTypeString",
     "alias": "Testable",
     "domain": {
      "type": "codedValue",
      "name": "YesNo",
      "description": "Yes or No",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "Testable"
    },
    {
     "name": "CustomerOwnerName",
     "type": "esriFieldTypeString",
     "alias": "Customer Owner Name",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "CustomerOwnerName"
    },
    {
     "name": "CustomerEmail",
     "type": "esriFieldTypeString",
     "alias": "Customer Email",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "CustomerEmail"
    },
    {
     "name": "CustomerPhone",
     "type": "esriFieldTypeString",
     "alias": "Customer Phone Number",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "CustomerPhone"
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape",
    "domain": null,
    "editable": true,
    "nullable": true,
    "defaultValue": null,
    "modelName": "Shape"
   },
   "indexes": [
    {
     "name": "UUID_47",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "GlobalID,OBJECTID"
    },
    {
     "name": "G119CustomerRGID",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "CustomerRGID"
    },
    {
     "name": "I119AccountNumber",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "AccountNumber"
    },
    {
     "name": "S9_idx",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "Shape"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "Mountain Standard Time",
    "timeZoneIANA": "America/Denver",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": {
    "timeZone": "Mountain Standard Time",
    "timeZoneIANA": "America/Denver",
    "respectsDaylightSaving": true
   },
   "types": [],
   "templates": [
    {
     "name": "BackflowDevice",
     "description": "",
     "prototype": {
      "attributes": {
       "CustomerEmail": null,
       "CustomerOwnerName": null,
       "parcel_id": null,
       "device_type": null,
       "device_size_in_inches": null,
       "manufacturer": null,
       "device_model": null,
       "serial_number": null,
       "install_date": null,
       "status": null,
       "notes": null,
       "CustomerPhone": null,
       "Testable": null,
       "TaskAssignedTo": null,
       "Last_Test_Date": null,
       "Recurring_Test_Due_Date": null,
       "Customer": null,
       "Address": null,
       "Hazard_Level": null,
       "Category": null,
       "Protection_Type": null,
       "Assembly_Location": null,
       "LastTester": null,
       "In_Compliance": null,
       "Active": null,
       "GroupID": null,
       "CustomerRGID": null,
       "AccountNumber": null,
       "LastInspectionDate": null,
       "LastInspectedBy": null,
       "InspectionPassFail": null,
       "TestPassFail": null,
       "Last_Rebuild_Date": null
      }
     },
     "drawingTool": "esriFeatureEditToolPoint"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": true,
   "supportedSpatialRelationships": [
    "esriSpatialRelIntersects",
    "esriSpatialRelContains",
    "esriSpatialRelCrosses",
    "esriSpatialRelEnvelopeIntersects",
    "esriSpatialRelIndexIntersects",
    "esriSpatialRelOverlaps",
    "esriSpatialRelTouches",
    "esriSpatialRelWithin",
    "esriSpatialRelRelation"
   ],
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 8000,
   "standardMaxRecordCountNoGeometry": 32000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "907657e3a3434ba2bceac3f508cfe234"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 2,
   "name": "Inspections",
   "type": "Table",
   "description": "",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user",
    "dateFieldsTimeReference": {
     "timeZone": "UTC",
     "timeZoneIANA": "Etc/UTC",
     "respectsDaylightSaving": false
    }
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": true,
   "relationships": [
    {
     "id": 1,
     "name": "BackflowDevice",
     "relatedTableId": 0,
     "cardinality": "esriRelCardinalityOneToMany",
     "role": "esriRelRoleDestination",
     "keyField": "DeviceGUID",
     "composite": false,
     "catalogID": "{E49207CF-B7E8-40C0-ABBE-DE005A1B9823}"
    }
   ],
   "isDataVersioned": true,
   "isDataArchived": true,
   "infoInEstimates": [
    "count"
   ],
   "isDataBranchVersioned": true,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "supportsRollbackOnFailureParameter": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": true,
    "startArchivingMoment": 1786966313000
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": false,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryAttachments": true,
    "supportsQueryAttachmentsWithReturnUrl": true,
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": false,
    "supportsQueryWithCacheHint": false
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "hasAttachments": true,
   "supportsAttachmentsByUploadId": true,
   "supportsAttachmentsResizing": true,
   "supportsApplyEditsWithGlobalIds": true,
   "supportsOidReservation": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "inspector_name",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "name": "InspectionType",
     "type": "esriFieldTypeString",
     "alias": "Inspection Type",
     "domain": {
      "type": "codedValue",
      "name": "InspectionType",
      "description": "Type of city inspection activity",
      "codedValues": [
       {
        "name": "Shell",
        "code": "Shell"
       },
       {
        "name": "Occupancy",
        "code": "Occupancy"
       },
       {
        "name": "Annual",
        "code": "Annual"
       },
       {
        "name": "City-Initiated",
        "code": "CityInitiated"
       },
       {
        "name": "Follow-Up",
        "code": "FollowUp"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "InspectionType"
    },
    {
     "name": "DateInspected",
     "type": "esriFieldTypeDate",
     "alias": "Date Inspected",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "DateInspected"
    },
    {
     "name": "inspector_name",
     "type": "esriFieldTypeString",
     "alias": "Inspector Name",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 100,
     "defaultValue": null,
     "modelName": "inspector_name"
    },
    {
     "name": "device_found",
     "type": "esriFieldTypeString",
     "alias": "Device Found",
     "domain": {
      "type": "codedValue",
      "name": "YesNo",
      "description": "Yes or No",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "device_found"
    },
    {
     "name": "device_accessible",
     "type": "esriFieldTypeString",
     "alias": "Device Accessible",
     "domain": {
      "type": "codedValue",
      "name": "YesNo",
      "description": "Yes or No",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "device_accessible"
    },
    {
     "name": "device_condition",
     "type": "esriFieldTypeString",
     "alias": "Device Condition",
     "domain": {
      "type": "codedValue",
      "name": "DeviceCondition",
      "description": "Physical condition observed during inspection",
      "codedValues": [
       {
        "name": "Good",
        "code": "Good"
       },
       {
        "name": "Fair",
        "code": "Fair"
       },
       {
        "name": "Poor",
        "code": "Poor"
       },
       {
        "name": "Damaged",
        "code": "Damaged"
       },
       {
        "name": "Not Found",
        "code": "NotFound"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "device_condition"
    },
    {
     "name": "device_labeled",
     "type": "esriFieldTypeString",
     "alias": "Device Labeled",
     "domain": {
      "type": "codedValue",
      "name": "YesNo",
      "description": "Yes or No",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "device_labeled"
    },
    {
     "name": "test_required",
     "type": "esriFieldTypeString",
     "alias": "Test Required",
     "domain": {
      "type": "codedValue",
      "name": "YNNoTest",
      "description": "Yes or No or Non testing",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       },
       {
        "name": "Non Testable",
        "code": "Non Testable"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 20,
     "defaultValue": null,
     "modelName": "test_required"
    },
    {
     "name": "test_required_reason",
     "type": "esriFieldTypeString",
     "alias": "Reason Test Required",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "test_required_reason"
    },
    {
     "name": "notes",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "notes"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user",
     "required": true
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date",
     "required": true
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user",
     "required": true
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date",
     "required": true
    },
    {
     "name": "DeviceGUID",
     "type": "esriFieldTypeGUID",
     "alias": "DeviceGUID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "DeviceGUID"
    },
    {
     "name": "CustomerGUID",
     "type": "esriFieldTypeGUID",
     "alias": "CustomerGUID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "CustomerGUID"
    },
    {
     "name": "Customer",
     "type": "esriFieldTypeString",
     "alias": "Customer",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Customer"
    },
    {
     "name": "GroupID",
     "type": "esriFieldTypeString",
     "alias": "GroupID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "GroupID"
    },
    {
     "name": "OGCustomer",
     "type": "esriFieldTypeString",
     "alias": "Original Customer",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "OGCustomer"
    }
   ],
   "indexes": [
    {
     "name": "UUID_40",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "GlobalID,OBJECTID"
    },
    {
     "name": "G111DeviceGUID",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "DeviceGUID"
    },
    {
     "name": "G111CustomerGUID",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "CustomerGUID"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "Mountain Standard Time",
    "timeZoneIANA": "America/Denver",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": {
    "timeZone": "Mountain Standard Time",
    "timeZoneIANA": "America/Denver",
    "respectsDaylightSaving": true
   },
   "types": [],
   "templates": [
    {
     "name": "Inspections",
     "description": "",
     "prototype": {
      "attributes": {
       "GroupID": null,
       "Customer": null,
       "OGCustomer": null,
       "InspectionType": null,
       "DateInspected": null,
       "inspector_name": null,
       "device_found": null,
       "device_accessible": null,
       "device_condition": null,
       "device_labeled": null,
       "test_required": null,
       "test_required_reason": null,
       "notes": null,
       "CustomerGUID": null,
       "DeviceGUID": null
      }
     },
     "drawingTool": "esriFeatureEditToolNone"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": 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
    }
   ],
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 2000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "907657e3a3434ba2bceac3f508cfe234"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 3,
   "name": "Testing",
   "type": "Table",
   "description": "",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user",
    "dateFieldsTimeReference": {
     "timeZone": "UTC",
     "timeZoneIANA": "Etc/UTC",
     "respectsDaylightSaving": false
    }
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": true,
   "relationships": [
    {
     "id": 2,
     "name": "BackflowDevice",
     "relatedTableId": 0,
     "cardinality": "esriRelCardinalityOneToMany",
     "role": "esriRelRoleDestination",
     "keyField": "DeviceGUID",
     "composite": false,
     "catalogID": "{90226C49-5FE5-47FE-B975-496B291D0EF0}"
    }
   ],
   "isDataVersioned": true,
   "isDataArchived": true,
   "infoInEstimates": [
    "count"
   ],
   "isDataBranchVersioned": true,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "supportsRollbackOnFailureParameter": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": true,
    "startArchivingMoment": 1786966315000
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": false,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryAttachments": true,
    "supportsQueryAttachmentsWithReturnUrl": true,
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": false,
    "supportsQueryWithCacheHint": false
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "hasAttachments": true,
   "supportsAttachmentsByUploadId": true,
   "supportsAttachmentsResizing": true,
   "supportsApplyEditsWithGlobalIds": true,
   "supportsOidReservation": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "TesterName",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "name": "device_type",
     "type": "esriFieldTypeString",
     "alias": "Device Type",
     "domain": {
      "type": "codedValue",
      "name": "device_type",
      "description": "Type of backflow prevention device",
      "codedValues": [
       {
        "name": "RP",
        "code": "RP"
       },
       {
        "name": "DCVA",
        "code": "DCVA"
       },
       {
        "name": "PVB",
        "code": "PVB"
       },
       {
        "name": "RPDA",
        "code": "RPDA"
       },
       {
        "name": "DCDA",
        "code": "DCDA"
       },
       {
        "name": "SVB",
        "code": "SVB"
       },
       {
        "name": "AirGap",
        "code": "AirGap"
       },
       {
        "name": "DC",
        "code": "DC"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "device_type"
    },
    {
     "name": "test_type",
     "type": "esriFieldTypeString",
     "alias": "Test Type",
     "domain": {
      "type": "codedValue",
      "name": "TestType",
      "description": "Type of third-party pressure test",
      "codedValues": [
       {
        "name": "Annual Compliance",
        "code": "Annual"
       },
       {
        "name": "Follow-Up",
        "code": "FollowUp"
       },
       {
        "name": "Initial Install",
        "code": "Initial"
       },
       {
        "name": "City-Ordered",
        "code": "CityOrdered"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "test_type"
    },
    {
     "name": "test_result",
     "type": "esriFieldTypeString",
     "alias": "Test Result",
     "domain": {
      "type": "codedValue",
      "name": "PassFail",
      "description": "Test pass or fail result",
      "codedValues": [
       {
        "name": "Pass",
        "code": "Pass"
       },
       {
        "name": "Fail",
        "code": "Fail"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "test_result"
    },
    {
     "name": "cert_number_snapshot",
     "type": "esriFieldTypeString",
     "alias": "Cert Number (at test)",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "cert_number_snapshot"
    },
    {
     "name": "cert_expiry_snapshot",
     "type": "esriFieldTypeDate",
     "alias": "Cert Expiry (at test)",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "cert_expiry_snapshot"
    },
    {
     "name": "cert_valid_at_test",
     "type": "esriFieldTypeString",
     "alias": "Cert Valid at Test",
     "domain": {
      "type": "codedValue",
      "name": "YesNo",
      "description": "Yes or No",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "cert_valid_at_test"
    },
    {
     "name": "check_valve_1_psid",
     "type": "esriFieldTypeDouble",
     "alias": "Check Valve 1 (PSID)",
     "domain": null,
     "editable": true,
     "nullable": true,
     "defaultValue": null,
     "modelName": "check_valve_1_psid"
    },
    {
     "name": "check_valve_2_psid",
     "type": "esriFieldTypeDouble",
     "alias": "Check Valve 2 (PSID)",
     "domain": null,
     "editable": true,
     "nullable": true,
     "defaultValue": null,
     "modelName": "check_valve_2_psid"
    },
    {
     "name": "relief_valve_open_psid",
     "type": "esriFieldTypeDouble",
     "alias": "Relief Valve Opens (PSID)",
     "domain": null,
     "editable": true,
     "nullable": true,
     "defaultValue": null,
     "modelName": "relief_valve_open_psid"
    },
    {
     "name": "air_inlet_open_psid",
     "type": "esriFieldTypeDouble",
     "alias": "Air Inlet Opens (PSID)",
     "domain": null,
     "editable": true,
     "nullable": true,
     "defaultValue": null,
     "modelName": "air_inlet_open_psid"
    },
    {
     "name": "pvb_check_valve_psid",
     "type": "esriFieldTypeDouble",
     "alias": "PVB Check Valve (PSID)",
     "domain": null,
     "editable": true,
     "nullable": true,
     "defaultValue": null,
     "modelName": "pvb_check_valve_psid"
    },
    {
     "name": "air_gap_distance_in",
     "type": "esriFieldTypeDouble",
     "alias": "Air Gap Distance (in)",
     "domain": null,
     "editable": true,
     "nullable": true,
     "defaultValue": null,
     "modelName": "air_gap_distance_in"
    },
    {
     "name": "air_gap_verified",
     "type": "esriFieldTypeString",
     "alias": "Air Gap Verified",
     "domain": {
      "type": "codedValue",
      "name": "YesNo",
      "description": "Yes or No",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "air_gap_verified"
    },
    {
     "name": "repair_actions",
     "type": "esriFieldTypeString",
     "alias": "Repair Actions",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 500,
     "defaultValue": null,
     "modelName": "repair_actions"
    },
    {
     "name": "notes",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "notes"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user",
     "required": true
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date",
     "required": true
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user",
     "required": true
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date",
     "required": true
    },
    {
     "name": "DeviceGUID",
     "type": "esriFieldTypeGUID",
     "alias": "DeviceGUID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "DeviceGUID"
    },
    {
     "name": "TesterName",
     "type": "esriFieldTypeString",
     "alias": "TesterName",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "TesterName"
    },
    {
     "name": "test_date",
     "type": "esriFieldTypeDate",
     "alias": "Test Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "test_date"
    },
    {
     "name": "CustomerGUID",
     "type": "esriFieldTypeGUID",
     "alias": "CustomerGUID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "CustomerGUID"
    },
    {
     "name": "Customer",
     "type": "esriFieldTypeString",
     "alias": "Customer",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Customer"
    },
    {
     "name": "GroupID",
     "type": "esriFieldTypeString",
     "alias": "GroupID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "GroupID"
    },
    {
     "name": "CustomerOwnerName",
     "type": "esriFieldTypeString",
     "alias": "CustomerOwnerName",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "CustomerOwnerName"
    },
    {
     "name": "CustomerEmail",
     "type": "esriFieldTypeString",
     "alias": "CustomerEmail",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "CustomerEmail"
    },
    {
     "name": "CustomerPhone",
     "type": "esriFieldTypeString",
     "alias": "CustomerPhone",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "CustomerPhone"
    },
    {
     "name": "TesterPosition",
     "type": "esriFieldTypeString",
     "alias": "TesterPosition",
     "domain": {
      "type": "codedValue",
      "name": "TesterPosition",
      "description": "Testers job Position to customer",
      "codedValues": [
       {
        "name": "Owner",
        "code": "Owner"
       },
       {
        "name": "Manager",
        "code": "Manager"
       },
       {
        "name": "Staff",
        "code": "Staff"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "TesterPosition"
    },
    {
     "name": "OGCustomer",
     "type": "esriFieldTypeString",
     "alias": "OGCustomer",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "OGCustomer"
    }
   ],
   "indexes": [
    {
     "name": "UUID_42",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "GlobalID,OBJECTID"
    },
    {
     "name": "G113DeviceGUID",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "DeviceGUID"
    },
    {
     "name": "G113CustomerGUID",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "CustomerGUID"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "Mountain Standard Time",
    "timeZoneIANA": "America/Denver",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": {
    "timeZone": "Mountain Standard Time",
    "timeZoneIANA": "America/Denver",
    "respectsDaylightSaving": true
   },
   "types": [],
   "templates": [
    {
     "name": "Testing",
     "description": "",
     "prototype": {
      "attributes": {
       "TesterPosition": null,
       "CustomerPhone": null,
       "OGCustomer": null,
       "device_type": null,
       "test_type": null,
       "test_result": null,
       "cert_number_snapshot": null,
       "cert_expiry_snapshot": null,
       "cert_valid_at_test": null,
       "check_valve_1_psid": null,
       "check_valve_2_psid": null,
       "relief_valve_open_psid": null,
       "air_inlet_open_psid": null,
       "pvb_check_valve_psid": null,
       "air_gap_distance_in": null,
       "air_gap_verified": null,
       "repair_actions": null,
       "notes": null,
       "CustomerEmail": null,
       "CustomerOwnerName": null,
       "GroupID": null,
       "Customer": null,
       "DeviceGUID": null,
       "TesterName": null,
       "test_date": null,
       "CustomerGUID": null
      }
     },
     "drawingTool": "esriFeatureEditToolNone"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": 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
    }
   ],
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 2000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "907657e3a3434ba2bceac3f508cfe234"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 4,
   "name": "Tasks",
   "type": "Table",
   "description": "",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user",
    "dateFieldsTimeReference": {
     "timeZone": "UTC",
     "timeZoneIANA": "Etc/UTC",
     "respectsDaylightSaving": false
    }
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": true,
   "relationships": [
    {
     "id": 0,
     "name": "BackflowDevice",
     "relatedTableId": 0,
     "cardinality": "esriRelCardinalityOneToMany",
     "role": "esriRelRoleDestination",
     "keyField": "DeviceGUID",
     "composite": false,
     "catalogID": "{2F2ED927-7CD0-40A7-8ACE-FC33E5E77B97}"
    }
   ],
   "isDataVersioned": true,
   "isDataArchived": true,
   "infoInEstimates": [
    "count"
   ],
   "isDataBranchVersioned": true,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "supportsRollbackOnFailureParameter": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": true,
    "startArchivingMoment": 1786966318000
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": false,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": false,
    "supportsQueryWithCacheHint": false
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "hasAttachments": false,
   "supportsApplyEditsWithGlobalIds": true,
   "supportsOidReservation": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "Customer",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "CustomerGUID",
     "type": "esriFieldTypeGUID",
     "alias": "CustomerGUID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "CustomerGUID"
    },
    {
     "name": "Customer",
     "type": "esriFieldTypeString",
     "alias": "Customer",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Customer"
    },
    {
     "name": "WorkToBeDone",
     "type": "esriFieldTypeString",
     "alias": "Work To Be Done",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 1000,
     "defaultValue": null,
     "modelName": "WorkToBeDone"
    },
    {
     "name": "WorkCompleted",
     "type": "esriFieldTypeString",
     "alias": "Work Completed",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 1000,
     "defaultValue": null,
     "modelName": "WorkCompleted"
    },
    {
     "name": "AssignedTo",
     "type": "esriFieldTypeString",
     "alias": "Assigned To",
     "domain": {
      "type": "codedValue",
      "name": "AssignedTo",
      "description": "List of city employees to assign to tasks",
      "codedValues": [
       {
        "name": "Nick Morris",
        "code": "Nick Morris"
       },
       {
        "name": "Joseph Meza",
        "code": "Joseph Meza"
       },
       {
        "name": "John Waters",
        "code": "John Waters"
       },
       {
        "name": "Paul Taylor",
        "code": "Paul Taylor"
       },
       {
        "name": "Melissa Smith",
        "code": "Melissa Smith"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "AssignedTo"
    },
    {
     "name": "Status",
     "type": "esriFieldTypeString",
     "alias": "Status",
     "domain": {
      "type": "codedValue",
      "name": "TaskStatus",
      "description": "Status of tasks",
      "codedValues": [
       {
        "name": "Completed",
        "code": "Completed"
       },
       {
        "name": "Not Completed",
        "code": "Not Completed"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 100,
     "defaultValue": null,
     "modelName": "Status"
    },
    {
     "name": "Address",
     "type": "esriFieldTypeString",
     "alias": "Address",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Address"
    },
    {
     "name": "DeviceGUID",
     "type": "esriFieldTypeGUID",
     "alias": "DeviceGUID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "DeviceGUID"
    },
    {
     "name": "GroupID",
     "type": "esriFieldTypeString",
     "alias": "GroupID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "GroupID"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user",
     "required": true
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date",
     "required": true
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user",
     "required": true
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date",
     "required": true
    },
    {
     "name": "WorkDate",
     "type": "esriFieldTypeDate",
     "alias": "Work Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "WorkDate"
    }
   ],
   "indexes": [
    {
     "name": "UUID_44",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "GlobalID,OBJECTID"
    },
    {
     "name": "G115CustomerGUID",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "CustomerGUID"
    },
    {
     "name": "G115DeviceGUID",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "DeviceGUID"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "Mountain Standard Time",
    "timeZoneIANA": "America/Denver",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": {
    "timeZone": "Mountain Standard Time",
    "timeZoneIANA": "America/Denver",
    "respectsDaylightSaving": true
   },
   "types": [],
   "templates": [
    {
     "name": "Tasks",
     "description": "",
     "prototype": {
      "attributes": {
       "GroupID": null,
       "WorkDate": null,
       "CustomerGUID": null,
       "Customer": null,
       "WorkToBeDone": null,
       "WorkCompleted": null,
       "AssignedTo": null,
       "Status": null,
       "Address": null,
       "DeviceGUID": null
      }
     },
     "drawingTool": "esriFeatureEditToolNone"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": true,
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 2000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "907657e3a3434ba2bceac3f508cfe234"
  },
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 5,
   "name": "Contact Log",
   "type": "Table",
   "description": "",
   "copyrightText": "",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user",
    "dateFieldsTimeReference": {
     "timeZone": "UTC",
     "timeZoneIANA": "Etc/UTC",
     "respectsDaylightSaving": false
    }
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": true,
   "relationships": [],
   "isDataVersioned": true,
   "isDataArchived": true,
   "infoInEstimates": [
    "count"
   ],
   "isDataBranchVersioned": true,
   "isDataReplicaTracked": false,
   "isCoGoEnabled": false,
   "supportsRollbackOnFailureParameter": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": true,
    "startArchivingMoment": 1786966319000
   },
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportsValidateSQL": true,
   "supportsCoordinatesQuantization": false,
   "supportsCalculate": true,
   "supportsASyncCalculate": true,
   "advancedQueryCapabilities": {
    "supportsPagination": true,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": false,
    "supportsQueryWithCacheHint": false
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "hasAttachments": false,
   "supportsApplyEditsWithGlobalIds": true,
   "supportsOidReservation": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "ContactName",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "CustomerRGID",
     "type": "esriFieldTypeGUID",
     "alias": "CustomerRGID",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 38,
     "defaultValue": null,
     "modelName": "CustomerRGID"
    },
    {
     "name": "ContactDateTime",
     "type": "esriFieldTypeDate",
     "alias": "Contact Date Time",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "ContactDateTime"
    },
    {
     "name": "RecordedBy",
     "type": "esriFieldTypeString",
     "alias": "Recorded By",
     "domain": {
      "type": "codedValue",
      "name": "AssignedTo",
      "description": "List of city employees to assign to tasks",
      "codedValues": [
       {
        "name": "Nick Morris",
        "code": "Nick Morris"
       },
       {
        "name": "Joseph Meza",
        "code": "Joseph Meza"
       },
       {
        "name": "John Waters",
        "code": "John Waters"
       },
       {
        "name": "Paul Taylor",
        "code": "Paul Taylor"
       },
       {
        "name": "Melissa Smith",
        "code": "Melissa Smith"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     },
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "RecordedBy"
    },
    {
     "name": "Customer",
     "type": "esriFieldTypeString",
     "alias": "Customer",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Customer"
    },
    {
     "name": "ContactName",
     "type": "esriFieldTypeString",
     "alias": "Contact Name",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "ContactName"
    },
    {
     "name": "PhoneNumber",
     "type": "esriFieldTypeString",
     "alias": "Phone Number",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "PhoneNumber"
    },
    {
     "name": "Email",
     "type": "esriFieldTypeString",
     "alias": "Email",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "Email"
    },
    {
     "name": "Reason",
     "type": "esriFieldTypeString",
     "alias": "Reason",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 1000,
     "defaultValue": null,
     "modelName": "Reason"
    },
    {
     "name": "ActionTaken",
     "type": "esriFieldTypeString",
     "alias": "Action Taken",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 1000,
     "defaultValue": null,
     "modelName": "ActionTaken"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "created_user",
     "required": true
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "created_date",
     "required": true
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "last_edited_user",
     "required": true
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "domain": null,
     "editable": false,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "last_edited_date",
     "required": true
    }
   ],
   "indexes": [
    {
     "name": "UUID_45",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "GlobalID,OBJECTID"
    },
    {
     "name": "G116CustomerRGID",
     "isAscending": true,
     "isUnique": false,
     "description": "",
     "fields": "CustomerRGID"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "Mountain Standard Time",
    "timeZoneIANA": "America/Denver",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": {
    "timeZone": "Mountain Standard Time",
    "timeZoneIANA": "America/Denver",
    "respectsDaylightSaving": true
   },
   "types": [],
   "templates": [
    {
     "name": "Contact Log",
     "description": "",
     "prototype": {
      "attributes": {
       "ActionTaken": null,
       "Reason": null,
       "CustomerRGID": null,
       "ContactDateTime": null,
       "RecordedBy": null,
       "Customer": null,
       "ContactName": null,
       "PhoneNumber": null,
       "Email": null
      }
     },
     "drawingTool": "esriFeatureEditToolNone"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": true,
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 2000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "907657e3a3434ba2bceac3f508cfe234"
  }
 ]
}