<div>
yeah, but theres a 2,500 request per day limit on that. I'm trying to plot transportation data and would need to do this for 150,000 plus records...
</div>


yeah, but theres a 2,500 request per day limit on that. I'm trying to plot transportation data and would need to do this for 150,000 plus records...

<div>
Decide if this project has any economic value to you. &nbsp;If so, contact Google about getting the rate limit lifted. &nbsp;You will have to pay them for the use of their data, and that makes sense. &nbsp;Or divide 150,000 by 2,500 and get 60, which is the number of days that you would need to work in batches of 2,500.<br />
<br />
IIRC there are about 36,000 useful ZIP codes in the continental US. &nbsp;The postal service publishes something like 47,000, but the extras are things like special purpose ZIP codes (think: the White House) or APO/FPO codes.
</div>


Decide if this project has any economic value to you.  If so, contact Google about getting the rate limit lifted.  You will have to pay them for the use of their data, and that makes sense.  Or divide 150,000 by 2,500 and get 60, which is the number of days that you would need to work in batches of 2,500.

IIRC there are about 36,000 useful ZIP codes in the continental US.  The postal service publishes something like 47,000, but the extras are things like special purpose ZIP codes (think: the White House) or APO/FPO codes.

<div>
<div class="content wysiwyg-content">
I have sql database of city, country, and postal code and i wanted to get longitude and latitude codes for each of them....does anyone have an easy way to do this instead of typing each one individually or buying a database?
</div>
</div>


I have sql database of city, country, and postal code and i wanted to get longitude and latitude codes for each of them....does anyone have an easy way to do this instead of typing each one individually or buying a database?

pulling longitude and latitude for postal codes around the world

The Global Positioning System (GPS) is a space-based global navigation satellite system (GNSS) that provides reliable location and time information in all weather and at all times and anywhere on or near the Earth when and where there is an unobstructed line of sight to four or more GPS satellites. A geographic information system (GIS) or geospatial information system is any system that captures, stores, analyzes, manages, and presents data that are linked to location(s). In the simplest terms, GIS is the merging of cartography, statistical analysis, and database technology.