I can execute spatial queries in pgAdmin 4 OK. select count(*) from df.pit as p inner join df.path as t on (ST_Intersects(t.path_line,ST_Buffer(p.pit_poly,10))) where p.pit_id = 50000
count 2 -- Simon Greener 39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia (m) +61 418 396 391 (w) www.spdba.com.au (m) [email protected] _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
