City and County of San Francisco / District Attorney

Agency file

District Attorney

Source file: City and County of San Francisco — Employee Compensation / ingested Jun 17, 2026

The District Attorney handles legal functions of government — prosecution, legal advice, and representing the state in court.

In 2025, this agency had 360 employees with median total compensation of $198,316; the highest distinct record was $462,815.

Year: 2025
Total payroll: $74.3M
Employees: 360
Median total: $198,316
Highest record: $462,815

What the records show

Compensation analytics

These summaries compare pay within the agency before listing individual records.

Salary distribution

$1,550$384,493+

Hover a bar for its range; click to filter the list below.

How 2025 total compensation is spread across the 360 employees. Each bar is a pay range; taller bars mean more people earn in that range. The amber line marks the median ($198,316) — half earn less, half more. The far-right bar collects the highest earners.

Average pay composition

Base — $152,577 (74%)
Overtime — $1,025 (0%)
Other — $3,921 (2%)
Benefits — $48,833 (24%)

What an average paycheck here is made of — base salary versus overtime, other pay (bonuses, allowances), and benefits. A large overtime or other-pay share means take-home often exceeds base salary.

Pay percentiles

10th

25th

Median

75th

90th

$64,508

$141,244

$198,316

$279,481

$349,095

The pay ladder for this department. Someone at the 90th percentile earns $349,095 — more than 90% of the department; the 10th percentile earns $64,508. The shaded band is the middle half of employees (25th–75th percentile).

Largest job titles

Attorney (Civil/Criminal)

139 · $248,030

Legal Assistant

36 · $168,657

Victim/Witness Investigator 1

28 · $127,577

District Attorney Investigator (Sfers)

26 · $211,387

Victim/Witness Investigator 3

18 · $179,807

The most common job titles in this department by headcount, with the median total compensation for each. Click a title to see everyone who holds it.

Trend

Year over year

How this department's total payroll, headcount, and median pay changed across the 2 published years.

Year	Total payroll	Employees	Median pay
2024	$75.5M —	372 —	$199,339 —
2025	$74.3M ▼ 1.6%	360 ▼ 3.2%	$198,316 ▼ 0.5%

Compare

Similar departments

Departments elsewhere with the most similar mix of roles — a proxy for the same kind of agency, matched by workforce composition rather than name. Pay is not cost-of-living adjusted.

Office of Public Utility Counsel Texas60% match
Public Defender City and County of San Francisco60% match
Office of Administrative Law California57% match
District Attorney Allegheny County, Pennsylvania50% match
Public Defender Council, Georgia Georgia50% match
Attorney General's Office South Carolina47% match

Record list

Employees

Page 1

Jodee Brown

Victim/Witness Investigator 1/District Attorney

2025 total comp

$145,014

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $102,187
Overtime: $0
Other pay: $0
Benefits: $42,828
Total compensation: $145,014
Employment type: Permanent Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 1

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $19,953
Job Code: 8129
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $7,849

At District Attorney, Jodee Brown serves as a Victim/Witness Investigator 1 within Legal & Court. They work permanent exempt. Their 2025 pay totaled $145,014. Union affiliation: SEIU, Local 1021, Misc.

Christina King

Legal Assistant/District Attorney

2025 total comp

$141,999

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $101,560
Overtime: $1,290
Other pay: $0
Benefits: $39,149
Total compensation: $141,999
Employment type: Permanent Civil Service
Union / bargaining unit: Prof & Tech Eng, Local 21
Full-time equivalent (FTE): 0.85

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $16,509
Job Code: 8173
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $7,737

Christina King holds the role of Legal Assistant at District Attorney within Legal & Court. Their status is permanent civil service, 0.85 FTE. In 2025, their total compensation was $141,999. Their bargaining unit is Prof & Tech Eng, Local 21.

Amy Prado

Victim/Witness Investigator 1/District Attorney

2025 total comp

$141,907

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $98,010
Overtime: $30
Other pay: $1,560
Benefits: $42,306
Total compensation: $141,907
Employment type: Permanent Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 1

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $19,945
Job Code: 8129
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $7,718

Amy Prado is a Victim/Witness Investigator 1 at District Attorney within Legal & Court. They work permanent exempt. 2025 total compensation came to $141,907. They are represented by SEIU, Local 1021, Misc.

Julietta Teran-Lehmann

Human Resources Analyst/District Attorney

2025 total comp

$141,244

Sub-department: Personnel
Organization group: Public Protection
Base pay: $99,443
Overtime: $0
Other pay: $0
Benefits: $41,802
Total compensation: $141,244
Employment type: Permanent Civil Service
Union / bargaining unit: Prof & Tech Eng, Local 21
Full-time equivalent (FTE): 1

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $19,546
Job Code: 1241
Job Family Code: 1200
Organization Group Code: Public Protection
Other Benefits: $7,632

