Layer: Sanitary Valves (ID:53)

View In: Map Viewer

Name: Sanitary Valves

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 10000

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":"type","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[201,182,103,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0}},"defaultLabel":"Unknown","uniqueValueGroups":[{"heading":"","classes":[{"label":"Air","description":"Air","symbol":{"type":"esriPMS","url":"b2ce03c63a587029b0bff059d7a71cc5","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAzUlEQVQokWNhoACwUEVzR5TzBEYGRgOCOv4znC9fvqcQRTNUoz0BrVMYGBlEMWwmAkwpX7YntzPKZQlJmuU09Y5F1vbloosT1Kzn4PHZI7X4dmRtHwNJmjl4eBd6pBZrMTAwvMQmz4JLo76z9y+P5MKEvJkMcxkYGC4Tr5mRYZp7UkE5QzI4RrIZGBj+EKWZkYFheunSPTmMSxn/g/mMjD9wuY4FQ+OyPdmMoKRABEBo/s9w/j8jA1d3tOv0Lnw6/v9/jqEZluRIARRlDAArujS7O+rPSgAAAABJRU5ErkJggg==","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"values":[["Air"]]},{"label":"Check","description":"Check","symbol":{"type":"esriPMS","url":"d1cab0a2e3a1de0cd0d6334c5511e094","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAAQCAYAAADAvYV+AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA/ElEQVQokaXQvSsEcBgH8M9xBmUyKUlyk5ciKSkWyct4JINTNmHhPzCZsFAG2y2kpBgMBk4ZZBLDSUkulBhIN3jNUcQ55Lv8+tWn53n6Bv0hwf/gCkSqSzTl5jjcOjCMs3S4DctYaK9SubitGHHUY+8zHsccegZb3PQ32ygaUIRRdHzEL+88VlK/J8nsLLfYQd3nM+7fJrwm4Gr32AM6MZ2xjf0Tya7J1OoYxjLhYN+MUEG+o+tTYdxlwuWJS3mLI2bDE+/wO/xYVmitNmT9y8o0+KKm1FI8kea+NLg1GjPV25CqsvsnvBppNBR4svmbyefRmOnoS2m/wN/mGbb1Pw1/5APMAAAAAElFTkSuQmCC","contentType":"image/png","width":8,"height":12,"angle":0,"xoffset":0,"yoffset":0},"values":[["Check"]]},{"label":"Gate","description":"Gate","symbol":{"type":"esriPMS","url":"6f08847289f835629c4cf218580ca154","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAMCAYAAABr5z2BAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABd0lEQVQokWNhoBCwwBhnOtLkTCpmPSJG06neLFnTomlPGBkZ/sMNYGRk2HOmK3XqPYUPU8LCVv/FpvF/QwPTOc5nWQx//uQcaGzQYWBo+AM3gOE/4zZGxn/nVB4ILjrdntFjWjnjPLLmcx3p+mcZn5YzMDDOZmD4vwHDCyBgXDbn8P6GhNO8HKzVZzpTw1mZfjR/ZRb5x/77azUD43/mXyw8yVZF/d/PdKa6YzUABBwbFvxgYGCoPd2eYfiHgXMb+79vjIwMjEVGZTPPMGABLNgEz/SkiTD++5f8/9//zYxMDH//MzCkXOzOeKRfOuMVQQPOdaXH/f/334rl/78W/Yo5T0BiF/oypP/8+dd0pivtjHHprLlnu7AY8J/pn8K5zrTZ///9W2NcMTsD2VCDohlPGRgYMk53prue60ybw8jAwI9hANN/xjs/WLlrQYGEzVsgYFo+c/f+hoTDvJysDa+1rv5HMcCofFYJLo3IABrIFTjDgFQAAODVkJgtrVA8AAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":9,"angle":0,"xoffset":0,"yoffset":0},"values":[["Gate"]]},{"label":"Plug","description":"Plug","symbol":{"type":"esriPMS","url":"a359cde9e7e7a3babd91c47f343fc881","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAMCAYAAABr5z2BAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABdUlEQVQokWNhoBCwwBgdcS5yFYv2PCJGU2+Em2zRil1PGBkY/sMNYPzDsKcrynWqwm+BKWGrV//FprGhoYGJ89aRrD8M/3IaHRx0GA4c+AM34D/D/22MTP/PPWB9v6g9wqWncsWe88iaO2Lc9RlvHylnYPg/m4GBcQOGF0CgbMneww0JDqc5frFUd0a5hDMxMzUz//j87zcbdzXj/7/MLL++JhetPv69M8rFHasBINCw4MAPBgaG2vYIF0MGhr/b/rFwMzL8ZSwqW7H7DAMWwIJNsCfSQeQf4//kfwyMm5kYGf4yMDGkdMe6PSpdvOsVQQO6olzi/jEyWv1n+N1SsfTAE5BYX5yT9J+/zE1dka5nSpfvntuFzQAmBkaFzijn2f8YGNZULN2dgWxo0aJ9TxkYGDI6I51dOyNd5jAwMPBjGPD///87rH++1YICCZu3QKB8+d7dDQkOhzl/sTRoiYr+RzGgfPneElwakQE0kCtwhgGpAABrXYran9x88QAAAABJRU5ErkJggg==","contentType":"image/png","width":12,"height":9,"angle":0,"xoffset":0,"yoffset":0},"values":[["Plug"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"b2ce03c63a587029b0bff059d7a71cc5","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAzUlEQVQokWNhoACwUEVzR5TzBEYGRgOCOv4znC9fvqcQRTNUoz0BrVMYGBlEMWwmAkwpX7YntzPKZQlJmuU09Y5F1vbloosT1Kzn4PHZI7X4dmRtHwNJmjl4eBd6pBZrMTAwvMQmz4JLo76z9y+P5MKEvJkMcxkYGC4Tr5mRYZp7UkE5QzI4RrIZGBj+EKWZkYFheunSPTmMSxn/g/mMjD9wuY4FQ+OyPdmMoKRABEBo/s9w/j8jA1d3tOv0Lnw6/v9/jqEZluRIARRlDAArujS7O+rPSgAAAABJRU5ErkJggg==","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"Air","label":"Air"},{"symbol":{"type":"esriPMS","url":"d1cab0a2e3a1de0cd0d6334c5511e094","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAAQCAYAAADAvYV+AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA/ElEQVQokaXQvSsEcBgH8M9xBmUyKUlyk5ciKSkWyct4JINTNmHhPzCZsFAG2y2kpBgMBk4ZZBLDSUkulBhIN3jNUcQ55Lv8+tWn53n6Bv0hwf/gCkSqSzTl5jjcOjCMs3S4DctYaK9SubitGHHUY+8zHsccegZb3PQ32ygaUIRRdHzEL+88VlK/J8nsLLfYQd3nM+7fJrwm4Gr32AM6MZ2xjf0Tya7J1OoYxjLhYN+MUEG+o+tTYdxlwuWJS3mLI2bDE+/wO/xYVmitNmT9y8o0+KKm1FI8kea+NLg1GjPV25CqsvsnvBppNBR4svmbyefRmOnoS2m/wN/mGbb1Pw1/5APMAAAAAElFTkSuQmCC","contentType":"image/png","width":8,"height":12,"angle":0,"xoffset":0,"yoffset":0},"value":"Check","label":"Check"},{"symbol":{"type":"esriPMS","url":"6f08847289f835629c4cf218580ca154","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAMCAYAAABr5z2BAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABd0lEQVQokWNhoBCwwBhnOtLkTCpmPSJG06neLFnTomlPGBkZ/sMNYGRk2HOmK3XqPYUPU8LCVv/FpvF/QwPTOc5nWQx//uQcaGzQYWBo+AM3gOE/4zZGxn/nVB4ILjrdntFjWjnjPLLmcx3p+mcZn5YzMDDOZmD4vwHDCyBgXDbn8P6GhNO8HKzVZzpTw1mZfjR/ZRb5x/77azUD43/mXyw8yVZF/d/PdKa6YzUABBwbFvxgYGCoPd2eYfiHgXMb+79vjIwMjEVGZTPPMGABLNgEz/SkiTD++5f8/9//zYxMDH//MzCkXOzOeKRfOuMVQQPOdaXH/f/334rl/78W/Yo5T0BiF/oypP/8+dd0pivtjHHprLlnu7AY8J/pn8K5zrTZ///9W2NcMTsD2VCDohlPGRgYMk53prue60ybw8jAwI9hANN/xjs/WLlrQYGEzVsgYFo+c/f+hoTDvJysDa+1rv5HMcCofFYJLo3IABrIFTjDgFQAAODVkJgtrVA8AAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Gate","label":"Gate"},{"symbol":{"type":"esriPMS","url":"a359cde9e7e7a3babd91c47f343fc881","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAMCAYAAABr5z2BAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABdUlEQVQokWNhoBCwwBgdcS5yFYv2PCJGU2+Em2zRil1PGBkY/sMNYPzDsKcrynWqwm+BKWGrV//FprGhoYGJ89aRrD8M/3IaHRx0GA4c+AM34D/D/22MTP/PPWB9v6g9wqWncsWe88iaO2Lc9RlvHylnYPg/m4GBcQOGF0CgbMneww0JDqc5frFUd0a5hDMxMzUz//j87zcbdzXj/7/MLL++JhetPv69M8rFHasBINCw4MAPBgaG2vYIF0MGhr/b/rFwMzL8ZSwqW7H7DAMWwIJNsCfSQeQf4//kfwyMm5kYGf4yMDGkdMe6PSpdvOsVQQO6olzi/jEyWv1n+N1SsfTAE5BYX5yT9J+/zE1dka5nSpfvntuFzQAmBkaFzijn2f8YGNZULN2dgWxo0aJ9TxkYGDI6I51dOyNd5jAwMPBjGPD///87rH++1YICCZu3QKB8+d7dDQkOhzl/sTRoiYr+RzGgfPneElwakQE0kCtwhgGpAABrXYran9x88QAAAABJRU5ErkJggg==","contentType":"image/png","width":12,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Plug","label":"Plug"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[242,252,197,255],"toColor":[242,252,197,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[246,179,252,255],"toColor":[246,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,235,252,255],"toColor":[182,235,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,193,192,255],"toColor":[252,193,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,194,252,255],"toColor":[179,194,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,179,255],"toColor":[179,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,252,224,255],"toColor":[189,252,224,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,245,255],"toColor":[252,212,245,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,219,182,255],"toColor":[252,219,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,217,255],"toColor":[252,179,217,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,217,252,255],"toColor":[210,217,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,252,248,255],"toColor":[212,252,248,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[213,179,252,255],"toColor":[213,179,252,255]}]}},"visualVariables":[{"type":"rotationInfo","field":"Rotation","rotationType":"geographic"}]},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field: type

Fields:

objectid (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
assetid (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Air: Air], [Check: Check], [Gate: Gate], ... 2 more ...)
diameter_mm (type: esriFieldTypeInteger, alias: Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [19: 19], [25: 25], [32: 32], ... 24 more ...)
depth_m (type: esriFieldTypeDouble, alias: Depth (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
normallyopen (type: esriFieldTypeString, alias: NormallyOpen, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
valve_status (type: esriFieldTypeString, alias: Valve Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Closed: Closed], [Open: Open], [Partial Closure: Partial Closure])
location (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Abandoned: Abandoned], [Removed: Removed], [Proposed: Proposed], ... 2 more ...)
owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [City of Kelowna: City of Kelowna], [District of Lake Country: District of Lake Country], [Ministry of Transportation: Ministry of Transportation], ... 3 more ...)
installation_date (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Fair: Fair], [Good: Good], ... 1 more ...)
condition_date (type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
rotation (type: esriFieldTypeDouble, alias: Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
mod_date (type: esriFieldTypeDate, alias: Mod Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
mod_by (type: esriFieldTypeString, alias: Mod By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Types:

Field Name: type
Inherited
Field Name: diameter_mm
Inherited
Field Name: normallyopen
Inherited
Field Name: valve_status
Inherited
Field Name: status
Inherited
Field Name: owner
Inherited
Field Name: condition
Inherited

type: Air

Field Name: type
Inherited
Field Name: diameter_mm
Inherited
Field Name: normallyopen
Inherited
Field Name: valve_status
Inherited
Field Name: status
Inherited
Field Name: owner
Inherited
Field Name: condition
Inherited

type: Check

Field Name: type
Inherited
Field Name: diameter_mm
Inherited
Field Name: normallyopen
Inherited
Field Name: valve_status
Inherited
Field Name: status
Inherited
Field Name: owner
Inherited
Field Name: condition
Inherited

type: Gate

Field Name: type
Inherited
Field Name: diameter_mm
Inherited
Field Name: normallyopen
Inherited
Field Name: valve_status
Inherited
Field Name: status
Inherited
Field Name: owner
Inherited
Field Name: condition
Inherited

type: Plug

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/15/2023 10:58:46 PM

Schema Last Edit Date: 12/15/2023 10:58:46 PM

Data Last Edit Date: 12/15/2023 10:58:46 PM

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