Anyone have table of US States, Counties and Zip Codes?
$10-15 USD
Cancelado
Publicado hace alrededor de 18 años
$10-15 USD
Pagado a la entrega
I need 2 tables:
1) A table of US zip codes, their city, county, and state. This must be a current and up-to-date list of postcodes.
2) A table of US counties and their state.
Zip codes Table:
Table name: postcodes_us
Field: postcodes_number Type: double
Field: postcodes_city Type: varchar(64)
Field: postcodes_ county Type: varchar(64)
Field: postcodes_state Type: char(2)
Example:
postcodes_number, postcodes_city, postcodes_county, postcodes_state
48174 ROMULUS WAYNE MI
48230 GROSSE POINTE WAYNE MI
48202 DETROIT WAYNE MI
48201 DETROIT WAYNE MI
48198 YPSILANTI WASHTENAW MI
48197 YPSILANTI WASHTENAW MI
48195 SOUTHGATE WAYNE MI
48188 CANTON WAYNE MI
48187 CANTON WAYNE MI
48186 WESTLAND WAYNE MI
52577 OSKALOOSA MAHASKA IA
County to State Table:
Table name: county_to_state
Field: Type Attributes Null Default Extra Action
Field: county_to_state_county Type: varchar(64)
Field: county_to_state_state Type: char(2)
Example:
county_to_state_county, county_to_state_state
WASHTENAW MI
WAYNE MI
MAHASKA IA
Please deliver the tables in MySQL format by exporting the MySQL tables to a zip file.
Thanks alot!
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Please deliver the tables in MySQL format by exporting the MySQL tables to a zip file.