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
2531 TRAMWAY TERRACE CT NE 35.1693078984714 -106.497607803515
8519 CLARKS FORK RD NW 35.1060572018886 -106.738845174188
817 ALAMEDA RD NW 35.1968668653708 -106.626100168624
104 BAKER LA NE 35.1990353924538 -106.602978180436
8401 RIVER ST NE 35.17881716572 -106.588606458427
1042 RED OAKS LOOP NE 35.1717859521666 -106.485940607486
9901 DENALI RD NE 35.15400802768 -106.531177830377
5908 TENABO RD NW 35.1105716323292 -106.707287783792
4809 14TH ST NW 35.133756277186 -106.654237358581
10200 CALLE CHULITA NW 35.1989546888561 -106.722005376551
5601 CLETSOWAY DR SW 34.9976806064939 -106.717629845646
3830 WESTERFELD DR NE 35.1263880903323 -106.534602788974
9 AXTON LA 35.0989925832801 -106.267374996426
2500 CENTRAL AV SW 35.094177594931 -106.677124281009
3604 ESCARPA DR NW 35.1241089771155 -106.716485305661
5900 ISLETA BLVD SW 34.9936977378383 -106.693868089493
25 DALTON TRL 35.1691473694964 -106.284885667629
11132 MALAGUENA LA NE 35.1500191251962 -106.513633977557
4112 GLEN CANYON RD NE 35.1286502929352 -106.501627397033
10502 JENARO ST SW 35.0545899017171 -106.749342885655

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query