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
1111 SILVER AV SW 35.0839810642187 -106.66072165825
1513 MYRLE DR SW 35.0487977605136 -106.673552196699
8320 FRUIT AV NE 35.0861664235038 -106.553320275672
357 ENCHANTED VALLEY RD NW 35.1576446944408 -106.63582413841
99999 LOMAS BLVD NW 35.0917137569362 -106.648698355908
12 DOC HOLIDAY RD 34.9324024071509 -106.226734187551
101 MESCALERO RD NW 35.1240369064983 -106.637636614367
2710 ZICKERT RD NW 35.111466510836 -106.677298345707
418 CENTRAL AV SW 35.0843841416763 -106.652714089957
2824 QUAIL POINTE DR NW 35.1160040178942 -106.703979237502
7524 2ND ST NW 35.1656082604942 -106.628940350417
1112 DAKOTA ST SE 35.0594888170028 -106.574028377242
10600 OSUNA RD NE 35.1366061256832 -106.521031927738
6705 MESA ANTIGUA PL NW 35.1621851668692 -106.690530853441
10240 OSO REDONDO NE 35.1371550775707 -106.524592880125
5101 PEBBLE RD NW 35.2125530352512 -106.685525268921
7139 NATALIE JANAE LA NE 35.1590653068808 -106.56590295109
9505 LYNDALE LA NW 35.1865928466481 -106.659228893485
8015 HANNETT AV NE 35.0983302172287 -106.554616162104
9801 DENALI RD NE 35.1539021844312 -106.532267920375

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query