GIS QAQC PROCESS FOR ELECTRICITY DISTRIBUTION USING ARC MAP

 

RAW DATA

• On the cloud: Click on the needed data
• Click on layer
• Click on export
• From the dialogue box, select ESRI shape file format

LT POLES QAQC

• Symbology: Unique values, value field - Upriser number; Label field - lt_pole_number
• Select all the LT poles on an upriser (work from upriser 1 upwards) 
• Use advanced sorting and sort by upriser_nu, lt_pole_number, pole_from and pole_to in ascending order
• Move LT poles away from roads and from building vectors and ensure they are close to customers
• Confirm the DSS id - same for all poles, upriser number, feeder type/id - must be the same for all the poles, is_it_pole (disconnected poles have ‘0’ value for pole from), number of must be 1, Road name must end with road, 

CUSTOMER 1ST LEVEL FME

• Import extracted customer file into the FME 1st level workflow
• Add reader
• Select format: Esri shape file
• 3 dots, navigate to folder
• ok
• Drag to data input
• Connect to ‘convert date time’
• Add the raw data
• Add issue log file if needed
• Writers on the tab
• Enable/disable feature type
• Unchecked all boxes (for 1st level)
• Scroll to the right end, 
• FME output folder
• Output file
• Enable
• 3rd icon to select host folder
• 3 dots
• Select DSS name
• Click on setting icon to change name: DSSName_Cleared
• Run

CUSTOMER QAQC

• Symbology: Unique values, Unique values, many; value fields - Connection status & Upriser number, Add All Values; Label - lt_pole_number (For DSS: Unique value; Value field - DSS type; Label - DSS name.
• Advanced sorting: upriser_nu, lt_pole_id, service_po, customer_n
• Columns to focus on: connection, upriser no, lt pole id, service point, customer no, linked cus, gis index, database_m, apartment, billornobill, customer type, meter type,
• INDIRECT: Customer number = 0, 
• DIRECT: Service point number from a new pole must begin with 1, Customer number should be serial according to upriser, GIS index = 0, 
• NOT CONNECTED: GIS index is blank, service point is 0, Customer number =0, 
• QUERIES: Check for Database matches: Not matched, Matched_juice: customer type - Metered, MeterType - Prepaid, Odoo_: Customer Type - Unmetered, Meter Type - Postpaid , Unistar: Customer Type - Metered, Meter Type - Prepaid, EMS: Customer Type - Metered, Meter Type - Postpaid; database_m = ‘not matched’ AND Direct = Connection. “phase_and_” = 1p2w - voltage level = 6, 2p3w - voltage level = 6, 3p4p - voltage level = 5; building_t: All bungalows must have ’number of flo’ as 1, duplexes must be 2, blocks of flat must specify their flat number under apartment FLAT 1 - 3, same goes for shops, stores and offices, building_u: special sub_use - 10, residential sub_use - 7 and number of - 8, commercial sub_use - 1 number_of varies, industrial sub_use - 6 Bill or no bill: Make sure ‘Duplicate Account’ is with title case sensitive, work to reduce duplicate account or not matched account, 

CREATE SHAPE FILE

• Catalog
• Right click on DSS folder worked on
• Select new
• Select shape file
• Specify the name, feature type - polygon
• click on edit
• Select geographic coordinate system
• Select world, double click on world
• WGS 1984, then ok, ok 
• Right click on the shape file, edit features for vectorization