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 23

Vanessa Lima

General Laborer/Public Works

2025 total comp

$109,788

Sub-department: Semi-Skilled & General Labor
Organization group: Public Works, Transportation & Commerce
Base pay: $72,223
Overtime: $2,432
Other pay: $2,919
Benefits: $32,214
Total compensation: $109,788
Employment type: Permanent Civil Service
Union / bargaining unit: Laborers, Local 261
Full-time equivalent (FTE): 0.81

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DPW
Health and Dental Benefits: $15,205
Job Code: 7514
Job Family Code: 7500
Organization Group Code: Public Works, Transportation & Commerce
Other Benefits: $6,008

At Public Works, Vanessa Lima serves as a General Laborer within Semi-Skilled & General Labor. They work permanent civil service, 0.81 FTE. Their 2025 pay totaled $109,788. Union affiliation: Laborers, Local 261.

Audrey Hoang

Junior Engineer/Public Works

2024 total comp

$109,627

Sub-department: Professional Engineering
Organization group: Public Works, Transportation & Commerce
Base pay: $77,459
Overtime: $1,322
Other pay: $0
Benefits: $30,846
Total compensation: $109,627
Employment type: Permanent Civil Service
Union / bargaining unit: Prof & Tech Eng, Local 21
Full-time equivalent (FTE): 0.73

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DPW
Health and Dental Benefits: $13,075
Job Code: 5201
Job Family Code: 5200
Organization Group Code: Public Works, Transportation & Commerce
Other Benefits: $6,038

Audrey Hoang works as a Junior Engineer for Public Works within Professional Engineering. Their status is permanent civil service, 0.73 FTE. Audrey earned $109,627 in 2024. They are represented by Prof & Tech Eng, Local 21.

Michael Diana

Asphalt Finisher Supervisor 1/Public Works

2025 total comp

$109,522

Sub-department: Supervisory-Labor & Trade
Organization group: Public Works, Transportation & Commerce
Base pay: $77,673
Overtime: $1,713
Other pay: $791
Benefits: $29,345
Total compensation: $109,522
Employment type: Permanent Civil Service
Union / bargaining unit: Laborers, Local 261
Full-time equivalent (FTE): 0.6

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DPW
Health and Dental Benefits: $11,453
Job Code: 7220
Job Family Code: 7200
Organization Group Code: Public Works, Transportation & Commerce
Other Benefits: $6,277

Michael Diana holds the role of Asphalt Finisher Supervisor 1 at Public Works within Supervisory-Labor & Trade. Their status is permanent civil service, 0.6 FTE. In 2025, their total compensation was $109,522. They are represented by Laborers, Local 261.

Yicheng Wu

Public Relations Officer/Public Works

2025 total comp

$109,508

Sub-department: Pub Relations & Spec Assts
Organization group: Public Works, Transportation & Commerce
Base pay: $80,379
Overtime: $0
Other pay: $0
Benefits: $29,129
Total compensation: $109,508
Employment type: Permanent Exempt
Union / bargaining unit: Prof & Tech Eng, Local 21
Full-time equivalent (FTE): 0.58

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DPW
Health and Dental Benefits: $11,276
Job Code: 1314
Job Family Code: 1300
Organization Group Code: Public Works, Transportation & Commerce
Other Benefits: $6,132

Yicheng Wu works as a Public Relations Officer for Public Works within Pub Relations & Specialist Assts. Their status is permanent exempt, 0.58 FTE. Yicheng earned $109,508 in 2025. Union affiliation: Prof & Tech Eng, Local 21.

Wai Cheung

Engineering Associate 1/Public Works

2025 total comp

$109,141

Sub-department: Sub-Professional Engineering
Organization group: Public Works, Transportation & Commerce
Base pay: $61,372
Overtime: $0
Other pay: $22,066
Benefits: $25,704
Total compensation: $109,141
Employment type: Permanent Civil Service
Union / bargaining unit: Prof & Tech Eng, Local 21
Full-time equivalent (FTE): 0.52

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DPW
Health and Dental Benefits: $10,157
Job Code: 5364
Job Family Code: 5300
Organization Group Code: Public Works, Transportation & Commerce
Other Benefits: $6,415

Wai Cheung is a Engineering Associate 1 at Public Works within Sub-Professional Engineering. They work permanent civil service, 0.52 FTE. 2025 total compensation came to $109,141. Their bargaining unit is Prof & Tech Eng, Local 21.