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

[Martin Davis]

Ah yes, good point!

On Mon, Mar 23, 2020 at 8:30 AM Paul Ramsey <pramsey at cleverelephant.ca>
wrote:

> Challenge accepted!!!!
>
> pramsey=# select st_isvalid(st_makepoint('NaN'::float8,1));
> NOTICE:  Invalid Coordinate at or near point nan 1
>  st_isvalid
> ------------
>  f
> (1 row)
>
>
>
>
> > On Mar 21, 2020, at 10:51 PM, Martin Davis <mtnclimb at gmail.com> wrote:
> >
> > 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
> >> 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
> >> 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
> >>
> >>
> >> _______________________________________________
> >> 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
> >
> > _______________________________________________
> > 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
>
> _______________________________________________
> 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/20200323/fa68ecd5/attachment.html>