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
3317 REINA CT NE 35.119700345105 -106.520064824342
1205 COPPER AV NE 35.0834770603461 -106.633064907286
4323 CAPROCK RD NW 35.2044982073672 -106.669942952282
14320 GRAND AV NE 35.0815353885393 -106.487769956911
1903 BARCELONA RD SW 35.0308884225106 -106.686659893365
310 PACIFIC AV SW 35.0744613888427 -106.652808833268
1426 BARELAS RD SW 35.0711325783534 -106.653557662065
2619 GENERAL MARSHALL ST NE 35.1149129690608 -106.550018398956
8402 CLAREMONT AV NE 35.1123294039838 -106.550384722748
1120 BRIDGE BLVD SW 35.067120890561 -106.668671021977
304 ALAMOSA RD NW 35.1447261212119 -106.638285386862
543 WHISPERING ST SW 35.0682333734586 -106.72621054131
208 GIRARD BLVD SE 35.0785551252585 -106.612942889365
2437 PUEBLO BONITO CT NW 35.1005405291061 -106.672554189784
804 58TH ST NW 35.0960159338628 -106.705761499571
3228 RIO GRANDE BLVD NW 35.1277942352964 -106.673096397282
1023 SANTA FE AV SW 35.0759022548177 -106.660816592192
9201 ORLANDO PL NE 35.1248851025357 -106.539764475578
1150 MARIGOLD DR NE 35.1672326623706 -106.491295895513
0 35.2168673711458 -106.738408162272

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query