Advice For Storing Locations Then Finding Locations Along A Route

I'm building an app that helps truck drivers navigate and find places to eat or park according to their preferences. I will store maybe 100,000 locations (truck stops, rest areas, restaurants, etc) in neo4j. I will get a route (likely from Google Routes API or elsewhere) for the driver and then find locations along that route based on the driver's preferences.

I'm unsure how to store the data for locations and then efficiently query that data. One suggestion was to convert the driver's route polyline to an array of coordinates and look for any locations within, say, two miles of any point in that array of coordinates.

I'm new to Neo4j. I'm using Aura, accessing it through Python.

How would you guys go about this? I don't need detailed code examples at this point, just the general approach:

  • Where should I get the routing information (Google Maps, OpenStreetMap, others)?
  • How should I structure the location data?
  • What approach should I take for finding places along the driver's route?

Just looking for a more general approach at this point before diving further into the specifics of coding it.

I sure appreciate it!

I have no insight on this matter, but I found these articles. Maybe they give you ideas.

Thanks, @glilienfield, I'll look into those. I appreciate it.

1 Like