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
12009 MODESTO AV NE 35.1890201400592 -106.505044550109
215 PRINCETON DR SE 35.0779974009235 -106.616168655136
99999 PAJARITO RD SW 34.9911639178121 -106.730343351153
10409 CARTAGENA AV SW 35.0444442358833 -106.747362789136
99999 EDITH BLVD NE 35.1653845002677 -106.621026943414
511 CORDOVA AV NW 35.1149406636292 -106.648705663407
4122 COLIBRI ST SW 35.0156881822503 -106.745438447784
909 TIJERAS AV NW 35.0881631638708 -106.657557947221
12 EQUESTRIAN CT 35.0852992282252 -106.286645306833
1326 OLD US 66 35.0906108646379 -106.273865516576
1123 TONY SANCHEZ DR SE 35.0593578456929 -106.524101119821
2509 RIO ORILLA LA NW 35.1688632071668 -106.664706190512
2713 MORTON LA SW 34.9819198248367 -106.713559610222
9 TIGER RD 35.1045928398228 -106.259590904435
1809 QUIET LA SW 35.0592935546655 -106.681772343322
216 RAVEN RD 34.9760981314745 -106.349519099066
4617 LARIAT AV NW 35.1550895462904 -106.691797848961
99999 WILSHIRE AV NE 35.1819662010092 -106.576203013814
817 CLAUDINE ST NE 35.0858107994801 -106.521529450885
10317 JENARO ST SW 35.0550209977605 -106.747457170566

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query