<div dir="ltr"><div dir="ltr">Not surprising - I'm not sure it's possible to make an invalid point.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Mar 21, 2020 at 10:07 PM john polo <<a href="mailto:jpolo@mail.usf.edu">jpolo@mail.usf.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>I used<br>
</p>
<p>SELECT "SAMPLING_EVENT_IDENTIFIER" FROM p_loc.ebird_sel_spt<br>
WHERE ST_IsValid(geom) is false<br>
;</p>
<p>No rows are returned. <br>
</p>
<p><br>
</p>
<div>On 3/21/2020 4:13 PM, Alexander Gataric
wrote:<br>
</div>
<blockquote type="cite">
<div dir="auto">Write a query using predicate<br>
<br>
</div>
<div dir="auto"> ST_IsValid(geom_column) is false <br>
<br>
</div>
<div dir="auto">Get
<a href="http://www.bluemail.me/r?b=15824" target="_blank">BlueMail for
Android</a>
</div>
<div class="gmail_quote">On Mar 21, 2020, at 10:06 AM, John Polo
<<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>> wrote:
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
They are stored as Point. One per row.
<br>
<br>
<br>
<div> <br>
On Saturday, March 21, 2020, Alexander Gataric < <a href="mailto:gataric@usa.net" target="_blank">gataric@usa.net</a>>
wrote: <br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div style="zoom:0%">
<div dir="auto"> What format are the points stored in?
Point, multipoint? How many points per row? <br>
<br>
</div>
<div dir="auto"> Get <a href="http://www.bluemail.me/r?b=15824" target="_blank">BlueMail for
Android</a> </div>
<div class="gmail_quote"> On Mar 20, 2020, at 11:36 PM,
john polo < <a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>>
wrote:
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<pre>Hi,
I'm trying to export a table of points to a shapefile. The table has
over 8,000,000 rows. I'm using PostGIS 3.0 and PostGIS Shapefile
Import/Export Manager on Windows 10. When I try to run the export, I
keep getting this error:
Error: record 3329432 could not be created
I'm not sure how to handle this. My first impulse is find the offending
row, but I don't know the SQL for such a query. Is there something I
need to write in a WHERE clause or a different clause to get a specific row?
</pre>
</blockquote>
</div>
</div>
</blockquote>
</div>
<pre> <hr>
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<pre cols="72">--
Enlightenment is ego's ultimate disappointment.
-Chogyam Trungpa</pre>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div></div>