[postgis-devel] PostGIS RC1/2 and QGIS

[Carl Anderson]

strk at refractions.net wrote:

>On Thu, Feb 10, 2005 at 09:03:43AM -0500, Carl Anderson wrote:
>  
>
>>Carl Anderson wrote:
>>
>>    
>>
>>>the offending statement that QGIS is making is
>>>
>>>declare qgisf binary cursor for select oid,asbinary(shape,'NDR') as 
>>>qgs_feature_geometry from case6 where shape && 
>>>GeometryFromText('BOX3D(  2288006.545455   1472366.000000,  
>>>2291123.454545   1475094.000000)'::box3d,102667)
>>>
>>>
>>>      
>>>
>>it can be helped as   (drop geometryfromtext  and add setsrid )
>>
>>declare qgisf binary cursor for select oid,asbinary(shape,'NDR') as 
>>qgs_feature_geometry from case6 where shape && setsrid('BOX3D(  
>>2288006.545455   1472366.000000,  2291123.454545   
>>1475094.000000)'::box3d,102667)
>>    
>>
>
>Are mapserver and postgis runnign on the same host (just to exclude
>byte ordering issues) ?
>
>--strk;
>
>  
>
qgis  -WinXp (intel P4)
Postgis -  Linux (intel P3)
mapserver 4.4.1 ( intel  P3)

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'm capturing these messages by enabling  statement logging on the 
postgres server


>>>
>>>
>>>strk at refractions.net wrote:
>>>
>>>      
>>>
>>>>On Wed, Feb 09, 2005 at 08:18:42PM -0900, Gary Sherman wrote:
>>>>
>>>>
>>>>        
>>>>
>>>>>On Wed, 2005-02-09 at 10:33 +0100, strk at refractions.net wrote:
>>>>> 
>>>>>
>>>>>          
>>>>>
>>>>>>On Tue, Feb 08, 2005 at 06:53:44PM -0900, Gary Sherman wrote:
>>>>>>   
>>>>>>
>>>>>>            
>>>>>>
>>>>>>>The latest release candidates of PostGIS do not work with QGIS.
>>>>>>>Currently we use a binary cursor, using the asbinary function to 
>>>>>>>fetch
>>>>>>>the features. I took a quick look around and didn't find any
>>>>>>>documentation on the changes in lwgeom and the appropriate way to 
>>>>>>>read
>>>>>>>features.
>>>>>>>Can anyone point me to a document or give me a hint?
>>>>>>>     
>>>>>>>              
>>>>>>>
>>>>>>Can you give *us* an hint ? We're hunting exactly this bug. Reports 
>>>>>>are multipolygons
>>>>>>work while polygons don't. Can you confirm this ?
>>>>>>Can you provide sample data exploiting the bug ?
>>>>>>   
>>>>>>            
>>>>>>
>>>>>I am unable to display any data type (point, linestring, polygon, or
>>>>>multipolygon) in QGIS.
>>>>>
>>>>>I have not had time to step through the source in debug to determine 
>>>>>the
>>>>>problem. A dump file of one of the polygon layers used for testing is
>>>>>available at http://qgis.org/lakes_dump.dmp.bz2 (this was dumped with
>>>>>the -d option).
>>>>>
>>>>>-gary
>>>>> 
>>>>>          
>>>>>
>>>>Thank you gary. I've tested your data against the wkbtester prog
>>>>attached in my previous mail. It reports no difference between HWGEOM
>>>>binary cursor and LWGEOM binary cursor !
>>>>
>>>>The program opens a binary cursor for:
>>>>asbinary(force_2d(force_collection(geom))), does qgis do the same ?
>>>>
>>>>--strk;
>>>>
>>>>
>>>>
>>>>        
>>>>
>>>>>
>>>>> 
>>>>>          
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>        
>>>>
>>>>>_______________________________________________
>>>>>postgis-devel mailing list
>>>>>postgis-devel at postgis.refractions.net
>>>>>http://postgis.refractions.net/mailman/listinfo/postgis-devel
>>>>> 
>>>>>          
>>>>>
>>>>_______________________________________________
>>>>postgis-devel mailing list
>>>>postgis-devel at postgis.refractions.net
>>>>http://postgis.refractions.net/mailman/listinfo/postgis-devel
>>>>
>>>>-----------------------------------------------------
>>>>This message has been scanned for viruses and
>>>>dangerous content for Fulton County by DefendMail, and is
>>>>believed to be clean.
>>>>
>>>>
>>>>
>>>>        
>>>>
>>>      
>>>
>>-- 
>>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
>>    
>>
>_______________________________________________
>postgis-devel mailing list
>postgis-devel at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-devel
>
>-----------------------------------------------------
>This message has been scanned for viruses and
>dangerous content for Fulton County by DefendMail, and is
>believed to be clean.
>
>  
>



-- 
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.