Thank Erik, Does this zip codes index that you created is a one-to-many mapping from zip code to Lat/Lon points? If so, where did you get this mapping CSV file?
Thanks, Manohar On Friday, March 4, 2016, Erik Hatcher <erik.hatc...@gmail.com> wrote: > 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 > <javascript:;>> 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 > >