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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users