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
3512 CYPRESS DR SW 35.0820994588659 -106.691529987095
3410 MACKLAND AV NE 35.0912006994667 -106.605943046553
6838 PIEDRA QUEMADA RD NW 35.1905274800609 -106.732318695636
140 PLEASANT AV NW 35.1310296415394 -106.637361211862
6111 SUNRAY RD NW 35.1092022917309 -106.709468378504
2339 FELICITAS RD SW 35.0798851243822 -106.689772383021
119 RIDER RD 35.1440554985362 -106.32731464073
901 SOLANO DR NE 35.090246828462 -106.602288249746
1244 TELSTAR LOOP NW 35.1002634628652 -106.714327189186
421 PANORAMA PL NE 35.0734804513861 -106.497643023108
6608 BRIARCLIFF NE 35.1548786939286 -106.526740545862
4613 LARCHMONT DR NE 35.1327336585126 -106.495823569769
6516 MESA SOLANA PL NW 35.1613935302925 -106.692122287859
8608 LA SALA GRANDE NE 35.118487995888 -106.547528191001
6600 VENTANA HILLS RD NW 35.1956754535799 -106.728468066055
9917 TREVINO LOOP NW 35.1952039475951 -106.717907631084
2538 CANONCITO SCHOOL RD 35.0391053868613 -107.08693654849
99999 POWERS WY SW 34.9648915136682 -106.746145540782
6916 ACEQUIA DR SW 34.9704922800876 -106.716266771682
2920 RIVER WILLOW TRL NW 35.1707171281428 -106.672072818212

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query