City and County of San Francisco / Public Works

Agency file

Public Works

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

The Public Works is a government agency that delivers public services and programs within its jurisdiction.

In 2025, this agency had 1,658 employees with median total compensation of $165,517; the highest distinct record was $459,222.

Year: 2025
Total payroll: $266.7M
Employees: 1,658
Median total: $165,517
Highest record: $459,222

What the records show

Compensation analytics

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

Salary distribution

$57$339,089+

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

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

Average pay composition

Base — $112,636 (70%)
Overtime — $4,205 (3%)
Other — $2,987 (2%)
Benefits — $41,050 (26%)

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

$38,268

$109,024

$165,517

$208,169

$263,712

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

Largest job titles

General Laborer

213 · $126,624

Public Service Aide-Public Works

140 · $72,705

Truck Driver

75 · $178,306

Assistant Engineer

72 · $200,441

Junior Engineer

68 · $159,888

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	$262.5M —	1,707 —	$156,771 —
2025	$266.7M ▲ 1.6%	1,658 ▼ 2.9%	$165,517 ▲ 5.6%

Record list

Employees

Page 2

Xiuqiong Liao

Public Service Aide-Public Works/Public Works

2024 total comp

$72,478

Sub-department: Public Service Aide
Organization group: Public Works, Transportation & Commerce
Base pay: $39,438
Overtime: $140
Other pay: $7,365
Benefits: $25,535
Total compensation: $72,478
Employment type: Temporary Exempt
Union / bargaining unit: Laborers, Local 261
Full-time equivalent (FTE): 0.85

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DPW
Health and Dental Benefits: $15,125
Job Code: 9916
Job Family Code: 9900
Organization Group Code: Public Works, Transportation & Commerce
Other Benefits: $3,399

Xiuqiong Liao works as a Public Service Aide-Public Works for Public Works within Public Service Aide. Their status is temporary exempt, 0.85 FTE. Xiuqiong earned $72,478 in 2024. Union affiliation: Laborers, Local 261.

Kamilo-Aucan Sepulveda-Jamett

Public Service Aide-Public Works/Public Works

2025 total comp

$72,170

Sub-department: Public Service Aide
Organization group: Public Works, Transportation & Commerce
Base pay: $43,615
Overtime: $0
Other pay: $1,998
Benefits: $26,558
Total compensation: $72,170
Employment type: Temporary Exempt
Union / bargaining unit: Laborers, Local 261
Full-time equivalent (FTE): 0.82

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DPW
Health and Dental Benefits: $15,748
Job Code: 9916
Job Family Code: 9900
Organization Group Code: Public Works, Transportation & Commerce
Other Benefits: $3,515

Kamilo-Aucan Sepulveda-Jamett holds the role of Public Service Aide-Public Works at Public Works within Public Service Aide. Their status is temporary exempt, 0.82 FTE. In 2025, their total compensation was $72,170. Their bargaining unit is Laborers, Local 261.

Olivia Sears

Stdntdsgntrain3, Arch/Eng/Plng/Public Works

2025 total comp

$71,728

Sub-department: Sub-Professional Engineering
Organization group: Public Works, Transportation & Commerce
Base pay: $58,629
Overtime: $0
Other pay: $0
Benefits: $13,099
Total compensation: $71,728
Employment type: Temporary Exempt
Union / bargaining unit: Prof & Tech Eng, Local 21
Full-time equivalent (FTE): 0.69

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DPW
Job Code: 5382
Job Family Code: 5300
Organization Group Code: Public Works, Transportation & Commerce
Other Benefits: $4,521
Retirement Contribution: $8,577

Olivia Sears works as a Stdntdsgntrain3, Arch/Eng/Plng for Public Works within Sub-Professional Engineering. Their status is temporary exempt, 0.69 FTE. Olivia earned $71,728 in 2025. Union affiliation: Prof & Tech Eng, Local 21.

Lizhen Zhou

Public Service Aide-Public Works/Public Works

2024 total comp

$71,552

Sub-department: Public Service Aide
Organization group: Public Works, Transportation & Commerce
Base pay: $39,438
Overtime: $140
Other pay: $6,361
Benefits: $25,613
Total compensation: $71,552
Employment type: Temporary Exempt
Union / bargaining unit: Laborers, Local 261
Full-time equivalent (FTE): 0.85

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DPW
Health and Dental Benefits: $15,125
Job Code: 9916
Job Family Code: 9900
Organization Group Code: Public Works, Transportation & Commerce
Other Benefits: $3,477

Lizhen Zhou holds the role of Public Service Aide-Public Works at Public Works within Public Service Aide. Their status is temporary exempt, 0.85 FTE. In 2024, their total compensation was $71,552. Union affiliation: Laborers, Local 261.

Wan Huang

Public Service Aide-Public Works/Public Works

2024 total comp

$70,908

Sub-department: Public Service Aide
Organization group: Public Works, Transportation & Commerce
Base pay: $39,438
Overtime: $0
Other pay: $6,047
Benefits: $25,423
Total compensation: $70,908
Employment type: Temporary Exempt
Union / bargaining unit: Laborers, Local 261
Full-time equivalent (FTE): 0.85

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DPW
Health and Dental Benefits: $15,125
Job Code: 9916
Job Family Code: 9900
Organization Group Code: Public Works, Transportation & Commerce
Other Benefits: $3,288

Wan Huang holds the role of Public Service Aide-Public Works at Public Works within Public Service Aide. Their status is temporary exempt, 0.85 FTE. In 2024, their total compensation was $70,908. Their bargaining unit is Laborers, Local 261.