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
99999 BRIDGE BLVD SW 35.068613376956 -106.708497122801
99999 ACADEMY RD NE 35.1567308851175 -106.501535214156
7401 PASEO DEL VOLCAN NW 35.128010323884 -106.788248254004
7636 OAKLAND AV NE 35.185485291027 -106.557995916666
5200 ILIFF RD NW 35.1027321623967 -106.700641925802
1019 MONTE LARGO DR NE 35.0834985731667 -106.491912405907
620 GARDUNO DR NW 35.1825853306524 -106.633667665307
3301 BRITT ST NE 35.1186602049889 -106.526915002347
717 TULANE DR NE 35.0882436987759 -106.606787202701
213 SUNNYSLOPE ST SW 35.0101226764755 -106.66366949868
7109 HEARTH DR NW 35.1652108033434 -106.698403174283
1532 EAGLE RIDGE DR NE 35.1604477243206 -106.48063608339
5737 PARADISE BLVD NW 35.1960557021826 -106.709041513637
1645 MCEWEN CT SW 35.0464716428336 -106.681066528036
509 PONDEROSA AV NW 35.1333000448213 -106.643920958689
6846 ARRINGTON RD SW 34.9659004350227 -106.710562544983
9515 CACHE CREEK DR NW 35.1902024669248 -106.707152008116
744 56TH ST NW 35.0961897374346 -106.702588208433
942 ORTIZ DR SE 35.0658604496332 -106.584910289243
4708 ISLETA BLVD SW 35.0054875142216 -106.688990985198

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query