{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "Valves", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102654, "latestWkid": 2232, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118767900, "falseY": -94525500, "xyUnits": 3.698511370706479E7, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "4789250c02e7dd3f7dc02edff1a0c082", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABmUlEQVQ4jbXTO0hbURzH8e8JF2MimKbBDhF8LCoUHFpQUBfBoaAuFqk4qUt1UVHrEBzuIEqXFrp0sZougooGKYW2FHQSVJQ2CF0EH0WFgo+IyU3i9R4H8XF77yVC6X87j9+H8z+co/CPpfwXoPmjzD/XeRNL8iSm4fVls/8wh/ez7WI8I9A2KfuONYZDdXhK8sAfAiAIfKh8Kwc1nafRVyJuC7ycli8uDF7PtaO4BJxoZnx5h9LKQtaAMltg65B3kY6rsFMt71D6fEJ2XLdzAwzMy3JD8sib5Ry+rqM4XYAZSOtURA+gN3K7MaXbA7EkQUsLboXY4iYsbpo3d1bBaIN5rmmChAXIcfE51408TWG6AbcCDzy345Vd8GWzbgHURpFoDsulmR9U2x8cDAkj39GyFPosAMDjQp5tH7K7+hv/3+FEGnoi6H4PQ+FWsWcLqLXiTF2QBUUBvnz9RdVpCvFzH/rnYeOAP8UBusdaxNTdjOUlqrXiDKhRP0lv3KA+peNzCVa+dYmoXVuOn0ltFAlgxmk9I3DfugT2SoEsYOskQgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 4851.719482421875, "ymin": 5018.049072280526, "xmax": 3126700.877372235, "ymax": 1742770.5879404843, "spatialReference": { "wkid": 102654, "latestWkid": 2232, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118767900, "falseY": -94525500, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Enabled", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Work Order", "length": 30, "domain": null }, { "name": "ValveType", "type": "esriFieldTypeString", "alias": "Valve Type", "length": 25, "domain": { "type": "codedValue", "name": "dValveType", "description": "", "codedValues": [ { "name": "Gate", "code": "Gate" }, { "name": "Butterfly", "code": "Butterfly" }, { "name": "Unknown", "code": "Unknown" }, { "name": "OS&Y", "code": "OSY" }, { "name": "Tapping", "code": "Tapping" }, { "name": "EZ Valve", "code": "EZ" }, { "name": "CurbStop", "code": "CurbStop" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ValveSize", "type": "esriFieldTypeInteger", "alias": "Valve Size", "domain": { "type": "codedValue", "name": "dMainSize", "description": "", "codedValues": [ { "name": "2\"", "code": 2 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "Unknown", "code": -99 }, { "name": "Other", "code": -98 }, { "name": "22\"", "code": 22 }, { "name": "28\"", "code": 28 }, { "name": "38\"", "code": 38 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "57\"", "code": 57 }, { "name": "60\"", "code": 60 }, { "name": "63\"", "code": 63 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "3\"", "code": 3 }, { "name": "15\"", "code": 15 }, { "name": "1\"", "code": 1 }, { "name": "26\"", "code": 26 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "Life Cycle Status", "length": 15, "domain": { "type": "codedValue", "name": "dLifeCycleStatus", "description": "", "codedValues": [ { "name": "Proposed", "code": "PROPOSED" }, { "name": "Active", "code": "ACTIVE" }, { "name": "Out of Service", "code": "OUTOFSERV" }, { "name": "Abandoned", "code": "ABANDONED" }, { "name": "Retired", "code": "RETIRED" }, { "name": "Conceptual", "code": "CONCEPTUAL" }, { "name": "Active - Private", "code": "Active - Private" }, { "name": "Active not Closed", "code": "ActiveNotClosed" }, { "name": "Abandoned - Show", "code": "ABANDONED_S" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 15, "domain": { "type": "codedValue", "name": "dOpenClosed", "description": "", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WaterType", "type": "esriFieldTypeString", "alias": "Water Type", "length": 15, "domain": { "type": "codedValue", "name": "dWaterType", "description": "", "codedValues": [ { "name": "Potable", "code": "Potable" }, { "name": "Raw", "code": "Raw" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Cut", "code": "Cut" }, { "name": "Drainage", "code": "Drainage" }, { "name": "Plant", "code": "Plant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": { "type": "codedValue", "name": "dValve Location", "description": "", "codedValues": [ { "name": "NPL", "code": "NPL" }, { "name": "SPL", "code": "SPL" }, { "name": "EPL", "code": "EPL" }, { "name": "WPL", "code": "WPL" }, { "name": "Aux", "code": "Aux" }, { "name": "MPL", "code": "MPL" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SurfaceCondition", "type": "esriFieldTypeString", "alias": "Surface Condition", "length": 25, "domain": { "type": "codedValue", "name": "dSurfaceCondition", "description": "", "codedValues": [ { "name": "Dirt", "code": "Dirt" }, { "name": "Asphalt", "code": "Asphalt" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Landscape", "code": "Landscape" }, { "name": "Other", "code": "Other" }, { "name": "Internal", "code": "Internal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "ServiceArea", "type": "esriFieldTypeString", "alias": "Service Area", "length": 20, "domain": { "type": "codedValue", "name": "dSystem", "description": "", "codedValues": [ { "name": "Denver", "code": "Denver" }, { "name": "MapleGrove", "code": "MapleGrove" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PressureZone", "type": "esriFieldTypeString", "alias": "Pressure Zone", "length": 65, "domain": { "type": "codedValue", "name": "dServiceArea", "description": "", "codedValues": [ { "name": "A-Blue PS #1, #2 & #5", "code": "A-Blue" }, { "name": "B-Blue PS #3", "code": "B-Blue" }, { "name": "C-Green PS #4", "code": "C-Green" }, { "name": "J-Red PS #7", "code": "J-Red" }, { "name": "G-Yellow Gravity East", "code": "G-YellowEast" }, { "name": "H-Yellow Gravity North", "code": "H-YellowNorth" }, { "name": "E-Orange TM-1, Cells A & B", "code": "E-OrangeMapleGroveFP" }, { "name": "N-Orange CP3, PS #10 & #16", "code": "N-OrangeCP3" }, { "name": "Q-Orange Retail - PRV", "code": "Q-OrangeDenverWRetail" }, { "name": "R-Orange Office Park - PRV", "code": "R-OrangeDenverWOfficePark" }, { "name": "K-Orange TM-2, PS #8 & #13", "code": "K-OrangeTM2" }, { "name": "K-Orange CP1, PS #8 & RR PRV", "code": "K-OrangeCP1" }, { "name": "L-Orange CP2, PS #9", "code": "L-OrangeCP2" }, { "name": "S-Orange CP4, PS #17", "code": "S-OrangeCP4" }, { "name": "V-Orange GM, PS #8", "code": "V-OrangeRooneyValley" }, { "name": "F-Orange PS #6 & #12", "code": "F-Orange" }, { "name": "D-Brown SS, PS #5 & #15", "code": "D-Brown" }, { "name": "X-OrangeSol2", "code": "X-OrangeSol2" }, { "name": "Y-OrangeSol3", "code": "Y-OrangeSol3" }, { "name": "Raw Water", "code": "RawWater" }, { "name": "Other System", "code": "Other" }, { "name": "C-1 Green", "code": "C-1" }, { "name": "C-2 Green", "code": "C-2" }, { "name": "T-Light Blue Zone \u2013 PRV", "code": "T-Light Blue Zone \u2013 PRV" }, { "name": "AB-Blue PS #1, #2, #3, & #5", "code": "AB-Blue" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FireDistrict", "type": "esriFieldTypeString", "alias": "Fire District", "length": 10, "domain": { "type": "codedValue", "name": "dFireDistrict", "description": "", "codedValues": [ { "name": "West Metro Fire Protection District", "code": "WMFPD" }, { "name": "Pleasant View Metropolitan District Fire Department", "code": "PVMDFD" }, { "name": "Wheatridge Fire Department", "code": "WRFD" }, { "name": "Golden Fire Department", "code": "GFD" }, { "name": "Arvada Fire Protection District", "code": "AFPD" }, { "name": "Dual Coverage - Pleasant View & West Metro", "code": "DC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SurveyCollection", "type": "esriFieldTypeString", "alias": "Survey Collection", "length": 30, "domain": { "type": "codedValue", "name": "dSurveyCollection", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "CAD", "code": "CAD" }, { "name": "Field Measurements", "code": "FieldMeas" }, { "name": "GPS (Survey Grade)", "code": "GPSSurveyGrade" }, { "name": "GPS (Sub-Meter)", "code": "GPSSubMeter" }, { "name": "Acquisition NO As-Builts", "code": "Acquisition" }, { "name": "As-Built", "code": "Asbuilt" }, { "name": "NOT MAPPED", "code": "NOTMAPPED" }, { "name": "Aerial Imagery", "code": "Aerial" }, { "name": "Leica", "code": "Leica" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": { "type": "codedValue", "name": "ValveManSimple", "description": "List of Valve manufacturers - simplified", "codedValues": [ { "name": "American AVK", "code": "American" }, { "name": "American Flow Control/ American Cast Iron Pipe Company", "code": "AFC/ACIPC" }, { "name": "Clow", "code": "Clow" }, { "name": "EJ", "code": "EJ" }, { "name": "Kennedy", "code": "Kennedy" }, { "name": "Mueller", "code": "Mueller" }, { "name": "U.S. Pipe and Foundry Company", "code": "USP" }, { "name": "Tyler Union", "code": "Tyler" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": { "type": "codedValue", "name": "dValveModel", "description": "", "codedValues": [ { "name": "A-2360 GV (2\" - 12\")", "code": "A-2360" }, { "name": "A-2361 GV (14\" - 48\")", "code": "A-2361" }, { "name": "LineSeal3Class150B (3\" - 48\")", "code": "LineSeal3Class150B" }, { "name": "OS&Y", "code": "OS&Y" }, { "name": "Monoflange Mark II", "code": "MonoflangeII" }, { "name": "T-2360-16", "code": "T236016" }, { "name": "R-2360-6 (2\"-12\")", "code": "R23606" }, { "name": "3211-23", "code": "3211-23" }, { "name": "2003", "code": "2003" }, { "name": "2002", "code": "2002" }, { "name": "2001", "code": "2001" }, { "name": "99", "code": "99" }, { "name": "2000", "code": "2000" }, { "name": "98", "code": "98" }, { "name": "96", "code": "96" }, { "name": "97", "code": "97" }, { "name": "95", "code": "95" }, { "name": "94", "code": "94" }, { "name": "21T", "code": "21T" }, { "name": "93", "code": "93" }, { "name": "42T", "code": "42T" }, { "name": "40T", "code": "40T" }, { "name": "92", "code": "92" }, { "name": "20T", "code": "20T" }, { "name": "39T", "code": "39T" }, { "name": "34T", "code": "34T" }, { "name": "41T", "code": "41T" }, { "name": "91", "code": "91" }, { "name": "28T", "code": "28T" }, { "name": "90", "code": "90" }, { "name": "27T", "code": "27T" }, { "name": "26T", "code": "26T" }, { "name": "87", "code": "87" }, { "name": "89", "code": "89" }, { "name": "14T", "code": "14T" }, { "name": "14-1/2T", "code": "14-1/2T" }, { "name": "22T", "code": "22T" }, { "name": "30-1/2T", "code": "301/2T" }, { "name": "27-1/2T", "code": "271/2T" }, { "name": "24-1/2T", "code": "241/2T" }, { "name": "28-1/2T", "code": "281/2T" }, { "name": "21-1/2T", "code": "211/2T" }, { "name": "20-1/4T", "code": "20-1/4T" }, { "name": "21-1/4T", "code": "21-1/4T" }, { "name": "21-3/4T", "code": "21-3/4T" }, { "name": "40-1/2T", "code": "40_1/2T" }, { "name": "34-1/2T", "code": "34_1/2T" }, { "name": "41-1/2T", "code": "41-1/2T" }, { "name": "33-1/2T", "code": "33-1/2T" }, { "name": "33T", "code": "33T" }, { "name": "39-1/4T", "code": "39-1/4T" }, { "name": "41-1/4T", "code": "41-1/4T" }, { "name": "40-1/4T", "code": "40-1/4T" }, { "name": "29-1/4T", "code": "29-1/4T" }, { "name": "88", "code": "88" }, { "name": "19T", "code": "19T" }, { "name": "49T", "code": "49T" }, { "name": "49-1/2T", "code": "49-1/2T" }, { "name": "15T", "code": "15T" }, { "name": "39-1/2T", "code": "39-1/2T" }, { "name": "20-1/2T", "code": "20-1/2T" }, { "name": "27-1/4T", "code": "27-1/4T" }, { "name": "41-3/4T", "code": "41-3/4T" }, { "name": "28-1/4T", "code": "28-1/4T" }, { "name": "30T", "code": "30T" }, { "name": "29-1/2T", "code": "29-1/2T" }, { "name": "38T", "code": "38T" }, { "name": "20-3/4T", "code": "20-3/4T" }, { "name": "29T", "code": "29T" }, { "name": "27-3/4T", "code": "27-3/4T" }, { "name": "30-1/4T", "code": "30-1/4T" }, { "name": "25-1/4T", "code": "25/1/4T" }, { "name": "40-3/4T", "code": "40-3/4T" }, { "name": "25T", "code": "25T" }, { "name": "25-1/2T", "code": "25-1/2T" }, { "name": "29-3/4T", "code": "29-3/4T" }, { "name": "37T", "code": "37T" }, { "name": "36T", "code": "36T" }, { "name": "35-3/4T", "code": "35-3/4T" }, { "name": "37-1/4T", "code": "37-1/4T" }, { "name": "32T", "code": "32T" }, { "name": "15-1/2T", "code": "15-1/2T" }, { "name": "31T", "code": "31T" }, { "name": "31-1/2T", "code": "31-1/2T" }, { "name": "23-1/2T", "code": "23-1/2T" }, { "name": "37-1/2T", "code": "37-1/2T" }, { "name": "30-3/4T", "code": "30-3/4T" }, { "name": "26-1/2T", "code": "36-1/2T" }, { "name": "38-1/2T", "code": "38-1/2T" }, { "name": "18-1/4T", "code": "18-1/4T" }, { "name": "19-1/2T", "code": "19-1/2T" }, { "name": "15-1/4T", "code": "15-1/4T" }, { "name": "26-1/2T", "code": "26-1/2T" }, { "name": "19-1/4T", "code": "19-1/4T" }, { "name": "26-3/4T", "code": "26-3/4T" }, { "name": "31-1/4T", "code": "31-1/4T" }, { "name": "1980", "code": "1980" }, { "name": "1981", "code": "1981" }, { "name": "150B", "code": "150B" }, { "name": "200W", "code": "200W" }, { "name": "56T", "code": "56T" }, { "name": "17T", "code": "17T" }, { "name": "18T", "code": "18T" }, { "name": "17-1/2T", "code": "17-1/2T" }, { "name": "32-1/2T", "code": "32-1/2T" }, { "name": "#300093", "code": "#300093" }, { "name": "24T", "code": "24T" }, { "name": "38-1/4T", "code": "38-1/4T" }, { "name": "49-1/4T", "code": "49-1/4T" }, { "name": "43T", "code": "43T" }, { "name": "23T", "code": "23T" }, { "name": "25-3/4T", "code": "25-3/4T" }, { "name": "12T", "code": "12T" }, { "name": "9T", "code": "9T" }, { "name": "020L", "code": "020L" }, { "name": "16T", "code": "16T" }, { "name": "44T", "code": "44T" }, { "name": "11T", "code": "11T" }, { "name": "45T", "code": "45T" }, { "name": "64T", "code": "64T" }, { "name": "7-1/2T", "code": "7-1/2T" }, { "name": "22-1/2T", "code": "22-1/2T" }, { "name": "13T", "code": "13T" }, { "name": "53T", "code": "53T" }, { "name": "Series 2500", "code": "Series 2500" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OpenDir", "type": "esriFieldTypeString", "alias": "Open Direction", "length": 10, "domain": { "type": "codedValue", "name": "dTurnDirection", "description": "", "codedValues": [ { "name": "Right", "code": "Right" }, { "name": "Left", "code": "Left" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ValveClass", "type": "esriFieldTypeString", "alias": "Valve Class", "length": 15, "domain": { "type": "codedValue", "name": "dValveClass", "description": "", "codedValues": [ { "name": "System", "code": "System" }, { "name": "Hydrant", "code": "Hydrant" }, { "name": "Fire Line", "code": "FireLine" }, { "name": "Domestic", "code": "Domestic" }, { "name": "Boundary", "code": "Boundary" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SedaruID", "type": "esriFieldTypeString", "alias": "SedaruID", "length": 18, "domain": null }, { "name": "additionalwork", "type": "esriFieldTypeString", "alias": "Additional Work Needed", "length": 50, "domain": { "type": "codedValue", "name": "Valve_AddWork", "description": "", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Valve Replace", "code": "Valve Replace" }, { "name": "Valve Box Replace", "code": "Valve Box Replace" }, { "name": "Valve Nut Missing", "code": "Valve Nut Missing" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NumTurns", "type": "esriFieldTypeString", "alias": "Number of Turns", "length": 5, "domain": null }, { "name": "MeasureDown", "type": "esriFieldTypeSingle", "alias": "Measure Down", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "DepthofMain", "type": "esriFieldTypeSingle", "alias": "DepthofMain", "domain": null }, { "name": "DataValid", "type": "esriFieldTypeString", "alias": "DataValid", "length": 50, "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" } }, { "name": "Accessibility", "type": "esriFieldTypeString", "alias": "Accessibility", "length": 255, "domain": { "type": "codedValue", "name": "dAccessibility", "description": "", "codedValues": [ { "name": "Direct_Bury", "code": "Direct_Bury" }, { "name": "Inside_Building", "code": "Inside_Building" }, { "name": "Inside_Vault", "code": "Inside_Vault" }, { "name": "Inside_Casing", "code": "Inside_Casing" }, { "name": "Exposed", "code": "Exposed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AdditionalWorkType", "type": "esriFieldTypeString", "alias": "AdditionalWorkType", "length": 255, "domain": { "type": "codedValue", "name": "ValveRepairType", "description": "", "codedValues": [ { "name": "Valve Replace", "code": "Valve Replace" }, { "name": "Vavle Box Reset-Replace", "code": "Valve Box Reset-Replace" }, { "name": "Valve Nut Missing/Rounded", "code": "Valve Nut Missing/Rounded" }, { "name": "Other", "code": "Other" }, { "name": "Work Complete", "code": "Work Complete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DataValid_Comment", "type": "esriFieldTypeString", "alias": "Data Valid Comment", "length": 255, "domain": null }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "Date Last Inspected", "length": 8, "domain": null }, { "name": "commentaddwork", "type": "esriFieldTypeString", "alias": "Additonal Work Comment", "length": 255, "domain": null }, { "name": "outofservice", "type": "esriFieldTypeString", "alias": "Out of Service", "length": 255, "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" } }, { "name": "turnstoclose", "type": "esriFieldTypeDouble", "alias": "turnstoclose", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R260_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_260", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_260", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a153_ix1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GIS_PROD.GDB_ADMIN.ValveHistory", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "ValveHistory", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "assetkey", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "Asset Key", "length": 20, "domain": null }, { "name": "workorderid", "type": "esriFieldTypeString", "alias": "Workorder Key", "length": 50, "domain": null }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "Work Date", "length": 8, "domain": null }, { "name": "workby", "type": "esriFieldTypeString", "alias": "Work By", "length": 50, "domain": null }, { "name": "turnstoclose", "type": "esriFieldTypeDouble", "alias": "Turns to Close", "domain": null }, { "name": "hightorque", "type": "esriFieldTypeSmallInteger", "alias": "HighTorque", "domain": null }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "Work Type", "length": 50, "domain": { "type": "codedValue", "name": "ValveWorkType", "description": "", "codedValues": [ { "name": "Valve Maintenance", "code": "Valve Maintenance" }, { "name": "Valve Install/Review/Update", "code": "Valve Install/Review/Update" }, { "name": "Valve Data Update", "code": "Valve Data Update" }, { "name": "Valve Box Dig", "code": "Valve Box Dig" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "attachmentid", "type": "esriFieldTypeInteger", "alias": "AttachmentID", "domain": null }, { "name": "currentlyopen", "type": "esriFieldTypeString", "alias": "CurrentlyOpen", "length": 10, "domain": null }, { "name": "operable", "type": "esriFieldTypeString", "alias": "Operable", "length": 10, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1000, "domain": null }, { "name": "valveboxblown", "type": "esriFieldTypeString", "alias": "Valve Box Blown", "length": 50, "domain": null }, { "name": "statusbefore", "type": "esriFieldTypeString", "alias": "Valve Status Before", "length": 50, "domain": null }, { "name": "operated", "type": "esriFieldTypeString", "alias": "Valve Operated", "length": 50, "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" } }, { "name": "resistance", "type": "esriFieldTypeString", "alias": "Turn Resistance", "length": 50, "domain": { "type": "codedValue", "name": "ValveResistance", "description": "", "codedValues": [ { "name": "Easy", "code": "Easy" }, { "name": "Average", "code": "Average" }, { "name": "Hard", "code": "Hard" }, { "name": "Not Operated", "code": "Not Operated" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "leak", "type": "esriFieldTypeString", "alias": "Leaks Present", "length": 50, "domain": null }, { "name": "currentstatus", "type": "esriFieldTypeString", "alias": "Valves Current Status", "length": 50, "domain": null }, { "name": "valvebox", "type": "esriFieldTypeString", "alias": "Valve Box Condition", "length": 50, "domain": { "type": "codedValue", "name": "ValveBoxStatus", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Repairs Made", "code": "Repairs Made" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "nut", "type": "esriFieldTypeString", "alias": "Nut Condition", "length": 50, "domain": { "type": "codedValue", "name": "ValveOperatingNut", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Rounded", "code": "Rounded" }, { "name": "Missing", "code": "Missing" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "repairreason", "type": "esriFieldTypeString", "alias": "Repair Reason", "length": 250, "domain": null }, { "name": "repairdescription", "type": "esriFieldTypeString", "alias": "Repair Description", "length": 250, "domain": { "type": "codedValue", "name": "ValveRepairType", "description": "", "codedValues": [ { "name": "Valve Replace", "code": "Valve Replace" }, { "name": "Vavle Box Reset-Replace", "code": "Valve Box Reset-Replace" }, { "name": "Valve Nut Missing/Rounded", "code": "Valve Nut Missing/Rounded" }, { "name": "Other", "code": "Other" }, { "name": "Work Complete", "code": "Work Complete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "attachmentid2", "type": "esriFieldTypeInteger", "alias": "AttachmentID", "domain": null }, { "name": "surface", "type": "esriFieldTypeString", "alias": "Surface", "length": 50, "domain": null }, { "name": "debris", "type": "esriFieldTypeString", "alias": "Open Direction", "length": 50, "domain": null }, { "name": "nutcomment", "type": "esriFieldTypeString", "alias": "Debris", "length": 200, "domain": null }, { "name": "sounded", "type": "esriFieldTypeString", "alias": "Nut Comment", "length": 50, "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" } }, { "name": "resistancecomment", "type": "esriFieldTypeString", "alias": "Sounded", "length": 200, "domain": null }, { "name": "otherissue", "type": "esriFieldTypeString", "alias": "Resistance Comment", "length": 200, "domain": null }, { "name": "additionalwork", "type": "esriFieldTypeString", "alias": "Other Issue", "length": 50, "domain": { "type": "codedValue", "name": "Valve_AddWork", "description": "", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Valve Replace", "code": "Valve Replace" }, { "name": "Valve Box Replace", "code": "Valve Box Replace" }, { "name": "Valve Nut Missing", "code": "Valve Nut Missing" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "reviewneeded", "type": "esriFieldTypeString", "alias": "Status Returned", "length": 10, "domain": null }, { "name": "valvecondition", "type": "esriFieldTypeString", "alias": "Valve Condition", "length": 50, "domain": null }, { "name": "MeasureDown", "type": "esriFieldTypeDouble", "alias": "MeasureDown", "domain": null }, { "name": "DataValidComment", "type": "esriFieldTypeString", "alias": "Data Valid Comment", "length": 255, "domain": null }, { "name": "AttachmentID3", "type": "esriFieldTypeInteger", "alias": "AttachmentID3", "domain": null }, { "name": "WorkingHours", "type": "esriFieldTypeInteger", "alias": "WorkingHours", "domain": null }, { "name": "Man_Hours_Breakdown", "type": "esriFieldTypeString", "alias": "Man_Hours_Breakdown", "length": 500, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "length": 38, "domain": null }, { "name": "assetkey2", "type": "esriFieldTypeString", "alias": "assetkey2", "length": 255, "domain": null }, { "name": "DataValid_Comment", "type": "esriFieldTypeString", "alias": "Data Valid Comment", "length": 255, "domain": null }, { "name": "DataValid", "type": "esriFieldTypeString", "alias": "Data Valid", "length": 255, "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" } }, { "name": "commentaddwork", "type": "esriFieldTypeString", "alias": "Additional Work Comment", "length": 255, "domain": null }, { "name": "outofservice", "type": "esriFieldTypeString", "alias": "Out of Service", "length": 255, "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" } } ], "indexes": [ { "name": "R443_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_443", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_443", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GIS_PROD.GDB_ADMIN.wValves", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }