Try unioning with the opposite condition. Sent from my iPod
On Mar 16, 2013, at 11:53 AM, Carsten Hogertz <[email protected]> wrote: > I've got a simple problem: I want to count the number of points within a set > of polygons. > > I have a SQL already but it only gives back the gid of the polygone that > actually contains points. > > My tables: a polygon layer with 19.000 rows and a point layer with 450 rows. > > The following SQL > > select grid.gid, count(*) AS totale FROM grid, kioskdhd3 WHERE > st_contains(grid.geom,kioskdhd3.geom) GROUP BY grid.gid; > return only some 320 polygons that actually contain points. But I want all > polygons returned, even thought the number of points is 0. > > Of course it has to do with my WHERE-clause. Where do I have to put in my > st_contains? > > Thank you Carsten > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
