Agency file

City Planning

Source file: City of Pittsburgh — Employee Salaries (2017-2019) / ingested Jun 19, 2026

The City Planning supports housing and community development — affordable housing, planning, and neighborhood programs.

In 2019, this agency had 46 employees with median total compensation of $10,532; the highest distinct record was $20,437.

Year: 2019
Total payroll: $478.7K
Employees: 46
Median total: $10,532
Highest record: $20,437

What the records show

Compensation analytics

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

Salary distribution

$2,185$20,436+

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

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

Average pay composition

Base — $8,235 (79%)
Overtime — $0 (0%)
Other — $590 (6%)
Benefits — $1,582 (15%)

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

$3,222

$8,428

$10,532

$12,030

$15,099

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

Largest job titles

6 · $11,393

4 · $11,286

3 · $7,018

3 · $2,920

2 · $12,497

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 3 published years.

Year	Total payroll	Employees	Median pay
2017	$3M —	55 —	$58,287 —
2018	$3.1M ▲ 4.0%	57 ▲ 3.6%	$59,592 ▲ 2.2%
2019	$478.7K ▼ 84.6%	46 ▼ 19.3%	$10,532 ▼ 82.3%

Record list

Employees

Page 1

Yesica Guerra

Public Art Manager-Heinz/City Planning

2019 total comp

$12,923

Sub-department: City Planning
Base pay: $10,930
Overtime: $0
Other pay: $811
Benefits: $1,182
Total compensation: $12,923
Hire date: 2017-01-23
Union / bargaining unit: Non-Union

Source-specific fields

Employment Status: Full-Time
Home Cost Center: 110000
Socrata Entity Number: 826310
Total Taxes: 811.04

Yesica Guerra is a Public Art Manager-Heinz at City Planning within City Planning. Hired in 2017, they have about 2 years of service. 2019 total compensation came to $12,923. They are represented by Non-Union.

Felipe Palomo

Planner 2/City Planning

2019 total comp

$12,845

Sub-department: City Planning
Base pay: $8,714
Overtime: $0
Other pay: $590
Benefits: $3,541
Total compensation: $12,845
Hire date: 2017-03-06
Union / bargaining unit: AFSCME Local 2719

Source-specific fields

Employment Status: Full-Time
Home Cost Center: 110000
Socrata Entity Number: 835962
Total Taxes: 589.98

At City Planning, Felipe Palomo serves as a Planner 2 within City Planning. Their tenure dates to 2017, about 2 years. Their 2019 pay totaled $12,845. Union affiliation: AFSCME Local 2719.