Database & Application Miscellaneous: ZipCode Search

• galofre / 216 / Sat, 23 Jan 2010 16:34:00 GMT / Comments (4)
• Hello all,
  I would like to create a search by zipcode having a 5 mile radio or so. Any suggestions where should I start?
  :confused:
• Keywords:

  zipcode, search, database, application

• http://database.itags.org/database-application/158224/«« Last Thread - Next Thread »»

• 1. First you have to buy the zip code database. This includes every zip code in the us and the radians of the centerpoint of that zip code. Then you do a little, okay a lot of, math to go from radians to miles. There are turoials for this on the web just google it.

     drawmack | Fri, 16 Nov 2007 01:58:00 GMT |

  2. Can I just use the information (zipcode) that I have Registered inthe database?
     
     As costumer add new listings, the zipcode database increases, If the zipcode if not found a message will display, if found, a list of listing will show.
     
     Can this be done without the ALL zipcode database?

     galofre | Fri, 16 Nov 2007 01:59:00 GMT |

  3. sure, but are you also storing the radians of the logitude and latitude of the center point of the zip code, you'll need that to do the search.

     drawmack | Fri, 16 Nov 2007 02:00:00 GMT |

  4. Look at the postgis package for postgresql - it's open source so you can see the innards.
     
     Project URL: http://freshmeat.net/projects/postgis/

     ultraslacker | Fri, 16 Nov 2007 02:01:00 GMT |