Super Seite:
http://www.google.de/url?sa=t&source...tZdzwQ&cad=rja
Code:SELECT m.name, Sum(v.ndp) AS ndp, Sum(v.liberal) AS liberal, Sum(v.green) AS green, Sum(v.unity) AS unity, Sum(v.vtotal) AS total FROM bc_voting_areas v, bc_municipality m WHERE ST_Intersects(v.the_geom, m.the_geom) GROUP BY m.name ORDER BY m.name; name | ndp | liberal | green | unity | total ---------------------------+-------+---------+-------+-------+------- 100 MILE HOUSE | 398 | 959 | 0 | 70 | 1527 ABBOTSFORD | 1507 | 9547 | 27 | 575 | 12726 ALERT BAY | 366 | 77 | 26 | 0 | 500 ANMORE | 247 | 1299 | 0 | 0 | 1644 ARMSTRONG | 433 | 1231 | 199 | 406 | 2389 ASHCROFT | 217 | 570 | 0 | 39 | 925 BELCARRA | 93 | 426 | 37 | 0 | 588 BURNABY | 15500 | 31615 | 8276 | 1218 | 58316 BURNS LAKE | 370 | 919 | 104 | 92 | 1589 CACHE CREEK | 76 | 323 | 0 | 27 | 489 CAMPBELL RIVER | 2814 | 6904 | 1064 | 0 | 11191 . . . . . . .



LinkBack URL
About LinkBacks
Zitieren
Lesezeichen