Location by zip code
goodguyndfw
posted 12th of August 2008
in
Community Voice.
4 comments.
How/where can I get the data for US zip codes including the long/lat?
| Field | Type |
| ZIPCode | varchar(8) |
| ZIPCodeType | char(1) |
| City | varchar(28) |
| CityType | char(1) |
| County | varchar(25) |
| CountyFIPS | varchar(5) |
| State | varchar(30) |
| StateCode | varchar(2) |
| StateFIPS | varchar(2) |
| MSA | varchar(4) |
| AreaCode | varchar(3) |
| TimeZone | varchar(10) |
| GMTOffset | int(11) |
| DST | char(1) |
| Latitude | double |
| Longitude |
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
The new Dolphin solution is powered by UNA Community Management System.
If you need the ZIP Code database, Expertzzz provides a vast selection in its own category.(http://www.expertzzz.com/Downloadz/home/dolphin/10/)
Sleep deprivation is good only on rare occasion I suppose.
I wonder if one expertezzz source is any better than another? Accuracy. Also wonder how they are compiled. I pulled a list for US from the census bureau and they state that their data is missing some coordinates. I'd try them but can't seem to import the data into the table correctly.