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
5204 WHITE RESERVE AV SW 35.0754366225029 -106.693551235201
1826 GALENA ST SE 35.0646066329839 -106.646689417657
6729 LAMAR AV NW 35.1464843833361 -106.718226159083
137 BUCKBOARD RD 34.9581184625504 -106.312527506804
911 WASHINGTON ST SE 35.063669146938 -106.595008008481
11900 LOMBARD LA NE 35.0820926546067 -106.514858579235
345 ALTEZ ST NE 35.0780210285052 -106.539607123305
1853 VALLEY RD SW 35.0413512624975 -106.685913023435
0 35.1172291295138 -106.500848346871
7324 CANARY LA NE 35.1730181518165 -106.563409369506
1219 2ND ST SW 35.0729846918123 -106.651959081184
99999 ELFEGO RD NW 35.1355368328033 -106.674349810324
0 35.1761690931333 -106.774103447928
1304 VILLA CHAMISA NE 35.1591674886816 -106.608478941567
4500 LAS CRESTAS DR NW 35.1337087332455 -106.70518747942
12500 CANDELARIA RD NE 35.1151707185385 -106.498741825184
240 RIO BRAVO BLVD SE 35.0262322652711 -106.653603695473
700 HERON CT SW 35.062272995286 -106.748128527877
433 SAN MATEO BLVD NE 35.081630919101 -106.586616823822
4008 PONDEROSA AV NE 35.1246938497492 -106.59905722235

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query