MongoDB write graph query
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
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