Name: W - Service Connection

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,92,230,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":null}},"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:

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)
• GisId (type: esriFieldTypeInteger, alias: GIS Id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Id (type: esriFieldTypeString, alias: Id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Communal Standpipe: Communal Standpipe], [Other: Other], [Service Connection: Service Connection])
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PhotoNumber (type: esriFieldTypeString, alias: Photo Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1 - Very Good: 1 - Very Good], [2 - Good: 2 - Good], [3 - Fair: 3 - Fair], ... 2 more ...)
• TenderInvoiceNmr (type: esriFieldTypeString, alias: Tender Nmr, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ScanNo (type: esriFieldTypeString, alias: Scan No, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Elevation (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Dark Fibre Africa: Dark Fibre Africa], [Eskom: Eskom], [Municipal: Municipal], ... 7 more ...)
• DataSource (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [As-Built: As-Built], [CAD: CAD], [Field Inspection: Field Inspection], ... 6 more ...)
• Comment (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Contractor (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HistoryOrActive (type: esriFieldTypeString, alias: History or Active, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Active: Active], [History: History], [Proposed: Proposed])
• PointX (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PointY (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AsbuiltHyperlink (type: esriFieldTypeString, alias: Asbuilt Hyperlink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DateCompleted (type: esriFieldTypeDate, alias: Date Completed (Practical), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConsultantPsp (type: esriFieldTypeString, alias: Consultant/Psp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Existing: Existing], [New: New], [Other: Other], ... 2 more ...)
• MeterType (type: esriFieldTypeString, alias: Meter Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Bulk Meter: Bulk Meter], [Normal Meter: Normal Meter], [Other: Other], ... 1 more ...)
• Department (type: esriFieldTypeString, alias: Department (Internal Project), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Cost (type: esriFieldTypeDouble, alias: Cost (R), SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• edited_user (type: esriFieldTypeString, alias: edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• edited_date (type: esriFieldTypeDate, alias: edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: W - Service Connection
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• HistoryOrActive: Active

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/20/2025 9:37:41 AM

Schema Last Edit Date: 2/20/2025 9:37:41 AM

Data Last Edit Date: 6/19/2024 9:23:26 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat