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
10800 GUADIANA PL SW 35.04471990121 -106.750343692868
2009 HENDOLA DR NE 35.103732124763 -106.557189565841
544 NM 217 35.0383095208211 -106.254642838994
1317 SAWMILL RD NW 35.0989435909473 -106.660806088589
7412 AUTUMN BREEZE RD SW 35.051222312565 -106.718239440092
10900 ARGUELLO TRL NE 35.0772119849819 -106.526075230199
1957 CHANDELLE LOOP NE 35.1044698880065 -106.498394121128
3328 LA VETA DR NE 35.1214888729992 -106.583476756482
4007 WALLACE ST SE 35.0215760330158 -106.653950217451
1211 BLUE QUAIL RD NE 35.0891693932058 -106.487593628866
12508 CATSKILL WY NE 35.1219722209211 -106.498397475954
321 WILSHIRE DR SW 35.0713073390786 -106.668678595337
19 RATTLESNAKE RIDGE 35.1233008453729 -106.324926333531
7824 ACADEMY TRL NE 35.1441629164529 -106.556314920758
623 82ND ST SW 35.0662021739572 -106.727385082859
3308 GRASSY CT SW 35.0258703246824 -106.739318411756
11117 PARIS AV NE 35.1439123029375 -106.517220386075
10 BLUE CORN CT 35.2141854501374 -106.313610320802
3514 LA HACIENDA PL NE 35.0953598503879 -106.605728085285
2809 BARCELONA RD SW 35.0309092131101 -106.699779202166

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query