<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>That could definitely be possible. I have a shapefile with
similar columns and just about as many rows as the one I am trying
to export and it's just under 10 GB. I can load it into QGIS, but
it obviously slows things down.<br>
</p>
<p>I hadn't considered any kind of limitation like that. Is the
limit one imposed by PostGIS Shapefile Import/Export Manager on
how large a shapefile it will write? <br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 3/21/2020 5:24 PM, Martin Davis
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAK2ens3kgTbtmixUKKa+mpggYBbh-+4W1qvPVGrNSUi2Q--W5g@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Is it possible you are simply exceeding the
allowable size for a shapefile? The SHP file is limited to a
size of 2 GB. </div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Fri, Mar 20, 2020 at 9:35
PM john polo <<a href="mailto:jpolo@mail.usf.edu"
moz-do-not-send="true">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">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>
<br>
-- <br>
Enlightenment is ego's ultimate disappointment.<br>
-Chogyam Trungpa<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Enlightenment is ego's ultimate disappointment.
-Chogyam Trungpa</pre>
</body>
</html>