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

[Jason Birch]

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