Layer: Controllable Valve (ID:200003)

View In: Map Viewer

Name: Controllable Valve

Display Field: assettype

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 20000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"assettype","defaultSymbol":{"type":"esriPMS","url":"33de81c028bbe1fbf43fee07d9a6a611","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADH0lEQVQ4jbWUP2wScRTHv613CX/usOEIV5BILS211fink4NJZ9voglCGM8aGdKmJi4lN3HQwbo3RrYmDN1DMxZimkroYOmhdOikqDLbKHw8LkbvjKIjEoeFyh7RUE7/T/d7v/T6/997v3SPwn0R0c+AFwUP8hIeiLG6lqij41Ss1SGS4QCDzT+BoVDjndjtnGYaZtFgtMJlMLEmQqFQqlbIkifH4aqysSK/CweDLA4F5QfAw1OErx0eGbjidTtZiNhv2GcZuBTDo8w3Ob37evBaPrz4uFr/f4zhO2hPMC4KH7bPfOnli9Ho/y+6XKSxmM8bGRlk7Y5//+Ck1zPP8jB5uADPU4StnT5+6zjB2AMDi4iLy+XxHsMvlQiQSQT/LgiTIgKpWRQBzf4CjUeGcb3DgRgsKAOFwGACQSCSwsbEBABgfH8fExER7eXBswHs1GhWehMOBdQPY7XbOHjniNuRPUVTHaDvZvd6jVrFQuAngsgbmBcHDMMyk/qFWVlagKAoAGMqRTqextLSkXTA1NQVgt+ZOh+N8LBYbC4VCSQIAdvvUGEY6nYYsy39EJsuyZqdp2rBH22i22Txk0yKm+qxUvV63rq2tdUx9L8myDP0Z/8gILBbTcQDrBADIktS3s7ODRCLxV2AAhjO0zQa1pua0iHuahzKKolQAWP+arFPzV7PS+iYAoNGoJtHTo/j9fg2cSqW6gmiahsvl0tZioSA2enuTGpjjOCkeX3188dKl+VZnLCwsdHy8dk1PTwMA1GoVr9+8fcFNXshoYAAoK9KrbDZ3bXjIxwJ797Beep9sNicWS9vLrbUGDgeDL589X35I09TdfpZFJBLpCm7pmyhi68vXp/pJZ5gVFbn84OOn1BmSIAP6X3s/FYslvHv/4aGYz97W2w1gjuMknudnVLUqHhvwXvV6j1rbx2ZLarWKbDYnbn35+lT8Ubq/79hswQHMxWKxR2KhcMfpcJynbTRLkiRIgkS9Xq9sF4uiWPj+oljaXj7woG8pFAolAVzmed5GEOYxirK4m82mTa2puUattt4e4YHBbRmsd/Nr1282IjpWhr5A/wAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"defaultLabel":"Other","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"33de81c028bbe1fbf43fee07d9a6a611","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADH0lEQVQ4jbWUP2wScRTHv613CX/usOEIV5BILS211fink4NJZ9voglCGM8aGdKmJi4lN3HQwbo3RrYmDN1DMxZimkroYOmhdOikqDLbKHw8LkbvjKIjEoeFyh7RUE7/T/d7v/T6/997v3SPwn0R0c+AFwUP8hIeiLG6lqij41Ss1SGS4QCDzT+BoVDjndjtnGYaZtFgtMJlMLEmQqFQqlbIkifH4aqysSK/CweDLA4F5QfAw1OErx0eGbjidTtZiNhv2GcZuBTDo8w3Ob37evBaPrz4uFr/f4zhO2hPMC4KH7bPfOnli9Ho/y+6XKSxmM8bGRlk7Y5//+Ck1zPP8jB5uADPU4StnT5+6zjB2AMDi4iLy+XxHsMvlQiQSQT/LgiTIgKpWRQBzf4CjUeGcb3DgRgsKAOFwGACQSCSwsbEBABgfH8fExER7eXBswHs1GhWehMOBdQPY7XbOHjniNuRPUVTHaDvZvd6jVrFQuAngsgbmBcHDMMyk/qFWVlagKAoAGMqRTqextLSkXTA1NQVgt+ZOh+N8LBYbC4VCSQIAdvvUGEY6nYYsy39EJsuyZqdp2rBH22i22Txk0yKm+qxUvV63rq2tdUx9L8myDP0Z/8gILBbTcQDrBADIktS3s7ODRCLxV2AAhjO0zQa1pua0iHuahzKKolQAWP+arFPzV7PS+iYAoNGoJtHTo/j9fg2cSqW6gmiahsvl0tZioSA2enuTGpjjOCkeX3188dKl+VZnLCwsdHy8dk1PTwMA1GoVr9+8fcFNXshoYAAoK9KrbDZ3bXjIxwJ797Beep9sNicWS9vLrbUGDgeDL589X35I09TdfpZFJBLpCm7pmyhi68vXp/pJZ5gVFbn84OOn1BmSIAP6X3s/FYslvHv/4aGYz97W2w1gjuMknudnVLUqHhvwXvV6j1rbx2ZLarWKbDYnbn35+lT8Ubq/79hswQHMxWKxR2KhcMfpcJynbTRLkiRIgkS9Xq9sF4uiWPj+oljaXj7woG8pFAolAVzmed5GEOYxirK4m82mTa2puUattt4e4YHBbRmsd/Nr1282IjpWhr5A/wAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"0","label":"Unknown"},{"symbol":{"type":"esriPMS","url":"ceb8556966d14d9dd7d42ae842aaeaf9","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADMUlEQVQ4jbWUT2jTYBjGH7cE+iftZlOamVU71w3dJk5xwoSJeBER9FJXikTEMaagMBiCAw9OPYgXD6IHRdzBHGoliE6s3WUHQSfMm53bQJxuzUxdpsvaxM0ueJgNSe3+CT6nfO/35pfn/b43L4H/JGK1BF4Q/MQv+CnKwWa0TAaLJUqOxCQXCk3+EzgaFZpZ1tdB0/QRh9MBm83GkASJbDabnVUUKR5PxGYzykCktbV/TWBeEPw0VXZy+7aaTp/Pxzjsdss+TXucAKqDweru8U/jp+PxRK8sf7vOcZyyLJgXBD9T7rm4o6HufAXDrFQpHHY76uvrGA/t6R4ZHavleb7NDLeAaars5O7Gnedp2gMAuNnfhInv74qCN2/cg65DQ6hgGJAEGVJVTQJw7i9wNCo0B6urOvNQAGjf3wcAeJnswZuP9wAA+4IdONzQU3g82FoVOBWNCg8jkdCgBcyyvo7KStZSv9u+qajbYvFAYItTSqcvADhugHlB8NM0fcR8UbGhM1C0KQCwHEdSfI77r44ZHwg33QWwdOY+r7clFovVh8PhYQIAlvqUoswOkuJzKJr4lzNFE5H8E3fbWcuey+1idL3UbTimyp3UT112JpIPipa+nBRNRCJ5xVg3es/C4bBtBzBIAMCcopSruRK8fN+zLjAAyzuenXuhzqui4XiDXjo5l1GyAJzrJpuk64vZ/DMBALmcNly6yGQa2KMGOCn2rQpy21ls3rjHWKenp6RciXfYAHMcp8Tjid4TBx515zvj8rPKopdXqPb9zwAAqqbh9Zu3L46FDk4aYACYzSgDqZR4urYmyABAma14D5tlzkmlREmemTbKNMCR1tb+J0/7brtc1LUKhkHXoaFVwXl9lSR8/jLx2DzpLLMiOzd7a2R0bBdJkCHzr72SZHkG75MfbktTqUvmuAXMcZzC83ybqmrS1qrAqUBgi7NwbOalahpSKVH6/GXisfRj5saKYzMPB3AuFovdkdLpqz6vt8XldjEkSYIkSCwsLGSnZVmS0t9eyDPTfWse9HmFw+FhAMd5nncThL2eohysrutudV4Vc/Pzg4UO1wwuqGBwtbxC/QahLzp8i5DkxgAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"482","label":"Bypass"},{"symbol":{"type":"esriPMS","url":"be0eb6da295854c815dc894f0ede9e63","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADKElEQVQ4jbWUTWjTYBzGH7NkmjTtZlIalxXbfeGc4geKiHhRLzLQS7cyITLmYQoThiA4EGHqQTwJoge9KBhcrQTRinVednSOedPpRNDNtTPd2rk0SVftqgdNaOucneBzSv553t/7fz/ykPhPIv9mkBXFS36Dl2UZUc/oOhYJLUdhSgoEpv4JHAopu0XR083zfCvjYFBpzgmENgNd1wyDYNRodDA8r2tDHe3tz8oCy4ri5dmqo80bGns9Ho/A0DQAQB+4jfTdfjgAB7/rUH3T6Xt9Hz987IpGB28lkzOXJEnS/giWFcUrVHNnNm/aeHKdICy3UjA0jZaWjQLHc31vx981ybJ8rBBeBObZqqPbt245yfPcstBCrRMEUCQVMM2MCqDnN3AopOxuqPf3lkLnrx9HduRxUW1hJIJEZy0IrgbuK6PgeQ51fl9nKKTc6egIDBeBRdHTXVsrCgAwe2onuHMREFwN8qlpLKbiv3VaWvP51jvUROI0gDYbLCuKl+f5Vuugvr1/WfZWWGJoGh63e284HG4JBoNjJAD8vKcsW2hMD/SveBKnyynk8xUuu2O22sFWrq50FJrMpzdX3DVFUWCYNc0AhkkASGtaNUVSKwYtJTNrxoFfHa/KV0wZhmHwPGd3zRzsBgBkRx4veXhL6Xv+u2E9kwCQy2XGdF3XAdhg55F+EFwN5lKHsThSHng2mVRzBDFmgyVJ0qLRwVv+On8fQ9OgGneUBSqUmclATcw8scLJvsfzujYUi8W7mhobBPeVUXsAwdWgghOLtqOCE+1vlmKxuJpMzUasdxvc0d7+7MHDyDWnk71YmBNVPTeAHkAfOI/03X4AANW4A2vPPbI9n1UVE5Of7hcmXVFWGOn5q2/H322jSCpQbl4kkym8ev3mmjodO1tYLwJLkqTJsnzMNDNqnd/X6fOtd1h/Y6nMTAaxWFydmPx0X/2SurxsbFpwAD3hcPi6mkhc8Ljde50up0DtP4FV9XvwdWHBiCem1bnnL54kU7ORsoPeUjAYHAPQJsuyiyTpFpZlxHw+7zKz2Xjuq2NYOrBP+9PYZcElKxj+m69UPwBvAjlbCWqt1QAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"483","label":"Emergency"},{"symbol":{"type":"esriPMS","url":"b7f96decb4b5b795686a3bf5180db496","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADK0lEQVQ4jbWUTWjTYBzGH2eiS5p2swmNzcraOcU6xe+DyBRE8CBOhLqyQ4ZMYQoKXoQNvMx5EPEmelAcE8yhVoK6Dst28eDQCfPm5hyIH1sz07XTxTRxWjsPmtB2c3aCzynvn//7y/N+PQT+k4i/NUiy7CO+w8cwtKCbuo4fZVqWxIQYCk38EzgSkXcJgqeVZdmDtIPGnP6Jz36egq5rmW8ErcbjfdEZXXvc1NjYXxJYkmUfy1Q0B9evPevxeHiaogAAw1238fJWBwA4hPqGNXs777a/e/uuJR7v606npy6Joqj9ESzJso+vdLdt2rjhzGqeX2yloCkKdXUbeDfrbh99PbZOkqTj+fACMMtUNG/bsvkMy7oXheZrNc+DJMiQYZgqgNPzwJGIvKt2TeBsMXTo8kkoA70FNWUghp6GKpRzXhzoHgLLulET8B+LROQ7TU2hwQKwIHhaq6oEHgD6W3Ziz5UYKM4LMzUJM6XMc1pc8/urHWoyeQ7AURssybKPZdmD1kF9Gn1R8lZYoikKHo6rj0ajdeFweIQAgF/3lGHyG4e7Opb8E6fLyedyy122Y6bSwaxYucKR3/Tmwc0luyZJEjRdHgQwSADAF02rJAlyyaCFZMwaCvDb8bLc8olMJpNhWbftuvZIKwBAGehd8PAW0lxuLmN9EwCQzZojuq7rAGzwxhMdoDgvnqQOwxwoDZxKp9VsWdmIDRZFUYvH+7oDNYF2mqKwKrijJFC+DNOEmpx6ZIWTfY9ndO1xIqG0rFtbyx/oHrInUJwXFCcUbAfFCQCAcs5r1xIJRU1Pp2LW2AY3NTb2338Yu+Z0Mhfzc2Jn2w2gDRjuumCFEFYFd2DPlR6756Oq4v2H8Xv5SVeQFZkvM1dHX49tJQkyVGpepNPTeDn86po6mTifXy8Ai6KoSZJ03DBMtSbgP+b3Vzus11gswzSRSCjq+w/j99TP05cXjU0LDuB0NBq9riaTnR6Oq3e6nDx76BS2B3dj9uvXzJQ6qT599vxRejoVKznoLYXD4REARyVJchEEVccwtJDL5VzG7KySnXMMivv3aX+auyi4aAWDf+sr1k/HojsJNc1A/wAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"485","label":"System"},{"symbol":{"type":"esriPMS","url":"1ae4d2efa979829be79b2f2e32043b2e","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADMUlEQVQ4jbWUTUgUYRjH/+kM7MfsqjvLjo2ba65RavRBBQUZRBAR1GV1ERoRJSxIECRI6JDVIbp0iDoUUYfmsG0MkUbrevEQlIHdXFMhKnXHZnUsx92ZtN2lQ+0ws21+BP1P877vM7/5P8/7zEPgP4lYK4AXBC/xA16KsrFJLZlEpkhJk5jhAoGZfwKHQsJBlvV00DR90ma3wWKxMCRBIpVKpRYVRYpEouHFpDLU3NQ0uC4wLwhemipp2bG9psvj8TA2q9V0TtMuO4Bqv7+659PHT22RSPSRLM/d4DhO+SuYFwQvU+q6tLO+trOcYVbLFDarFXV1tYyLdvWMT0xu43m+3Qg3gWmqpGXv7l2dNO0CAAze2o+v0+8Kgsu27MPx7hGUMwxIggyoqiYBuPAHOBQSDvqrq7pyUABoONsPAIgN9OLDm/sAAP+hDtSf6M0vD7ZW+VpDIeFxc3Ng2ARmWU9HRQVryt/q3FzQbaF9n6/SLiUSFwE06mBeELw0TZ80XtRI+Bw0ZRYATOUQYy/w6sFp/QP7g/cA/Kq5x+0+HA6H64LB4BgBAL/6lKKMDsTYC2iK+IczTRGhxcTfYNZ05nA6mGy22Kk7pkrtVOa7bI9FHxZM/W/SFBGx6FV9Te85D5vNsgPAMAEAS4pSmtaKMDrQuyEwANM7u+gDUJdVUXe8KVs8k1xSUgDsGyYblMlkUrlnAgDSaW0sU8wk2fpTOliM9a8JsjpZlG3Zp6/nErNSusg9poM5jlMikeijI2ee9OQ6o+9KRcHLy1fD2T4AgKppeP3m7Uvu2NEZHQwAi0llKB4X27bV+BkAsJQU7mGjjDHxuCjJC/N6mjq4ualp8Nnz/jsOB3W9nGFwvHtkTXBOXyQJn6emnxonnWlWpJYWb49PTO4hCTJg/LVXkywvYDT2/o40G79s3DeBOY5TeJ5vV1VN2lrla/X5Ku35YzMnVdMQj4vS56npp9K3hZurjs0cHMCFcDh8V0okrnnc7sMOp4MhSRIkQWJlZSU1L8uSlJh7KS/M96970OcUDAbHADTyPO8kCGsdRdnYbDbrVJdVMb28PJzvcN3gvAyG14rL10+Xwjp4+iAOmwAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"486","label":"Meter"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[198,252,184,255],"toColor":[198,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[242,182,252,255],"toColor":[242,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,233,252,255],"toColor":[179,233,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,196,179,255],"toColor":[252,196,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,242,189,255],"toColor":[252,242,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,241,255],"toColor":[252,215,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,197,252,255],"toColor":[184,197,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,252,232,255],"toColor":[204,252,232,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,230,215,255],"toColor":[252,230,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,207,255],"toColor":[252,184,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,220,252,255],"toColor":[212,220,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,230,255],"toColor":[252,182,230,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,207,211,255],"toColor":[252,207,211,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: true

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: globalid

Type ID Field: assettype

Fields:

OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
assettype (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [482: Bypass], [485: System], ... 2 more ...)
creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
adddetails (type: esriFieldTypeSmallInteger, alias: Clockwise to Close, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Counter Clockwise], [1: Clockwise])
devicestatus (type: esriFieldTypeSmallInteger, alias: Device Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
regulatorytype (type: esriFieldTypeSmallInteger, alias: Regulatory Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Distribution], [2: Gathering], ... 3 more ...)
designtype (type: esriFieldTypeSmallInteger, alias: Valve Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Ball], [2: Butterfly], ... 8 more ...)
accessible (type: esriFieldTypeSmallInteger, alias: Accessible, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
turnstoclose (type: esriFieldTypeDouble, alias: Turns to Close, SQL Type: sqlTypeOther, nullable: true, editable: true)
normalposition (type: esriFieldTypeSmallInteger, alias: Normal Position, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 7 more ...)
maopdesign (type: esriFieldTypeDouble, alias: MAOP Design, SQL Type: sqlTypeOther, nullable: false, editable: true, Range: [0 - 10000])
maoptest (type: esriFieldTypeDouble, alias: MAOP Test, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 10000])
maoprecord (type: esriFieldTypeDouble, alias: MAOP Record, SQL Type: sqlTypeOther, nullable: false, editable: true, Range: [0 - 10000])
depth (type: esriFieldTypeDouble, alias: Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
depthtonut (type: esriFieldTypeDouble, alias: Depth to Nut, SQL Type: sqlTypeOther, nullable: true, editable: true)
measuredlength (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
symbolrotation (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
barcode (type: esriFieldTypeString, alias: Barcode, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [0: Unknown], [35: Industrial Pipe Fittings], [73: Plasson], ... 38 more ...)
manufacturerlotno (type: esriFieldTypeInteger, alias: Manufacturer Lot #, SQL Type: sqlTypeOther, nullable: true, editable: true)
manufacturedate (type: esriFieldTypeDate, alias: Manufacture Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
manufacturecomponent (type: esriFieldTypeString, alias: Manufacture Component, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [V0: Other Valve], [V1: Ball Valve], [V2: Butterfly Valve], ... 6 more ...)
material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [A: Plastic PE2406], [B: Plastic PE2708], [C: Plastic PE3408], ... 29 more ...)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
spatialaccuracy (type: esriFieldTypeSmallInteger, alias: Spatial Accuracy, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Greater than 300 Meters], [3: 31-100 Meters], ... 7 more ...)
bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bonded], [2: Insulated])
locationdescription (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
wallthickness (type: esriFieldTypeDouble, alias: Wall Thickness, SQL Type: sqlTypeOther, nullable: true, editable: true)
wallthickness2 (type: esriFieldTypeDouble, alias: Wall Thickness 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
diameter2 (type: esriFieldTypeDouble, alias: Diameter 2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.25: 1/4"], [0.375: 3/8"], ... 29 more ...)
rating (type: esriFieldTypeDouble, alias: Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
specification (type: esriFieldTypeString, alias: Specification, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
remoteoperation (type: esriFieldTypeSmallInteger, alias: Remote Operation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
valvekeysize (type: esriFieldTypeSmallInteger, alias: Valve Key Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: 1], [2: 2], ... 6 more ...)
modelnumber (type: esriFieldTypeString, alias: Model Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
deviceactuatortype (type: esriFieldTypeSmallInteger, alias: Device Actuator Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Pneumatic - Single Acting], [2: Pneumatic - Double Acting], ... 3 more ...)
operatortype (type: esriFieldTypeSmallInteger, alias: Operator Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Manual], [2: Remote])
remotedevicefailtype (type: esriFieldTypeSmallInteger, alias: Remote Device Fail Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Fail to Open], [2: Fail to Close], ... 3 more ...)
ESRIGNSS_POSITIONSOURCETYPE (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_H_RMS (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_V_RMS (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_FIXDATETIME (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ESRIGNSS_FIXTYPE (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
ESRIGNSS_CORRECTIONAGE (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_STATIONID (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 1023])
ESRIGNSS_NUMSATS (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
ESRIGNSS_PDOP (type: esriFieldTypeDouble, alias: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: VDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_DIRECTION (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_SPEED (type: esriFieldTypeDouble, alias: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRISNSR_AZIMUTH (type: esriFieldTypeDouble, alias: Compass reading (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_H_RMS (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_V_RMS (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_POSITIONS (type: esriFieldTypeSmallInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_H_STDDEV (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
cpprotected (type: esriFieldTypeSmallInteger, alias: Cathodically Protected, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])

Types:

Field Name: assettype
Inherited
Field Name: adddetails
Inherited
Field Name: devicestatus
Inherited
Field Name: regulatorytype
Inherited
Field Name: designtype
Inherited
Field Name: accessible
Inherited
Field Name: normalposition
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: maopdesign
Inherited
Field Name: maoptest
Inherited
Field Name: maoprecord
Inherited
Field Name: symbolrotation
Inherited
Field Name: manufacturer
Inherited
Field Name: manufacturecomponent
Inherited
Field Name: material
Inherited
Field Name: spatialaccuracy
Inherited
Field Name: bondedinsulated
Inherited
Field Name: diameter2
Inherited
Field Name: remoteoperation
Inherited
Field Name: valvekeysize
Inherited
Field Name: deviceactuatortype
Inherited
Field Name: operatortype
Inherited
Field Name: remotedevicefailtype
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Field Name: cpprotected
Inherited

designtype: 0
lifecyclestatus: 8
devicestatus: 1
regulatorytype: 0
remoteoperation: 0
deviceactuatortype: 0
operatortype: 0
assettype: 0
accessible: 1
normalposition: 1
maopdesign: 0
manufacturer: 0
manufacturecomponent: 0
spatialaccuracy: 0
diameter2: 0
valvekeysize: 0
remotedevicefailtype: 0

Field Name: assettype
Inherited
Field Name: adddetails
Inherited
Field Name: devicestatus
Inherited
Field Name: regulatorytype
Inherited
Field Name: designtype
Inherited
Field Name: accessible
Inherited
Field Name: normalposition
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: maopdesign
Inherited
Field Name: maoptest
Inherited
Field Name: maoprecord
Inherited
Field Name: symbolrotation
Inherited
Field Name: manufacturer
Inherited
Field Name: manufacturecomponent
Inherited
Field Name: material
Inherited
Field Name: spatialaccuracy
Inherited
Field Name: bondedinsulated
Inherited
Field Name: diameter2
Inherited
Field Name: remoteoperation
Inherited
Field Name: valvekeysize
Inherited
Field Name: deviceactuatortype
Inherited
Field Name: operatortype
Inherited
Field Name: remotedevicefailtype
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Field Name: cpprotected
Inherited

designtype: 0
lifecyclestatus: 8
devicestatus: 1
regulatorytype: 0
remoteoperation: 0
deviceactuatortype: 0
operatortype: 0
maopdesign: 0
maoptest: 0
assettype: 482
accessible: 1
normalposition: 1
maoprecord: 0
manufacturer: 0
manufacturecomponent: 0
spatialaccuracy: 0
diameter2: 0
valvekeysize: 0
remotedevicefailtype: 0

Field Name: assettype
Inherited
Field Name: adddetails
Inherited
Field Name: devicestatus
Inherited
Field Name: regulatorytype
Inherited
Field Name: designtype
Inherited
Field Name: accessible
Inherited
Field Name: normalposition
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: maopdesign
Inherited
Field Name: maoptest
Inherited
Field Name: maoprecord
Inherited
Field Name: symbolrotation
Inherited
Field Name: manufacturer
Inherited
Field Name: manufacturecomponent
Inherited
Field Name: material
Inherited
Field Name: spatialaccuracy
Inherited
Field Name: bondedinsulated
Inherited
Field Name: diameter2
Inherited
Field Name: remoteoperation
Inherited
Field Name: valvekeysize
Inherited
Field Name: deviceactuatortype
Inherited
Field Name: operatortype
Inherited
Field Name: remotedevicefailtype
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Field Name: cpprotected
Inherited

designtype: 0
lifecyclestatus: 8
devicestatus: 1
regulatorytype: 0
remoteoperation: 0
deviceactuatortype: 0
operatortype: 0
maopdesign: 0
maoptest: 0
assettype: 483
accessible: 1
normalposition: 1
maoprecord: 0
manufacturer: 0
manufacturecomponent: 0
spatialaccuracy: 0
diameter2: 0
valvekeysize: 0
remotedevicefailtype: 0

Field Name: assettype
Inherited
Field Name: adddetails
Inherited
Field Name: devicestatus
Inherited
Field Name: regulatorytype
Inherited
Field Name: designtype
Inherited
Field Name: accessible
Inherited
Field Name: normalposition
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: maopdesign
Inherited
Field Name: maoptest
Inherited
Field Name: maoprecord
Inherited
Field Name: symbolrotation
Inherited
Field Name: manufacturer
Inherited
Field Name: manufacturecomponent
Inherited
Field Name: material
Inherited
Field Name: spatialaccuracy
Inherited
Field Name: bondedinsulated
Inherited
Field Name: diameter2
Inherited
Field Name: remoteoperation
Inherited
Field Name: valvekeysize
Inherited
Field Name: deviceactuatortype
Inherited
Field Name: operatortype
Inherited
Field Name: remotedevicefailtype
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Field Name: cpprotected
Inherited

designtype: 0
lifecyclestatus: 8
devicestatus: 1
regulatorytype: 0
remoteoperation: 0
deviceactuatortype: 0
operatortype: 0
assettype: 485
accessible: 1
normalposition: 1
maopdesign: 0
manufacturer: 0
manufacturecomponent: 0
spatialaccuracy: 0
diameter2: 0
valvekeysize: 0
remotedevicefailtype: 0

Field Name: assettype
Inherited
Field Name: adddetails
Inherited
Field Name: devicestatus
Inherited
Field Name: regulatorytype
Inherited
Field Name: designtype
Inherited
Field Name: accessible
Inherited
Field Name: normalposition
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: maopdesign
Inherited
Field Name: maoptest
Inherited
Field Name: maoprecord
Inherited
Field Name: symbolrotation
Inherited
Field Name: manufacturer
Inherited
Field Name: manufacturecomponent
Inherited
Field Name: material
Inherited
Field Name: spatialaccuracy
Inherited
Field Name: bondedinsulated
Inherited
Field Name: diameter2
Inherited
Field Name: remoteoperation
Inherited
Field Name: valvekeysize
Inherited
Field Name: deviceactuatortype
Inherited
Field Name: operatortype
Inherited
Field Name: remotedevicefailtype
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Field Name: cpprotected
Inherited

designtype: 0
lifecyclestatus: 8
devicestatus: 1
regulatorytype: 0
remoteoperation: 0
deviceactuatortype: 0
operatortype: 0
maopdesign: 0
maoptest: 0
assettype: 486
accessible: 1
normalposition: 1
maoprecord: 0
manufacturer: 0
manufacturecomponent: 0
spatialaccuracy: 0
diameter2: 0
valvekeysize: 0
remotedevicefailtype: 0

Relationships:

Controllable_Valve (1) -- Related To: Valve Inspection (1200003)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/19/2021 9:28:30 PM

Schema Last Edit Date: 1/19/2021 9:28:30 PM

Data Last Edit Date: 1/19/2021 9:28:30 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Boxplots Query Related Records Query Attachments Generate Renderer Validate SQL Get Estimates ConvertFormat