[postgis-devel] PostGIS RC1/2 and QGIS

[Carl Anderson]

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
>  
>
>  
>
I'll bet QGIS was relying on Postgres converting a Bytea to a 
(de)hexstring  using the WKB  type.

check the CSTRING representation of what QGIS is recieiving

if  the ascii  form is   (Postgis 0.8 and prior)
01060000000100000001030000.....    then you are getting a  (de)hexstring
if it is  (Postgis RC1/2)
\001\006\000\000\000\000 ..... then you are getting a bytea converted to 
an escaped string

if it is binary
then it somewhere else


C.



>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-devel mailing list
>postgis-devel at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-devel
>  
>


-- 
Carl Anderson
GIS Manager Fulton County, Georgia
carl.anderson at co.fulton.ga.us
404.730.8026



-----------------------------------------------------
This message has been scanned for viruses and
dangerous content for Fulton County by DefendMail, and is
believed to be clean.