Name: Water Fittings
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:
XMin: 323929.752
YMin: 5541579.9931
XMax: 332734.227
YMax: 5556962.2827
Spatial Reference: 26911 (26911)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"Type","defaultSymbol":{"type":"esriPMS","url":"4fb48273a824defb7a39c7a09ef5bdf6","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAtUlEQVQokaWSzQ3CMAxGn9suUdYIJ1A3KGtkDbJGWSMjRPTGSjUH95DSPwrvFMny8yc7FX9SbVaTOgAaef0mKAgoDjgdF9j0FgF69VzkcUxQ0qHjeyAABwS9+jG6IdQ8NXCVsC9I6hgIyKxyJ2n8XOhcUOCBejFZQQBu6wJbnF9sNlqSujzFVGATtinpgPNcYItrdwWKy8+aJ9iKPiU7qwmS2mKE1S87QcaeRqIJGolA/DpBxhstZDXXTQBJyAAAAABJRU5ErkJggg==","contentType":"image/png","width":12,"height":10,"angle":0,"xoffset":0,"yoffset":0},"defaultLabel":"Unknown","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"2b4945fca8bf8c57b8b6487561b99e01","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAAPCAYAAAAyPTUwAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABEElEQVQokaXRsUobABCA4e9iIFAEQYfStUO76RBdkkyFFi1YKIgOfYBIx26Cgw+QOZuLD+DYB2iT1OLYpUNA0toOoaCLQrDmHFpIbQwo3vxx/NwV3WGK98MH+dBvJbX45kM+UlRQiR8340vvhB6apmzjM/YmZZQN7YNQNtQcz2jnW8xiScGqdj6X5oU177PrZQxGOA0wJ/wSTqXH+C6cjW+uxa5WvsEDlWjoZN3QQDUa4/hjloUVoa+VNbwQvmplzU+frMflCBfU8Uo6FJ5IzzAtLJixgbMRrtjU8VrJsr6CGccqlkXkeMaBpziyGBfauYQv/8LreOhc2Pp73xNp5/8HjHA1euj9SYouupPxLeYK7rhPO82bljUAAAAASUVORK5CYII=","contentType":"image/png","width":8,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"Blowoff","label":"Blowoff"},{"symbol":{"type":"esriPMS","url":"f1b2da3db31927743e628ebabf62d2bf","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABIklEQVQokaXSO0sDURCG4ffsTZHFaAybQkEEEcTSRpu0trZW+gesBP+CYGMjgmAp2tlKwCqVhdhbGEyxMYu3rBeyy16ORYJJPBuL+MFhYOBhZuAYDBnj33C7KneClFkAN2LqNWLChHhmBM/WCQAmdc7258R1H7xvsbvp4JSbsJYDN4JVG24+IZBQMKAaANAPTQ3pJ3AyDwI4fYL1fPt5ERw+DljVi7C2nDb6naIJtg4PIZYCNcDMUp0sjcHlG0UFZo7qXU1AKtEUmMq/YS2EvElTgTmDuPIOpfFseNcCx8RXoK2RBCmcP8NGoQteYjhuwIoNV363/wOlpH7UQHyl6HsuViIRB3VSBExbhJUPxMIoNQVeLIrlQffddmq5pzf0X/0GDfVVQhyCiZsAAAAASUVORK5CYII=","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Coupler","label":"Coupler"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,197,255,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"Domestic Service","label":"Domestic Service"},{"symbol":{"type":"esriPMS","url":"5a1a629b75dc6f668888c8da2a97bf19","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAKCAYAAACE2W/HAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAV0lEQVQokWNhIBOwUK7xyP8jDIwMbxisGQMwVB39b8DAwHCegYnBlcGScQ+VbBwojU4MR/9fwaKOA7dGRob9DAwML/BYcoHhP8NLTI3WjLXEOhNVI4kAAI1SECTFjlAJAAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":7,"angle":0,"xoffset":0,"yoffset":0},"value":"End Cap","label":"End Cap"},{"symbol":{"type":"esriPMS","url":"a1102c0dc5a08f37d3293ebf3d8f2aee","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAPCAYAAADZCo4zAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAZUlEQVQYlWNhIABYiFNw5H8OAyNDCIrMf4YaBhvGIzATXjMwMPxgYGBwh/IXMDAyfEGYYMO4kuHY/48M/6EKfjFkMjgy/iDBDcNJwTsGBoaDDAwMDAxiDP8wFVgxnmJgYHAg2QoAH9YUg/hhKOsAAAAASUVORK5CYII=","contentType":"image/png","width":6,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"Hydrant Tee","label":"Hydrant Tee"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[38,115,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"Irrigation Service","label":"Irrigation Service"},{"symbol":{"type":"esriPMS","url":"338d755e72fe8a5cbd49ec48e399dbc2","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA6ElEQVQokZ2PP0tCcRiFnzdcbOgO5qC4J5TTb2tLaAuCgprcg3aH/AA1NTgYtNngF1Dair5ANDRGS8S9N4RE6R+Xi6dFoStx+/Os530478nwRzL/EiQVL4dcVD3qZtadhpKKL2M2/YjVpazVvjYUWiHlqocDupLcU8T24SP7rZCFRgmAhDDF3b3rrPFA7SSEQZyyIRLs3bPR7sPH+BejY8HtW/pxQpifg/MKp1cjto59FnvPoDRhQrDmWV6Su3ml3QxY7vS/F4KdHAA+gJldAyuS3EGJo1FMISGYmQ/Y7kzdRFxPe+lHPgHjbk8dPqofFgAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Reducer","label":"Reducer"},{"symbol":{"type":"esriPMS","url":"af988015e4b799a938631baf5fcebdd6","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAATCAYAAABGKffQAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABQUlEQVQokaXQPUhVcRgG8N970hyqpSEaxKUtx0Aoj0NTS4uUIhK09IFTuTn0sTQUtDY2BhVBgzhYgZL3nqAag6D2C00RQh9ePW9DJOnxFtKz/f/8hud9+uwiff+HM0PbtDIe9MaZ4ZWLKlMKI9o5Lt1WxtsmrszipnBDOoxvwpKVPGYsPmyvMSPdsuaefhNGnVd5p3AKDXxI4evmK6LG0V4HzqtdM6Cj/tcaaUa4Kz0UQiuf2+OO4/GiictYxWUrOafwWvii9kyVZ5yIp9tr/Mq6Vf0+KeOsKh9JV/EHbuWQwrLatK7NXaWPGN5ao6tjrwGFWQec8x2LuU8Yx8ut+GSsa+cl6Ykf3giD9nuv9lnX9eaBo7GglUcUTmPOhisOWjQcazvtTBkdj/O+QSPGYr73zr8zGRu40PjfEf8lu8I/Aa5TY9rKnXflAAAAAElFTkSuQmCC","contentType":"image/png","width":8,"height":14,"angle":0,"xoffset":0,"yoffset":0},"value":"Reservoir Overflow/Drain","label":"Reservoir Overflow/Drain"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[217,184,252,255],"toColor":[217,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,252,187,255],"toColor":[192,252,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,200,187,255],"toColor":[252,200,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,238,252,255],"toColor":[192,238,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,242,184,255],"toColor":[252,242,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,202,229,255],"toColor":[252,202,229,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,216,252,255],"toColor":[210,216,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,229,255],"toColor":[179,252,229,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[224,252,215,255],"toColor":[224,252,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,236,212,255],"toColor":[252,236,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,249,255],"toColor":[252,182,249,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,190,252,255],"toColor":[179,190,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,185,255],"toColor":[252,182,185,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:
IsSystemMaintained : True
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: [Blowoff: Blowoff], [Coupler: Coupler], [Domestic Service: Domestic Service], ... 6 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 ...)
- 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)
Types:
ID: Blowoff
Name: Blowoff
Domains:
- Field Name: type
Inherited
- Field Name: diameter_mm
Inherited
- Field Name: status
Inherited
- Field Name: owner
Inherited
- Field Name: condition
Inherited
Templates:
Name: Blowoff
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- type: Blowoff
- status: In Service-Active
ID: Coupler
Name: Coupler
Domains:
- Field Name: type
Inherited
- Field Name: diameter_mm
Inherited
- Field Name: status
Inherited
- Field Name: owner
Inherited
- Field Name: condition
Inherited
Templates:
Name: Coupler
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
ID: Domestic Service
Name: Domestic Service
Domains:
- Field Name: type
Inherited
- Field Name: diameter_mm
Inherited
- Field Name: status
Inherited
- Field Name: owner
Inherited
- Field Name: condition
Inherited
Templates:
Name: Domestic Service
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
ID: End Cap
Name: End Cap
Domains:
- Field Name: type
Inherited
- Field Name: diameter_mm
Inherited
- Field Name: status
Inherited
- Field Name: owner
Inherited
- Field Name: condition
Inherited
Templates:
Name: End Cap
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
ID: Hydrant Tee
Name: Hydrant Tee
Domains:
- Field Name: type
Inherited
- Field Name: diameter_mm
Inherited
- Field Name: status
Inherited
- Field Name: owner
Inherited
- Field Name: condition
Inherited
Templates:
Name: Hydrant Tee
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
ID: Irrigation Service
Name: Irrigation Service
Domains:
- Field Name: type
Inherited
- Field Name: diameter_mm
Inherited
- Field Name: status
Inherited
- Field Name: owner
Inherited
- Field Name: condition
Inherited
Templates:
Name: Irrigation Service
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
ID: Reducer
Name: Reducer
Domains:
- Field Name: type
Inherited
- Field Name: diameter_mm
Inherited
- Field Name: status
Inherited
- Field Name: owner
Inherited
- Field Name: condition
Inherited
Templates:
Name: Reducer
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
ID: Reservoir Overflow/Drain
Name: Reservoir Overflow/Drain
Domains:
- Field Name: type
Inherited
- Field Name: diameter_mm
Inherited
- Field Name: status
Inherited
- Field Name: owner
Inherited
- Field Name: condition
Inherited
Templates:
Name: Reservoir Overflow/Drain
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- type: Reservoir Overflow/Drain
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/12/2021 10:45:06 PM
Schema Last Edit Date: 1/12/2021 10:45:06 PM
Data Last Edit Date: 1/12/2021 10:45:06 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat