[postgis-devel] PostGIS RC1/2 and QGIS

strk at refractions.net strk at refractions.net
Thu Feb 10 06:12:33 PST 2005


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;

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



More information about the postgis-devel mailing list