Quote Originally Posted by psychicpet View Post
I have reorganized and sorted the data by county so now it is: County, City, Tax. I am not adverse to setting tax using county if that will make it more accurate.
psychicpet + LadyHLG

Have prev done taxes via zip with a hack/mod but since Ca update in 2009 I wanted a easy way to make these changes as our taxes will surely go up again

Am trying to do the same thing here "counties as zones" setup for California and realize thats alot of work to do this, well over 1000+ records to do. I was hoping there would be a SQL file to just add this to the database.....

So if anyone has something already setup that can share that would be great, if not if LadyHLG has a starter script for adding these zones to SQL I could start creating the script(s).

Needed for SQL script(s) is;
  1. Zone for each county in California
  2. Zone definition for each county
  3. Adding the details for each definition
  4. Tax rate for each county


Let me know if I left out anything as I'm sure theres more to this than a few SQL scripts.

Thanks in advance for any help that is offered