Skip to content

Instantly share code, notes, and snippets.

@dphiffer
Created June 14, 2017 13:50
Show Gist options
  • Save dphiffer/39388701370b26441cb70b665f73ed55 to your computer and use it in GitHub Desktop.
Save dphiffer/39388701370b26441cb70b665f73ed55 to your computer and use it in GitHub Desktop.
select * from entity where lat > 37.748212 and lat < 37.7725278668 and lng > -122.431025471 and lng < -122.405240263;
id name instance_of lat lng
Q564339 Central Freeway Q34442 37.77 -122.421
Q4552246 16th Street Mission Station Q55488 37.7648 -122.42
Q4796232 Arroyo Dolores Q618123 37.762638888889 -122.41671111111
Q4943962 Bootie 37.7711 -122.413
Q5116742 Church and 22nd Street Q2175765 37.7549 -122.428
Q5116746 Church and Clipper Q2175765 37.7493 -122.427
Q6056711 Intersection for the Arts Q1007870 37.7658 -122.422
Q7927081 Victoria Theatre, San Francisco Q3469910 37.765 -122.419
Q8033549 Woodward's Gardens 37.768 -122.421
Q14681694 Camp Alert 37.75138889 -122.41611111
Q14684020 Southern Exposure Q163740 37.76804 -122.42274
Q20977858 Aatxe Q11707 37.76669167 -122.43061389
Q7469 Mission District Q123705 37.76 -122.42
Q4631434 22nd Street 37.7548 -122.428
Q4852412 Balmy Alley Q79007 37.7518 -122.412
Q5116737 Church and 14th Street Q2175765 37.7677 -122.429
Q5116739 Church and 16th Street Q2175765 37.7645 -122.429
Q5116741 Church and 24th Street Q2175765 37.7517 -122.427
Q5127018 Clarion Alley 37.763 -122.421
Q5205728 DNA Lounge Q622425 37.771008333333 -122.41269444444
Q7033828 Nightingale House Q41176 37.7718 -122.427
Q7047734 Noisebridge Q163740 37.7624 -122.419
Q7196809 Pioneer Trunk Factory-C. A. Malm & Co. Q655686 37.7625 -122.414
Q7414038 San Francisco Friends School Q3914 37.769 -122.423
Q7729375 The Deaf Club Q811430 37.7643 -122.422
Q19867070 Dance Mission Theater 37.752361 -122.418832
Q22078026 New Mission Theater, San Francisco 37.75622 -122.41909
Q1002264 California's 12th congressional district Q17166756 37.77 -122.42
Q2316537 St.-Matthäus-Kirche (San Francisco) Q811979 37.764432 -122.425882
Q3859226 Mission High School Q9826 37.7618 -122.427
Q5017096 Cafe Du Nord Q17350442 37.7667 -122.43
Q5052096 Catharine Clark Gallery Q33506 37.765732 -122.40656
Q5116718 Church Street Station Q55488 37.767814 -122.429067
Q5116738 Church and 18th Street Q2175765 37.7613 -122.428
Q6541562 Liberty Q55488 37.7572 -122.427
Q7413920 San Francisco Armory Q1412205 37.7678 -122.421
Q7414058 San Francisco LGBT Community Center Q163740 37.77175 -122.42405
Q7440659 Seals Stadium Q1076486 37.766666666667 -122.40916666667
Q7686852 Tartine Q11707 37.7617 -122.424
Q14682453 Immaculate Conception Academy (San Francisco, California) 37.75166667 -122.42333333
Q16984091 Rescue Row Q123705 37.766095 -122.412492
Q11519 Dolores Park Q22698 37.758333333333 -122.4275
Q1000321 Mission San Francisco de Asís Q16970 37.7644 -122.427
Q3445703 Roxie Theater 37.7647 -122.423
Q4630809 20th Street Q55488 37.7582 -122.428
Q4631167 21st Street Q55488 37.7565 -122.427
Q5564622 Girls Club Q41176 37.760833 -122.417222
Q6693515 Lower Haight Q1969642 37.772116 -122.430466
Q7303057 Recreation Park Q1076486 37.7674 -122.423
Q7306286 Redstone Building Q41176 37.7654 -122.418
Q7842937 Trinity Presbyterian Church Q16970 37.766389 -122.416944
Q15266593 Pioneer Race Course Q1076486 37.75138889 -122.41611111
Q16903643 The Women's Building Q163740 37.7614 -122.423
Q1819474 Eureka Valley Q1969642 37.76594 -122.43093
Q4632033 24th Street Mission Station Q55488 37.752 -122.419
Q4644616 826 Valencia Q618123 37.7597 -122.422
Q4686669 Adventures of the Mind 37.759665 -122.421509
Q5036103 Capp Street Project Q811430 37.7658 -122.418
Q5311051 Duboce and Church Q2175765 37.7695 -122.429
Q5523101 Garfield Square Q22698 37.7501 -122.412
Q7745022 The Lab Q1007870 37.765 -122.419
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment