Guest User

Untitled

a guest
Mar 9th, 2015
318
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. gis_local=> select a.landuse,ST_Area(ST_Transform(ST_Union(a.way),4326)::geography) from planet_osm_polygon a,planet_osm_polygon b where a.way && b.way and st_within(a.way,b.way) and b.osm_id=-1738468 and a.landuse is not null group by a.landuse
  2. ;
  3. landuse | st_area
  4. ------------+------------------
  5. cemetery | 9796.49467898815
  6. meadow | 1017.31218878931
  7. farm | 227498.036150773
  8. landfill | 5751881.69882699
  9. farmland | 23018403.2776626
  10. allotments | 551756.553468814
  11. reservoir | 8910753.30623372
  12. forest | 270299.308343124
  13. industrial | 9931401.54529006
  14. (9 rows)
Advertisement
Add Comment
Please, Sign In to add comment