Proximity Searching Delivery Area

I'm certainly no expert, but you may have some success using a PostGreSQL/PostGIS approach, as PostGreSQL is going to have spatial analysis tool superior to MySQL. This module is quite helpful: http://drupal.org/project/sync_postgis

I read that MySQL 5.6.1 will have these features.

http://dev.mysql.com/doc/refman/5.6/en/functions-for-testing-spatial-rel...

MySQL originally implemented these functions such that they used object bounding rectangles and returned the same result as the corresponding MBR-based functions. As of MySQL 5.6.1, corresponding versions are available that use precise object shapes. These versions are named with an ST_ prefix. For example, Contains() uses object bounding rectangles, whereas ST_Contains() uses object shapes.

As of MySQL 5.6.1, there are also ST_ aliases for existing spatial functions that were already exact. For example, ST_IsEmpty() is an alias for IsEmpty()

James Sinkiewicz
Drupal Site Builder and Generalist
http://MyDrupalJourney.com

Has anybody had any luck integrating Search API (allows the use of external search servers, like Apache Solr) with Proximity-based searching? Spatial searching should be something that would come naturally with more complex search indexes.

i haven't personally used it, but i believe your main starting point should be this thread:
http://drupal.org/node/1798168

drunken_monkey, the search_api maintainer has started reworking the search_api_location module which still seems to be at an experimental, but usable status.

I went thru the thread and it looks very promising. I'll open up Search API Location and see if I can make it work.

I was able to setup Search API Location with Apache Solr but unfortunately proximity searching isn't there quite yet. It's very promising, though. FYI: I checked out GIT because, for some reason, the dev version isn't being updated.

• tom_o_t
• webgeer
• Brandonian
• zzolo

• Arabic
• Alappuzha
• Event Platform
• Western Ohio User Group
• Goa Drupal Community
• Liverpool
• Chandigarh Drupal Geeks (C.D.G.)
• API-First Working Group
• Compony opinionated developers
• 4SPOTS