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

[Paul Ramsey]

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