[postgis-devel] PostGIS RC1/2 and QGIS

Gary Sherman sherman at mrcc.com
Fri Feb 11 11:12:10 PST 2005


On Fri, 2005-02-11 at 18:46 +0100, strk at refractions.net wrote:
>On Fri, Feb 11, 2005 at 08:10:49AM -0900, Gary Sherman wrote:
>> On Thu, 2005-02-10 at 09:30 -0500, Carl Anderson wrote:
>> 
>> >mapserver 4.4.1 is working --- it uses this statement
>> >
>> >DECLARE mycursor BINARY CURSOR FOR SELECT 
>> >asbinary(force_collection(force_2d(shape)),'NDR'),geo_oid::text from 
>> >z2.case6 WHERE shape && setSRID('BOX3D(2228328.35384 
>> >1482507.61292179,2230568.16919753 1483897.32106711)'::BOX3D, 
>> >find_srid('','z2.case6','shape') )
>> >
>> I tried this syntax in QGIS and it does not allow the features to be
>> drawn. The attribute table is populated with the data from the table so
>> the cursor (both old and new syntax) is working.
>> 
>> From this I gather the problem is in the way QGIS interprets the binary
>> data for the features.
>> -gary
>
>This doesn't explain why it was working against postgis-0.x ...
>Can you manually run the query and actually get results for the
>geometry column ? Can you try with a newly created database
>and the latest postgis CVS snapshot ?
>
>--strk;
>
I changed geometryfromtext to setsrid in the declare statement and now
the features display (this is with RC2). My question is -- is this
backwards compatible to 0.9x or do we have to implement different
cursors to support previous versions of PostGIS?

-gary
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20050211/66a3cd31/attachment.sig>


More information about the postgis-devel mailing list