[postgis-users] reverse geocoding

[Richard Greenwood]

On Sat, Apr 3, 2010 at 11:05 AM, Randall, Eric
<ERandall at eriecountygov.org> wrote:
> -- Here's my go at it.  Paste into favorite sql editor for easier reading.  Cheers.   -Eric

Really nice! Initially my sides were NULL because my road centerlines
were LINESTRING rather than MULTILINESTRING which caused
ST_GeometryN() to return NULL. Used ST_Multi() to cast them, and am
now getting good looking results.

Thanks Eric, I owe you a few beers!

Rich

-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com