MongoDB write graph query

Job ID: 31547027

Budget: $25 – $50 USD

Hi All

I have download open street map on (MongoDB and MySql) and it has different tables
nodes
ways
relations

every node can have many ways ..

and so on ...



to help you understand structure here is sample of query as mysql shows


- SELECT * FROM osm.waynodes where id=85191648;
- SELECT * FROM osm.waynodes where nodeid=289242645;
- SELECT * FROM osm.waynodes where id=43068209;

first query is way then it is connected to node then to way then to node then to way .. until achieve my final destination way


I want someone to help write a graph query in mongoDB or "MYSQL" to do from point to point and select best route for this .. either based on time, or distance or whatever

from node
289242645
to
1776112660

Thank you
Related categories: NoSQL Couch & Mongo MySQL