The USPS has been de-emphasizing the usage of carrier-routes for several years now. They will eventually phase them out completely in lieu of other schemes, including enhanced line-of-travel (ELOT), etc. The pool of eligible carrier-routes decreases every month (from the mailer's perspective).
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO - USA Central Time Zone 636-755-2652 fax 636-755-2503 [EMAIL PROTECTED] www.nisc.coop -----Original Message----- From: Kieran Kelleher [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 28, 2005 16:21 To: Brian Dunning Cc: 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 certainly more manageable than 70,000,000 zip+4's. Does anyone know where you can buy USA carrier route lat/lng data? -Kieran ________________________________________________________________ Blog: http://webobjects.webhop.org/ On Jun 28, 2005, at 11:53 AM, Brian Dunning wrote: >>> 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: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]