<div dir="ltr">DBase III 1 milliard d'enregistrements par fichier ;</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le lun. 23 mars 2020 à 20:03, <<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: query a certain row from a table. (Willem Hoffmans) (Willem)<br>
2. Re: query a certain row from a table. (Willem Hoffmans)<br>
(john polo)<br>
3. Re: query a certain row from a table. (Paul Ramsey)<br>
4. Re: query a certain row from a table. (Martin Davis)<br>
5. Re: query a certain row from a table. (Paul Ramsey)<br>
6. Re: postgis-users Digest, Vol 217, Issue 15 (Freddy Gonthier)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Mon, 23 Mar 2020 10:12:21 +0100<br>
From: Willem <<a href="mailto:info@ruimtemaatwerk.nl" target="_blank">info@ruimtemaatwerk.nl</a>><br>
To: <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. (Willem<br>
Hoffmans)<br>
Message-ID: <<a href="mailto:43cc4dcf-b918-3bb1-17ad-5798c2baf8a5@ruimtemaatwerk.nl" target="_blank">43cc4dcf-b918-3bb1-17ad-5798c2baf8a5@ruimtemaatwerk.nl</a>><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br>
<br>
<br>
I'm pretty sure it's the limitations of the Shapefile (or, more <br>
precisely, the underlying .dbf format) that gives the error.<br>
Those .dbf files can only contain 2GB of data, see also:<br>
<br>
<a href="https://en.wikipedia.org/wiki/Shapefile" rel="noreferrer" target="_blank">https://en.wikipedia.org/wiki/Shapefile</a><br>
<br>
So ask yourself the question: why export to shapefile? Try Geopackage, <br>
for instance, it's better, without those limitations.<br>
<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 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>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20200323/24c1459e/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200323/24c1459e/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Mon, 23 Mar 2020 06:24:32 -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] query a certain row from a table. (Willem<br>
Hoffmans)<br>
Message-ID: <<a href="mailto:0b36910b-9469-2fe1-ef85-63aa10d72dbc@mail.usf.edu" target="_blank">0b36910b-9469-2fe1-ef85-63aa10d72dbc@mail.usf.edu</a>><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br>
<br>
Thanks, Willem. I'll try that instead.<br>
<br>
best regards,<br>
<br>
John<br>
<br>
On 3/23/2020 2:12 AM, Willem wrote:<br>
><br>
> I'm pretty sure it's the limitations of the Shapefile (or, more <br>
> precisely, the underlying .dbf format) that gives the error.<br>
> Those .dbf files can only contain 2GB of data, see also:<br>
><br>
> <a href="https://en.wikipedia.org/wiki/Shapefile" rel="noreferrer" target="_blank">https://en.wikipedia.org/wiki/Shapefile</a><br>
><br>
> So ask yourself the question: why export to shapefile? Try Geopackage, <br>
> for instance, it's better, without those limitations.<br>
><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>
> 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>
> _______________________________________________<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/20200323/0b0e420f/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200323/0b0e420f/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Mon, 23 Mar 2020 08:30:01 -0700<br>
From: Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>><br>
To: PostGIS Users Discussion <<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:7AFC7B1F-919D-4DAD-99AC-94E2E4DF3D6B@cleverelephant.ca" target="_blank">7AFC7B1F-919D-4DAD-99AC-94E2E4DF3D6B@cleverelephant.ca</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
Challenge accepted!!!!<br>
<br>
pramsey=# select st_isvalid(st_makepoint('NaN'::float8,1));<br>
NOTICE: Invalid Coordinate at or near point nan 1<br>
st_isvalid <br>
------------<br>
f<br>
(1 row)<br>
<br>
<br>
<br>
<br>
> On Mar 21, 2020, at 10:51 PM, Martin Davis <<a href="mailto:mtnclimb@gmail.com" target="_blank">mtnclimb@gmail.com</a>> wrote:<br>
> <br>
> Not surprising - I'm not sure it's possible to make an invalid point.<br>
> <br>
> On Sat, Mar 21, 2020 at 10:07 PM john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>> wrote:<br>
> I used<br>
> <br>
> SELECT "SAMPLING_EVENT_IDENTIFIER" FROM p_loc.ebird_sel_spt<br>
> WHERE ST_IsValid(geom) is false<br>
> ;<br>
> <br>
> No rows are returned. <br>
> <br>
> <br>
> <br>
> On 3/21/2020 4:13 PM, Alexander Gataric wrote:<br>
>> Write a query using predicate<br>
>> <br>
>> ST_IsValid(geom_column) is false <br>
>> <br>
>> Get BlueMail for Android<br>
>> 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:<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>> wrote: <br>
>> What format are the points stored in? Point, multipoint? How many points per row? <br>
>> <br>
>> Get BlueMail for Android<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>> 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 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>
>> <br>
>> postgis-users mailing list<br>
>> <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>
>> postgis-users mailing list<br>
>> <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>
> 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>
> 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>
------------------------------<br>
<br>
Message: 4<br>
Date: Mon, 23 Mar 2020 09:54:15 -0700<br>
From: Martin Davis <<a href="mailto:mtnclimb@gmail.com" target="_blank">mtnclimb@gmail.com</a>><br>
To: PostGIS Users Discussion <<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>
<CAK2ens2-Xs7d=<a href="mailto:Bw83L35GZ9j2GwpVRiefBqt6tXwD-5mQ1Ovdg@mail.gmail.com" target="_blank">Bw83L35GZ9j2GwpVRiefBqt6tXwD-5mQ1Ovdg@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Ah yes, good point!<br>
<br>
On Mon, Mar 23, 2020 at 8:30 AM Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>><br>
wrote:<br>
<br>
> Challenge accepted!!!!<br>
><br>
> pramsey=# select st_isvalid(st_makepoint('NaN'::float8,1));<br>
> NOTICE: Invalid Coordinate at or near point nan 1<br>
> st_isvalid<br>
> ------------<br>
> f<br>
> (1 row)<br>
><br>
><br>
><br>
><br>
> > On Mar 21, 2020, at 10:51 PM, Martin Davis <<a href="mailto:mtnclimb@gmail.com" target="_blank">mtnclimb@gmail.com</a>> wrote:<br>
> ><br>
> > Not surprising - I'm not sure it's possible to make an invalid point.<br>
> ><br>
> > On Sat, Mar 21, 2020 at 10:07 PM john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>> wrote:<br>
> > I used<br>
> ><br>
> > SELECT "SAMPLING_EVENT_IDENTIFIER" FROM p_loc.ebird_sel_spt<br>
> > WHERE ST_IsValid(geom) is false<br>
> > ;<br>
> ><br>
> > No rows are returned.<br>
> ><br>
> ><br>
> ><br>
> > On 3/21/2020 4:13 PM, Alexander Gataric wrote:<br>
> >> Write a query using predicate<br>
> >><br>
> >> ST_IsValid(geom_column) is false<br>
> >><br>
> >> Get BlueMail for Android<br>
> >> 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:<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>
> wrote:<br>
> >> What format are the points stored in? Point, multipoint? How many<br>
> points per row?<br>
> >><br>
> >> Get BlueMail for Android<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>> 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 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<br>
> row?<br>
> >><br>
> >><br>
> >><br>
> >> postgis-users mailing list<br>
> >><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>
> >> postgis-users mailing list<br>
> >><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>
> > 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>
> > 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>
> 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>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20200323/fa68ecd5/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200323/fa68ecd5/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 5<br>
Date: Mon, 23 Mar 2020 09:54:50 -0700<br>
From: Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>><br>
To: PostGIS Users Discussion <<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:CB8820B0-9DAF-40A4-8232-3263ED7345E3@cleverelephant.ca" target="_blank">CB8820B0-9DAF-40A4-8232-3263ED7345E3@cleverelephant.ca</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
Very punny<br>
<br>
> On Mar 23, 2020, at 9:54 AM, Martin Davis <<a href="mailto:mtnclimb@gmail.com" target="_blank">mtnclimb@gmail.com</a>> wrote:<br>
> <br>
> Ah yes, good point!<br>
> <br>
> On Mon, Mar 23, 2020 at 8:30 AM Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>> wrote:<br>
> Challenge accepted!!!!<br>
> <br>
> pramsey=# select st_isvalid(st_makepoint('NaN'::float8,1));<br>
> NOTICE: Invalid Coordinate at or near point nan 1<br>
> st_isvalid <br>
> ------------<br>
> f<br>
> (1 row)<br>
> <br>
> <br>
> <br>
> <br>
> > On Mar 21, 2020, at 10:51 PM, Martin Davis <<a href="mailto:mtnclimb@gmail.com" target="_blank">mtnclimb@gmail.com</a>> wrote:<br>
> > <br>
> > Not surprising - I'm not sure it's possible to make an invalid point.<br>
> > <br>
> > On Sat, Mar 21, 2020 at 10:07 PM john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>> wrote:<br>
> > I used<br>
> > <br>
> > SELECT "SAMPLING_EVENT_IDENTIFIER" FROM p_loc.ebird_sel_spt<br>
> > WHERE ST_IsValid(geom) is false<br>
> > ;<br>
> > <br>
> > No rows are returned. <br>
> > <br>
> > <br>
> > <br>
> > On 3/21/2020 4:13 PM, Alexander Gataric wrote:<br>
> >> Write a query using predicate<br>
> >> <br>
> >> ST_IsValid(geom_column) is false <br>
> >> <br>
> >> Get BlueMail for Android<br>
> >> 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:<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>> wrote: <br>
> >> What format are the points stored in? Point, multipoint? How many points per row? <br>
> >> <br>
> >> Get BlueMail for Android<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>> 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 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>
> >> <br>
> >> postgis-users mailing list<br>
> >> <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>
> >> postgis-users mailing list<br>
> >> <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>
> > 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>
> > 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>
> 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>
> 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>
------------------------------<br>
<br>
Message: 6<br>
Date: Mon, 23 Mar 2020 17:56:26 +0100<br>
From: Freddy Gonthier <<a href="mailto:freddy.gonthier@gmail.com" target="_blank">freddy.gonthier@gmail.com</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:<br>
<CABDF1V0OaNFyB=<a href="mailto:yH1fC-mFrU7DRrjgNxV1LRYM3Rdv4wCZrpAQ@mail.gmail.com" target="_blank">yH1fC-mFrU7DRrjgNxV1LRYM3Rdv4wCZrpAQ@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<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>> a<br>
é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><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. 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>><br>
> To: PostGIS Users Discussion <<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>
> 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 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<br>
> 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>><br>
> To: PostGIS Users Discussion <<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>
> Content-Type: text/plain; charset="utf-8"<br>
><br>
> What format are the points stored in? Point, multipoint? How many points<br>
> per row?<br>
><br>
> Get BlueMail for Android <br>
><br>
> On Mar 20, 2020, 11:36 PM, at 11:36 PM, john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>><br>
> 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 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 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><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>
><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>><br>
> To: PostGIS Users Discussion <<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>
> 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>> wrote:<br>
><br>
> > What format are the points stored in? Point, multipoint? How 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>> wrote:<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 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<br>
> 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>
><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 15<br>
> **********************************************<br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20200323/d8941043/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200323/d8941043/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 17<br>
**********************************************<br>
</blockquote></div>