Layer: Sanitary Fittings (ID:175)

View In: Map Viewer

Name: Sanitary Fittings

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This table contains information describing different types of sanitary fittings and their locations in the District of Lake Country. Sanitary fittings have different functions. For example, an end cap is used to cap the the end of the pipe and a reducer is used to reduce the pipe size from a larger to smaller inner diameter. Each fitting is assigned to a unique AssetID for documentation and the purpose of asset management. Along with their physical properties, the sanitary fittings also have location description, relevant As-Built information in the comments, the ownership information, the current status, important dates, as well as the associated personnels.

Copyright Text: District of Lake Country, Regional District of Central Okanagan

Min. Scale: 0

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,255],"width":0}},"defaultLabel":"Unknown","uniqueValueGroups":[{"heading":"","classes":[{"label":"Coupling","description":"Coupling","symbol":{"type":"esriPMS","url":"cbffe67b9e28dcdc5062c11c66d3d97b","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABW0lEQVQoka2TMUhCQRzGv7t87+XT0lIhKEIMCRwKgsoWaWmKJGiXIFsLgqbWaGhqsO2VY605NLSVBrlUQy4KSYIRUoSU2dO8Cx8kxaUQ9o13/Ph/9/2/M6ENmf4FPtOCl9W350FwhvJLQQH/IIzVCKUdHFTi5i6XDlBIak8uEI6N/YDr4FTowJE+3YE3sArVPoDbCw0efxjlYh6ZeMTqDazgPLpAfrHNkLs6xOjcNkAa94bMtn6MzG4hk4gAnIu29dKT7JlcEsCGCIF7PIR0fFcWJ3MOyWxvGZDUaUM9EwHmzSaKFiDA5NtbWouLMAiFXnqEYnE2xd5fCyCUcgFWLM5KNrmP4ek1ECp2h9WqyCajkNXeqjgZgHtiEdexdQz5l9Hd52ucFx9Sxs59MxvI3xyJtuvNSezNG2ncp45lxnQKxpA62QQ1KUyxOCpxLQjF6roT4K/K/UVtfYxPKPtv623+Pf4AAAAASUVORK5CYII=","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"values":[["Coupling"]]},{"label":"Deflection","description":"Deflection","symbol":{"type":"esriPMS","url":"953b39ecbf7ccf0b0852909d33dc7158","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAxElEQVQokY2SPwrCMBSHv6GXMIPg4iIIktmlIDi0q5OTYHONCuLmLNVjtJN3aK/gFiguegLlBVu0VuxvCOHlfe9vPL6lAA1YIG8+em937Y+IJwOC2Rjmu9qeAWET0CufeLsgaMkYvLKpGpDIP5wr9YAEMAIoKYP/iipAS80dFQpgyxvQ7wRYAfLy3jlD7po+nMmW0799HOVwwOVKaE7YZO2m0RoZ2NSAKM1RPEiGiqgxBIkszrKLj02TFhgKzD5zm239Gk+v1i1n3OgZogAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"values":[["Deflection"]]},{"label":"End Cap","description":"End Cap","symbol":{"type":"esriPMS","url":"126df87222bcdb9310430904566d563c","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAAPCAYAAAAyPTUwAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAfUlEQVQokWNhIAGwkKV4RQFDNQMDgya6AkYGhnvhExjqUBT/Z2BwZWRgsEdX/J+R4SwDA5pi5qcMzqLaIIMQ4OUHhjdYnRG2muEvw2pUU1cU4HAzMWBIK16Zz7DuPyODFZo8H1bF/5kYnjL8Z7iDphjEv4GhOKKfIZeqbgYAr8UZ1ZXRqrgAAAAASUVORK5CYII=","contentType":"image/png","width":8,"height":11,"angle":0,"xoffset":0,"yoffset":0},"values":[["End Cap"]]},{"label":"Reducer","description":"Reducer","symbol":{"type":"esriPMS","url":"286ba2b532a5fd3488aa6c9931c4de77","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABCUlEQVQokWNhIBOwUKzx////xgwMDGmMjIzp2BT+///fl4GB4SwjI+MzdBvTjswLTPv///8WRkbGzUga0r59fJp1eVuNvpiq8w0GBgZNDKf++PQc2Xbjjy+u5Z5Znanz4NQChr9/fjAIyZkw4/Ojz7vHZ9Ju7OtieHJxLcP////w+xEEvn96znBgukvay1t7iQ8cEPj35yfDt/ePCGrC0MgtpMDglHek6eGZxTF3jk5XevfoNAMugOFHJiaWM0rmSfWgAHp2bcuy24enqL24sZOwRhhgZGQ8y8DAoA4y4PW9Q313j860Y/j/7zU2jY0uBSdAEQyPQyQD7KFRhGkjNEXMIuACwk4lBACXNHDtDE/lfAAAAABJRU5ErkJggg==","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"values":[["Reducer"]]},{"label":"Tee","description":"Tee","symbol":{"type":"esriPMS","url":"111c7a8dea3d7f24b9e9a39c9bf80f1b","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAPCAYAAADZCo4zAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAbklEQVQYlWNhIABYiFKwIp8h5z8jQwiyBPN/hpqwiQxHwAr+MzC8ZmRg+MHAwOAOlV/AwMjwBW5C5ESGlcsKGT4y/Yco+C7AkJnYANZApBuGjwIWBoZ3fxkYDoLY3AwM/zAUhPUznGJgYHAg2QoAn5YY0H1fUI0AAAAASUVORK5CYII=","contentType":"image/png","width":6,"height":11,"angle":0,"xoffset":0,"yoffset":0},"values":[["Tee"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"cbffe67b9e28dcdc5062c11c66d3d97b","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABW0lEQVQoka2TMUhCQRzGv7t87+XT0lIhKEIMCRwKgsoWaWmKJGiXIFsLgqbWaGhqsO2VY605NLSVBrlUQy4KSYIRUoSU2dO8Cx8kxaUQ9o13/Ph/9/2/M6ENmf4FPtOCl9W350FwhvJLQQH/IIzVCKUdHFTi5i6XDlBIak8uEI6N/YDr4FTowJE+3YE3sArVPoDbCw0efxjlYh6ZeMTqDazgPLpAfrHNkLs6xOjcNkAa94bMtn6MzG4hk4gAnIu29dKT7JlcEsCGCIF7PIR0fFcWJ3MOyWxvGZDUaUM9EwHmzSaKFiDA5NtbWouLMAiFXnqEYnE2xd5fCyCUcgFWLM5KNrmP4ek1ECp2h9WqyCajkNXeqjgZgHtiEdexdQz5l9Hd52ucFx9Sxs59MxvI3xyJtuvNSezNG2ncp45lxnQKxpA62QQ1KUyxOCpxLQjF6roT4K/K/UVtfYxPKPtv623+Pf4AAAAASUVORK5CYII=","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"Coupling","label":"Coupling"},{"symbol":{"type":"esriPMS","url":"953b39ecbf7ccf0b0852909d33dc7158","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAxElEQVQokY2SPwrCMBSHv6GXMIPg4iIIktmlIDi0q5OTYHONCuLmLNVjtJN3aK/gFiguegLlBVu0VuxvCOHlfe9vPL6lAA1YIG8+em937Y+IJwOC2Rjmu9qeAWET0CufeLsgaMkYvLKpGpDIP5wr9YAEMAIoKYP/iipAS80dFQpgyxvQ7wRYAfLy3jlD7po+nMmW0799HOVwwOVKaE7YZO2m0RoZ2NSAKM1RPEiGiqgxBIkszrKLj02TFhgKzD5zm239Gk+v1i1n3OgZogAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Deflection","label":"Deflection"},{"symbol":{"type":"esriPMS","url":"126df87222bcdb9310430904566d563c","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAAPCAYAAAAyPTUwAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAfUlEQVQokWNhIAGwkKV4RQFDNQMDgya6AkYGhnvhExjqUBT/Z2BwZWRgsEdX/J+R4SwDA5pi5qcMzqLaIIMQ4OUHhjdYnRG2muEvw2pUU1cU4HAzMWBIK16Zz7DuPyODFZo8H1bF/5kYnjL8Z7iDphjEv4GhOKKfIZeqbgYAr8UZ1ZXRqrgAAAAASUVORK5CYII=","contentType":"image/png","width":8,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"End Cap","label":"End Cap"},{"symbol":{"type":"esriPMS","url":"286ba2b532a5fd3488aa6c9931c4de77","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABCUlEQVQokWNhIBOwUKzx////xgwMDGmMjIzp2BT+///fl4GB4SwjI+MzdBvTjswLTPv///8WRkbGzUga0r59fJp1eVuNvpiq8w0GBgZNDKf++PQc2Xbjjy+u5Z5Znanz4NQChr9/fjAIyZkw4/Ojz7vHZ9Ju7OtieHJxLcP////w+xEEvn96znBgukvay1t7iQ8cEPj35yfDt/ePCGrC0MgtpMDglHek6eGZxTF3jk5XevfoNAMugOFHJiaWM0rmSfWgAHp2bcuy24enqL24sZOwRhhgZGQ8y8DAoA4y4PW9Q313j860Y/j/7zU2jY0uBSdAEQyPQyQD7KFRhGkjNEXMIuACwk4lBACXNHDtDE/lfAAAAABJRU5ErkJggg==","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Reducer","label":"Reducer"},{"symbol":{"type":"esriPMS","url":"111c7a8dea3d7f24b9e9a39c9bf80f1b","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAPCAYAAADZCo4zAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAbklEQVQYlWNhIABYiFKwIp8h5z8jQwiyBPN/hpqwiQxHwAr+MzC8ZmRg+MHAwOAOlV/AwMjwBW5C5ESGlcsKGT4y/Yco+C7AkJnYANZApBuGjwIWBoZ3fxkYDoLY3AwM/zAUhPUznGJgYHAg2QoAn5YY0H1fUI0AAAAASUVORK5CYII=","contentType":"image/png","width":6,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"Tee","label":"Tee"}],"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: [Coupling: Coupling], [Deflection: Deflection], [End Cap: End Cap], ... 3 more ...)
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)
projectid (type: esriFieldTypeString, alias: ProjectID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
mod_date (type: esriFieldTypeDate, alias: Mod Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
mod_by (type: esriFieldTypeString, alias: Mod By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
cre_date (type: esriFieldTypeDate, alias: Create Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
cre_by (type: esriFieldTypeString, alias: Create By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
old_assetid (type: esriFieldTypeString, alias: Old AssetID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
rdco_link (type: esriFieldTypeString, alias: Link to RDCO Doc Mgt, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
depth_m (type: esriFieldTypeDouble, alias: Depth (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
location (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
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: status
Inherited
Field Name: owner
Inherited
Field Name: condition
Inherited

type: Coupling

Field Name: type
Inherited
Field Name: status
Inherited
Field Name: owner
Inherited
Field Name: condition
Inherited

type: Deflection

Field Name: type
Inherited
Field Name: status
Inherited
Field Name: owner
Inherited
Field Name: condition
Inherited

type: End Cap

Field Name: type
Inherited
Field Name: status
Inherited
Field Name: owner
Inherited
Field Name: condition
Inherited

type: Reducer

Field Name: type
Inherited
Field Name: status
Inherited
Field Name: owner
Inherited
Field Name: condition
Inherited

type: Tee

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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

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

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

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