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 LUCCA AV SW 34.969386195807 -106.702506226005
2149 GLORIETA ST NE 35.1069560471183 -106.5358044499
13 ROBINHOOD RD 34.9882058688617 -106.340128868962
0 35.1025238361985 -106.302819631593
307 ALAMO AV SE 35.0560259330531 -106.64936946198
10300 GREEN MEADOWS DR NW 35.2023653705024 -106.685484926201
42 BEARCAT RD 34.9437419258168 -106.283095315494
9301 SUNDORO PL NW 35.0954729341526 -106.74339685355
908 3RD ST SW 35.0761254385782 -106.651738702565
1801 FLORIDA ST NE 35.0948245883469 -106.573480280551
12308 CASA GRANDE AV NE 35.0891797120608 -106.511382648967
813 SOLAR RD NW 35.1482893031483 -106.648055828589
6305 ANNAPOLIS DR NE 35.1513065426001 -106.527850524502
4 RAMPART RD 35.016493905061 -106.3511925409
9706 AVENIDA DEL OSO NE 35.1450052984091 -106.533980942387
58 ROCK POINT PL NE 35.1870062485583 -106.48067140307
6712 CISCO RD NW 35.1276683245515 -106.716321905534
2001 CIRCULO DEL MONTE NE 35.1039727406993 -106.491091182087
7844 VIA VISTA MESA NW 35.1963723911994 -106.747448455421
10706 BENITO ST SW 35.0482169326779 -106.75088734312

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query