[postgis-devel] PostGIS RC1/2 and QGIS

[strk at refractions.net]

On Fri, Feb 11, 2005 at 01:35:17PM -0500, Carl Anderson wrote:
> 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

In a binary cursor they return the same datatype: a stream of bytes
in binary form. Which the same for all postgis version. 

--strk;

> 
> 
> 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.
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel