I have download open street map on (MongoDB and MySql) and it has different tables
every node can have many ways ..
and so on ...
to help you understand structure here is sample of query as mysql shows
- SELECT * FROM [login to view URL] where id=85191648;
- SELECT * FROM [login to view URL] where nodeid=289242645;
- SELECT * FROM [login to view URL] 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