Is there any package that I could use for zipcode search. I want to display schools that near a particular zipcode. I have no idea how to do this. It will be great if anyone can point me where I could find info -- Rgds, --Siva Jagadeesan http://www.varcasa.com/ Education Through Collabration -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060203/9d16f458/attachment.html
On 2/3/06, Siva Jagadeesan <sivajagdev@gmail.com> wrote:> Is there any package that I could use for zipcode search. > > I want to display schools that near a particular zipcode. I have no idea > how to do this. It will be great if anyone can point me where I could find > infoHm. It''s probably lots easier to find a school IN a particular zip code instead of near one. Would that be good enough? Joe
Do you have longitude/latitude information? I can send you the
proximity query but you need the longitude and latitude in order to
find proximity zips.
Basically what you do is find the zip code in question. Then find all
the zipcodes X miles away and then find all the schools in that range
of zipcodes.
query looks like this
@places = Place.find_by_sql ["select p.* from places p where ((3963.0
* acos(sin(p.latitude/57.2958) *
sin(?/57.2958) + cos(p.latitude/57.2958) * cos(?/57.2958) *
cos(?/57.2958 - p.longitude/57.2958))) < ?)", lat, lat, lon,
distance]
check out this guys site, he really helped me out.
http://www.geocodeamerica.com/home/proximity
good luck
adam
On 2/3/06, Joe Van Dyk <joevandyk@gmail.com>
wrote:> On 2/3/06, Siva Jagadeesan <sivajagdev@gmail.com> wrote:
> > Is there any package that I could use for zipcode search.
> >
> > I want to display schools that near a particular zipcode. I have no
idea
> > how to do this. It will be great if anyone can point me where I could
find
> > info
>
> Hm. It''s probably lots easier to find a school IN a particular
zip
> code instead of near one. Would that be good enough?
>
> Joe
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
Adam Denenberg <straightflush@...> writes:> Do you have longitude/latitude information?This was posted yesterday. It contains a migration to give you lat/long/zip mapping. http://www.jvoorhis.com/articles/2006/02/02/geocoding-with-ruby-on-rails -damon
This is great guys. I will go through this and let you guys know abt it. -- Rgds, --Siva Jagadeesan http://www.varcasa.com/ My First Rails Project. Education Through Collabration -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060203/e70cb912/attachment.html