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
8011 CUTLER AV NE 35.1051185985253 -106.555085296694
8415 MOCK HEATHER RD NW 35.1653236588309 -106.732525748282
9624 WEEMS AV SW 35.063746306458 -106.740087589621
729 COMMERCIAL ST SE 35.0757006396809 -106.648212799512
8920 CANDELARIA RD NE 35.115970697782 -106.543412929841
99999 FOOTHILL RD SW 35.0463361560465 -106.706520136735
3548 RIO GRANDE BLVD NW 35.1319502530421 -106.671338669407
832 CHELWOOD PARK BLVD NE 35.0845780652621 -106.505888402523
505 WHISPER DR SW 35.0694627402297 -106.725422384123
3002 MANZANO ST NE 35.116702312014 -106.588283256602
7115 BOXWOOD AV NE 35.1914718159714 -106.567375432038
8821 MODESTO AV NE 35.1891389005507 -106.544724306059
2408 RIO GRANDE DEL SOL CT NW 35.1358268394515 -106.670822157679
4825 CUTTING AV NW 35.1885114323915 -106.674974901196
1939 SHADETREE DR SW 35.0493922449219 -106.722988545676
6716 CALLE SANTIAGO NE 35.1556461131328 -106.611518500572
2905 ALAMOGORDO DR NW 35.1151082354976 -106.697757393402
7327 WILD OLIVE AV NE 35.1906706678749 -106.563095108279
1739 BLAKE RD SW 35.0368906132064 -106.683478319687
3213 CASA BONITA DR NE 35.1183189496589 -106.492607862066

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query