Python query optimization

Question

I constructed a python query to look for all the bus routes passing by a given box. However, I need to speed up the query as much as possible. I only need the lat/lon coordinates of each node representing the bus stops and the name of the routes that they belong to. My current code:

import requests

overpass_url = "http://overpass-api.de/api/interpreter"

bbox = [48.87542724909715, 2.1707384550740683, 48.88884184835508, 2.1821696229817267]
bbox_str = '('+str(bbox)[1:-1]+')'

overpass_query = '''
[out:json];
(
relation'''+bbox_str+'''['route'='bus'];
);
out body;
>;
out skel;
'''

response = requests.get(overpass_url, params={'data': overpass_query})
data = response.json()

Answer 1

I don't know if it is more efficient and/or faster but you could search for every bus stop in a given bounding box and then recurse back to the relations that have that stop as member:

[out:json][timeout:25];

// query part for: “highway=bus_stop”
node["highway"="bus_stop"]({{bbox}})->.stops;

foreach.stops ->.s(

  //get the route (stop must be a member!)
  rel(bn.s)[type=route]->.r;

  //produce output
  make stop name = s.u(t["name"]),
  lat = s.u(lat()), 
  lon = s.u(lon()),
  lines = r.set(t["ref"]);

  //print
  out meta;     
);

Python query optimization

Follow this question

Related questions