[postgis-users] reverse geocoding

[Randall, Eric]

Rich,

You should just not use st_geometryn then...since linestring is what is desired by the functions in the first place.
Also, I find that the single query is slower than using separate table operations.

-Eric

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of
Richard Greenwood
Sent: Saturday, April 03, 2010 11:28 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] reverse geocoding


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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users