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
3615 CAMINO ALAMEDA SW 35.0222631701202 -106.692940088401
9701 CENTRAL AV NE 35.0730947566022 -106.53965206984
1009 CAROL ST NE 35.0896475445783 -106.531381889766
2 PONDER PINE RD 35.01271418385 -106.347499214508
515 TULANE DR SE 35.0725319741979 -106.607427518335
1245 HUPMOBILE DR NE 35.0882676253218 -106.494670952454
1646 RANCHO GUADALUPE TRL NW 35.138595376485 -106.660185203995
4512 TRES VISTAS RD NW 35.1498906126084 -106.689834104666
417 PALOMAS DR SE 35.0745894389349 -106.583283363128
528 MANISTEE ST SE 35.0637931820605 -106.517887804342
8116 CAYENNE DR NW 35.1724864229895 -106.71615128349
1413 GIRARD BLVD SE 35.0662520495239 -106.613518082876
7010 LUELLA ANNE DR NE 35.1562929946606 -106.567988522882
621 CLAUDINE ST NE 35.0809987636419 -106.521918157847
2629 JEFFERSON ST NE 35.1103769673137 -106.593039306366
4700 CENTRAL AV SE 35.0780720026824 -106.592092632672
9211 HAINES AV NE 35.1001608074772 -106.542069896499
100 PHEASANT HILL DR NE 35.1214769286527 -106.494436610178
3714 CANDELARIA RD NE 35.1162806591789 -106.600941007128
0 35.0717357988857 -106.764844028273

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query