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
7521 KEYSTONE DR NE 35.1661199963355 -106.558979136442
2309 GENERAL MARSHALL ST NE 35.1106629371886 -106.550004218904
5605 ALTIMA PL NW 35.1488935679885 -106.692286949315
4601 CROYDEN AV NW 35.1883158253971 -106.678865731344
10300 MATTHEW AV NE 35.1152074267331 -106.52588480554
9219 REDMONT RD NE 35.1602565365318 -106.538959000519
9908 BUCKEYE ST NW 35.1924269789891 -106.667693153534
1305 VILLA LILA NE 35.1625857899047 -106.607323522159
361 BIG HORN RIDGE RD NE 35.1760421932405 -106.484163550065
11323 OVERLOOK DR NE 35.1417106419718 -106.512150767724
1701 CHANDELLE LOOP NE 35.1013109113525 -106.498623156935
8002 ROBIN AV NE 35.0989046429013 -106.554537760641
708 TORRETTA DR SW 35.0615007902568 -106.731054954227
99999 HOSPITAL LOOP NE 35.132827416907 -106.591833449186
1038 TEXAS ST NE 35.0888402364214 -106.555293966729
6300 MOJAVE ASTER WY NE 35.1518213947272 -106.491672658393
5612 LITO RD NW 35.2143445391622 -106.694663832012
5906 HANNETT AV NE 35.0986455639238 -106.578181866754
231 CALLE DEL REY SW 35.0716367952352 -106.734064726245
1208 FAIRHAVEN AV SW 35.0696667497859 -106.670765947073

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query