Guest User

Untitled

a guest
Oct 12th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. LAYER
  2. NAME res
  3. DATA res
  4. STATUS ON
  5. TYPE POLYGON
  6. DUMP TRUE
  7. CONNECTIONTYPE POSTGIS
  8. CONNECTION "user=blue password=applesnoranges dbname=dappl host=127.0.0.1"
  9. DATA "the_geom from (SELECT ST_ConvexHull(ST_Collect(the_geom))
  10. FROM resturants) as blankers using unique gid using SRID=5570"
  11. CLASS
  12. NAME "Resturants"
  13. STYLE
  14. COLOR 232 232 232
  15. OUTLINECOLOR 32 32 32
  16. END
  17. END
  18.  
  19. the_geom from (SELECT ST_ConvexHull(ST_Collect(the_geom))
  20. FROM resturants) as blankers using unique gid using SRID=5570;
  21.  
  22. SELECT ST_ConvexHull(
  23. ST_Collect(r.the_geom::geometry)
  24. ) AS the_geom
  25. FROM restaurants AS r;
  26.  
  27. CREATE TABLE ch AS
  28. SELECT ST_ConvexHull(
  29. ST_Collect(r.the_geom::geometry)
  30. ) AS the_geom
  31. FROM restaurants AS r;
Add Comment
Please, Sign In to add comment