Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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 )

Condition:

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

share|improve this question
add comment

2 Answers 2

I would use the NeighborFinder transformer. This would let you search for items within a 2 metre radius and would add the attributes of any feature it finds within that distance.

For example:

workspace

The trick is to get the output from both MATCHED and UNMATCHED output ports, as not every pole will have a switch or transformer within your 2m distance.

I've used separate NeighborFinders for each search. I think this will work better. With one NeighborFinder you'd have to handle the Switch/Transformer as a list and this would not be as simple.

share|improve this answer
    
Thanks Brad and Mark for your response; @ Mark, I used the NeighborFinder as you mentioned above, but I am getting all the Poles having Transformer and Switch. I'm confused how to set the Unit '2m'? It might be silly but really I am confused ! –  Nihar Jun 27 '13 at 3:52
    
Just enter 2 in the maximum distance. The "m" part is assumed by whatever coordinate system you are using. –  Mark Ireland Jun 27 '13 at 13:57
    
Thanks Mark, I rebuild the process and it works –  Nihar Jun 30 '13 at 23:28
add comment

If the switch attribute on pole matches the value of switch found within 2 mtrs?
I would perform a join of switch table to pole using switch as key field for one to one join keep only matching.
Then the same for transformer.
Using copy attribute transformer each time to end up with one table to load into oracle.

share|improve this answer
    
Thank you Brad, Actually there is no such field to match between Pole and Switch or Pole with Transformer. the only input is 2mt radius. I am new to FME so if you describe in details will be really great. –  Nihar Jun 27 '13 at 4:04
    
I thought the fields you mentioned on pole were related to the other tables. "•Pole layer have 3 attribute field: PoleID, Switch and Transformer" –  Brad Nesom Jun 27 '13 at 18:17
    
otherwise fme will do the trick. –  Brad Nesom Jun 27 '13 at 18:17
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.