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: [email protected] [mailto:[email protected]]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 <[email protected]> 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 [email protected] www.greenwoodmap.com _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
