Like Hugues example... . :) [http://sig.cmparks.net/cmp-ms-90x122.png] Stephen V. Mather GIS Manager (216) 635-3243 (Work) clevelandmetroparks.com<http://www.clemetparks.com>
________________________________ From: [email protected] [[email protected]] on behalf of Stephen Mather [[email protected]] Sent: Saturday, March 16, 2013 1:47 PM To: PostGIS Users Discussion Cc: PostGIS Users Discussion Subject: Re: [postgis-users] Count Points in Polygon with Postgis Try unioning with the opposite condition. Sent from my iPod On Mar 16, 2013, at 11:53 AM, Carsten Hogertz <[email protected]<mailto:[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]<mailto:[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
