[postgis-users] help with pgsql2shp error
ssnellings at gmail.com
Fri Nov 5 18:43:14 PDT 2010
select count(asEWKB(the_geom)) from global_points;
Returns the following error:
ERROR: function asewkb(geography) does not exist
Perhaps I don't understand your use of the term 'invalid geometry,' but I'm
using a geography datatype in both tables (airports and global_points) - so
there shouldn't be any geometry datatypes used. Also, asEWKB(),
ST_isValid() and ST_isValidReason() don't work with geography data types,
On Fri, Nov 5, 2010 at 6:19 PM, strk <strk at keybit.net> wrote:
> On Fri, Nov 05, 2010 at 04:43:54PM -0400, Sam Snellings wrote:
> > The output of postgis_full_version() is:
> > POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September
> > LIBXML="2.6.26" USE_STATS
> Uhm. Maybe we need more fixes then.
> See if this query gives you the ERROR:
> select count(asEWKB(the_geom)) from global_points;
> Anyway, would you want the invalid geometries in your shapefile ?
> I'd think you'd better fix the invalidities and then try again.
> See ST_isValid and ST_isValidReason.
> () Free GIS & Flash consultant/developer
> /\ http://strk.keybit.net/services.html
> postgis-users mailing list
> postgis-users at postgis.refractions.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users