<html><head></head><body style="zoom: 0%;"><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"><!-- tmjah_g_1299s -->Get <!-- tmjah_g_1299e --><a href="http://www.bluemail.me/r?b=15824"><!-- tmjah_g_1299s -->BlueMail for Android<!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --> <!-- tmjah_g_1299e --></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">gataric@usa.net</a>> wrote:
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;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,<br><br>I'm trying to export a table of points to a shapefile. The table has <br>over 8,000,000 rows. I'm using PostGIS 3.0 and PostGIS Shapefile <br>Import/Export Manager on Windows 10. When I try to run the export, I <br>keep getting this error:<br><br>Error: record 3329432 could not be created<br><br>I'm not sure how to handle this. My first impulse is find the offending <br>row, but I don't know the SQL for such a query. Is there something I <br>need to write in a WHERE clause or a different clause to get a specific row?<br></pre>
</blockquote>
</div>
</div>
</blockquote>
</div>
<pre class="blue"> <hr><br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre></blockquote></div></body></html>