RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

I haven't personally done a store locator, but... Store locators are relatively crude, yet useful. It is unlikely that exacting math will make one less crude in such a way as to make it significantly more useful. They usually just display a list of locations that *might* be convenient, and that's

Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

On 2006-04-26, at 20:53, Nicolas Verhaeghe wrote: Also, in order to do the Zip+4 translation, you need a good CASS certification script. Most of these products are expensive. You could program your own, but from talking to a programmer who created such a product, it takes years to come with a g

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

]; Daevid Vincent Cc: mysql@lists.mysql.com Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) You could further explain the lats and longs being "slightly off" by the use of a different datum. There are many many datums utilised by different geographical/geological a

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

r anything. > -Original Message- > From: Gmail User [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 25, 2006 6:03 AM > To: mysql@lists.mysql.com > Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. > negative longitude) > > On Tue, 2006-04-25 at 00:43 -0700, D

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

To: Daevid Vincent Cc: mysql@lists.mysql.com Subject: Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) Daevid Vincent wrote: My confusion is that I have some formulas to plug in these values, but it seems to me that if I use the wrong set of data, my zipcodes wil

Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

--- From: Gmail User [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 25, 2006 6:03 AM To: mysql@lists.mysql.com Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) On Tue, 2006-04-25 at 00:43 -0700, Daevid Vincent wrote: So for a sanity check, I decided to loo

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

[snip] Thanks for the graph. So are you saying that I should use the database that has the negative values, and not the one that uses positive values? I'm in the USA. I don't care about anywhere else (for my location needs that is). [/snip] Yes, that would be using the proper notation for lat

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

ROTECTED] > Sent: Tuesday, April 25, 2006 6:03 AM > To: mysql@lists.mysql.com > Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. > negative longitude) > > On Tue, 2006-04-25 at 00:43 -0700, Daevid Vincent wrote: > > So for a sanity check, I decided to look "online

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

