NOTICE:: CivicSpace is Faulty!(zipcode/city/state DB Dump)
Posted: Fri Aug 11, 2006 3:52 pm
Hi Guys,
Just thought i let you guys know that the database table dump of US City/state/zip from civicspace http://civicspacelabs.org/home/developers/download is faulty.
Sorry, I should say "Partly" Faulty.... but faulty nonetheless.
It's missing 00's & 0's from some of the zip codes.
for example, if the zip code has 2 "00's" before any other number (>0) it just displays the zip code in 3 digits. for example, the first INSERT query has the following #:
"210" (NOTICE that its' missing 00 at the beginning)
I have corrected this issue and have uploaded a corrected file...
http://www.upload2.net/page/download/1Z ... s.rar.html
If you have already found a workaround this, then please ignore this post
hope this helps anyone who encountered similar problems
-Matt
Just thought i let you guys know that the database table dump of US City/state/zip from civicspace http://civicspacelabs.org/home/developers/download is faulty.
Sorry, I should say "Partly" Faulty.... but faulty nonetheless.
It's missing 00's & 0's from some of the zip codes.
for example, if the zip code has 2 "00's" before any other number (>0) it just displays the zip code in 3 digits. for example, the first INSERT query has the following #:
"210" (NOTICE that its' missing 00 at the beginning)
I have corrected this issue and have uploaded a corrected file...
http://www.upload2.net/page/download/1Z ... s.rar.html
If you have already found a workaround this, then please ignore this post
hope this helps anyone who encountered similar problems
-Matt