Home » Category » Database & Application Miscellaneous

Database & Application Miscellaneous: ZipCode Search

216| Thu, 15 Nov 2007 12:07:00 GMT| galofre| 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 & Tags: zipcode, search, database, application

URL: http://database.itags.org/database-application/158224/
 
«« Prev - Next »» 4 helpful answers below.
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 |

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 |

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 |

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 |

Database & Application Miscellaneous Hot Answers

Database & Application Miscellaneous New questions

Database & Application Miscellaneous Related Categories