I want to add from excel file start and end point that are in Meters, to the road network(which is complex) and create line from it. attaching sample shapefile and excel file. Join field is RoadName.
Does anyone solved such case? All suggestion will be very helpful.
Thanks a lot.
Hi @gisgis2014devel
To replace a point you can use the transformer VertexCreator and for do a Join between value of attributes, you can use the FeatureMerger.
Thanks in Advance,
Danilo
Hi @gisgis2014devel As you say, your road network is quite complex. If it was just three lines - B1, B2 & B3 then the next step would be to add measures with a MeasureGenerator, then join the Excel data as @danilo_fme suggested, and finally create the lines with a Snipper. If you could identify the ends of the lines then you could use a ShortestPathFinder to create a single line from the input features. Or if accuracy isn't necessary then you could buffer each road and then use a CenterLineReplacer to recreate it. But even then you will still need to determine which end is the start of each road. Hopefully you have some other data for that.
Hi @gisgis2014devel As you say, your road network is quite complex. If it was just three lines - B1, B2 & B3 then the next step would be to add measures with a MeasureGenerator, then join the Excel data as @danilo_fme suggested, and finally create the lines with a Snipper. If you could identify the ends of the lines then you could use a ShortestPathFinder to create a single line from the input features. Or if accuracy isn't necessary then you could buffer each road and then use a CenterLineReplacer to recreate it. But even then you will still need to determine which end is the start of each road. Hopefully you have some other data for that.
Hi, thank you for your reply. No I don't have other data.