Thanks for the graph. So are you saying that I should use the database that has the negative values, and not the one that uses positive values? I'm in the USA. I don't care about anywhere else (for my location needs that is). > -Original Message- > From: Jay Blanchard [mailto:[EMAIL PR

Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

Hello, Not wanting to "hijack" this thread, but what is the best source for a zip code database? The "best" free one I could find was from census data from the last census. Sometimes it won't recognize all the zips from large cities. Thanks, R -- MySQL General Mailing List For list archiv

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

[snip] I procured myself some zip/lat/long databases from various places. Then I noticed that for the same zip code, I got different values in different databases??!!! [/snip] Latitudes and longitudes are often represented based on their location relative to the equator and the prime meridian;

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

I'm so confused. I'm finally getting around to needing to do a 'store locator' thing. I procured myself some zip/lat/long databases from various places. Then I noticed that for the same zip code, I got different values in different databases??!!! So for a sanity check, I decided to look "online

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

Read these http://en.wikipedia.org/wiki/Longitude http://en.wikipedia.org/wiki/Lattitude And no, you cannot drive my yacht ;-) -Original Message- From: Gmail User [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 9:05 AM To: mysql@lists.mysql.com Subject: RE: Calculate LONG/LAT

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

... err, as would be South... N+, S-, E+, W- Ed :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

On Tue, 2006-04-25 at 00:43 -0700, Daevid Vincent wrote: > So for a sanity check, I decided to look "online" and punch in some to see > what the "real" lat/long should be. Well, different sites give different > values, and not only are they "slightly" off, but sometimes they're > _positive_ or _neg

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

I'm so confused. I'm finally getting around to needing to do a 'store locator' thing. I procured myself some zip/lat/long databases from various places. Then I noticed that for the same zip code, I got different values in different databases??!!! So for a sanity check, I decided to look "online"

RE: Calculate LONG/LAT from ZIP+4

mysql@lists.mysql.com Subject: Re: Calculate LONG/LAT from ZIP+4 One compromise between the large 5 digit zips and the 9-digit zip+4's is carrier route. There are about 600,000 carrier routes in the USA each denoted by the 5-digit zip and the carrier route, for example 34685-R036. 600,000 is

Re: Calculate LONG/LAT from ZIP+4

One compromise between the large 5 digit zips and the 9-digit zip+4's is carrier route. There are about 600,000 carrier routes in the USA each denoted by the 5-digit zip and the carrier route, for example 34685-R036. 600,000 is certainly more manageable than 70,000,000 zip+4's. Does anyone know

Re: Calculate LONG/LAT from ZIP+4

http://www.buyzips.com/platinum-expanded.htm This one also says it's only updated every 6 months. Ouch!! Another reason I recommend Zipwise instead. Cheaper and fresher data: http://www.zipwise.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Calculate LONG/LAT from ZIP+4

A lot cheaper here: http://www.zipwise.com/database-download-now.php On Jun 28, 2005, at 5:30 AM, Mattias Håkansson wrote: This one goes for $169, and you get longitudes and latitudes. http://www.buyzips.com/platinum-expanded.htm Regards, Mattias Håkansson - Original Message - From

Re: Calculate LONG/LAT from ZIP+4

Just remember, there is a big difference in 5-digit ZIPs which cover a large area (can be many miles in width and height) and 9-digit ZIP+4's which usually cover a city block. Zip+4 lat/lngs provide greater accuracy for accurate radius analysis of say a list of mailing addresses for a mailing c

Re: Calculate LONG/LAT from ZIP+4

This one goes for $169, and you get longitudes and latitudes. http://www.buyzips.com/platinum-expanded.htm Regards, Mattias Håkansson - Original Message - From: "Jack Lauman" <[EMAIL PROTECTED]> To: "MySql" Sent: Monday, June 27, 2005 2:29 AM Subject: Calculate LONG/LAT from ZIP+4 >

Re: Calculate LONG/LAT from ZIP+4

There are about 70 million ZIP+4's in the USA. Buying a data file that you can import into your own database typically costs around $10,000 from the small handful of companies that actually compile the data! However, there are data broker companies such as Melissa Data (http://www.melissadata.c

Re: Calculate LONG/LAT from ZIP+4

Changes average about 10 a month, in my experience: new ZIP codes and split ZIP codes, plus quite a few that go away. So you are working with a database that's probably around 2% wrong. I've never seen a *free* source of current accurate data: the USPS charges a lot for this, so generally t

Re: Calculate LONG/LAT from ZIP+4

Brian Dunning <[EMAIL PROTECTED]> writes: > Dude, that's more than 5 years old. Yup, but it's worked fine for every application I've used it for. ZIP codes don't tend to get moved around very often, and when they do it's not very far... ScottG. [...] >> As I said below, you can download a

Re: Calculate LONG/LAT from ZIP+4

Dude, that's more than 5 years old. On Jun 26, 2005, at 8:27 PM, Scott Gifford wrote: Brian Dunning <[EMAIL PROTECTED]> writes: You have to purchase a database. ZIP codes are not geographic, you can't calculate lat/lon from them. Here is one source: http://www.zipwise.com As I said below

Re: Calculate LONG/LAT from ZIP+4

Brian Dunning <[EMAIL PROTECTED]> writes: > You have to purchase a database. ZIP codes are not geographic, you > can't calculate lat/lon from them. Here is one source: > http://www.zipwise.com As I said below, you can download a free database from the US Census Bureau. Specifically, the data her

Re: Calculate LONG/LAT from ZIP+4

You have to purchase a database. ZIP codes are not geographic, you can't calculate lat/lon from them. Here is one source: http://www.zipwise.com On Jun 26, 2005, at 6:43 PM, Scott Gifford wrote: Jack Lauman <[EMAIL PROTECTED]> writes: A couple of months ago these was a discussion about ZI

Re: Calculate LONG/LAT from ZIP+4

Jack Lauman <[EMAIL PROTECTED]> writes: > A couple of months ago these was a discussion about ZIP code plotting > on this list. Does anyone know how to calculate LONG/LAT coordinates > from ZIP+4? In the U.S., you can use the census data: http://www.census.gov/geo/www/gazetteer/places2k.htm