Proximity Searching Delivery Area

Events happening in the community are now at Drupal community events on www.drupal.org.
mastermindg's picture
Posted by mastermindg on March 25, 2013 at 1:15pm

I'm developing a site that needs to utilize a delivery area component in address location. Typically a node would have a single geolocation, but for delivery a node would have a radius around a single point (so multiple points). Does anybody know what the best way to implement this would be so that a proximity search would give proper results based on multiple points?

Thanks!

Categories: ,

Comments

PostGIS

Posted by blattmann on March 25, 2013 at 1:28pm
blattmann's picture

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

Posted by JSCSJSCS on March 25, 2013 at 2:06pm
JSCSJSCS's picture

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

Integrating Proximity with Search API

Posted by mastermindg on April 25, 2013 at 5:00pm
mastermindg's picture

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,

Posted by dasjo on April 25, 2013 at 5:12pm
dasjo's picture

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.

Thanks!

Posted by mastermindg on April 25, 2013 at 5:23pm
mastermindg's picture

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.

Proximity isn't enabled yet...

Posted by mastermindg on April 26, 2013 at 10:37am
mastermindg's picture

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.

Location and Mapping

Group organizers

Group categories

Wiki type

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: