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
13919 LIMA PL NE 35.0808361748156 -106.49460769768
8323 HAWK EYE RD NW 35.162233834656 -106.729653563317
7701 WHITE ST NE 35.1691157981658 -106.558499946248
1631 TIERRA DEL RIO NW 35.1407011392519 -106.65706832834
457 60TH ST NW 35.089042407996 -106.707353917598
817 TANAGER DR SW 35.06016554242 -106.75297557218
9401 ENDEE RD NW 35.0910259086063 -106.742761055275
9736 LORRETTA DR NW 35.1917842433264 -106.650246863295
4800 MENAUL BLVD NE 35.1086666322049 -106.590620663879
1409 HENDOLA DR NE 35.0957962938218 -106.555447210451
1829 JUNE ST NE 35.1031335618651 -106.522803562955
1014 11TH ST NW 35.0960959015708 -106.657592338096
308 GENE AV NW 35.139349093739 -106.639630100299
99999 VENTANA RIDGE RD NW 35.1987239195141 -106.750069416949
832 DAKOTA ST SE 35.0639979874074 -106.573963772761
845 ARITAS RD SW 35.0436810530695 -106.671464342579
4415 PROSPECT AV NE 35.1076295735984 -106.595062885884
10012 TREASURE CT NW 35.1969185580934 -106.695292772314
3001 DON LUCIANO RD SW 34.9984921941184 -106.719589166521
5216 SOONER TRL NW 35.1640620121576 -106.698836793567

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query