[postgis-users] help with pgsql2shp error

[Sam Snellings]

*(database geog_three, tutorial data) select
asEWKB(setSRID(geog::geometry,-1), 'XDR') from airports;*
*
*
asewkb
*\00000000001c05d9a1b089a02754040f8c154c985f0*
\000000000014004727bb2fec56d4048810ff9724745
\00000000001c035dce075f6fd224050083afb7e9100

3 row(s)



On Sat, Nov 6, 2010 at 4:56 PM, strk <strk at keybit.net> wrote:

> On Sat, Nov 06, 2010 at 01:44:12PM -0400, Sam Snellings wrote:
> > Thanks for the ::geometry tip.
> >
> > (database geog_test, my data) *select count(asEWKB(location::geometry))
> from
> > global_points;*
> >
> > count: 1
> >
> > (database geog_three, tutorial data) *select
> count(asEWKB(geog::geometry))
> > from airports;*
> >
> > count: 3
>
> The suggestion was due to the fact that pgsql2shp should be
> using that call. In particular:
>
>  asEWKB(setSRID("%s"::geometry, -1), 'XDR')
>
> Want to try that as well ?
> (substitute %s with the name of your geometry column)
>
> --strk;
>
>  ()   Free GIS & Flash consultant/developer
>  /\   http://strk.keybit.net/services.html
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101106/980611f3/attachment.html>