home / transit

Search Bus Stops Near Location

Search Bus Stops Near a Location

Custom SQL query returning 1 row

select s.rowid, s.stop_id, s.stop_name, s.stop_desc, CvtToUsMi(k.distance) as miles from KNN as k join stops as s on (s.rowid = k.fid) where f_table_name = 'stops' AND ref_geometry = MakePoint(cast(:longitude as decimal), cast(:latitude as decimal)) AND max_items=cast(:max as decimal);

Query parameters

rowidstop_idstop_namestop_descmiles
6193 42111 Water St & Myrtle St Near side S 6357.4266460354
Powered by Datasette · Query took 251.189ms