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
3212 MOUNTAINSIDE PKWY NE 35.1170621139667 -106.498012968604
2425 MONROE ST NE 35.1065823665938 -106.591467317834
10231 RED ROBIN RD SW 35.0582936090529 -106.747413820084
107 NORTH ZAMORA RD 35.1013508825727 -106.358211010416
4105 GUAJALOTE ST SW 35.0169292823717 -106.742251619875
99999 4TH ST NW 35.2161115276708 -106.596433996259
99999 RIO ROJO AV SW 35.0263489901943 -106.742309233128
961 FAIRWAY RD NW 35.1498744330432 -106.651470254714
679 BLACK HAWK DR NE 35.1836353889382 -106.488236986406
323 TEXAS ST NE 35.079094044906 -106.55616797562
1515 ROLLING ROCK PL SW 35.0548593689612 -106.721545447383
10411 LAGRANGE PARK DR NE 35.0732948225694 -106.531350419928
1512 LOS ARBOLES AV NW 35.1168558909311 -106.664596740664
10544 TUSCANY DR NW 35.2083740051676 -106.691589199804
8306 LA CAMILA RD NE 35.1178481513744 -106.551877106166
13109 VERBENA PL NE 35.0937635866968 -106.49496478067
1524 PRESTO WY NW 35.1106095792732 -106.667266533308
8912 5TH ST NW 35.1829371117901 -106.62569524312
1520 BRIDGE BLVD SW 35.0659225323905 -106.67576233029
404 DESERT ROCK DR SW 35.0692986041968 -106.74120613218

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query