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
352 ANTELOPE CIR SE 35.0680964048744 -106.513838527455
3304 BLUME ST NE 35.1188911780994 -106.527168748717
4910 RIO GRANDE LA NW 35.1500324407012 -106.668077467863
704 MARCELLA ST NE 35.0836322273375 -106.522666615139
1908 WHITE CLOUD ST NE 35.1035957350678 -106.494241994053
2801 MARY ELLEN ST NE 35.1146188839935 -106.532507612652
440 PRINCETON DR SE 35.0739214769902 -106.615463622906
1233 ZENA LONA ST NE 35.0934309572116 -106.511013563139
99999 GOLD AV SE 35.080102819912 -106.624286577492
505 VERANDA RD NW 35.1221022076537 -106.646433828476
1504 OLD COORS DR SW 35.0563032876244 -106.7048351192
10204 KEEPING DR NW 35.202020318436 -106.697280190566
1437 CHIHUAHUA AV NE 35.0906413868217 -106.494985938186
5512 ALICE AV NE 35.0880783831462 -106.582466253646
7239 BOXWOOD AV NE 35.1914456579169 -106.56487341368
514 FITZGERALD RD NW 35.1190953545312 -106.647173303638
18 NICHOLS RD 34.9797304276391 -106.316534617151
9709 TORRISO CT SW 35.061069350913 -106.740370648428
8815 HENRIETTE WYETH DR NE 35.1849273180806 -106.551994997361
6814 GLACIER RD NW 35.194075483285 -106.7303713472

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query