[mapserver-users] SQL equivalent for MapScript queryByRect

[Rahkonen Jukka]

Hi,

I was thinking that why not to use standard WFS which supports well your example query.  However, it can be difficult to optimize WFS for some certaind frequently used queries because WFS must support almost everything you and your users can imagine. I did a quick search and I believe this article is worth reading
http://etd.ohiolink.edu/send-pdf.cgi/Chen%20Wei.pdf?osu1251042506

-Jukka Rahkonen-



Shorthouse, David
> Lähetetty: 20. joulukuuta 2010 17:02
> Vastaanottaja: mapserver-users at lists.osgeo.org
> Aihe: [mapserver-users] SQL equivalent for MapScript queryByRect
> 
> Hello folks,
> 
> First, I'd like to say that I have been enjoying MapServer for many
> years and really appreciate the work you guys put into it. I recently
> got back into it in more earnest with a pet project for users to
> produce print-quality, greyscale point maps...learned some new tricks.
> 
> Second, I have project that requires me to query either shapefiles or
> spatially indexed tables and produce some simple web service
> responses. So, this has to perform very quickly. I am writing to
> inquire if anyone knows how one would reproduce in spatial SQL the
> exact equivalent of the PHP MapScript queryByShape? I'm starting to
> get a mess of SQL with unexpected record sets and am nowhere further
> ahead.
> 
> e.g. SELECT column FROM table WHERE (WITHIN(GEOMFROMTEXT('WKT'),
> the_geom) OR (OVERLAPS(GEOMFROMTEXT('WKT'), the_geom)) etc.
> 
> Thanks for any insights,
> 
> David P. Shorthouse
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>