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