<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>Hi,</div><div><br></div><div>I'm a newbie using postgis from Debian's Testing repos. (v. 1.5) I used the tiger_loader script to load the data.</div><div><br></div><div>Plenty of addresses geocode just fine. Using the below query, I get an error.</div><div><br></div><div>SELECT g.rating, ST_X(ST_AsEWKT(ST_SnapToGrid(g.geomout,0.00000001))) As lon, ST_Y(ST_AsEWKT(ST_SnapToGrid(g.geomout,0.00000001))) As lat, ST_AsEWKT(ST_SnapToGrid(g.geomout,0.00000001)) As wktlonlat, <br> (addy).address As stno, (addy).streetname As street, <br> (addy).streettypeabbrev As styp, (addy).location As city, (addy).stateabbrev As st,(addy).zip <br> FROM geocode(pprint_addy(normalize_address('3261 South West 160 Avenue, Miramar, FL 33027'))) As g <br>
order by g.rating</div><div><br></div><div>Error: ERROR: query "SELECT substring(reducedStreet, '(?i)(^' || name<br> || ')' || ws) FROM direction_lookup WHERE<br> reducedStreet ILIKE '%' || name || '%' AND texticregexeq(reducedStreet, '(?i)(^' || name || ')' || ws)<br> ORDER BY length(name) DESC" returned more than one row<br> Where: PL/pgSQL function "normalize_address" line 280 at assignment<br>PL/pgSQL function "geocode" line 10 at assignment<br>SQLState: 21000<br>ErrorCode: 0</div><br>The problem is with the street name 'South West 160 Avenue.' Is that a bug?<br><br>Also, Southwest 160 Avenue' returns some very low-accuracy results. What queries can I use to view the tiger data to increase the rating? In my head, I'd like to select all street names in the zip code 33027 using like statements to
narrow results to figure out why the g.rating is so bad on this address. But, that's probably different than how TIGER data is structured. Can someone post an example of a select to improve the accuracy? It's also possible the address is slightly wrong, but I get accurate results from google earth.<br><br>Thanks in advance.<br><br><br><br><br><div></div></div></body></html>