[postgis-users] Thematic map and spatial joins

[Hugues François]

Hello,

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

Hugues

Ps: Nico i'm home :)

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