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

[john polo]

I used

SELECT "SAMPLING_EVENT_IDENTIFIER" FROM p_loc.ebird_sel_spt
WHERE ST_IsValid(geom) is false
;

No rows are returned.


On 3/21/2020 4:13 PM, Alexander Gataric wrote:
> Write a query using predicate
>
> ST_IsValid(geom_column) is false
>
> Get BlueMail for Android <http://www.bluemail.me/r?b=15824>
> On Mar 21, 2020, at 10:06 AM, John Polo <jpolo at mail.usf.edu 
> <mailto: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
>     <mailto: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
>         <mailto: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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-- 
Enlightenment is ego's ultimate disappointment.
-Chogyam Trungpa

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/899bbb84/attachment.html>