Hi, We've USA ZIP codes table with the following values. and we have a total of 81,939 ZIP codes.
INSERT INTO pages_zip_code (id, zip, city, st) VALUES > (1, '00501', 'Holtsville', 'NY'), > (2, '00544', 'Holtsville', 'NY'), > (3, '00601', 'Adjuntas', 'PR'), > (4, '00602', 'Aguada', 'PR'), > (5, '00603', 'Aguadilla', 'PR'), > ....................................... > We need to calculate the distance between each zip code and save the distance value in table like "zip_codes_distance" with the following table columns zip_codes_distance table > id | from_zip | to_zip | distancev We're looking for an appropriate library that might be available in Python/Django to calculate the distance easily instead of using any API. We know we can use Google's distance API with allowable requests, but we are trying to see if any Python library out there that is capable of doing the same calculation. I would appreciate expert advice on this. Best regards ~Ram -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CA%2BOi5F1-E-70zWo-8EPu0%2BrWD%2BCjFqZaCVaUEtbb9mRNKjpMNQ%40mail.gmail.com.
