Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CONNECTIONTYPE POSTGIS
- CONNECTION "dbname=contours host=localhost user=contour_xxxx password=xxx"
- PROCESSING "CLOSE_CONNECTION=DEFER"
- DATA "wkb_geometry from contours USING UNIQUE ogc_fid USING
- contourinterval=40"
- select
- "contourelevation",
- encode(ST_AsBinary(ST_Force2D("wkb_geometry"),'NDR'),'hex') as geom,
- "ogc_fid"
- from contours
- where wkb_geometry &&
- ST_GeomFromText('POLYGON((-111.939697265625
- 33.4213636331582,-111.939697265625 33.4323499612832,-111.9287109375
- 33.4323499612832,-111.9287109375 33.4213636331582,-111.939697265625
- 33.4213636331582))',find_srid('','contours','wkb_geometry'))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement