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
0 34.9218269511649 -106.248770593061
7409 ARVADA AV NE 35.1055239749175 -106.562601466605
4915 INSPIRATION DR SE 35.0686822423853 -106.587886259907
608 TRADING POST TRL SE 35.0648136136632 -106.514185240676
99999 LADERA DR NW 35.0939442011114 -106.746325538836
10900 FAROLA DR NW 35.2143203404012 -106.672432574105
99999 CLOUDCROFT RD NW 35.0808701877896 -106.768818687909
820 LANDMARK ST NW 35.0968593161845 -106.718978994083
617 2ND ST SW 35.0786626540235 -106.650570038623
1125 KENTUCKY ST SE 35.0590352613743 -106.57025702069
1276 MOUNTAIN VALLEY RD 35.1444898277778 -106.259998407752
2122 COAL PL SE 35.0767228629064 -106.623042264041
921 SANTA FE AV SW 35.0759180409986 -106.659437052667
99999 CAMINO DEL REPOSO DR NW 35.058245147754 -106.880380788358
7012 BRINDISI PL NW 35.2013946941406 -106.735002438896
3400 WYOMING BLVD NE 35.1213508417521 -106.549735309293
3210 TULANE DR NE 35.1190040719504 -106.605744248667
2711 MONTEREY AV SE 35.0713798306512 -106.616021702087
6819 PLATT PL NW 35.1950795649219 -106.731091561985
3000 LOS ANAYAS RD NW 35.1156502087584 -106.680932681085

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query