Name: Borehole Components

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":"esriPMS","url":"576d6964116af13c9f8ba8e74ea89c9a","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAALCAYAAABLcGxfAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAmUlEQVQokZWQsQ3CMBBFn5GXyBUskTVCH1nQhjWyBm6DED1zsESKW8PINpIVOUHhN5bO9/7dfcufsqvViw7pncTvA2Ag0AI7gOiem+GsN+5y3QactgTGxSSnnoe81wETRjBNXeNUA9Hd0FUrGtOlv++UAmT3+vyoAy9ACpAPrd2LmtQzibf0cyRz7r+Uw/CW51FxuohuU/0sH7XnK0X3dzflAAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":8,"angle":0,"xoffset":0,"yoffset":0}},"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: [Electrical: Electrical], [Instrumentation: Instrumentation], [Mechanical: Mechanical], ... 3 more ...)
• 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)
• Type2 (type: esriFieldTypeString, alias: Type 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Base Steel Panel: Base Steel Panel], [Casing: Casing], [Chlorinator: Chlorinator], ... 21 more ...)
• Class (type: esriFieldTypeString, alias: Class, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [4: 4], [6: 6], [9: 9], ... 7 more ...)
• Diameter (type: esriFieldTypeString, alias: Diameter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DutyPoint (type: esriFieldTypeDouble, alias: Duty Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Power (type: esriFieldTypeSmallInteger, alias: Power (kW), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Speed (type: esriFieldTypeSmallInteger, alias: Speed (RPM), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowRate (type: esriFieldTypeDouble, alias: Flow Rate (litres per second), SQL Type: sqlTypeOther, 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 ...)
• 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: Borehole Components
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/14/2024 8:51:39 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