<div><br></div><div>select count(asEWKB(the_geom)) from global_points;</div><div><br></div><div>Returns the following error:</div><br>ERROR: function asewkb(geography) does not exist<div><br></div><div><br></div><div>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?</div>
<div><br></div><div><br></div><div>-Sam</div><div><div><br></div><div><br><div class="gmail_quote">On Fri, Nov 5, 2010 at 6:19 PM, strk <span dir="ltr"><<a href="mailto:strk@keybit.net">strk@keybit.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Fri, Nov 05, 2010 at 04:43:54PM -0400, Sam Snellings wrote:<br>
> The output of postgis_full_version() is:<br>
><br>
> POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September 2009"<br>
> LIBXML="2.6.26" USE_STATS<br>
<br>
</div>Uhm. Maybe we need more fixes then.<br>
<br>
See if this query gives you the ERROR:<br>
select count(asEWKB(the_geom)) from global_points;<br>
<br>
Anyway, would you want the invalid geometries in your shapefile ?<br>
I'd think you'd better fix the invalidities and then try again.<br>
<br>
See ST_isValid and ST_isValidReason.<br>
<div><div></div><div class="h5"><br>
--strk;<br>
<br>
() Free GIS & Flash consultant/developer<br>
/\ <a href="http://strk.keybit.net/services.html" target="_blank">http://strk.keybit.net/services.html</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br></div></div>