{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "W - Valve Events", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OPERATOR_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "TYPE", "type": "esriFieldTypeInteger", "alias": "Valve Type", "domain": { "type": "codedValue", "name": "Water_Valve_Types", "description": "Water Valve Types for Valve Breaks", "codedValues": [ { "name": "Gate Valve", "code": 420 }, { "name": "Butterfly Valve", "code": 112 }, { "name": "Hydrant Valve", "code": 481 }, { "name": "Zone Valve", "code": 461 }, { "name": "Private Valve", "code": 550 }, { "name": "Service Line Valve", "code": 421 }, { "name": "PRV", "code": 408 }, { "name": "ARV", "code": 412 }, { "name": "Blowoff Valve", "code": 417 }, { "name": "Other (See Notes)", "code": 999 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "UNITID", "type": "esriFieldTypeString", "alias": "Unit ID", "length": 50, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 150, "domain": null }, { "name": "LOC_DESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 255, "domain": null }, { "name": "INSTALL_DT", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "REHAB_YR", "type": "esriFieldTypeString", "alias": "Rehab Year", "length": 4, "domain": null }, { "name": "EVENT_DT", "type": "esriFieldTypeDate", "alias": "Event Date", "length": 8, "domain": null }, { "name": "EVENT_TYPE", "type": "esriFieldTypeString", "alias": "Event Type", "length": 40, "domain": { "type": "codedValue", "name": "Water_Valve_Event_Type", "description": "Event types for Water Valve Breaks and Exercises", "codedValues": [ { "name": "Routine Operation", "code": "Routine Operation" }, { "name": "Needs Repair / Maintenance", "code": "Needs Repair" }, { "name": "Repaired / Rehab Completed", "code": "Repaired / Rehab Completed" }, { "name": "Unable to Locate", "code": "Unable to Locate" }, { "name": "Other (See Note)", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ISSUE_CONDITION", "type": "esriFieldTypeString", "alias": "Issue / Condition", "length": 40, "domain": { "type": "codedValue", "name": "Water_Valve_Event_Issue", "description": "Broken Water Valve issue or condition", "codedValues": [ { "name": "Broken", "code": "Broken" }, { "name": "Broken Stem / Extension", "code": "Broken Stem" }, { "name": "Missing Nut", "code": "Missing Nut" }, { "name": "Needs Exercise", "code": "Needs Exercise" }, { "name": "Needs Vacuum", "code": "Needs Vacuum" }, { "name": "Offset (Can't Access)", "code": "Offset" }, { "name": "Overlaid", "code": "Overlaid" }, { "name": "Packing Leak", "code": "Packing Leak" }, { "name": "Rounded / Broken Nut", "code": "Rounded Nut" }, { "name": "Unable to Locate", "code": "Unable to Locate" }, { "name": "Other (See Note)", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACTION_TAKEN", "type": "esriFieldTypeString", "alias": "Action Taken", "length": 40, "domain": { "type": "codedValue", "name": "Water_Valve_Event_Action", "description": "Water Valve Event Action Taken", "codedValues": [ { "name": "Operated Valve", "code": "Operated Valve" }, { "name": "Valve Exercise", "code": "Valve Exercise" }, { "name": "Isolation", "code": "Isolation" }, { "name": "Update Attributes", "code": "Update Attributes" }, { "name": "Replaced / Rehab", "code": "Replaced / Rehab" }, { "name": "Repaired", "code": "Repaired" }, { "name": "Other (See Note)", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SERVICE_STATUS", "type": "esriFieldTypeString", "alias": "Service Status", "length": 40, "domain": { "type": "codedValue", "name": "Water_Valve_Service_Status", "description": "Water Valve working status", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "In Service \u2013 Needs Repair", "code": "In Service \u2013 Needs Repair" }, { "name": "Out of Service - Needs Repair", "code": "Out of Service - Needs Repair" }, { "name": "Decommissioned / Not in Use", "code": "Decommissioned" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POSITION", "type": "esriFieldTypeString", "alias": "Position", "length": 25, "domain": { "type": "codedValue", "name": "Water_Valve_Position", "description": "Water Valve Positions", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" }, { "name": "Broken Open", "code": "Broken Open" }, { "name": "Broken Closed", "code": "Broken Closed" }, { "name": "Temporarily Closed for Isolation", "code": "Temp Closed" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EXERCISED", "type": "esriFieldTypeString", "alias": "Exercised During Event?", "length": 3, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OFFSET", "type": "esriFieldTypeString", "alias": "Valve is Offset?", "length": 3, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TURNS", "type": "esriFieldTypeDouble", "alias": "Turns", "domain": null }, { "name": "STIFF", "type": "esriFieldTypeString", "alias": "Stiff?", "length": 3, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TORQUE", "type": "esriFieldTypeString", "alias": "Torque", "length": 25, "domain": null }, { "name": "VACUUMED", "type": "esriFieldTypeString", "alias": "Vacuumed?", "length": 3, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "EVENT_NOTES", "type": "esriFieldTypeString", "alias": "Event Notes", "length": 255, "domain": null }, { "name": "OPER_NOTES", "type": "esriFieldTypeString", "alias": "Operational Notes", "length": 255, "domain": null }, { "name": "OPERATOR_NAME", "type": "esriFieldTypeString", "alias": "Operator Name", "length": 100, "domain": null }, { "name": "CREW_INITIALS", "type": "esriFieldTypeString", "alias": "Crew Initials", "length": 50, "domain": null }, { "name": "EVENT_CNT", "type": "esriFieldTypeInteger", "alias": "Event Count", "domain": null }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "Creator", "length": 100, "domain": null }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "Create Date", "length": 8, "domain": null }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "Editor", "length": 100, "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "Edit Date", "length": 8, "domain": null }, { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "GIS ID", "domain": null }, { "name": "Rel_GIS_ID", "type": "esriFieldTypeInteger", "alias": "Rel GIS ID", "domain": null }, { "name": "Rel_GIS_GUID", "type": "esriFieldTypeInteger", "alias": "Rel GIS GUID", "domain": null }, { "name": "Rel_GlobalID", "type": "esriFieldTypeGUID", "alias": "Rel GloablID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R871_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_871", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_871", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "Rel_GIS_GUID", "fields": "Rel_GIS_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Rel_GIS_GID", "fields": "Rel_GIS_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Event_Date", "fields": "EVENT_DT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Rel_GlobalID", "fields": "Rel_GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "LastRecord", "fields": "Rel_GlobalID,EVENT_DT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Exercised", "fields": "EXERCISED,Rel_GlobalID,EVENT_DT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "LastAction", "fields": "ACTION_TAKEN,Rel_GlobalID,EVENT_DT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "W - Valve", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "Rel_GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7AD95ABD-13FB-44EC-9189-5DE4BC47FDCB}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }