Name: Minisub Inspections (2017)

Display Field: Facility_Description

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 45c3659220c14a34b5a956b57471595d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -59495.433699999936
YMin: -3770118.5322000002
XMax: 12479.178000000305
YMax: -3725455.277
Spatial Reference: PROJCS["Hartebeesthoek94_Lo23",GEOGCS["GCS_Hartebeesthoek_1994",DATUM["D_Hartebeesthoek_1994",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",23.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: State_of_Audit
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 0, 0, 153]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 1
  Label: Recent Inspection
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [38, 115, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: Was Inspected
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [204, 204, 204, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 3
  Label: Incomplete Inspection
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 13
Font Family: Calibri
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 15000.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Facility_Description ( type: esriFieldTypeString, alias: Facility Description / Name (Label), length: 255 )
• MS_Supplier ( type: esriFieldTypeString, alias: Name of Minisub Supplier, length: 50 )
• Street_Address ( type: esriFieldTypeString, alias: Street Address, length: 255 )
• Load_Centre ( type: esriFieldTypeSmallInteger, alias: Load Centre )
• Location_Type ( type: esriFieldTypeSmallInteger, alias: Estate or Business Property , Coded Values: [0: Unknown] , [1: Council Property] , [2: Sidewalk] , ...4 more... )
• Load_Type ( type: esriFieldTypeSmallInteger, alias: Load Type , Coded Values: [1: Residential] , [2: Industrial] , [3: Rural] , ...6 more... )
• Bulk_ ( type: esriFieldTypeSmallInteger, alias: Bulk , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Switching_Station ( type: esriFieldTypeString, alias: Switching Station, length: 255 )
• Supply_From ( type: esriFieldTypeSmallInteger, alias: Supply From , Coded Values: [0: Unknown] , [1: LC] , [2: DS] , ...1 more... )
• MS_Enclosure ( type: esriFieldTypeSmallInteger, alias: MS Enclosure , Coded Values: [0: Unknown] , [1: Indoor] , [2: Sidewalk - Open] , ...5 more... )
• MS_Plinth ( type: esriFieldTypeSmallInteger, alias: MS Plinth , Coded Values: [0: Unknown] , [1: Concrete] , [2: Bricks] , ...1 more... )
• MS_Enclosure_Colour ( type: esriFieldTypeSmallInteger, alias: MS Enclosure Colour , Coded Values: [0: Unknown] , [1: Avo] , [2: Brown] , ...4 more... )
• Switchgear_Serial_Number ( type: esriFieldTypeString, alias: MV Switchgear Serial Number, length: 255 )
• Switchgear_Make ( type: esriFieldTypeString, alias: MV Switchgear Make, length: 255 )
• Switchgear_Type ( type: esriFieldTypeString, alias: MV Switchgear Type, length: 255 )
• Switchgear_Year ( type: esriFieldTypeString, alias: MV Switchgear Year of Manufacture, length: 255 )
• Switchgear_Insulating_Medium ( type: esriFieldTypeSmallInteger, alias: MV Switchgear Insulating Medium , Coded Values: [0: Not Known] , [1: Oil] , [2: SF6] , ...1 more... )
• Switchgear_Trfr_Rating ( type: esriFieldTypeString, alias: MV Switchgear Trfr Rating (A), length: 255 )
• Switchgear_Cable_Rating ( type: esriFieldTypeString, alias: MV Switchgear Cable Feeder Rating (A), length: 255 )
• Switchgear_ShortTime ( type: esriFieldTypeSmallInteger, alias: MV Switchgear Short Time (seconds) , Coded Values: [0: Unknown] , [1: 1s] , [3: 3s] )
• Switchgear_Short_Time_Current ( type: esriFieldTypeString, alias: MV Switchgear Short Time Current (kA), length: 255 )
• Switchgear_Fault_Level ( type: esriFieldTypeString, alias: MV Switchgear Fault Level (MVA), length: 255 )
• Switchgear_Max ( type: esriFieldTypeSmallInteger, alias: MV Switchgear Max System Voltage (kV) )
• Switchgear_BIL ( type: esriFieldTypeString, alias: MV Switchgear BIL (kV), length: 255 )
• MV_Protection_TRF ( type: esriFieldTypeSmallInteger, alias: MV Protection Type for Trfr , Coded Values: [1: Fuses] , [0: Unknown] , [2: CBs] )
• MV_Make_Protection ( type: esriFieldTypeString, alias: MV Make of protection (relay if applicable), length: 255 )
• MV_Protection_Size ( type: esriFieldTypeString, alias: MV Protection Size / Setting, length: 255 )
• MV_Through_Fault_Indicator ( type: esriFieldTypeSmallInteger, alias: MV Through Fault Indicator , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• MV_Feeder1 ( type: esriFieldTypeString, alias: MV Feeder 1 Label (left), length: 255 )
• MV_Feeder1_Position ( type: esriFieldTypeSmallInteger, alias: MV Feeder 1 Position , Coded Values: [0: Unknown] , [1: Open] , [2: Close] , ...1 more... )
• MV_Feeder2 ( type: esriFieldTypeString, alias: MV Feeder 2 Label (right), length: 255 )
• MV_Feeder2_Position ( type: esriFieldTypeSmallInteger, alias: MV Feeder 2 Position , Coded Values: [0: Unknown] , [1: Open] , [2: Close] , ...1 more... )
• Maximum_Demand_P1 ( type: esriFieldTypeString, alias: Maximum Demand (A) - Phase 1, length: 255 )
• Maximum_Demand_P2 ( type: esriFieldTypeString, alias: Maximum Demand (A) - Phase 2, length: 50 )
• Maximum_Demand_P3 ( type: esriFieldTypeString, alias: Maximum Demand (A) - Phase 3, length: 50 )
• LV_Main_Protection ( type: esriFieldTypeSmallInteger, alias: LV Main Protection , Coded Values: [0: Unknown] , [1: 1P CB's] , [3: 3P CB's] , ...1 more... )
• LV_Rating ( type: esriFieldTypeString, alias: Rating of LV Main Protection (A), length: 255 )
• LV_Curve ( type: esriFieldTypeString, alias: Protection curve of main LV Protection, length: 255 )
• LV_Feeder1 ( type: esriFieldTypeString, alias: LV Feeder 1 Label, length: 255 )
• LV_Feeder1_Rating ( type: esriFieldTypeString, alias: LV Feeder 1 CB Rating, length: 50 )
• LV_Feeder1_Curve ( type: esriFieldTypeString, alias: LV Feeder 1 Protection Curve, length: 50 )
• LV_Feeder1_CableSize ( type: esriFieldTypeSmallInteger, alias: LV Feeder 1 Cable Size , Coded Values: [0: Unknown] , [1: Cable LV 4²mm 4 core] , [2: Cable LV 10²mm 2 core] , ...24 more... )
• LV_Feeder2 ( type: esriFieldTypeString, alias: LV Feeder 2 Label, length: 255 )
• LV_Feeder2_Rating ( type: esriFieldTypeString, alias: LV Feeder 2 CB Rating, length: 50 )
• LV_Feeder2_Curve ( type: esriFieldTypeString, alias: LV Feeder 2 Protection Curve, length: 50 )
• LV_Feeder2_CableSize ( type: esriFieldTypeSmallInteger, alias: LV Feeder 2 Cable Size , Coded Values: [0: Unknown] , [1: Cable LV 4²mm 4 core] , [2: Cable LV 10²mm 2 core] , ...24 more... )
• LV_Feeder3 ( type: esriFieldTypeString, alias: LV Feeder 3 Label, length: 255 )
• LV_Feeder3_Rating ( type: esriFieldTypeString, alias: LV Feeder 3 CB Rating, length: 50 )
• LV_Feeder3_Curve ( type: esriFieldTypeString, alias: LV Feeder 3 Protection Curve, length: 50 )
• LV_Feeder3_CableSize ( type: esriFieldTypeSmallInteger, alias: LV Feeder 3 Cable Size , Coded Values: [0: Unknown] , [1: Cable LV 4²mm 4 core] , [2: Cable LV 10²mm 2 core] , ...24 more... )
• LV_Feeder4 ( type: esriFieldTypeString, alias: LV Feeder 4 Label, length: 255 )
• LV_Feeder4_Rating ( type: esriFieldTypeString, alias: LV Feeder 4 CB Rating, length: 50 )
• LV_Feeder4_Curve ( type: esriFieldTypeString, alias: LV Feeder 4 Protection Curve, length: 50 )
• LV_Feeder4_CableSize ( type: esriFieldTypeSmallInteger, alias: LV Feeder 4 Cable Size , Coded Values: [0: Unknown] , [1: Cable LV 4²mm 4 core] , [2: Cable LV 10²mm 2 core] , ...24 more... )
• LV_Feeder5 ( type: esriFieldTypeString, alias: LV Feeder 5 Label, length: 255 )
• LV_Feeder5_Rating ( type: esriFieldTypeString, alias: LV Feeder 5 CB Rating, length: 50 )
• LV_Feeder5_Curve ( type: esriFieldTypeString, alias: LV Feeder 5 Protection Curve, length: 50 )
• LV_Feeder5_CableSize ( type: esriFieldTypeSmallInteger, alias: LV Feeder 5 Cable Size , Coded Values: [0: Unknown] , [1: Cable LV 4²mm 4 core] , [2: Cable LV 10²mm 2 core] , ...24 more... )
• LV_Feeder6 ( type: esriFieldTypeString, alias: LV Feeder 6 Label, length: 50 )
• LV_Feeder6_Rating ( type: esriFieldTypeString, alias: LV Feeder 6 CB Rating, length: 50 )
• LV_Feeder6_Curve ( type: esriFieldTypeString, alias: LV Feeder 6 Protection Curve, length: 50 )
• LV_Feeder6_CableSize ( type: esriFieldTypeSmallInteger, alias: LV Feeder 6 Cable Size , Coded Values: [0: Unknown] , [1: Cable LV 4²mm 4 core] , [2: Cable LV 10²mm 2 core] , ...24 more... )
• Streetlighting_Equipment ( type: esriFieldTypeSmallInteger, alias: Streetlighting Equipment , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Customer_Metering ( type: esriFieldTypeSmallInteger, alias: Customer Metering , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Maximum_Demand_P2_copy ( type: esriFieldTypeString, alias: Maximum Demand (A) - Phase 2, length: 50 )
• Maximum_Demand_P3_copy ( type: esriFieldTypeString, alias: Maximum Demand (A) - Phase 3, length: 50 )
• TRF_Serial_Number ( type: esriFieldTypeString, alias: TRF Serial Number, length: 255 )
• TRF_Make ( type: esriFieldTypeString, alias: TRF Make, length: 255 )
• TRF_Year ( type: esriFieldTypeString, alias: TRF Year of Manufacture, length: 255 )
• TRF_Rating ( type: esriFieldTypeSmallInteger, alias: TRF Rating , Coded Values: [0: Unknown] , [50: 50kVA] , [75: 75kVA] , ...13 more... )
• TRF_Voltage_HV ( type: esriFieldTypeString, alias: TRF Voltage HV (kV), length: 255 )
• TRF_Voltage_LV ( type: esriFieldTypeString, alias: TRF Voltage LV (kV), length: 255 )
• TRF_Impedance ( type: esriFieldTypeString, alias: TRF Impedance (Z), length: 255 )
• TRF_Ph ( type: esriFieldTypeSmallInteger, alias: TRF Ph )
• TRF_Vector_Group ( type: esriFieldTypeString, alias: TRF Vector Group, length: 255 )
• TRF_Oil_Quantity ( type: esriFieldTypeString, alias: TRF Oil Quantity, length: 255 )
• TRF_Cooling ( type: esriFieldTypeString, alias: TRF Cooling, length: 255 , Coded Values: [0: Other] , [1: Air Natural] , [2: Air Blast] , ...4 more... )
• TRF_TAP_Position ( type: esriFieldTypeSmallInteger, alias: TRF TAP Position , Coded Values: [0: Not Known] , [1: 1] , [2: 2] , ...3 more... )
• LV_Nominal_Tap ( type: esriFieldTypeSmallInteger, alias: LV Nominal Tap (V) , Coded Values: [380: 380V] , [400: 400V] , [415: 415V] , ...2 more... )
• Condition ( type: esriFieldTypeSmallInteger, alias: Criticality - Condition , Coded Values: [0: Very Good] , [1: Good] , [2: Fair] , ...3 more... )
• RUL ( type: esriFieldTypeSmallInteger, alias: Criticality - RUL , Coded Values: [35: 35-43-50] , [23: 23-29-35] , [13: 13-18-23] , ...3 more... )
• H_S ( type: esriFieldTypeSmallInteger, alias: Criticality - H&S , Coded Values: [1: No Effect] , [2: Single illness/injury] , [3: Loss of life or multiple illness/injury] , ...1 more... )
• Service_Delivery ( type: esriFieldTypeSmallInteger, alias: Criticality - Service Delivery , Coded Values: [1: No Effect] , [2: Minor Impact] , [3: Major Imapct] , ...1 more... )
• Evironment ( type: esriFieldTypeSmallInteger, alias: Criticality - Environment )
• Data_Confidence ( type: esriFieldTypeSmallInteger, alias: Criticality -Data Confidence , Coded Values: [1: Accurate] , [2: Minor Inaccuracies] , [3: 50% Estimated] , ...3 more... )
• Con_Safety ( type: esriFieldTypeSmallInteger, alias: Condition - Safety, security & accessibility , Coded Values: [0: Unknown] , [1: Safe; secure; excellent fence (if applicable) and padlocked; decent access] , [2: Relatively safe and secure; fence in decent state (if applicaeble) and still padlocked; decent access] , ...2 more... )
• Con_Env ( type: esriFieldTypeSmallInteger, alias: Condition - Environment & cleaniness , Coded Values: [0: Unknown] , [1: New, clean and clear] , [2: Fairly clean and clear] , ...2 more... )
• Con_Tank ( type: esriFieldTypeSmallInteger, alias: Condition - Corrosion of Tank , Coded Values: [0: Unknown] , [1: None] , [2: Slight] , ...2 more... )
• Con_Oil ( type: esriFieldTypeSmallInteger, alias: Condition - Trf Oil Leaks , Coded Values: [0: Unknown] , [1: None] , [2: Slight] , ...2 more... )
• Con_RMU ( type: esriFieldTypeSmallInteger, alias: Condition - Corrosion of RMU , Coded Values: [0: Unknown] , [1: None] , [2: Slight] , ...2 more... )
• Con_RMUOil ( type: esriFieldTypeSmallInteger, alias: Condition - Oil Leaks of RMU , Coded Values: [0: Unknown] , [1: None] , [2: Slight] , ...2 more... )
• Con_Theft ( type: esriFieldTypeSmallInteger, alias: Condition - Damage/ Theft , Coded Values: [0: Unknown] , [1: None] , [2: Slight] , ...2 more... )
• Photo_Wide_Angle ( type: esriFieldTypeSmallInteger, alias: Have you taken a wide angle photo? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_Front ( type: esriFieldTypeSmallInteger, alias: Have you taken a front photo? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_Back ( type: esriFieldTypeSmallInteger, alias: Have you taken a back photo? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_Side_1 ( type: esriFieldTypeSmallInteger, alias: Have taken a photo of Side 1? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_Side_2 ( type: esriFieldTypeSmallInteger, alias: Have taken a photo of Side 2? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_Plinth ( type: esriFieldTypeSmallInteger, alias: Have taken a photo of the Plinth? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_Trfr_nameplate ( type: esriFieldTypeSmallInteger, alias: Have taken a photo of the Trfr nameplate? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_RMU_Nameplate ( type: esriFieldTypeSmallInteger, alias: Have taken a photo of the RMU Nameplate? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_MV_Protection ( type: esriFieldTypeSmallInteger, alias: Have taken a photo of the MV Protection? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_MV_Feeders ( type: esriFieldTypeSmallInteger, alias: Have taken a photo of the MV Feeders? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_LV_Compartment ( type: esriFieldTypeSmallInteger, alias: Have taken a photo of the LV Compartment? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_Max_Demand_Meter ( type: esriFieldTypeSmallInteger, alias: Have taken a photo of the Max Demand Meter? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_LV_Feeders ( type: esriFieldTypeSmallInteger, alias: Have taken a photo of the LV Feeders? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• Photo_Streetlights ( type: esriFieldTypeSmallInteger, alias: Have taken a photo of the Streetlights? , Coded Values: [0: Yes] , [1: No] , [2: In Process] )
• State_of_Audit ( type: esriFieldTypeSmallInteger, alias: State of Audit , Coded Values: [0: Unknown] , [1: Recent Inspection] , [2: Was Inspected] , ...1 more... )
• Assessor_Comments ( type: esriFieldTypeString, alias: Assessor Comments, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 50 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata