Value added tax

I’ve always wondered what the differences between the European VAT and the US’ own sales tax systems where.

The following Wikipedia article explains some of the differences.

The question I want to keep track of here is: what do Spain and San Francisco governments do with my IVA and sales tax proceeds, respectively? What percentage goes towards which particular use?