Skip to content

Instantly share code, notes, and snippets.

@emoen

emoen/gist:8a6e2c2554ba177a26ae

Last active August 29, 2015 14:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save emoen/8a6e2c2554ba177a26ae to your computer and use it in GitHub Desktop.
Save emoen/8a6e2c2554ba177a26ae to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT hid, id,value,gridname,periodname,depthlayername,parametername,
encode(ST_AsBinary(ST_Force_2D(geoshape)),'base64') as "geoshape"
FROM areavalue_new
WHERE gridname = 'NorMar' AND parametername = 'Test_febr2014' AND depthlayername = 'L10.0:20.0' AND
periodname = 'Q20001' AND value >= 0.0 AND value <= 19.0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment