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

[Martin Davis]

Not surprising - I'm not sure it's possible to make an invalid point.

On Sat, Mar 21, 2020 at 10:07 PM john polo <jpolo at mail.usf.edu> wrote:

> 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> 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 listpostgis-users at lists.osgeo.orghttps://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>>
> _______________________________________________
> postgis-users mailing listpostgis-users at lists.osgeo.orghttps://lists.osgeo.org/mailman/listinfo/postgis-users
>
> --
> Enlightenment is ego's ultimate disappointment.
> -Chogyam Trungpa
>
> _______________________________________________
> 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/b3c933f5/attachment.html>