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

[Paul Ramsey]

Very punny

> On Mar 23, 2020, at 9:54 AM, Martin Davis <mtnclimb at gmail.com> wrote:
> 
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users