Does anyone know where I might be able to download/purchase a database of US cities and their longitude/latitude coordinates? I''d like to provide a search option on a website that allows users to search by city but include cities in the surrounding area. Thanks, Carl Youngblood _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
I¹ve used this in the past: http://www.zipcodedownload.com/ From: Carl Youngblood <carl.youngblood-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> Reply-To: <carl-MJzSGySFh6ZUfOvSQQQpYw@public.gmane.org>, <rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org> Date: Tue, 14 Jun 2005 12:18:46 -0700 To: <rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org> Subject: [Rails] OT: US city proximity search Does anyone know where I might be able to download/purchase a database of US cities and their longitude/latitude coordinates? I''d like to provide a search option on a website that allows users to search by city but include cities in the surrounding area. Thanks, Carl Youngblood _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
I did some stuff related to this a looong time ago; you can find what I put together at: http://glueless.net/rails/zip/ The initial data was from the census2k website: http://www.census.gov/geo/www/gazetteer/places2k.html (Copies of what I used are included at my URL) You can do proximity stuff with the earth_distance function I believe. I did it manually in psql but never added that functionality to my models. It seemed rather fast (enough). Feel free to do whatever you want with what I''ve done. Have fun! -d. On 6/14/05, Carl Youngblood <carl.youngblood-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Does anyone know where I might be able to download/purchase a database of US > cities and their longitude/latitude coordinates? I''d like to provide a > search option on a website that allows users to search by city but include > cities in the surrounding area.
Check out Geo::PostalCode in perls cpan http://search.cpan.org/~tjmather/Geo-PostalCode-0.06/lib/Geo/PostalCode.pm It loads in data and places them in a berkley db> -----Original Message----- > From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Dan Peterson > Sent: June 14, 2005 12:24 PM > To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > Subject: Re: [Rails] OT: US city proximity search > > I did some stuff related to this a looong time ago; you can find what > I put together at: > > http://glueless.net/rails/zip/ > > The initial data was from the census2k website: > > http://www.census.gov/geo/www/gazetteer/places2k.html > > (Copies of what I used are included at my URL) > > You can do proximity stuff with the earth_distance function I believe. > I did it manually in psql but never added that functionality to my > models. It seemed rather fast (enough). Feel free to do whatever you > want with what I''ve done. > > Have fun! > -d. > > On 6/14/05, Carl Youngblood <carl.youngblood-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > Does anyone know where I might be able to download/purchase > a database of US > > cities and their longitude/latitude coordinates? I''d like > to provide a > > search option on a website that allows users to search by > city but include > > cities in the surrounding area. > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
The USGS is a free database with every city in the US, lat/lon and a bunch of other useful information. This doesn''t have zip code data. Last I checked you have to buy that. -Jeff ----- Original Message ----- From: "Dan Peterson" <dpiddy-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> To: <rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org> Sent: Tuesday, June 14, 2005 1:24 PM Subject: Re: [Rails] OT: US city proximity search I did some stuff related to this a looong time ago; you can find what I put together at: http://glueless.net/rails/zip/ The initial data was from the census2k website: http://www.census.gov/geo/www/gazetteer/places2k.html (Copies of what I used are included at my URL) You can do proximity stuff with the earth_distance function I believe. I did it manually in psql but never added that functionality to my models. It seemed rather fast (enough). Feel free to do whatever you want with what I''ve done. Have fun! -d. On 6/14/05, Carl Youngblood <carl.youngblood-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Does anyone know where I might be able to download/purchase a database of > US > cities and their longitude/latitude coordinates? I''d like to provide a > search option on a website that allows users to search by city but include > cities in the surrounding area._______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
I also did some research on this a while back and found some free information and put it on my blog... here ya go: http://www.getintothis.com/blog/2005/04/05/ip-to-country-lookup-us-zipcode-database-free-and-much-more On 6/14/05, Clayton Cottingham <dr.frog-fVOoFLC7IWo@public.gmane.org> wrote:> > Check out Geo::PostalCode in perls cpan > http://search.cpan.org/~tjmather/Geo-PostalCode-0.06/lib/Geo/PostalCode.pm > > It loads in data and places them in a berkley db > > > > > > -----Original Message----- > > From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Dan Peterson > > Sent: June 14, 2005 12:24 PM > > To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > Subject: Re: [Rails] OT: US city proximity search > > > > I did some stuff related to this a looong time ago; you can find what > > I put together at: > > > > http://glueless.net/rails/zip/ > > > > The initial data was from the census2k website: > > > > http://www.census.gov/geo/www/gazetteer/places2k.html > > > > (Copies of what I used are included at my URL) > > > > You can do proximity stuff with the earth_distance function I believe. > > I did it manually in psql but never added that functionality to my > > models. It seemed rather fast (enough). Feel free to do whatever you > > want with what I''ve done. > > > > Have fun! > > -d. > > > > On 6/14/05, Carl Youngblood <carl.youngblood-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Does anyone know where I might be able to download/purchase > > a database of US > > > cities and their longitude/latitude coordinates? I''d like > > to provide a > > > search option on a website that allows users to search by > > city but include > > > cities in the surrounding area. > > _______________________________________________ > > Rails mailing list > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- - Ramin http://www.getintothis.com/blog _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
On Tue, 14 Jun 2005, Ramin wrote:> I also did some research on this a while back and found some free > information and put it on my blog... here ya go: > http://www.getintothis.com/blog/2005/04/05/ip-to-country-lookup-us-zipcode-database-free-and-much-moreI think the main point of the commercial stuff is that they keep it updated and give QAed updates. Speaking on the IP-to-country lookup, it''s a much harder problem than you''d think; a lot of the answers are not easy. There''s no single source of information you can rely upon consistently. Then again, I''m a Network Geographer for a living, so I''m used to seeing the hard stuff. :) -- _Deirdre web: http://deirdre.net blog: http://deirdre.org/blog/ yarn: http://fuzzyorange.com cat''s blog: http://fuzzyorange.com/vsd/ "Memes are a hoax! Pass it on!"
OpenACS includes some of the US census data from 1998 or something like that, which seems to be the last set made available on-line. The US Census now charges for newer versions of the data (because I think the US Post Office charges for it now). The US City info includes lat+long (of city hall or "center" of the postal area), and some other data. or you might try googling w.r.t US Census, city, etc. You can buy CDs from the USPS that have all the zipcode+5 information... -corey lawson On 6/14/05, Hunter Hillegas <lists-HAWAbpnI61OZ1JSuHaJ1sQC/G2K4zDHf@public.gmane.org> wrote:> I''ve used this in the past: > > http://www.zipcodedownload.com/ > > ________________________________ > From: Carl Youngblood <carl.youngblood-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > Reply-To: <carl-MJzSGySFh6ZUfOvSQQQpYw@public.gmane.org>, <rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org> > Date: Tue, 14 Jun 2005 12:18:46 -0700 > To: <rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org> > Subject: [Rails] OT: US city proximity search > > Does anyone know where I might be able to download/purchase a database of > US cities and their longitude/latitude coordinates? I''d like to provide a > search option on a website that allows users to search by city but include > cities in the surrounding area. > > Thanks, > Carl Youngblood > > ________________________________ > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >