def test_within_distance(self):
r1 = session.query(Road).filter(Road.road_name=='Jeff Rd').one()
r2 = session.query(Road).filter(Road.road_name=='Graeme Ave').one()
r3 = session.query(Road).filter(Road.road_name=='Geordie Rd').one()
roads_within_distance = session.query(Road).filter(
Road.road_geom.within_distance(r1.road_geom, 0.20)).all()
ok_(r2 in roads_within_distance)
ok_(r3 not in roads_within_distance)
eq_(session.scalar(functions.within_distance('POINT(-88.9139332929936 42.5082802993631)', 'POINT(-88.9139332929936 35.5082802993631)', 10)), True)
def test_within_distance(self):
r1 = session.query(Road).filter(Road.road_name=='Jeff Rd').one()
r2 = session.query(Road).filter(Road.road_name=='Graeme Ave').one()
r3 = session.query(Road).filter(Road.road_name=='Geordie Rd').one()
roads_within_distance = session.query(Road).filter(
Road.road_geom.within_distance(r1.road_geom, 0.20)).all()
ok_(r2 in roads_within_distance)
ok_(r3 not in roads_within_distance)
eq_(session.scalar(functions.within_distance('POINT(-88.9139332929936 42.5082802993631)', 'POINT(-88.9139332929936 35.5082802993631)', 10)), True)
def test_issue17(self):
r1 = session.query(Road).filter(Road.road_name=='Jeff Rd').one()
lakes_within_distance = session.query(Lake).filter(
Lake.road.has(functions._within_distance(Road.road_geom,r1.road_geom, 0.20))).all()
lakes_within_distance = session.query(Lake).filter(
Lake.road.has(functions.within_distance(Road.road_geom,r1.road_geom, 0.20))).all()
def test_issue17(self):
r1 = session.query(Road).filter(Road.road_name=='Jeff Rd').one()
lakes_within_distance = session.query(Lake).filter(
Lake.road.has(functions._within_distance(Road.road_geom,r1.road_geom, 0.20))).all()
lakes_within_distance = session.query(Lake).filter(
Lake.road.has(functions.within_distance(Road.road_geom,r1.road_geom, 0.20))).all()
