<div dir="ltr">SELECT *<br>
FROM (SELECT *,<br>
row_number() OVER () AS NumLigne<br>
FROM p_loc.ebird_sel_spt<br>
) AS p_loc_ebird_sel_sptAvecNumLigne<br>
WHERE p_loc_ebird_sel_sptAvecNumLigne.NumLigne = 3329432;</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mer. 25 mars 2020 à 20:02, <<a href="mailto:postgis-users-request@lists.osgeo.org">postgis-users-request@lists.osgeo.org</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send postgis-users mailing list submissions to<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank">postgis-users-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:postgis-users-owner@lists.osgeo.org" target="_blank">postgis-users-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of postgis-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: postgis-users Digest, Vol 217, Issue 15 (john polo)<br>
2. Re: postgis-users Digest, Vol 217, Issue 15 (john polo)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Tue, 24 Mar 2020 21:42:29 -0700<br>
From: john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>><br>
To: <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
Subject: Re: [postgis-users] postgis-users Digest, Vol 217, Issue 15<br>
Message-ID: <<a href="mailto:601441d5-0063-6f85-3e02-b3b4189be381@mail.usf.edu" target="_blank">601441d5-0063-6f85-3e02-b3b4189be381@mail.usf.edu</a>><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br>
<br>
Thanks for the code, Freddy. It doesn't work for me though. I'm still <br>
pretty new to SQL and subqueries are something I'm still learning, so I <br>
don't know if there is something obvious I missed in running this. I've <br>
not seen row_number() before. I read a couple of things online and there <br>
was something that said the query needs ORDER BY inside the OVER() <br>
function. However, I don't know what to refer to for an ORDER BY(), <br>
because I don't know how the table determines the line numbers.<br>
<br>
SELECT *<br>
FROM p_loc.ebird_sel_spt<br>
(SELECT *,<br>
row_number() OVER () AS NumLigne<br>
FROM p_loc.ebird_sel_spt<br>
) AS p_loc.ebird_sel_sptAvecNumLigne<br>
WHERE NumLigne = 3329432;<br>
<br>
ERROR: syntax error at or near "SELECT"<br>
LINE 3: (SELECT *,<br>
^<br>
SQL state: 42601<br>
Character: 3<br>
<br>
I tried the query without the "AS p_loc.ebird_sel_sptAvecNumLigne". I <br>
also forgot to change the TaTable that was in the 2nd FROM to <br>
p_loc.ebird_sel_spt at first. A few other little tweaks didn't seem to <br>
make it work for me.<br>
<br>
best,<br>
<br>
John<br>
<br>
<br>
On 3/23/2020 9:56 AM, Freddy Gonthier wrote:<br>
> SELECT *<br>
> FROM<br>
> (SELECT *,<br>
> row_number() OVER () AS NumLigne<br>
> FROM TaTable<br>
> ) AS TaTableAvecNumLigne<br>
> WHERE NumLigne = 3329432;<br>
><br>
> Le sam. 21 mars 2020 à 20:01, <<a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank">postgis-users-request@lists.osgeo.org</a> <br>
> <mailto:<a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank">postgis-users-request@lists.osgeo.org</a>>> a écrit :<br>
><br>
> Send postgis-users mailing list submissions to<br>
> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
><br>
> To subscribe or unsubscribe via the World Wide Web, visit<br>
> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
> or, via email, send a message with subject or body 'help' to<br>
> <a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank">postgis-users-request@lists.osgeo.org</a><br>
> <mailto:<a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank">postgis-users-request@lists.osgeo.org</a>><br>
><br>
> You can reach the person managing the list at<br>
> <a href="mailto:postgis-users-owner@lists.osgeo.org" target="_blank">postgis-users-owner@lists.osgeo.org</a><br>
> <mailto:<a href="mailto:postgis-users-owner@lists.osgeo.org" target="_blank">postgis-users-owner@lists.osgeo.org</a>><br>
><br>
> When replying, please edit your Subject line so it is more specific<br>
> than "Re: Contents of postgis-users digest..."<br>
><br>
><br>
> Today's Topics:<br>
><br>
> 1. query a certain row from a table. (john polo)<br>
> 2. Re: query a certain row from a table. (Alexander Gataric)<br>
> 3. Re: query a certain row from a table. (John Polo)<br>
><br>
><br>
> ----------------------------------------------------------------------<br>
><br>
> Message: 1<br>
> Date: Fri, 20 Mar 2020 21:35:21 -0700<br>
> From: john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a> <mailto:<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>>><br>
> To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>>><br>
> Subject: [postgis-users] query a certain row from a table.<br>
> Message-ID: <<a href="mailto:d05371ca-fcf0-d3e7-c85f-42f144a9132a@mail.usf.edu" target="_blank">d05371ca-fcf0-d3e7-c85f-42f144a9132a@mail.usf.edu</a><br>
> <mailto:<a href="mailto:d05371ca-fcf0-d3e7-c85f-42f144a9132a@mail.usf.edu" target="_blank">d05371ca-fcf0-d3e7-c85f-42f144a9132a@mail.usf.edu</a>>><br>
> Content-Type: text/plain; charset=utf-8; format=flowed<br>
><br>
> 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<br>
> 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<br>
> specific row?<br>
><br>
> -- <br>
> Enlightenment is ego's ultimate disappointment.<br>
> -Chogyam Trungpa<br>
><br>
><br>
><br>
> ------------------------------<br>
><br>
> Message: 2<br>
> Date: Sat, 21 Mar 2020 02:36:24 -0500<br>
> From: Alexander Gataric <<a href="mailto:gataric@usa.net" target="_blank">gataric@usa.net</a> <mailto:<a href="mailto:gataric@usa.net" target="_blank">gataric@usa.net</a>>><br>
> To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>>><br>
> Subject: Re: [postgis-users] query a certain row from a table.<br>
> Message-ID: <<a href="mailto:5c4820aa-f60d-4b7e-9ca1-45da6a8d416a@usa.net" target="_blank">5c4820aa-f60d-4b7e-9ca1-45da6a8d416a@usa.net</a><br>
> <mailto:<a href="mailto:5c4820aa-f60d-4b7e-9ca1-45da6a8d416a@usa.net" target="_blank">5c4820aa-f60d-4b7e-9ca1-45da6a8d416a@usa.net</a>>><br>
> Content-Type: text/plain; charset="utf-8"<br>
><br>
> What format are the points stored in? Point, multipoint? How many<br>
> points per row?<br>
><br>
> Get BlueMail for Android <br>
><br>
> On Mar 20, 2020, 11:36 PM, at 11:36 PM, john polo<br>
> <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a> <mailto:<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>>> wrote:<br>
> >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<br>
> offending<br>
> ><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<br>
> specific<br>
> >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">postgis-users@lists.osgeo.org</a> <mailto:<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><br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL:<br>
> <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/b1b44f20/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/b1b44f20/attachment-0001.html</a>><br>
><br>
> ------------------------------<br>
><br>
> Message: 3<br>
> Date: Sat, 21 Mar 2020 08:06:34 -0700<br>
> From: John Polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a> <mailto:<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>>><br>
> To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>>><br>
> Subject: Re: [postgis-users] query a certain row from a table.<br>
> Message-ID:<br>
> <br>
> <<a href="mailto:CALTSVX9DsHew5rm2kbxjTQjDYo11Y9b_xHpy8D7Pm%2BpSsCB-ww@mail.gmail.com" target="_blank">CALTSVX9DsHew5rm2kbxjTQjDYo11Y9b_xHpy8D7Pm+pSsCB-ww@mail.gmail.com</a><br>
> <mailto:<a href="mailto:CALTSVX9DsHew5rm2kbxjTQjDYo11Y9b_xHpy8D7Pm%252BpSsCB-ww@mail.gmail.com" target="_blank">CALTSVX9DsHew5rm2kbxjTQjDYo11Y9b_xHpy8D7Pm%2BpSsCB-ww@mail.gmail.com</a>>><br>
> Content-Type: text/plain; charset="utf-8"<br>
><br>
> They are stored as Point. One per row.<br>
><br>
><br>
><br>
> On Saturday, March 21, 2020, Alexander Gataric <<a href="mailto:gataric@usa.net" target="_blank">gataric@usa.net</a><br>
> <mailto:<a href="mailto:gataric@usa.net" target="_blank">gataric@usa.net</a>>> wrote:<br>
><br>
> > What format are the points stored in? Point, multipoint? How<br>
> many points<br>
> > per row?<br>
> ><br>
> > Get BlueMail for Android <<a href="http://www.bluemail.me/r?b=15824" rel="noreferrer" target="_blank">http://www.bluemail.me/r?b=15824</a>><br>
> > On Mar 20, 2020, at 11:36 PM, john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a><br>
> <mailto:<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>>> wrote:<br>
> >><br>
> >> Hi,<br>
> >><br>
> >> I'm trying to export a table of points to a shapefile. The<br>
> 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<br>
> 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<br>
> offending<br>
> >> row, but I don't know the SQL for such a query. Is there<br>
> something I<br>
> >> need to write in a WHERE clause or a different clause to get a<br>
> specific row?<br>
> >><br>
> >><br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL:<br>
> <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/3c2986ce/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/3c2986ce/attachment-0001.html</a>><br>
><br>
> ------------------------------<br>
><br>
> Subject: Digest Footer<br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<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><br>
><br>
> ------------------------------<br>
><br>
> End of postgis-users Digest, Vol 217, Issue 15<br>
> **********************************************<br>
><br>
><br>
> _______________________________________________<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><br>
<br>
-- <br>
Enlightenment is ego's ultimate disappointment.<br>
-Chogyam Trungpa<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20200324/60c6afe6/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200324/60c6afe6/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 25 Mar 2020 06:22:35 -0700<br>
From: john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>><br>
To: <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
Subject: Re: [postgis-users] postgis-users Digest, Vol 217, Issue 15<br>
Message-ID: <<a href="mailto:00de2ca7-dd58-15ab-2516-3a43e46777d2@mail.usf.edu" target="_blank">00de2ca7-dd58-15ab-2516-3a43e46777d2@mail.usf.edu</a>><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br>
<br>
I see my mistake. I shouldn't have added the table name between the <br>
first FROM and the second SELECT.<br>
<br>
I don't know what's wrong with that row. It looks normal. I suppose the <br>
problem is as others have pointed out: exporting the table to shapefile <br>
leads to a shapefile that exceeds a size limit of which I was not aware.<br>
<br>
Merci beaucoup, Freddy.<br>
<br>
best regards,<br>
<br>
John<br>
<br>
On 3/24/2020 9:42 PM, john polo wrote:<br>
><br>
> Thanks for the code, Freddy. It doesn't work for me though. I'm still <br>
> pretty new to SQL and subqueries are something I'm still learning, so <br>
> I don't know if there is something obvious I missed in running this. <br>
> I've not seen row_number() before. I read a couple of things online <br>
> and there was something that said the query needs ORDER BY inside the <br>
> OVER() function. However, I don't know what to refer to for an ORDER <br>
> BY(), because I don't know how the table determines the line numbers.<br>
><br>
> SELECT *<br>
> FROM p_loc.ebird_sel_spt<br>
> (SELECT *,<br>
> row_number() OVER () AS NumLigne<br>
> FROM p_loc.ebird_sel_spt<br>
> ) AS p_loc.ebird_sel_sptAvecNumLigne<br>
> WHERE NumLigne = 3329432;<br>
><br>
> ERROR: syntax error at or near "SELECT"<br>
> LINE 3: (SELECT *,<br>
> ^<br>
> SQL state: 42601<br>
> Character: 3<br>
><br>
> I tried the query without the "AS p_loc.ebird_sel_sptAvecNumLigne". I <br>
> also forgot to change the TaTable that was in the 2nd FROM to <br>
> p_loc.ebird_sel_spt at first. A few other little tweaks didn't seem to <br>
> make it work for me.<br>
><br>
> best,<br>
><br>
> John<br>
><br>
><br>
> On 3/23/2020 9:56 AM, Freddy Gonthier wrote:<br>
>> SELECT *<br>
>> FROM<br>
>> (SELECT *,<br>
>> row_number() OVER () AS NumLigne<br>
>> FROM TaTable<br>
>> ) AS TaTableAvecNumLigne<br>
>> WHERE NumLigne = 3329432;<br>
>><br>
>> Le sam. 21 mars 2020 à 20:01, <<a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank">postgis-users-request@lists.osgeo.org</a> <br>
>> <mailto:<a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank">postgis-users-request@lists.osgeo.org</a>>> a écrit :<br>
>><br>
>> Send postgis-users mailing list submissions to<br>
>> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
>><br>
>> To subscribe or unsubscribe via the World Wide Web, visit<br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
>> or, via email, send a message with subject or body 'help' to<br>
>> <a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank">postgis-users-request@lists.osgeo.org</a><br>
>> <mailto:<a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank">postgis-users-request@lists.osgeo.org</a>><br>
>><br>
>> You can reach the person managing the list at<br>
>> <a href="mailto:postgis-users-owner@lists.osgeo.org" target="_blank">postgis-users-owner@lists.osgeo.org</a><br>
>> <mailto:<a href="mailto:postgis-users-owner@lists.osgeo.org" target="_blank">postgis-users-owner@lists.osgeo.org</a>><br>
>><br>
>> When replying, please edit your Subject line so it is more specific<br>
>> than "Re: Contents of postgis-users digest..."<br>
>><br>
>><br>
>> Today's Topics:<br>
>><br>
>> 1. query a certain row from a table. (john polo)<br>
>> 2. Re: query a certain row from a table. (Alexander Gataric)<br>
>> 3. Re: query a certain row from a table. (John Polo)<br>
>><br>
>><br>
>> ----------------------------------------------------------------------<br>
>><br>
>> Message: 1<br>
>> Date: Fri, 20 Mar 2020 21:35:21 -0700<br>
>> From: john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a> <mailto:<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>>><br>
>> To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
>> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>>><br>
>> Subject: [postgis-users] query a certain row from a table.<br>
>> Message-ID: <<a href="mailto:d05371ca-fcf0-d3e7-c85f-42f144a9132a@mail.usf.edu" target="_blank">d05371ca-fcf0-d3e7-c85f-42f144a9132a@mail.usf.edu</a><br>
>> <mailto:<a href="mailto:d05371ca-fcf0-d3e7-c85f-42f144a9132a@mail.usf.edu" target="_blank">d05371ca-fcf0-d3e7-c85f-42f144a9132a@mail.usf.edu</a>>><br>
>> Content-Type: text/plain; charset=utf-8; format=flowed<br>
>><br>
>> 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<br>
>> 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<br>
>> specific row?<br>
>><br>
>> -- <br>
>> Enlightenment is ego's ultimate disappointment.<br>
>> -Chogyam Trungpa<br>
>><br>
>><br>
>><br>
>> ------------------------------<br>
>><br>
>> Message: 2<br>
>> Date: Sat, 21 Mar 2020 02:36:24 -0500<br>
>> From: Alexander Gataric <<a href="mailto:gataric@usa.net" target="_blank">gataric@usa.net</a> <mailto:<a href="mailto:gataric@usa.net" target="_blank">gataric@usa.net</a>>><br>
>> To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
>> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>>><br>
>> Subject: Re: [postgis-users] query a certain row from a table.<br>
>> Message-ID: <<a href="mailto:5c4820aa-f60d-4b7e-9ca1-45da6a8d416a@usa.net" target="_blank">5c4820aa-f60d-4b7e-9ca1-45da6a8d416a@usa.net</a><br>
>> <mailto:<a href="mailto:5c4820aa-f60d-4b7e-9ca1-45da6a8d416a@usa.net" target="_blank">5c4820aa-f60d-4b7e-9ca1-45da6a8d416a@usa.net</a>>><br>
>> Content-Type: text/plain; charset="utf-8"<br>
>><br>
>> What format are the points stored in? Point, multipoint? How many<br>
>> points per row?<br>
>><br>
>> Get BlueMail for Android <br>
>><br>
>> On Mar 20, 2020, 11:36 PM, at 11:36 PM, john polo<br>
>> <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a> <mailto:<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>>> wrote:<br>
>> >Hi,<br>
>> ><br>
>> >I'm trying to export a table of points to a shapefile. The table<br>
>> 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<br>
>> 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<br>
>> offending<br>
>> ><br>
>> >row, but I don't know the SQL for such a query. Is there<br>
>> something I<br>
>> >need to write in a WHERE clause or a different clause to get a<br>
>> specific<br>
>> >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">postgis-users@lists.osgeo.org</a> <mailto:<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><br>
>> -------------- next part --------------<br>
>> An HTML attachment was scrubbed...<br>
>> URL:<br>
>> <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/b1b44f20/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/b1b44f20/attachment-0001.html</a>><br>
>><br>
>> ------------------------------<br>
>><br>
>> Message: 3<br>
>> Date: Sat, 21 Mar 2020 08:06:34 -0700<br>
>> From: John Polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a> <mailto:<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>>><br>
>> To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
>> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>>><br>
>> Subject: Re: [postgis-users] query a certain row from a table.<br>
>> Message-ID:<br>
>> <br>
>> <<a href="mailto:CALTSVX9DsHew5rm2kbxjTQjDYo11Y9b_xHpy8D7Pm%2BpSsCB-ww@mail.gmail.com" target="_blank">CALTSVX9DsHew5rm2kbxjTQjDYo11Y9b_xHpy8D7Pm+pSsCB-ww@mail.gmail.com</a><br>
>> <mailto:<a href="mailto:CALTSVX9DsHew5rm2kbxjTQjDYo11Y9b_xHpy8D7Pm%252BpSsCB-ww@mail.gmail.com" target="_blank">CALTSVX9DsHew5rm2kbxjTQjDYo11Y9b_xHpy8D7Pm%2BpSsCB-ww@mail.gmail.com</a>>><br>
>> Content-Type: text/plain; charset="utf-8"<br>
>><br>
>> They are stored as Point. One per row.<br>
>><br>
>><br>
>><br>
>> On Saturday, March 21, 2020, Alexander Gataric <<a href="mailto:gataric@usa.net" target="_blank">gataric@usa.net</a><br>
>> <mailto:<a href="mailto:gataric@usa.net" target="_blank">gataric@usa.net</a>>> wrote:<br>
>><br>
>> > What format are the points stored in? Point, multipoint? How<br>
>> many points<br>
>> > per row?<br>
>> ><br>
>> > Get BlueMail for Android <<a href="http://www.bluemail.me/r?b=15824" rel="noreferrer" target="_blank">http://www.bluemail.me/r?b=15824</a>><br>
>> > On Mar 20, 2020, at 11:36 PM, john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a><br>
>> <mailto:<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>>> wrote:<br>
>> >><br>
>> >> Hi,<br>
>> >><br>
>> >> I'm trying to export a table of points to a shapefile. The<br>
>> 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<br>
>> 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<br>
>> offending<br>
>> >> row, but I don't know the SQL for such a query. Is there<br>
>> something I<br>
>> >> need to write in a WHERE clause or a different clause to get a<br>
>> specific row?<br>
>> >><br>
>> >><br>
>> -------------- next part --------------<br>
>> An HTML attachment was scrubbed...<br>
>> URL:<br>
>> <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/3c2986ce/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/3c2986ce/attachment-0001.html</a>><br>
>><br>
>> ------------------------------<br>
>><br>
>> Subject: Digest Footer<br>
>><br>
>> _______________________________________________<br>
>> postgis-users mailing list<br>
>> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<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><br>
>><br>
>> ------------------------------<br>
>><br>
>> End of postgis-users Digest, Vol 217, Issue 15<br>
>> **********************************************<br>
>><br>
>><br>
>> _______________________________________________<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><br>
> -- <br>
> Enlightenment is ego's ultimate disappointment.<br>
> -Chogyam Trungpa<br>
<br>
-- <br>
Enlightenment is ego's ultimate disappointment.<br>
-Chogyam Trungpa<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20200325/ecfd1837/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200325/ecfd1837/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<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><br>
<br>
------------------------------<br>
<br>
End of postgis-users Digest, Vol 217, Issue 19<br>
**********************************************<br>
</blockquote></div>