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
225 VIRGINIA ST SE 35.0716281700889 -106.552937011693
6700 GLENLOCHY WY NE 35.1861318422349 -106.573033512044
1939 BLACK GOLD RD SE 35.0473420863384 -106.510117906953
95 JUNIPER HILL RD NE 35.1843580869504 -106.486330181691
522 ATLANTIC AV SW 35.0769595920652 -106.655381028053
6788 PALACIO DR SW 34.9699450726389 -106.711128018318
1412 LOMAS BLVD NW 35.0924852425005 -106.662828900926
11 TEWA CT 35.1942295376227 -106.325775809032
2513 RIO ORILLA LA NW 35.1684655011535 -106.665133205112
99999 REDONDO DR NE 35.0844647264404 -106.625773261967
99999 SUMMERWOOD DR NW 35.106586267625 -106.70849895574
916 20TH ST NW 35.1027727885438 -106.667208125597
10424 SAN GABRIEL RD NE 35.1255737192718 -106.522337164037
4404 CONDESA CT NW 35.2064709064959 -106.672361634606
204 VIA SEDILLO RD 35.0723888597121 -106.2840235524
2020 BROADWAY BLVD SE 35.0621953239163 -106.644922749946
10731 MONTEREY BAY CT NW 35.2131859798693 -106.6938732231
10009 CARTAGENA AV SW 35.0444395984979 -106.741557509985
7020 PRAIRIE RD NE 35.133275568541 -106.567293266676
213 SHANNON PL NW 35.1341855598266 -106.639518791918

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query