[mapguide-users] OGR / GEOS selection problem

[Traian Stanev]

Sure, but the actual geometric operation is what matters. If it ends up
doing a BBOX, it would not be right. It needs to do Intersects.

 

 

 

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Kenneth,
GEOGRAF A/S
Sent: Thursday, June 14, 2007 4:15 AM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] OGR / GEOS selection problem

 

It should not work if you make a polygon selection.
Tooltip and Click sends a square, so the envelope of the filter should
be the same as the filter



Regards, Kenneth, GEOGRAF A/S
 



Traian Stanev skrev: 

 

Wait, from this it looks like it takes the BBOX (envelope) of the filter
and sends that to PostGIS...? That may explain things.

 

 

 

	-----Original Message----- 
	From: mapguide-users-bounces at lists.osgeo.org on behalf of
Kenneth, GEOGRAF A/S 
	Sent: Wed 6/13/2007 5:42 PM 
	To: MapGuide Users Mail List 
	Cc: 
	Subject: Re: [mapguide-users] OGR / GEOS selection problem

	It is actually forwarded to PostGIS:
	
	        OGREnvelope  sEnvelope;
	
	        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 );
	
	
	Not too good with PostGIS syntax, but since the m_poFilterGeom
is the filter used (a small square in this case) it reads:
	"Select from geometry_column where features are within the bbox
of the filer"
	
	Which should be quite ok, unless they have a similar idea of
optimizing this to a BBOX test, as OGR does.
	
	Anyway, I can confirm that Traians fix works with MapInfo TAB
files, but NOT with PostGIS :(
	
	
	

	Regards, Kenneth, GEOGRAF A/S
	    

	
	
	Traian Stanev skrev: 

	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: mapguide-users-bounces at lists.osgeo.org
	[mailto:mapguide-users-bounces at lists.osgeo.org] 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:
	  

		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
		    

	that
	  

		had the same problem as your screenshot). May be the
PostGIS OGR
		    

	driver
	  

		does something else, like forward the spatial filter to
PostGIS? In
		    

	that
	  

		case, may be I need to upgrade my PostGIS SDK...?
Anybody know the
		answer to that one?
		 
		 
		Traian
		 
		 
		-----Original Message-----
		From: mapguide-users-bounces at lists.osgeo.org
		[mailto:mapguide-users-bounces at lists.osgeo.org] 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.
		 
		http://imagepolis.com/images/20070613819095046.JPG
		 
		http://imagepolis.com/images/20070613818181055.JPG
		 
		http://imagepolis.com/images/20070613434408347.JPG
		 
		 
		Maciek
		 
		ps. and i still can't use SetSelectionXML...
		 
		    

	
http://www.nabble.com/SetSelectionXML-on-layer-from-database-%28PostgreS
	  

		QL-%3EPostgGIS%29-tf3900386s16610.html
		 
		(tiny of this url to forum)
		http://tiny.pl/fdtn
		 
		 
		maciek skorczewski
		 
		 
		 
		_______________________________________________
		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
		  
		    

	_______________________________________________
	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
	  

 


  _____  



 
_______________________________________________
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/20070614/eb725569/attachment.html