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
10223 NM 337 34.9075801424867 -106.279091875568
9544 JACKS CREEK DR NW 35.1906703558059 -106.703602664475
10700 FOUR MILE RD SW 35.0403464507211 -106.750079503673
11801 EAGLE ROCK AV NE 35.187571746923 -106.508327842894
12117 EMPEROR DR NE 35.0827913215136 -106.511731292819
4 MALLES DR 34.9551134082351 -106.334694414523
5721 PAPAYA PL NE 35.1466073601375 -106.503725898101
1631 LA VEGA DR SW 35.0464267659006 -106.668480379231
6209 FLOR DE MAYO PL NW 35.1501064432308 -106.710811031269
7241 SPRINGFIELD DR NE 35.1701271784198 -106.566061583583
1944 COUNT FLEET ST SE 35.0461899422529 -106.509112899815
1201 GABALDON RD NW 35.106905746267 -106.684438028163
2605 MARBLE AV NW 35.0956049330745 -106.679627547491
3843 FLORA VISTA AV SW 35.0296082428665 -106.718641845531
0 34.9094110791413 -106.595794164472
2065 DON ANDRES PL SW 35.0462333233885 -106.69394777646
1100 CALIFORNIA ST NE 35.0882744379216 -106.574843742571
44 SCOTT RD 35.0916249160772 -106.252959562804
9215 MARRON CIR NE 35.0889983652287 -106.542700109931
1413 KIRBY ST NE 35.0962554453071 -106.511841019867

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query