NOTE: This page is experimental. Bug reports to carter.barry@gmail.com. Query language is SQLite3.

Prepend rss. to the URL for an RSS feed, csv. to the URL for CSV output.

QUERY: SELECT full_address AS Address, centroid_lat AS Latitude, centroid_lon AS Longitude FROM abqaddresses ORDER BY RANDOM() LIMIT 20

To edit query (or if query above is munged), see textbox at bottom of page

Empty result may indicate error: I'm not sure why my error checking code isn't working.

Source code

Address Latitude Longitude
2520 ALGODONES ST NE 35.1123523227199 -106.511796787818
6334 CASTLE DOME PL NW 35.202565143768 -106.72237644368
4624 ARLINGTON AV NW 35.1891669889483 -106.679829941901
500 FREEMAN AV NW 35.1284373399461 -106.644772203112
12400 MOUNTAINSIDE WY NE 35.1209694704341 -106.499814103875
10815 FORT POINT LA NE 35.0779734665059 -106.527296087791
7008 VISTA DEL SOL DR NW 35.1654592092176 -106.728618293983
99999 POWERS WY SW 34.9631822222008 -106.733668065152
4100 CENTRAL AV SE 35.0787805728876 -106.598250686582
106 PAA-KO DR 35.1909435200246 -106.318903235957
425 VASSAR DR SE 35.0738006177774 -106.614932978514
2901 EUCLID AV NE 35.1036470303324 -106.613510936865
3003 SIOUX ST NW 35.1142352896855 -106.662726820287
9536 CANTARIELLO CT NW 35.0936241797492 -106.745830532647
4619 VALLEY PARK DR SW 35.0084333810642 -106.708302679042
2105 LAKEVIEW RD SW 35.0153755817584 -106.695855815681
939 COREL DR SW 35.0583257562902 -106.725127955009
1650 RANCHO GUADALUPE TRL NW 35.1389308757287 -106.660404843034
9900 STOUGHTON PL NW 35.1933664697932 -106.731724958806
4417 GLENWOOD HILLS DR NE 35.1290522314694 -106.491192851241

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query