[mapguide-users] postgis fdo-ogr and spatial indexes

[Traian Stanev]

Trunk is the only one that I check fixes into.
 

	-----Original Message----- 
	From: mapguide-users-bounces at lists.osgeo.org on behalf of Jason Birch 
	Sent: Wed 6/13/2007 6:30 PM 
	To: MapGuide Users Mail List 
	Cc: 
	Subject: RE: [mapguide-users] postgis fdo-ogr and spatial indexes
	
	

	I believe that this is the 3.2.x branch:
	
	http://svn.osgeo.org/fdoogr/branches/3.2.x/Providers/OGR/
	
	And this is the "bloated" version in trunk :)
	
	http://svn.osgeo.org/fdo/trunk/Providers/OGR/
	
	(that's a joke.  fdoogr is the most minimal provider out there)
	
	I'm not sure which is being used for the recent builds...
	
	Jason
	
	
	-----Original Message-----
	From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of alucas
	Sent: Wednesday, June 13, 2007 14:48
	To: mapguide-users at lists.osgeo.org
	Subject: Re: [mapguide-users] postgis fdo-ogr and spatial indexes
	
	
	Where can I download the source code of ogr provider?
	
	
	
	Frank Warmerdam-2 wrote:
	>
	> alucas wrote:
	>> Hello,
	>>
	>> I'm testing the ogr provider with postgis and it works fine, I
	>> connect vía Map 2008 and MGOS 1.2. So, the question is about the
	>> spatial indexes (gist).
	>> How works the ogr provider with gist indexes? I'm attempting to get
	>> better performance with this configuration.
	>
	> "alucas",
	>
	> GDAL/OGR 1.4 uses the following construct when building a query
	> against a postgis table to apply a spatial filter.
	>
	>      m_poFilterGeom->getEnvelope( &sEnvelope );
	>          osWHERE.Printf("WHERE %s && SetSRID('BOX3D(%.12f %.12f, %.12f
	> %.12f)'::box3d,%d) ",
	>                         pszGeomColumn,
	>                         sEnvelope.MinX, sEnvelope.MinY,
	>                         sEnvelope.MaxX, sEnvelope.MaxY,
	>                         nSRSId );
	>
	> This is intended to use the spatial index and normally works as far as
	> I know.  If you run MgServer from the commandline, and enable
	> CPL_DEBUG (set this enviroment variable to ON) you should see debug
	> output from the OGR provider indicating the specific query it ends up
	> using.  It should be prefixed with something like:
	>
	>    OGRPGTableLayer::BuildWhere returns:
	>
	> Best regards,
	> --
	> ---------------------------------------+------------------------------
	> ---------------------------------------+--------
	> I set the clouds in motion - turn up   | Frank Warmerdam,
	> warmerdam at pobox.com
	> light and sound - activate the windows | http://pobox.com/~warmerdam
	> and watch the world go round - Rush    | President OSGeo, http://osgeo.org <http://osgeo.org/> 
	>
	> _______________________________________________
	> mapguide-users mailing list
	> mapguide-users at lists.osgeo.org
	> http://lists.osgeo.org/mailman/listinfo/mapguide-users
	>
	>
	
	--
	View this message in context: http://www.nabble.com/postgis-fdo-ogr-and-spatial-indexes-tf3917522s16610.html#a11109589
	Sent from the MapGuide Users mailing list archive at Nabble.com.
	
	_______________________________________________
	mapguide-users mailing list
	mapguide-users at lists.osgeo.org
	http://lists.osgeo.org/mailman/listinfo/mapguide-users
	_______________________________________________
	mapguide-users mailing list
	mapguide-users at lists.osgeo.org
	http://lists.osgeo.org/mailman/listinfo/mapguide-users
	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070613/555cac1e/attachment.html