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
9900 TANOAN DR NE 35.1580821860558 -106.530452073817
2518 ALYSSA DR SW 35.037572060435 -106.697250965387
728 TURNER DR NE 35.0784781831468 -106.488858625269
1204 PACHECO LA NW 35.1070637865559 -106.681934446393
1613 CATALINA PL SW 35.0479708605162 -106.750445322955
72 VALLE ESCONDIDO RD 35.1550924269703 -106.302915963769
10417 NOGAL PL NW 35.2029653514735 -106.7111901193
801 WILMOORE DR SE 35.0711575766733 -106.623462928444
10909 SERPENTINE CT NW 35.2150040365082 -106.687791653392
1800 PROPPS ST NE 35.1018102232231 -106.524907641734
4901 HAWKINS ST NE 35.1625448507884 -106.589927217274
604 MARQUIS DR NE 35.0796534912842 -106.512247652563
4416 PURPLE SAGE AV NW 35.1586580958491 -106.686961663099
7436 SANDIA GLOW CT NE 35.16535134442 -106.53087614895
13101 CHICO RD NE 35.0764651208563 -106.503336011403
11268 CAMPO DEL SOL AV NE 35.085126689874 -106.524811238412
6112 KEARNY TRL NW 35.1535588664535 -106.7013373277
1025 PALOMAS DR SE 35.0644226102002 -106.583370681991
2206 HOLLYWOOD AV NW 35.0964587280184 -106.672949102258
12300 HORSESHOE TRL SE 35.0643798435401 -106.512434932185

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query