Methodology
Employee Residency and Compensation Information
The Bay Citizen submitted Sunshine Ordinance requests to the city Department of Human Resources and the Office of the Controller, asking for a correlation of public employees' total compensation and home zip code.
The Controller’s Office provided a list of names, titles, departments and total compensation for all employees of the city and county of San Francisco, and the DHR sent a database of employees’ home zip codes. Both were for the calendar year 2009, although the DHR’s zip code records are not real-time, since it is up to an employee to inform the city if he or she has moved. The city said it had no way to correlate the two documents.
The Bay Citizen used the following process to correlate the data:
The payroll file contained nearly 33,000 names. Nearly 1,500 of these reflected duplications (caused by either a single person drawing two salaries or, possibly, separate individuals with the same name). These entries were deleted from the sample. Additionally, nearly 9,700 names from the payroll list did not appear in the DHR's zip code database and were dropped from the sample. We further limited the sample to employees residing in the nine Bay Area counties. Finally, the city did not limit the payroll list to full-time workers — hundreds made less than $1,000. In an effort to capture full-time employees, The Bay Citizen restricted the sample to workers paid more than $20,000 in 2009.
The final sample used in The Bay Citizen’s calculations for this data application contained 22,657 city and county employees.
Pension Information
The Bay Citizen submitted a Sunshine Ordinance request to the San Francisco Employees’ Retirement System, asking for the annual payout amount and home zip codes for all the retirement fund’s beneficiaries. These payments are generated from the SFERS fund, not from the city’s general fund, though the city pays money from the General Fund to SFERs each year. This fiscal year the contribution from the City's General Fund will be $173 million, and next year it is forecast to be between $225 million and $273 million.