[postgis-users] query a certain row from a table.

Alexander Gataric gataric at usa.net
Sat Mar 21 16:13:50 PDT 2020


Write a query using predicate

ST_IsValid(geom_column) is false 

⁣Get BlueMail for Android ​

On Mar 21, 2020, 10:06 AM, at 10:06 AM, John Polo <jpolo at mail.usf.edu> wrote:
>They are stored as Point. One per row.
>
>
>
>On Saturday, March 21, 2020, Alexander Gataric <gataric at usa.net> wrote:
>
>> What format are the points stored in? Point, multipoint? How many
>points
>> per row?
>>
>> Get BlueMail for Android <http://www.bluemail.me/r?b=15824>
>> On Mar 20, 2020, at 11:36 PM, john polo <jpolo at mail.usf.edu> wrote:
>>>
>>> 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?
>>>
>>>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/f40d4565/attachment.html>


More information about the postgis-users mailing list