[postgis-users] Thematic map and spatial joins

Hugues François hugues.francois at irstea.fr
Mon Jun 3 02:59:48 PDT 2013


I'm not sure your query can give you the expected results. To count points from a within polys of b you should try something like
Select b.gid, count(*) from a, b
Where st_within(a.the_geom, b.the_geom)
Group by b.gid


Ps: Nico i'm home :)

Raffaele Morelli <raffaele.morelli at gmail.com> a écrit :

More information about the postgis-users mailing list