I have three Point file (*.mif); Pole, Switch and Transformer
Pole is the main feature which will be my Output, but I need additional information within pole layer attribute using information from Switch and Transformer layer.
- Pole layer have 3 attribute field: PoleID, Switch and Transformer
- The attribute I will use from Switch layer is SwitchType – (i.e. LV/HV etc.)
- From transformer, I want only the status of availability within pole (Yes / No )
a. I want to search any Switch which is available within 2mtrs buffer to a Pole
b. If switch identified, then I will read the attribute field of the switch; SwitchType – (i.e. LV/HV etc.) and update in the particular Pole attribute in the Switch field.
c. For Transformer, I want to search any Transformer which is available within 2mtrs buffer to a Pole
d. If Transformer Identified, then the Pole attribute field (Transformer) will updated with Yes otherwise No
e. Finally all the poles with updated attributes will import to Oracle
Kindly help me to update these attribute updation using different point layer