{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 33, "name": "HydrantHistory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "GIS_PROD.GDB_ADMIN.wHydrant", "relatedTableId": 20, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "assetkey", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "Asset Key", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "assetkey" }, { "name": "workorderkey", "type": "esriFieldTypeString", "alias": "Workorder Key", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "workorderkey" }, { "name": "staticpressure", "type": "esriFieldTypeDouble", "alias": "Static Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "staticpressure" }, { "name": "residualpressure", "type": "esriFieldTypeDouble", "alias": "Residual Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "residualpressure" }, { "name": "pitotpressure", "type": "esriFieldTypeDouble", "alias": "Pitot Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pitotpressure" }, { "name": "flow", "type": "esriFieldTypeDouble", "alias": "Flow", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "flow" }, { "name": "nozzlediameter", "type": "esriFieldTypeDouble", "alias": "Nozzle Diameter", "domain": { "type": "codedValue", "name": "FH_Size1", "description": "", "codedValues": [ { "name": "2", "code": 2 }, { "name": "2.5", "code": 2.5 }, { "name": "4", "code": 4 }, { "name": "4.5", "code": 4.5 }, { "name": "5.25", "code": 5.25 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 2.5, "modelName": "nozzlediameter" }, { "name": "flowduration", "type": "esriFieldTypeInteger", "alias": "Flow Duration", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "flowduration" }, { "name": "gallonsused", "type": "esriFieldTypeInteger", "alias": "GallonsUsed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "gallonsused" }, { "name": "attachmentid1", "type": "esriFieldTypeInteger", "alias": "AttachmentID1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid1" }, { "name": "attachmentid2", "type": "esriFieldTypeInteger", "alias": "AttachmentID2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid2" }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "WorkDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "workdate" }, { "name": "workby", "type": "esriFieldTypeString", "alias": "WorkBy", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "workby" }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "WorkType", "domain": { "type": "codedValue", "name": "FH_WorkType", "description": "", "codedValues": [ { "name": "2 Hydrant Fire Flow Test", "code": "2 Hydrant Fire Flow Test" }, { "name": "1 Hydrant Fire Flow Test", "code": "1 Hydrant Fire Flow Test" }, { "name": "Hydrant Maintenance", "code": "Hydrant Maintenance" }, { "name": "Hydrant Maintenance w/Flush", "code": "Hydrant Maintenance w/Flush" }, { "name": "Fire Hydrant Flush", "code": "Fire Hydrant Flush" }, { "name": "Simple Asset Data update", "code": "Simple Asset Data update" }, { "name": "Hydrant Install/Review/Update", "code": "Hydrant Install/Review/Update" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "worktype" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Maintenance Comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "comments" }, { "name": "paint", "type": "esriFieldTypeString", "alias": "Paint Condition", "domain": { "type": "codedValue", "name": "FH_Paint", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Needs Painted", "code": "Needs Painted" }, { "name": "Needs Stenciled", "code": "Needs Stenciled" }, { "name": "Needs Paint and Stencil", "code": "Needs Paint and Stencil" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "paint" }, { "name": "stencil", "type": "esriFieldTypeString", "alias": "Stencil", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "stencil" }, { "name": "flowat20", "type": "esriFieldTypeDouble", "alias": "Flow at 20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "flowat20" }, { "name": "caps", "type": "esriFieldTypeString", "alias": "Caps Condition", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "caps" }, { "name": "chains", "type": "esriFieldTypeString", "alias": "Chains Condition", "domain": { "type": "codedValue", "name": "pipe_condition", "description": "", "codedValues": [ { "name": "Excellent", "code": "excellent" }, { "name": "Good", "code": "good" }, { "name": "Fair", "code": "fair" }, { "name": "Poor", "code": "poor" }, { "name": "Failure Imminent", "code": "failure_imminent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "chains" }, { "name": "drainage", "type": "esriFieldTypeString", "alias": "Drainage Condition", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "drainage" }, { "name": "nozzle", "type": "esriFieldTypeString", "alias": "Nozzle", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "nozzle" }, { "name": "nozzleleaks", "type": "esriFieldTypeString", "alias": "Nozzle Leaks", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "nozzleleaks" }, { "name": "nozzlegreased", "type": "esriFieldTypeString", "alias": "Nozzle Greased", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "nozzlegreased" }, { "name": "residuallocation", "type": "esriFieldTypeString", "alias": "Residual PSI Reading Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "residuallocation" }, { "name": "clearance", "type": "esriFieldTypeString", "alias": "Clearance", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "clearance" }, { "name": "height", "type": "esriFieldTypeString", "alias": "Height", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "height" }, { "name": "obstruction", "type": "esriFieldTypeString", "alias": "Obstruction", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "obstruction" }, { "name": "commentzone", "type": "esriFieldTypeString", "alias": "Clear Zone Obstructions Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "commentzone" }, { "name": "leadnozzle", "type": "esriFieldTypeString", "alias": "Lead Nozzle", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "leadnozzle" }, { "name": "capthreadseal", "type": "esriFieldTypeString", "alias": "Cap Thread Seal", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "capthreadseal" }, { "name": "commentcapnozzle", "type": "esriFieldTypeString", "alias": "Comment Cap/Nozzle", "domain": { "type": "codedValue", "name": "FH_CapsChains", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Repaired", "code": "Repaired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "commentcapnozzle" }, { "name": "initialcondition", "type": "esriFieldTypeString", "alias": "Initial Condition", "domain": { "type": "codedValue", "name": "EasyHard", "description": "", "codedValues": [ { "name": "Easy", "code": "Easy" }, { "name": "Hard", "code": "Hard" }, { "name": "Medium", "code": "Medium" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "initialcondition" }, { "name": "stemoiledexercised", "type": "esriFieldTypeString", "alias": "Stem Oiled/Exercised", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "stemoiledexercised" }, { "name": "finalcondition", "type": "esriFieldTypeString", "alias": "Final Condition", "domain": { "type": "codedValue", "name": "EasyHard", "description": "", "codedValues": [ { "name": "Easy", "code": "Easy" }, { "name": "Hard", "code": "Hard" }, { "name": "Medium", "code": "Medium" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "finalcondition" }, { "name": "additionalwork", "type": "esriFieldTypeString", "alias": "Additional Work", "domain": { "type": "codedValue", "name": "FH_AddWork", "description": "", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Replace", "code": "Replace" }, { "name": "Future Replace", "code": "Future Replace" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "additionalwork" }, { "name": "commentaddwork", "type": "esriFieldTypeString", "alias": "Additional Work Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "commentaddwork" }, { "name": "beginturbidity", "type": "esriFieldTypeDouble", "alias": "Beginning Turbidity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "beginturbidity" }, { "name": "begincl2", "type": "esriFieldTypeDouble", "alias": "Beginning Chlorine", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "begincl2" }, { "name": "beginwatertemp", "type": "esriFieldTypeDouble", "alias": "Beginning Water Temperature", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "beginwatertemp" }, { "name": "endturbidity", "type": "esriFieldTypeDouble", "alias": "Ending Turbidity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "endturbidity" }, { "name": "endcl2", "type": "esriFieldTypeDouble", "alias": "Ending Chlorine", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "endcl2" }, { "name": "ph", "type": "esriFieldTypeDouble", "alias": "pH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ph" }, { "name": "pitot", "type": "esriFieldTypeDouble", "alias": "Pitot", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pitot" }, { "name": "testduration", "type": "esriFieldTypeDouble", "alias": "Test Duration", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "testduration" }, { "name": "issue", "type": "esriFieldTypeString", "alias": "Issue", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "issue" }, { "name": "flowrate", "type": "esriFieldTypeString", "alias": "Flow Rate", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "flowrate" }, { "name": "DataValidComment", "type": "esriFieldTypeString", "alias": "DataValidComment", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "DataValidComment" }, { "name": "WorkInitials", "type": "esriFieldTypeString", "alias": "Work Initials", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WorkInitials" }, { "name": "attachmentid3", "type": "esriFieldTypeInteger", "alias": "AttachmentID3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid3" }, { "name": "WorkingHours", "type": "esriFieldTypeInteger", "alias": "WorkingHours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WorkingHours" }, { "name": "Man_Hours_Breakdown", "type": "esriFieldTypeString", "alias": "Man Hours Breakdown", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Man_Hours_Breakdown" }, { "name": "Pressure", "type": "esriFieldTypeInteger", "alias": "Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Pressure" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GUID" }, { "name": "DataValid_Comment", "type": "esriFieldTypeString", "alias": "Data Valid Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DataValid_Comment" }, { "name": "SolidStem", "type": "esriFieldTypeString", "alias": "Solid Stem", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SolidStem" }, { "name": "PaintStencil", "type": "esriFieldTypeString", "alias": "Paint/Stencil", "domain": { "type": "codedValue", "name": "FH_Paint", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Needs Painted", "code": "Needs Painted" }, { "name": "Needs Stenciled", "code": "Needs Stenciled" }, { "name": "Needs Paint and Stencil", "code": "Needs Paint and Stencil" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PaintStencil" }, { "name": "DataValid", "type": "esriFieldTypeString", "alias": "Data Valid", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DataValid" } ], "indexes": [ { "name": "R439_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_439", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5785_GUID", "fields": "GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_439", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "HydrantHistory", "description": "", "prototype": { "attributes": { "PaintStencil": null, "SolidStem": null, "assetkey": null, "workorderkey": null, "staticpressure": null, "residualpressure": null, "pitotpressure": null, "flow": null, "nozzlediameter": 2.5, "flowduration": null, "gallonsused": null, "attachmentid1": null, "attachmentid2": null, "workdate": null, "workby": null, "worktype": null, "comments": null, "paint": null, "stencil": null, "flowat20": null, "caps": null, "chains": null, "drainage": null, "nozzle": null, "nozzleleaks": null, "nozzlegreased": null, "residuallocation": null, "clearance": null, "height": null, "obstruction": null, "commentzone": null, "leadnozzle": null, "capthreadseal": null, "commentcapnozzle": null, "initialcondition": null, "stemoiledexercised": null, "finalcondition": null, "additionalwork": null, "commentaddwork": null, "beginturbidity": null, "begincl2": null, "beginwatertemp": null, "endturbidity": null, "endcl2": null, "ph": null, "pitot": null, "testduration": null, "issue": null, "flowrate": null, "DataValidComment": null, "WorkInitials": null, "attachmentid3": null, "WorkingHours": null, "Man_Hours_Breakdown": null, "Pressure": null, "DataValid": null, "GUID": null, "DataValid_Comment": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }