This is just like an implementation I recently worked on with a customer. It’s
very much like this sort of thing ;) -
<http://nyulangone.org/doctors?query=&insurance=&location=10019&specialty=&condition=&treatment=&language=&gender=&sort=distance&originalCriteria=
<http://nyulangone.org/doctors?query=&insurance=&location=10019&specialty=&condition=&treatment=&language=&gender=&sort=distance&originalCriteria=>>
It’s implemented with Solr, leveraging the Lucidworks Fusion query pipelines to
do these steps:
- &zipcode=NNNNN comes in to the query pipeline
- a sub-query is made to a separate zipcodes index (built from a CSV file of
zipcodes and their corresponding representative lat/lon)
- the matching lat/lon is used to build the appropriate geo-filtering and
sorting parameters to pass on to the main collection
Straightforward, clean, and effective for the needs.
—
Erik Hatcher, Senior Solutions Architect
http://www.lucidworks.com <http://www.lucidworks.com/>
> On Mar 4, 2016, at 7:09 AM, Manohar Sripada <manohar...@gmail.com> wrote:
>
> Here's my requirement - User enters postal code and provides the radius. I
> need to find the records with in the radius from the provided postal code.
>
> There are few ways I thought through after going through the "Spatial
> Search" Solr wiki
>
> 1. As Latitude and Longitude positions are required for spatial search. Get
> Latitude Longitude position (may be using GeoCoding API) of a postal code
> and use "LatLonType" field type and query accordingly. As the GeoCoding API
> returns one point and if the postal code area is too big, then I may end up
> not getting any results (apart from the records from the same postal code)
> if the radius provided is small.
>
> 2. Get the latitude longitude points of the postal code which forms a
> border (not sure yet on how to get) and build a polygon (using RPT). While
> querying use this polygon and provide the distance. Can this be achieved?
> Or Am I ruminating too much? :(
>
> Appreciate any help on this.
>
> Thanks
