Advertisement
Guest User

Untitled

a guest
Oct 11th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. CONNECTIONTYPE POSTGIS
  2. CONNECTION "dbname=contours host=localhost user=contour_xxxx password=xxx"
  3. PROCESSING "CLOSE_CONNECTION=DEFER"
  4. DATA "wkb_geometry from contours USING UNIQUE ogc_fid USING
  5. contourinterval=40"
  6.  
  7. select
  8. "contourelevation",
  9. encode(ST_AsBinary(ST_Force2D("wkb_geometry"),'NDR'),'hex') as geom,
  10. "ogc_fid"
  11. from contours
  12. where wkb_geometry &&
  13. ST_GeomFromText('POLYGON((-111.939697265625
  14. 33.4213636331582,-111.939697265625 33.4323499612832,-111.9287109375
  15. 33.4323499612832,-111.9287109375 33.4213636331582,-111.939697265625
  16. 33.4213636331582))',find_srid('','contours','wkb_geometry'))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement