{
 "extent": {
  "ymin": -12000000,
  "xmin": -18000000,
  "ymax": 16000000,
  "xmax": 18000000,
  "spatialReference": {"wkid": 3857}
 },
 "supportedContingentValuesFormats": "JSON, PBF",
 "supportsApplyEditsWithGlobalIds": true,
 "maxRecordCount": 2000,
 "attachmentProperties": [
  {
   "fieldName": "attachmentid",
   "isEnabled": true,
   "name": "id"
  },
  {
   "fieldName": "globalid",
   "isEnabled": true,
   "name": "globalId"
  },
  {
   "fieldName": "att_name",
   "isEnabled": true,
   "name": "name"
  },
  {
   "fieldName": "data_size",
   "isEnabled": true,
   "name": "size"
  },
  {
   "fieldName": "content_type",
   "isEnabled": true,
   "name": "contentType"
  },
  {
   "fieldName": "keywords",
   "isEnabled": true,
   "name": "keywords"
  },
  {
   "fieldName": "exifinfo",
   "isEnabled": true,
   "name": "exifInfo"
  }
 ],
 "attachmentFields": [
  {
   "nullable": false,
   "editable": false,
   "defaultValue": null,
   "domain": null,
   "name": "attachmentid",
   "alias": "attachmentid",
   "type": "esriFieldTypeOID"
  },
  {
   "nullable": false,
   "editable": false,
   "defaultValue": null,
   "domain": null,
   "length": 38,
   "name": "globalid",
   "alias": "globalid",
   "type": "esriFieldTypeGlobalID"
  },
  {
   "nullable": false,
   "editable": false,
   "defaultValue": null,
   "domain": null,
   "length": 250,
   "name": "att_name",
   "alias": "att_name",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": false,
   "editable": false,
   "defaultValue": null,
   "domain": null,
   "name": "data_size",
   "alias": "data_size",
   "type": "esriFieldTypeInteger"
  },
  {
   "nullable": false,
   "editable": false,
   "defaultValue": null,
   "domain": null,
   "length": 150,
   "name": "content_type",
   "alias": "content_type",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": false,
   "defaultValue": null,
   "domain": null,
   "length": 2048,
   "name": "keywords",
   "alias": "keywords",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": false,
   "defaultValue": null,
   "domain": null,
   "length": 1073741822,
   "name": "exifinfo",
   "alias": "exifinfo",
   "type": "esriFieldTypeString"
  }
 ],
 "infoInEstimates": [
  "extent",
  "count"
 ],
 "type": "Table",
 "hasStaticData": true,
 "supportsAttachmentsByUploadId": true,
 "relationships": [
  {
   "keyField": "assetguid",
   "role": "esriRelRoleDestination",
   "composite": false,
   "name": "Fire Hydrant",
   "relatedTableId": 501007,
   "id": 2,
   "cardinality": "esriRelCardinalityOneToMany"
  }
 ],
 "hasViews": true,
 "supportsAttachmentsResizing": true,
 "id": 5010070,
 "supportsSubtypeEditing": true,
 "supportsStatistics": true,
 "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
 "standardMaxRecordCount": 16000,
 "isDataVersioned": false,
 "templates": [
  {
   "name": "Hydrant Maintenance Inspection",
   "description": "",
   "drawingTool": "esriFeatureEditToolNone",
   "prototype": {
    "attributes": {
     "operable": null,
     "inspgroup": null,
     "notes": null,
     "firestation": null,
     "chains": null,
     "outletdiameter": null,
     "staticpressure": null,
     "paint": null,
     "flowrate": null,
     "greased": null,
     "drain": null,
     "oil": null,
     "flush": null,
     "discharge": null,
     "inspectiontype": null,
     "leaking": null,
     "pitotpressure": null,
     "rmaint": null,
     "maintstatus": null,
     "pressure": null,
     "inspector": null,
     "flowduration": null,
     "marker": null,
     "dischargecoe": null,
     "insdate": null,
     "residualpressure": null
    }
   }
  }
 ],
 "supportsAdvancedQueries": true,
 "supportsTilesAndBasicQueriesMode": true,
 "currentVersion": 11.4,
 "advancedEditingCapabilities": {
  "supportsAsyncApplyEdits": true,
  "supportsApplyEditsbyUploadID": true,
  "supportsReturnEditResults": true,
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportedApplyEditsUploadIDFormats": "JSON,PBF"
 },
 "objectIdField": "objectid",
 "supportsQuantizationEditMode": true,
 "hasContingentValuesDefinition": false,
 "name": "Hydrant Maintenance Inspection",
 "displayField": "pressure",
 "supportsCalculate": true,
 "fields": [
  {
   "nullable": false,
   "editable": false,
   "defaultValue": null,
   "length": 4,
   "type": "esriFieldTypeOID",
   "domain": null,
   "name": "objectid",
   "alias": "OBJECTID"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_maintstatus_68a309a0672b4fee819f635cc4cfd004",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 1,
      "name": "Submitted"
     },
     {
      "code": 2,
      "name": "Acknowledged"
     },
     {
      "code": 3,
      "name": "Planned"
     },
     {
      "code": 4,
      "name": "Completed"
     },
     {
      "code": 5,
      "name": "Deferred"
     },
     {
      "code": 6,
      "name": "Rejected"
     }
    ]
   },
   "name": "maintstatus",
   "alias": "Maintenance Status",
   "type": "esriFieldTypeInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "inspector",
   "length": 50,
   "alias": "Inspector",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "precision": 1,
   "name": "insdate",
   "length": 29,
   "alias": "Inspection Date",
   "type": "esriFieldTypeDate"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_chains_f7c75bbca8dc40c6a4d7c30445310227",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "No"
     },
     {
      "code": 1,
      "name": "Yes"
     }
    ]
   },
   "name": "chains",
   "alias": "Are chains missing?",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_paint_eeea61eaf35b4178860faff2c273b13d",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "No"
     },
     {
      "code": 1,
      "name": "Yes"
     }
    ]
   },
   "name": "paint",
   "alias": "Needs to be painted?",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_marker_2fb27f8ccf204b2d9ef394a6f8293b9d",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "No"
     },
     {
      "code": 1,
      "name": "Yes"
     }
    ]
   },
   "name": "marker",
   "alias": "Needs marker?",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_oil_d1f325d0a3494231931b0cd0b3b480a3",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "No"
     },
     {
      "code": 1,
      "name": "Yes"
     }
    ]
   },
   "name": "oil",
   "alias": "Needs lubrication?",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_greased_0186ba99e1554fec89b95b1b8c51337e",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "No"
     },
     {
      "code": 1,
      "name": "Yes"
     }
    ]
   },
   "name": "greased",
   "alias": "Needs grease?",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_drain_b80965260b1d4c8690d6649a159175b0",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "No"
     },
     {
      "code": 1,
      "name": "Yes"
     }
    ]
   },
   "name": "drain",
   "alias": "Drains correctly?",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "notes",
   "length": 2000,
   "alias": "Notes",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "pressure",
   "alias": "Pressure",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "flowrate",
   "alias": "Flow Rate",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "flowduration",
   "alias": "Flow Duration",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "assetguid",
   "length": 38,
   "alias": "Asset GlobalID",
   "type": "esriFieldTypeGUID"
  },
  {
   "nullable": false,
   "editable": false,
   "defaultValue": null,
   "length": 38,
   "type": "esriFieldTypeGlobalID",
   "domain": null,
   "name": "globalid",
   "alias": "GlobalID"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "created_user",
   "length": 255,
   "alias": "Creator",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "precision": 1,
   "name": "created_date",
   "length": 29,
   "alias": "Creation date",
   "type": "esriFieldTypeDate"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "last_edited_user",
   "length": 255,
   "alias": "Updated by",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "precision": 1,
   "name": "last_edited_date",
   "length": 29,
   "alias": "Last update",
   "type": "esriFieldTypeDate"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_leaking_6fa17eff3cb0472985061eec6c7c56eb",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "No"
     },
     {
      "code": 1,
      "name": "Yes"
     }
    ]
   },
   "name": "leaking",
   "alias": "Is the hydrant leaking?",
   "type": "esriFieldTypeInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_operable_6ca7468dcf1a4eff846989ef1e21510a",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "No"
     },
     {
      "code": 1,
      "name": "Yes"
     }
    ]
   },
   "name": "operable",
   "alias": "Is the hydrant operable?",
   "type": "esriFieldTypeInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_inspgroup_d0eae36217e94e2981d7aecd4ca007f5",
    "type": "codedValue",
    "codedValues": [
     {
      "code": "0",
      "name": "Water Company"
     },
     {
      "code": "1",
      "name": "Fire Department"
     },
     {
      "code": "2",
      "name": "Contractor"
     }
    ]
   },
   "name": "inspgroup",
   "length": 75,
   "alias": "Inspection Group",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_firestation_0ffe772dfdeb4d7385a9a34fcd2ccaca",
    "type": "codedValue",
    "codedValues": [
     {
      "code": "1",
      "name": "Station 1"
     },
     {
      "code": "2",
      "name": "Station 2"
     },
     {
      "code": "3",
      "name": "Station 3"
     },
     {
      "code": "4",
      "name": "Station 4"
     },
     {
      "code": "5",
      "name": "Station 5"
     },
     {
      "code": "6",
      "name": "Station 6"
     },
     {
      "code": "7",
      "name": "Station 7"
     },
     {
      "code": "8",
      "name": "Station 8"
     },
     {
      "code": "9",
      "name": "Station 9"
     },
     {
      "code": "10",
      "name": "Station 10"
     }
    ]
   },
   "name": "firestation",
   "length": 75,
   "alias": "Station Completing Inspection",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "totalused",
   "alias": "Total Water Used",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_inspectiontype_2bdda6cae3b6440180bd0391eb45d210",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 3,
      "name": "Flow Test"
     },
     {
      "code": 2,
      "name": "Flush"
     }
    ]
   },
   "name": "inspectiontype",
   "alias": "Inspection Type",
   "type": "esriFieldTypeInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "dischargecoe",
   "alias": "Discharge Coefficient",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "outletdiameter",
   "alias": "Outlet Diameter",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "discharge",
   "alias": "Available Fire Flow",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "staticpressure",
   "alias": "Static Pressure",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "residualpressure",
   "alias": "Residual Pressure",
   "type": "esriFieldTypeInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "name": "WaterDistributionSystem_d1981a7da27a4170878f10323bc69311_HydrantMaintenanceInspection_flush_0cccfface40c45b3889fac409c4a1161",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 1,
      "name": "Yes"
     },
     {
      "code": 2,
      "name": "No"
     }
    ]
   },
   "name": "flush",
   "alias": "Flush",
   "type": "esriFieldTypeInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "pitotpressure",
   "alias": "Pitot Pressure",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "rmaint",
   "length": 256,
   "alias": "Maintenance Required",
   "type": "esriFieldTypeString"
  }
 ],
 "maxRecordCountFactor": 1,
 "dateFieldsTimeReference": {
  "timeZoneIANA": "Etc/UTC",
  "respectsDaylightSaving": false,
  "timeZone": "UTC"
 },
 "supportsFieldDescriptionProperty": true,
 "allowGeometryUpdates": false,
 "enableUseOfScaleOutReplicasWhenEditable": true,
 "useStandardizedQueries": true,
 "globalIdField": "globalid",
 "description": "",
 "syncCanReturnChanges": true,
 "supportsAsyncDelete": true,
 "supportedSpatialRelationships": [
  "esriSpatialRelIntersects",
  "esriSpatialRelContains",
  "esriSpatialRelCrosses",
  "esriSpatialRelEnvelopeIntersects",
  "esriSpatialRelOverlaps",
  "esriSpatialRelTouches",
  "esriSpatialRelWithin"
 ],
 "supportsRollbackOnFailureParameter": true,
 "isDataReplicaTracked": true,
 "supportsTruncate": false,
 "indexes": [
  {
   "name": "r289_sde_rowid_uk",
   "isUnique": false,
   "description": "",
   "fields": "objectid",
   "isAscending": true
  },
  {
   "name": "uuid_289",
   "isUnique": true,
   "description": "",
   "fields": "globalid",
   "isAscending": true
  },
  {
   "name": "assetguid_waterdistributionsyste_hydrantmaintenanceinspection",
   "isUnique": false,
   "description": "",
   "fields": "assetguid",
   "isAscending": true
  }
 ],
 "supportedAppendSourceFilterFormats": "featureService",
 "editFieldsInfo": null,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "exceedsLimitFactor": 1,
 "GUIDFormat": "O",
 "minScale": 0,
 "hasAttachments": true,
 "queryBinsCapabilities": {
  "supportedStatisticTypes": [
   "count",
   "sum",
   "min",
   "max",
   "avg",
   "stddev",
   "var",
   "percentile_cont",
   "percentile_disc"
  ],
  "supportsFixedIntervalBin": true,
  "supportsAutoIntervalBin": true,
  "supportsFixedBoundariesBin": true,
  "supportsDateBin": true
 },
 "advancedQueryCapabilities": {
  "supportsSqlExpression": true,
  "supportsQueryWithResultType": true,
  "supportsQueryRelatedPagination": true,
  "supportsQueryWithCacheHint": false,
  "supportsQueryWithDatumTransformation": true,
  "supportsCurrentUserQueries": true,
  "supportsQueryAttachmentsWithReturnUrl": true,
  "supportsDefaultSR": true,
  "supportsQueryDateBins": false,
  "supportsQueryWithLodSR": false,
  "supportsPaginationOnAggregatedQueries": true,
  "supportsMaxRecordCountFactor": true,
  "supportsPagination": true,
  "supportsStatistics": true,
  "supportsOrderBy": true,
  "supportsFullTextSearch": true,
  "supportsLod": false,
  "supportsSpatialAggregationStatistics": false,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryAttachments": true,
  "supportsQueryAttachmentsCountOnly": true,
  "supportsReturningQueryExtent": true,
  "supportsOrderByOnlyOnLayerFields": false,
  "supportsOutFieldSqlExpression": true,
  "supportsTopFeaturesQuery": true,
  "supportsDistinct": true,
  "supportsQueryAnalytic": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true
 },
 "supportsValidateSql": true,
 "serviceItemId": "bc8ccf320fb4426fba2e4cf3b084c5c9",
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": true,
 "types": [],
 "capabilities": "Query,Sync",
 "maxScale": 0,
 "supportsAppend": true,
 "supportedSyncDataOptions": 4,
 "supportsExceedsLimitStatistics": true,
 "sourceSchemaChangesAllowed": true,
 "defaultVisibility": true,
 "advancedQueryAnalyticCapabilities": {
  "supportsAsync": true,
  "supportsLinearRegression": true,
  "supportsPercentileAnalytic": false
 },
 "hasMetadata": false,
 "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile",
 "uniqueIdField": {
  "isSystemMaintained": true,
  "name": "objectid"
 },
 "tileMaxRecordCount": 4000,
 "typeIdField": "",
 "supportsASyncCalculate": true,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "sqlParserVersion": "PG_11.4.0",
 "copyrightText": "",
 "supportsLayerOverrides": true
}