Skip to main content
  • EN

hello guys

i am finding a solution to join excel files related to stations on highways

each excel file had the specific data for stations ( 1- shops 2- car services 3- motel,toilets etc) including coordinates for each related service.

there is no unique id for station on which i can join them except the coordinates.

each station has 3 to 4 points having attributes for services.

and the distance between points varies as per accuracy on the device some time it comes within 50 meters and some time more than 100 meters according to the area of stations.

i tried the buffer in arcgis but it not covers all and some time if the distance between two stations less joins the two stations as one

 

is there any way i can join points related to each station with out having overlap and not joining stations from one side of road to the other side as some time there is station on both sides of the road infront of each other..

also i want to create station id for each station

If you need an accuracy of 100 meters and you may have stations at the same spot but opposite sides of the road you can run into trouble there.

Looking at your data I get the impression there is one station point for each location and then corresponding points for standards and restaurants. You can use an AnchoredSnapper with the stations as anchors to get all points for one station at the same location and do a PointOnPointOverlay or SpatialRelator from there.

@mehar There is a great article, Merging or Joining Spatial Data, that can help you find the most appropriate transformer to do a spatial join.

In this case, I think the NeighborFinder might be what you could use. The NeighborFinder can create a list of the nearest candidate points to the Base (stations). You can use the Listexploder to split the merged candicates (standards, restaurants) into separate features for 1:m cases

I've attached an example workspace (2019.1): nearestneighbor.fmwt

Community Stats

31,952
Posts
121,340
Replies
39,564
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.