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
6719 MAYHILL CT NW 35.1294067747803 -106.716730572296
8108 VENTANA AZUL AV NW 35.1943589003738 -106.754665166769
3201 PITT ST NE 35.1173928738909 -106.529581977933
13300 I40 WEST FRONTAGE RD SW 35.060077782712 -106.794195973694
12401 APPALACHIAN WY NE 35.117357899679 -106.499561090783
99999 ALOHA DR NW 35.0546667432895 -106.881941721628
4301 CHINLEE AV NE 35.0967962102758 -106.597384520676
6445 PINE PARK PL NE 35.1574619167166 -106.577268712499
9104 LYNX LOOP NE 35.1735267552025 -106.48695986806
3003 TRUMAN ST NE 35.1167034959337 -106.587926527758
7501 RICHMOND HILL RD NW 35.1700132344368 -106.698245908265
1147 MCKEE DR NE 35.091221471967 -106.549076808419
1013 PAMPAS DR SE 35.0616220508716 -106.593974000393
10776 GALAXIA PARK DR NW 35.2114690106066 -106.664317912695
228 AVALON PL NW 35.0828689604334 -106.708270606643
4650 LOS POBLANOS CIR NW 35.1465096716008 -106.662187109455
8101 LOMAS BLVD NE 35.0888339920057 -106.555995292717
504 ALISO DR SE 35.0729970178758 -106.600788540885
3115 MORRISSEY ST SW 35.0267538357582 -106.746493099823
8005 PENNSYLVANIA CIR NE 35.0903026672134 -106.557516950855

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query