{ "preferredTimeReference": { "timeZoneIANA": "America/Los_Angeles", "respectsDaylightSaving": true, "timeZone": "Pacific Standard Time" }, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "attachmentProperties": [ { "fieldName": "ATTACHMENTID", "isEnabled": true, "name": "id" }, { "fieldName": "GLOBALID", "isEnabled": true, "name": "globalid" }, { "fieldName": "KEYWORDS", "isEnabled": false, "name": "keywords" }, { "fieldName": "ATT_NAME", "isEnabled": true, "name": "name" }, { "fieldName": "CONTENT_TYPE", "isEnabled": true, "name": "contentType" }, { "fieldName": "DATA_SIZE", "isEnabled": true, "name": "size" }, { "fieldName": "EXIFINFO", "isEnabled": false, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "domain": null, "name": "ATTACHMENTID", "length": 4, "alias": "ATTACHMENTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "domain": null, "name": "GLOBALID", "length": 38, "alias": "GLOBALID", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": true, "domain": null, "name": "ATT_NAME", "length": 250, "alias": "ATT_NAME", "type": "esriFieldTypeString" }, { "nullable": false, "editable": true, "domain": null, "name": "CONTENT_TYPE", "length": 150, "alias": "CONTENT_TYPE", "type": "esriFieldTypeString" }, { "nullable": false, "editable": true, "domain": null, "name": "DATA_SIZE", "length": 4, "alias": "DATA_SIZE", "type": "esriFieldTypeInteger" } ], "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [ { "keyField": "HydrantGUID", "role": "esriRelRoleDestination", "catalogID": "{73FA6CA6-056D-4B15-A7B0-6F4A6EDB8174}", "composite": false, "name": "Water_Hydrant", "relatedTableId": 8, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "HydrantGUID", "role": "esriRelRoleDestination", "catalogID": "{65B714E5-F1EF-4D64-9684-409D155B5474}", "composite": false, "name": "Water_Hydrant", "relatedTableId": 9, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "indexes": [ { "name": "R865_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "UUID_865", "isUnique": true, "description": "", "fields": "GlobalID", "isAscending": true }, { "name": "UUID_OID_865", "isUnique": true, "description": "", "fields": "GlobalID,OBJECTID", "isAscending": true }, { "name": "GDB_4065_HydrantGUID", "isUnique": false, "description": "", "fields": "HydrantGUID", "isAscending": true } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.6.0", "isDataArchived": false, "id": 40, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": true, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsQueryWithDistance": true, "supportsQueryAttachmentOrderByFields": true, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "serviceItemId": "97cc89b918ad43e7851c9fc65c96c196", "capabilities": "Map,Query,Data", "supportsExceedsLimitStatistics": true, "isDataVersioned": true, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "currentVersion": 12, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "Hydrant Inspections", "displayField": "Asset_ID", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "Asset_ID", "length": 25, "alias": "Asset_ID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "InspectionDate", "length": 8, "alias": "Inspection Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "InspectedBy", "length": 50, "alias": "Inspected By", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Hydrant_Inspec_Type", "description": "Major Minor Teardown", "type": "codedValue", "codedValues": [ { "code": "TearDown", "name": "Tear Down" }, { "code": "Major", "name": "Major" }, { "code": "Minor", "name": "Minor" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "InspectionType", "length": 20, "alias": "Inspection Type", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes_No_NA", "description": "Yes No NA", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "PressureTested", "length": 10, "alias": "Pressure Tested", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes_No_NA", "description": "Yes No NA", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "StaticPressureTested", "length": 10, "alias": "Static Pressure Tested", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "StaticPressureTestStatic", "alias": "Static Pressure Test - Static", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "StaticPressureTestResidual", "alias": "Static Pressure Test - Residual", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "StaticPressureTestHM", "alias": "Static Pressure Test HM", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes_No_NA_NL_NO", "description": "Yes No NA Not Located Not Operable", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "NA", "name": "NA" }, { "code": "No", "name": "No" }, { "code": "Not Located", "name": "Not Located" }, { "code": "Not Operable", "name": "Not Operable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ExercisedISOValve", "length": 25, "alias": "Exercised ISO Valve", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes_No_NA", "description": "Yes No NA", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "HydrantFlushed", "length": 10, "alias": "Hydrant Flushed", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes_No_NA", "description": "Yes No NA", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "FlowTested", "length": 15, "alias": "Flow Tested", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "TestFlow", "alias": "Test Flow", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Capacity", "alias": "Capacity", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes_No_NA", "description": "Yes No NA", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "CheckedPortThreads", "length": 10, "alias": "Checked Port Threads", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes_No_NA", "description": "Yes No NA", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "CheckedORings", "length": 10, "alias": "Checked O-Rings", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes_No_NA", "description": "Yes No NA", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "PartsLubricated", "length": 10, "alias": "Parts Lubricated", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Condition_Simple", "description": "Good Fair Poor NA", "type": "codedValue", "codedValues": [ { "code": "Good", "name": "Good" }, { "code": "Fair", "name": "Fair" }, { "code": "Poor", "name": "Poor" }, { "code": "NA", "name": "NA" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "PaintCondition", "length": 50, "alias": "Paint Condition", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Condition_Simple", "description": "Good Fair Poor NA", "type": "codedValue", "codedValues": [ { "code": "Good", "name": "Good" }, { "code": "Fair", "name": "Fair" }, { "code": "Poor", "name": "Poor" }, { "code": "NA", "name": "NA" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Drainage", "length": 10, "alias": "Drainage", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Condition_Simple", "description": "Good Fair Poor NA", "type": "codedValue", "codedValues": [ { "code": "Good", "name": "Good" }, { "code": "Fair", "name": "Fair" }, { "code": "Poor", "name": "Poor" }, { "code": "NA", "name": "NA" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "InternalPartsCondition", "length": 50, "alias": "Condition Of Internal Parts", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Condition_Simple", "description": "Good Fair Poor NA", "type": "codedValue", "codedValues": [ { "code": "Good", "name": "Good" }, { "code": "Fair", "name": "Fair" }, { "code": "Poor", "name": "Poor" }, { "code": "NA", "name": "NA" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "HydrantValveCondition", "length": 10, "alias": "Condition of Hydrant Valve", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes_No_NA", "description": "Yes No NA", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "RepairsRequired", "length": 10, "alias": "Repairs Required", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "RepairsRequiredDetails", "length": 255, "alias": "Repairs Required Details", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "RepairsCompleted", "length": 255, "alias": "Repairs Completed", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ChargeableParts", "length": 255, "alias": "Chargeable Parts", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes_No_NA", "description": "Yes No NA", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ExtensionRequired", "length": 10, "alias": "Extension Required", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Comments", "length": 255, "alias": "General Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PressureTestComments", "length": 255, "alias": "Pressure Test Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "StaticPresTestComments", "length": 255, "alias": "Static Pressure Test Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ExercisedISOValveComments", "length": 255, "alias": "Exercised ISO Valve Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "HydrantFlushComments", "length": 255, "alias": "Hydrant Flush Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "FlowTestComments", "length": 255, "alias": "Flow Test Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PortThreadComments", "length": 255, "alias": "Port Thread Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ORingComments", "length": 255, "alias": "O-Ring Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PartsLubricatedComments", "length": 255, "alias": "Parts Lubricated Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PaintConditionComments", "length": 255, "alias": "Paint Condition Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "DrainageComments", "length": 255, "alias": "Drainage Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "InternalPartsComments", "length": 255, "alias": "Internal Parts Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "HydrantValveComments", "length": 255, "alias": "Hydrant Valve Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ObstructionComments", "length": 255, "alias": "Obstruction Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ExtensionRequiredComments", "length": 255, "alias": "Extension Required Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes_No_NA", "description": "Yes No NA", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Obstructions", "length": 15, "alias": "Obstructions", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "HydrantGUID", "length": 38, "alias": "HydrantGUID", "type": "esriFieldTypeGUID" }, { "nullable": false, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Operational_Status", "description": "Operational Status", "type": "codedValue", "codedValues": [ { "code": "In Service", "name": "In Service" }, { "code": "In Service with Deficiencies", "name": "In Service with Deficiencies" }, { "code": "Repairs Required", "name": "Repairs Required" }, { "code": "Out of Service", "name": "Out of Service" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Status_Operational", "length": 50, "alias": "Operational_Status", "type": "esriFieldTypeString" } ], "dateFieldsTimeReference": { "timeZoneIANA": "America/Los_Angeles", "respectsDaylightSaving": true, "timeZone": "Pacific Standard Time" } }