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
1624 GARDEN WY SW 35.073713510582 -106.68234814996
5441 GOLD RUSH DR NW 35.1610678592323 -106.701132615578
2301 METZGAR RD SW 35.0055860313132 -106.707017175872
3315 RIO CANON CT SW 35.0255106365499 -106.744757226868
19 CAMINO DEL SIERRA 34.9924330357584 -106.264680323494
209 TULANE DR SE 35.078395988967 -106.607402689655
1124 GEORGIA ST SE 35.0591936422232 -106.571821021633
403 WYOMING BLVD SE 35.0688224312578 -106.550928467067
107 LLANO DEL SUR SE 35.0011828678919 -106.658167326066
403 HAZELDINE AV SE 35.0772206473294 -106.644169370405
615 QUAILBRUSH DR NW 35.0921889778668 -106.716794044633
3232 RUNNING BIRD PL NW 35.1205592494921 -106.726669805997
4808 CHOCTAW TRL NW 35.1736031391266 -106.693238915528
30 SUMMIT CT 35.1175980009017 -106.3128687805
5330 HATTIESBURG AV NW 35.1693318632858 -106.699538117461
2312 MORROW RD NE 35.1022882708338 -106.622455016262
8920 LOMAS BLVD NE 35.0859419818834 -106.544814657004
99999 GLENDALE AV NE 35.1896898450403 -106.516081008769
7424 VIA DESIERTO NE 35.1632566614352 -106.614783718154
1701 VAIL PL SE 35.0616317746838 -106.630243879891

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query