{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 47, "name": "Hydrant Maintenance ", "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": "DBO.wHydrant", "relatedTableId": 28, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "HydrantGLOBAL", "composite": false, "catalogID": "{17892B08-2BDE-44A4-AEC2-F8C9C8B34EBA}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "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": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Facility_Identifier", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Facility_Identifier", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Facility_Identifier" }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Inspection_Date" }, { "name": "Residual_Hydrant", "type": "esriFieldTypeString", "alias": "Residual Hydrant", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Residual_Hydrant" }, { "name": "Make", "type": "esriFieldTypeString", "alias": "Make", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Make" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Model" }, { "name": "Flushed", "type": "esriFieldTypeString", "alias": "Flushed", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Flushed" }, { "name": "Lubed", "type": "esriFieldTypeString", "alias": "Lubed", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Lubed" }, { "name": "Oil", "type": "esriFieldTypeString", "alias": "Oil", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Oil" }, { "name": "Drains", "type": "esriFieldTypeString", "alias": "Drains", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Drains" }, { "name": "DURATION", "type": "esriFieldTypeString", "alias": "Duration", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DURATION" }, { "name": "WATERSAMPLERESULT", "type": "esriFieldTypeString", "alias": "Water Sample Result", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WATERSAMPLERESULT" }, { "name": "FLOWRATE", "type": "esriFieldTypeString", "alias": "Flow Rate", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FLOWRATE" }, { "name": "DYNAMICPRESSURE", "type": "esriFieldTypeString", "alias": "Dynamic Pressure", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DYNAMICPRESSURE" }, { "name": "VARIABLEFLOW", "type": "esriFieldTypeString", "alias": "Variable Flow", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "VARIABLEFLOW" }, { "name": "DURATIONMINUTES", "type": "esriFieldTypeString", "alias": "Duration Minutes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DURATIONMINUTES" }, { "name": "DURATIONSECONDS", "type": "esriFieldTypeString", "alias": "Duration Seconds", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DURATIONSECONDS" }, { "name": "DISCOLORATIONDURATIONMINUTES", "type": "esriFieldTypeString", "alias": "Discoloration Duration Minutes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DISCOLORATIONDURATIONMINUTES" }, { "name": "DISCOLORATIONDURATIONSECONDS", "type": "esriFieldTypeString", "alias": "Discoloration Duration Seconds", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DISCOLORATIONDURATIONSECONDS" }, { "name": "Pitot", "type": "esriFieldTypeString", "alias": "Pitot", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Pitot" }, { "name": "INSPECTEDBY", "type": "esriFieldTypeString", "alias": "Inspected by", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INSPECTEDBY" }, { "name": "PAINT", "type": "esriFieldTypeString", "alias": "Paint", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PAINT" }, { "name": "FLAG", "type": "esriFieldTypeString", "alias": "Flag", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FLAG" }, { "name": "AUXVALVE", "type": "esriFieldTypeString", "alias": "Aux valve", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AUXVALVE" }, { "name": "AUXVALVEKEYABLE", "type": "esriFieldTypeString", "alias": "Aux Valve Keyable", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AUXVALVEKEYABLE" }, { "name": "Issue", "type": "esriFieldTypeString", "alias": "Issue", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Issue" }, { "name": "HydrantGLOBAL", "type": "esriFieldTypeGUID", "alias": "Field", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "HydrantGLOBAL" }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ADDRESS" }, { "name": "ACTUALRESIDUAL", "type": "esriFieldTypeDouble", "alias": "Actual Residual", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACTUALRESIDUAL" }, { "name": "COEFFICIENT", "type": "esriFieldTypeDouble", "alias": "Coefficient", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COEFFICIENT" }, { "name": "COLOR", "type": "esriFieldTypeString", "alias": "Color", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COLOR" }, { "name": "COLORADDITIONAL", "type": "esriFieldTypeString", "alias": "Color Additional", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COLORADDITIONAL" }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CONDITION" }, { "name": "DISCHARGE", "type": "esriFieldTypeDouble", "alias": "Discharge", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DISCHARGE" }, { "name": "FLOW", "type": "esriFieldTypeDouble", "alias": "Flow", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FLOW" }, { "name": "FLOWHYDRANT", "type": "esriFieldTypeString", "alias": "Flow Hydrant", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FLOWHYDRANT" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NOTES" }, { "name": "NOZZLESIZE", "type": "esriFieldTypeString", "alias": "Nozzle Size", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "NOZZLESIZE" }, { "name": "NUMNOZZLE", "type": "esriFieldTypeString", "alias": "Num Nozzle", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "NUMNOZZLE" }, { "name": "NUMPUMPPORT", "type": "esriFieldTypeString", "alias": "Num Pump Port", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "NUMPUMPPORT" }, { "name": "OBSTRUCTIONS", "type": "esriFieldTypeString", "alias": "Obstructions", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "OBSTRUCTIONS" }, { "name": "OUTLETDIAMETER", "type": "esriFieldTypeDouble", "alias": "Outlet Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OUTLETDIAMETER" }, { "name": "PITOTD", "type": "esriFieldTypeDouble", "alias": "Pitot ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PITOTD" }, { "name": "PITOTGAUGEFLOW", "type": "esriFieldTypeDouble", "alias": "Pitot Gauge Flow", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PITOTGAUGEFLOW" }, { "name": "PSI", "type": "esriFieldTypeDouble", "alias": "PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PSI" }, { "name": "PUMPSIZE", "type": "esriFieldTypeString", "alias": "Pump Size", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PUMPSIZE" }, { "name": "RAISEORLOWER", "type": "esriFieldTypeString", "alias": "Raise or Lower", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "RAISEORLOWER" }, { "name": "RESIDUAL", "type": "esriFieldTypeDouble", "alias": "Residual", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RESIDUAL" }, { "name": "STATIC", "type": "esriFieldTypeDouble", "alias": "Static", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STATIC" }, { "name": "YEAR", "type": "esriFieldTypeString", "alias": "Year", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "YEAR" }, { "name": "DISCOLORATIONDURATION", "type": "esriFieldTypeString", "alias": "DISCOLORATIONDURATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DISCOLORATIONDURATION" }, { "name": "STATICPRESSIRE", "type": "esriFieldTypeString", "alias": "STATICPRESSIRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATICPRESSIRE" }, { "name": "PORTFLUSHED", "type": "esriFieldTypeString", "alias": "PORTFLUSHED", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PORTFLUSHED" }, { "name": "Flow_Test_Activity", "type": "esriFieldTypeString", "alias": "Flow Test Activity", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Flow_Test_Activity" }, { "name": "unMigration_duration", "type": "esriFieldTypeDouble", "alias": "unMigration_duration", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "unMigration_duration" }, { "name": "unMigration_flowrate", "type": "esriFieldTypeDouble", "alias": "unMigration_flowrate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "unMigration_flowrate" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R3223_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G7243HydrantGLOB", "isAscending": true, "isUnique": false, "description": "", "fields": "HydrantGLOBAL" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "Etc/GMT+6", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "Etc/GMT+6", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Hydrant Maintenance ", "description": "", "prototype": { "attributes": { "unMigration_flowrate": null, "unMigration_duration": null, "Facility_Identifier": null, "Inspection_Date": null, "Residual_Hydrant": null, "Make": null, "Model": null, "Flushed": null, "Lubed": null, "Oil": null, "Drains": null, "DURATION": null, "WATERSAMPLERESULT": null, "FLOWRATE": null, "DYNAMICPRESSURE": null, "VARIABLEFLOW": null, "DURATIONMINUTES": null, "DURATIONSECONDS": null, "DISCOLORATIONDURATIONMINUTES": null, "DISCOLORATIONDURATIONSECONDS": null, "Pitot": null, "INSPECTEDBY": null, "PAINT": null, "FLAG": null, "AUXVALVE": null, "AUXVALVEKEYABLE": null, "Issue": null, "HydrantGLOBAL": null, "ADDRESS": null, "ACTUALRESIDUAL": null, "COEFFICIENT": null, "COLOR": null, "COLORADDITIONAL": null, "CONDITION": null, "DISCHARGE": null, "FLOW": null, "FLOWHYDRANT": null, "NOTES": null, "NOZZLESIZE": null, "NUMNOZZLE": null, "NUMPUMPPORT": null, "OBSTRUCTIONS": null, "OUTLETDIAMETER": null, "PITOTD": null, "PITOTGAUGEFLOW": null, "PSI": null, "PUMPSIZE": null, "RAISEORLOWER": null, "RESIDUAL": null, "STATIC": null, "YEAR": null, "DISCOLORATIONDURATION": null, "STATICPRESSIRE": null, "PORTFLUSHED": null, "Flow_Test_Activity": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "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": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ad70ab8f51fc4da6a4d39fac96323779" }