# Zipcode Search

**URL:** <https://www.ruby-forum.com/t/zipcode-search/100593>\
**Category:** Rails\
**Created:** [February 3, 2006, 9:31am UTC](https://www.ruby-forum.com/t/zipcode-search/100593 "2006-02-03T09:31:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Siva\_J](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/f19dbf/32.png) [@Siva\_J](https://www.ruby-forum.com/u/Siva_J)\
**Post date:** [February 3, 2006, 9:31am UTC](https://www.ruby-forum.com/t/zipcode-search/100593/1 "2006-02-03T09:31:17Z")

</div>

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 J.  
[http://www.varcasa.com/](http://www.varcasa.com/)  
Education Through Collabration

---

<div class="post-metadata">

**Author:** ![Siva\_J](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/f19dbf/32.png) [@Siva\_J](https://www.ruby-forum.com/u/Siva_J)\
**Post date:** [February 3, 2006, 10:49am UTC](https://www.ruby-forum.com/t/zipcode-search/100593/2 "2006-02-03T10:49:31Z")

</div>

On 2/3/06, Siva J. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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

---

<div class="post-metadata">

**Author:** ![Siva\_J](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/f19dbf/32.png) [@Siva\_J](https://www.ruby-forum.com/u/Siva_J)\
**Post date:** [February 3, 2006, 4:39pm UTC](https://www.ruby-forum.com/t/zipcode-search/100593/3 "2006-02-03T16:39:50Z")

</div>

Adam D. \<straightflush@…\> writes:

> Do you have longitude/latitude information?  
> This was posted yesterday. It contains a migration to give you  
> lat/long/zip  
> mapping.

> **[JvoorHis.com is for sale | HugeDomains](https://www.hugedomains.com/domain_profile.cfm?d=jvoorhis.com)**
>
> Own this domain today. We make your shopping experience easy. Friendly and quick customer service.

-damon

---

<div class="post-metadata">

**Author:** ![Siva\_J](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/f19dbf/32.png) [@Siva\_J](https://www.ruby-forum.com/u/Siva_J)\
**Post date:** [February 3, 2006, 3:05pm UTC](https://www.ruby-forum.com/t/zipcode-search/100593/4 "2006-02-03T15:05:53Z")

</div>

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](http://www.geocodeamerica.com/home/proximity)

good luck  
adam

---

<div class="post-metadata">

**Author:** ![Siva\_J](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/f19dbf/32.png) [@Siva\_J](https://www.ruby-forum.com/u/Siva_J)\
**Post date:** [February 3, 2006, 9:52pm UTC](https://www.ruby-forum.com/t/zipcode-search/100593/5 "2006-02-03T21:52:48Z")

</div>

This is great guys. I will go through this and let you guys know abt it.

–  
Rgds,  
–Siva J.  
[http://www.varcasa.com/](http://www.varcasa.com/)  
My First Rails Project.  
Education Through Collabration