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
4401 TRES VISTAS RD NW 35.1504318370051 -106.68852973421
99999 GIBSON BLVD SE 35.0579921456756 -106.625397817353
6012 PERSIMMON CT NE 35.1494568193252 -106.505098194724
6925 VIVIAN DR NE 35.1581153941997 -106.56989194255
9531 SAN RAFAEL AV NE 35.1642168484038 -106.535730025228
1005 INDIANA ST SE 35.0615435663423 -106.571307595744
3021 BARCELONA PL SW 35.0316989634273 -106.719007068326
6419 ALOE RD NW 35.1749953055222 -106.715785097999
2720 ALVARADO DR NE 35.1120844324004 -106.581611291702
3013 DONA TERESA PL SW 35.008125734232 -106.719523478476
9905 RAWHIDE AV SW 35.0678425606972 -106.743221977996
2648 SARITA AV NW 35.1055225518682 -106.676187502475
6541 CLIFFROSE RD NW 35.1420986369589 -106.715752802746
8305 DECATUR AV SE 35.0721879116979 -106.556799008327
12201 PALM SPRINGS AV NE 35.1169957679823 -106.503456650899
11720 PINO AV NE 35.1679117728746 -106.508893381154
2701 MILES RD SE 35.0570799014523 -106.613999835881
1210 PIERRE DR SW 35.0625042283895 -106.695541620643
99999 EDITH BLVD NE 35.1652335922731 -106.619519409761
4132 RANCHO ALEGRE RD NW 35.1731262248608 -106.682541668227

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query