<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=KOI8-R" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
It is actually forwarded to PostGIS:<br>
<br>
<tt>ššššššš OGREnvelopeš sEnvelope;<br>
<br>
ššššššš m_poFilterGeom-&gt;getEnvelope( &amp;sEnvelope );<br>
ššššššš osWHERE.Printf("WHERE %s &amp;&amp; SetSRID('BOX3D(%.12f %.12f,
%.12f %.12f)'::box3d,%d) ",<br>
šššššššššššššššššššššš pszGeomColumn,<br>
šššššššššššššššššššššš sEnvelope.MinX, sEnvelope.MinY,<br>
šššššššššššššššššššššš sEnvelope.MaxX, sEnvelope.MaxY,<br>
šššššššššššššššššššššš nSRSId );<br>
</tt><br>
<br>
Not too good with PostGIS syntax, but since the m_poFilterGeom is the
filter used (a small square in this case) it reads:<br>
"Select from geometry_column where features are within the bbox of the
filer"<br>
<br>
Which should be quite ok, unless they have a similar idea of optimizing
this to a BBOX test, as OGR does.<br>
<br>
Anyway, I can confirm that Traians fix works with MapInfo TAB files,
but NOT with PostGIS :(<br>
<br>
<pre class="moz-signature" cols="72">Regards, Kenneth, GEOGRAF A/S
</pre>
<br>
<br>
Traian Stanev skrev:
<blockquote
 cite="mid:0345418B84C1684C8467DC5A2D7EFF6A04C13776@msgusaebk01.autodesk.com"
 type="cite">
  <pre wrap="">To put test data into PostGres I use the tool that comes with it that
can import SHP files into the database.

I think it's called shp2pgsql.


Traian


-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>
[<a class="moz-txt-link-freetext" href="mailto:mapguide-users-bounces@lists.osgeo.org">mailto:mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of Kenneth,
GEOGRAF A/S
Sent: Wednesday, June 13, 2007 3:21 PM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] OGR / GEOS selection problem

I tried it with MapInfo TAB files, and it works fine.

Maciej, can you post an SQL dump of one of the PostGIS tables?

I have installed PostGIS on my machine for testing, but I have no data, 
and no luck getting Fdo2Fdo working with FDO OGR.

Regards, Kenneth, GEOGRAF A/S



Traian Stanev skrev:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Well, I only tried it with SHP files and am pretty sure it fixed the
problem for SHP files (I did a before and after test, on a polygon
    </pre>
  </blockquote>
  <pre wrap=""><!---->that
  </pre>
  <blockquote type="cite">
    <pre wrap="">had the same problem as your screenshot). May be the PostGIS OGR
    </pre>
  </blockquote>
  <pre wrap=""><!---->driver
  </pre>
  <blockquote type="cite">
    <pre wrap="">does something else, like forward the spatial filter to PostGIS? In
    </pre>
  </blockquote>
  <pre wrap=""><!---->that
  </pre>
  <blockquote type="cite">
    <pre wrap="">case, may be I need to upgrade my PostGIS SDK...? Anybody know the
answer to that one?


Traian


-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>
[<a class="moz-txt-link-freetext" href="mailto:mapguide-users-bounces@lists.osgeo.org">mailto:mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of Maciej
Skorczewski
Sent: Wednesday, June 13, 2007 12:29 PM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] OGR / GEOS selection problem

Traian


i have still this same error...

take a look on screen.

<a class="moz-txt-link-freetext" href="http://imagepolis.com/images/20070613819095046.JPG">http://imagepolis.com/images/20070613819095046.JPG</a>

<a class="moz-txt-link-freetext" href="http://imagepolis.com/images/20070613818181055.JPG">http://imagepolis.com/images/20070613818181055.JPG</a>

<a class="moz-txt-link-freetext" href="http://imagepolis.com/images/20070613434408347.JPG">http://imagepolis.com/images/20070613434408347.JPG</a>


Maciek

ps. and i still can't use SetSelectionXML...

    </pre>
  </blockquote>
  <pre wrap=""><!----><a class="moz-txt-link-freetext" href="http://www.nabble.com/SetSelectionXML-on-layer-from-database-%28PostgreS">http://www.nabble.com/SetSelectionXML-on-layer-from-database-%28PostgreS</a>
  </pre>
  <blockquote type="cite">
    <pre wrap="">QL-%3EPostgGIS%29-tf3900386s16610.html

(tiny of this url to forum)
<a class="moz-txt-link-freetext" href="http://tiny.pl/fdtn">http://tiny.pl/fdtn</a>


maciek skorczewski



_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>


_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
  
    </pre>
  </blockquote>
  <pre wrap=""><!---->_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>


_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
  </pre>
</blockquote>
</body>
</html>