Julietta Teran-Lehmann works as a Human Resources Analyst for District Attorney within Personnel. Their status is permanent civil service. Julietta earned $141,244 in 2025. They are represented by Prof & Tech Eng, Local 21.

Oscar Gonzalez

Victim/Witness Investigator 1/District Attorney

2025 total comp

$140,740

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $97,289
Overtime: $0
Other pay: $1,560
Benefits: $41,891
Total compensation: $140,740
Employment type: Permanent Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 1

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $19,876
Job Code: 8129
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $7,478

Oscar Gonzalez holds the role of Victim/Witness Investigator 1 at District Attorney within Legal & Court. Their status is permanent exempt. In 2025, their total compensation was $140,740. Their bargaining unit is SEIU, Local 1021, Misc.

Megan Cheng

Victim/Witness Investigator 1/District Attorney

2025 total comp

$136,199

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $95,582
Overtime: $287
Other pay: $0
Benefits: $40,330
Total compensation: $136,199
Employment type: Permanent Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 1

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $18,828
Job Code: 8129
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $7,449

Megan Cheng holds the role of Victim/Witness Investigator 1 at District Attorney within Legal & Court. Their status is permanent exempt. In 2025, their total compensation was $136,199. Union affiliation: SEIU, Local 1021, Misc.

Tracy Wu

Victim/Witness Investigator 1/District Attorney

2025 total comp

$133,235

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $90,524
Overtime: $558
Other pay: $1,560
Benefits: $40,594
Total compensation: $133,235
Employment type: Permanent Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 1

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $19,953
Job Code: 8129
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $7,102

Tracy Wu works as a Victim/Witness Investigator 1 for District Attorney within Legal & Court. Their status is permanent exempt. Tracy earned $133,235 in 2025. They are represented by SEIU, Local 1021, Misc.

Tiffany Roduit

Victim/Witness Investigator 1/District Attorney

2025 total comp

$132,911

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $92,614
Overtime: $0
Other pay: $1,914
Benefits: $38,384
Total compensation: $132,911
Employment type: Permanent Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 0.9

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $17,897
Job Code: 8129
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $6,849

Tiffany Roduit holds the role of Victim/Witness Investigator 1 at District Attorney within Legal & Court. Their status is permanent exempt, 0.9 FTE. In 2025, their total compensation was $132,911. They are represented by SEIU, Local 1021, Misc.

Diana Garcia

Attorney (Civil/Criminal)/District Attorney

2025 total comp

$132,800

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $65,236
Overtime: $0
Other pay: $45,700
Benefits: $21,864
Total compensation: $132,800
Employment type: Temporary Exempt
Union / bargaining unit: Municipal Attorneys Assoc
Full-time equivalent (FTE): 0.29

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $7,090
Job Code: 8177
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $8,649

Diana Garcia is a Attorney (Civil/Criminal) at District Attorney within Legal & Court. They work temporary exempt, 0.29 FTE. 2025 total compensation came to $132,800. Their bargaining unit is Municipal Attorneys Assoc.

Heidy Carlson

Victim/Witness Investigator 1/District Attorney

2025 total comp

$131,501

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $93,059
Overtime: $0
Other pay: $0
Benefits: $38,441
Total compensation: $131,501
Employment type: Permanent Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 0.9

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $17,954
Job Code: 8129
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $6,812

Heidy Carlson holds the role of Victim/Witness Investigator 1 at District Attorney within Legal & Court. Their status is permanent exempt, 0.9 FTE. In 2025, their total compensation was $131,501. They are represented by SEIU, Local 1021, Misc.

Janet Pedroza

Victim/Witness Investigator 1/District Attorney

2025 total comp

$131,252

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $88,964
Overtime: $435
Other pay: $1,560
Benefits: $40,292
Total compensation: $131,252
Employment type: Permanent Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 1

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $19,953
Job Code: 8129
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $7,028

Janet Pedroza is a Victim/Witness Investigator 1 at District Attorney within Legal & Court. They work permanent exempt. 2025 total compensation came to $131,252. They are represented by SEIU, Local 1021, Misc.

Luis Campos-Coolbaugh

Attorney (Civil/Criminal)/District Attorney

2025 total comp

$130,709

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $95,769
Overtime: $0
Other pay: $0
Benefits: $34,939
Total compensation: $130,709
Employment type: Permanent Exempt
Union / bargaining unit: Municipal Attorneys Assoc
Full-time equivalent (FTE): 0.63

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $13,755
Job Code: 8177
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $7,454

Luis Campos-Coolbaugh is a Attorney (Civil/Criminal) at District Attorney within Legal & Court. They work permanent exempt, 0.63 FTE. 2025 total compensation came to $130,709. They are represented by Municipal Attorneys Assoc.