Advertisement
Guest User

Untitled

a guest
Aug 18th, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. SELECT *, ST_Area(the_geom::geography,true) alan FROM pl_park
  2.  
  3. SELECT subquery.*
  4. FROM (
  5. [your query]
  6. ) AS subquery
  7. WHERE ST_Area(subquery.the_geom) > [some_value]
  8.  
  9. ALTER TABLE pl_park ADD COLUMN area numeric;
  10. UPDATE pl_park SET area = ST_Area(pl_park.the_geom);
  11.  
  12. SELECT *, ST_Area(the_geom::geography,true) alan FROM pl_park WHERE ST_Area(the_geom::geography,true) > 1000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement