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, correct? -Sam On Fri, Nov 5, 2010 at 6:19 PM, strk <[email protected]> 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 > 2009" > > 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. > > --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
