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