search

MapServer / MapServer-import

3 stars 2 forks source link

Postgis should not suppose that data are at elevation=0 #1227

Open tbonfort opened 12 years ago

tbonfort commented 12 years ago

Reporter: jdenisgiguere@fastmail.fm Date: 2005/02/10 - 22:57

In the postgis query string 
[ex.  
query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(wkb_geometry)),'NDR'),OID::text from
habit_p_ll WHERE wkb_geometry && setSRID('BOX3D(38.5633333333333
-79.77,69.0166666666667 -56.93)'::BOX3D, find_srid('','habit_p_ll','wkb_geometry') )
]
, we should not suppose that data are at sea level. Arbitrary third coordonnate
should be mapped.

see : http://xserve.flids.com/pipermail/gdal-dev/2005-February/008066.html
tbonfort commented 12 years ago

Author: jdenisgiguere@fastmail.fm Date: 2005/02/11 - 02:02

The current request is okay. My problem was due to a bad bounding box and a
misunderstanding of && operator. Simple feature overlap is a 2D operator. (Hope
I'm right...)