Name: Sanitary Service Laterals

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This table contains information describing different types of sanitary service laterals and their locations in the District of Lake Country. A sanitary service lateral is a pipe that takes the wastewater from the individual building to the sanitary main. Each sanitary service lateral is assigned to its unique AssetID for documentation and the purpose of asset management. Along with the properties, the drainage service laterals also have location description, the relevant As-Built Drawings information under the comments, the current status, the ownership information, the important dates and the associated personnels if available.

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:

XMin: 325094.6281
YMin: 5542815.395
XMax: 330605.7719
YMax: 5553940.8775
Spatial Reference: 26911 (26911)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[140,140,140,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

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: [Force: Force], [Gravity: Gravity])
• 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)
• slope (type: esriFieldTypeDouble, alias: Slope (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ABS Plastic: ABS Plastic], [Big O: Big O], [Concrete: Concrete], ... 6 more ...)
• ic_depth_m (type: esriFieldTypeDouble, alias: Inspection Chamber Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hist_asset_id (type: esriFieldTypeString, alias: Historic Asset ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• 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)
• 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)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Sanitary Service Laterals
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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

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

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

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