Suchergebnisse

... meters of them? select p.name, p.city, sum(v.gp) as greens from bc_pubs p, bc_voting_areas v where ST_DWithin(p.the_geom, v.the_geom, 500) group by ...

... direkt nach Google Earth: Man starte psql (Beispiel mit Box um Victoria, BC, Kanada): -- Set output to unaligned \a -- Show only tuples \t ...