Illustration of datascience Tables on Open Data from Berkeley

David E. Culler

Datascience Table provides a simple, yet powerful data structure for a range of analyses. The basic concept is an ordered set of named columns.

  • It builds on the intuition many develop with excel - data is represented as rectangular regions. But, rather than labeling cells, the column labels really mean something.
  • Tables embed smoothly in jupyter notebooks, so the user experience is that of a computational document, rather than a spreadsheet. This provides a much clearer sequence of steps from raw data to finished product, at least if they are well constructed. There is no need to break out into visual basic or the like when you need more than the basics.
  • Tables draws heavily from relational database tables, but there is no separate language (e.g., SQL) required to do relational operations in them.
  • Tables provide also the concepts associated with pivot tables in Excel, which are closely related to relational operations, but often more natural.
  • Tables can be viewed as simple variants of the dataframes in R or Pandas. The key is simplicity. They are simple rectangular structures. The cells of a table can hold arbitrary values, although columns are homogeneous, so the additional power (and complexity) of higher dimensions are rarely needed.
  • Tables builds directly on the scipy ecosystem. Almost any sequence can go in, numpy.arrays come out. Thus, it is natural to manipulate data directly from Tables. Basic visualization is provide directly in terms of Tables, so you can go a long ways before reading matplotlib documentation. However, if you need more, a lot of it can be gained through keyword args - and if that is not enough, drop into scipy.

This notebook illustrates some of the use of Tables using municipal salary data made possible though the City of Berkeley's open data portal.


In [1]:
# This useful nonsense just goes at the top
from datascience import *
import numpy as np
import matplotlib.pyplot as plots
plots.style.use('fivethirtyeight')
%matplotlib inline
# datascience version number of last run of this notebook
version.__version__


Out[1]:
'0.5.19'

Reading raw data into a Table

Let's pull a big wad of City Employee salary data from the Berkeley Open Data portal.

Since this was a trial till June 30, 2015 and you have to mouse around to get csv files, we happen to have pulled a local copy.


In [2]:
raw_berkeley_sal_2011 = Table.read_table("./data/City_of_Berkeley_Employee_Salaries_-_2011.csv")
Let's take a peek at what we have got.

In [3]:
# Tables are rendered to work in a notebook, even if they are large.  Only part shows.
# You can adjust how much of it you see, but here we'd have ~1500 rows!
raw_berkeley_sal_2011


Out[3]:
Employee Name Job Title Base Pay Overtime Pay Other Pay Total Benefits Total Pay Total Pay Benefits
HOWARD H NONOGUCHI POLICE SERGEANT $132540.85 $114387.97 $53483.56 $102377.48 $300412.38 $402789.86
DAVID A FRANKEL POLICE LIEUTENANT $159094.73 $38995.01 $41465.57 $124819.29 $239555.31 $364374.60
MICHAEL K MEEHAN POLICE CHIEF $205400.00 $0.00 $7380.00 $124814.56 $212780.00 $337594.56
ERIK M UPSON POLICE CAPTAIN $182382.48 $0.00 $19346.55 $133848.06 $201729.03 $335577.09
KEVIN M SCHOFIELD POLICE LIEUTENANT $159094.73 $31284.18 $20132.52 $119134.15 $210511.43 $329645.58
CYNTHIA HARRIS POLICE CAPTAIN $182382.48 $0.00 $21884.00 $121365.25 $204266.48 $325631.73
ANDREW R GREENWOOD POLICE CAPTAIN $159094.73 $7668.11 $34550.65 $123852.11 $201313.49 $325165.60
RANDOLPH FILES POLICE LIEUTENANT $159094.73 $28364.65 $19671.10 $117449.09 $207130.48 $324579.57
EDWARD A SPILLER POLICE LIEUTENANT $134457.24 $36225.22 $38738.16 $111729.65 $209420.62 $321150.27
JOHN R TARASCIO FIRE LIEUTENANT $117198.12 $87476.09 $27504.05 $82069.44 $232178.26 $314247.70

... (1427 rows omitted)

Accessing data in a Table

A column of Table data is accessed by indexing it by name. This returns the column as a numpy array.


In [4]:
raw_berkeley_sal_2011['Base Pay']


Out[4]:
array(['$132540.85', '$159094.73', '$205400.00', ..., '$0.00', '$0.00',
       '$0.00'], 
      dtype='<U10')

Some prefer the selectors - column and row


In [5]:
raw_berkeley_sal_2011.column('Overtime Pay')


Out[5]:
array(['$114387.97', '$38995.01', '$0.00', ..., '$0.00', '$0.00', '$0.00'], 
      dtype='<U10')

Rows in the table can be indexed and sliced. A row is a little like a record or dict. It is an tupled, ordered according to the table it comes from and keeping the column names.


In [6]:
raw_berkeley_sal_2011.rows[0]


Out[6]:
Row(Employee Name='HOWARD H NONOGUCHI', Job Title='POLICE SERGEANT', Base Pay='$132540.85', Overtime Pay='$114387.97', Other Pay='$53483.56', Total Benefits='$102377.48', Total Pay='$300412.38', Total Pay Benefits='$402789.86')

In [7]:
raw_berkeley_sal_2011.row(0).item('Base Pay')


Out[7]:
'$132540.85'

In [8]:
raw_berkeley_sal_2011.row(0)[2]


Out[8]:
'$132540.85'

In [9]:
raw_berkeley_sal_2011.row(0).asdict()


Out[9]:
OrderedDict([('Employee Name', 'HOWARD H NONOGUCHI'),
             ('Job Title', 'POLICE SERGEANT'),
             ('Base Pay', '$132540.85'),
             ('Overtime Pay', '$114387.97'),
             ('Other Pay', '$53483.56'),
             ('Total Benefits', '$102377.48'),
             ('Total Pay', '$300412.38'),
             ('Total Pay Benefits', '$402789.86')])

In [10]:
raw_berkeley_sal_2011.rows[0:10]


Out[10]:
<generator object Table.Rows.__getitem__.<locals>.<genexpr> at 0x10fc605c8>

Converting data in a Table to make it workable

When we read in data from a csv file we got a bunch of columns filled with a bunch of strings. As is often the case, we want the data in a column to represent values that we can analyze, whereas we want the printed format of a column to reflect its meaning. Currency is the most common such situation. Let's clean up our salary table.

We might start by getting ahold of the names of column that we want to clean up


In [11]:
paylabels = raw_berkeley_sal_2011.labels[2:]
paylabels


Out[11]:
('Base Pay',
 'Overtime Pay',
 'Other Pay',
 'Total Benefits',
 'Total Pay',
 'Total Pay Benefits')

Clean derivatives of raw tables

It is good hygene to keep the raw data raw and produce distinct, clean derivatives. Let's start by making a copy of the raw table. A new name and a new table.


In [12]:
berkeley_sal_2011 = raw_berkeley_sal_2011.copy()

Tables allow columns to have customized formatters

In Excel you do this by formatting the cells. We want to have the data as numbers, keep track of the type, and have it look nice.


In [13]:
berkeley_sal_2011.set_format(paylabels, CurrencyFormatter)
berkeley_sal_2011


Out[13]:
Employee Name Job Title Base Pay Overtime Pay Other Pay Total Benefits Total Pay Total Pay Benefits
HOWARD H NONOGUCHI POLICE SERGEANT $132,540.85 $114,387.97 $53,483.56 $102,377.48 $300,412.38 $402,789.86
DAVID A FRANKEL POLICE LIEUTENANT $159,094.73 $38,995.01 $41,465.57 $124,819.29 $239,555.31 $364,374.60
MICHAEL K MEEHAN POLICE CHIEF $205,400.00 $0.00 $7,380.00 $124,814.56 $212,780.00 $337,594.56
ERIK M UPSON POLICE CAPTAIN $182,382.48 $0.00 $19,346.55 $133,848.06 $201,729.03 $335,577.09
KEVIN M SCHOFIELD POLICE LIEUTENANT $159,094.73 $31,284.18 $20,132.52 $119,134.15 $210,511.43 $329,645.58
CYNTHIA HARRIS POLICE CAPTAIN $182,382.48 $0.00 $21,884.00 $121,365.25 $204,266.48 $325,631.73
ANDREW R GREENWOOD POLICE CAPTAIN $159,094.73 $7,668.11 $34,550.65 $123,852.11 $201,313.49 $325,165.60
RANDOLPH FILES POLICE LIEUTENANT $159,094.73 $28,364.65 $19,671.10 $117,449.09 $207,130.48 $324,579.57
EDWARD A SPILLER POLICE LIEUTENANT $134,457.24 $36,225.22 $38,738.16 $111,729.65 $209,420.62 $321,150.27
JOHN R TARASCIO FIRE LIEUTENANT $117,198.12 $87,476.09 $27,504.05 $82,069.44 $232,178.26 $314,247.70

... (1427 rows omitted)

Now we get values we can compute on - and they still display as currency.


In [14]:
berkeley_sal_2011['Base Pay']


Out[14]:
array([ 132540.85,  159094.73,  205400.  , ...,       0.  ,       0.  ,
             0.  ])

In [15]:
max(berkeley_sal_2011['Total Pay Benefits'])


Out[15]:
402789.85999999999

Descriptive Statistics Summary

Now we can try to get a summary of the data with some descriptive statistics.

The stats method on Tables computes a list of statistics over each column and creates a new Table containing these statistics. The default is tailored to the Berkeley Data8 course. Here we provide what you expect from the summary operation in R


In [16]:
def firstQtile(x) : return np.percentile(x,25)
def thirdQtile(x) : return np.percentile(x,25)
summary_ops = (min, firstQtile, np.median, np.mean, thirdQtile, max)

In [17]:
berkeley_sal_2011.select(paylabels).stats(ops=summary_ops)


Out[17]:
statistic Base Pay Overtime Pay Other Pay Total Benefits Total Pay Total Pay Benefits
min 0 0 -94730.8 0 0 0
firstQtile 57674 0 0 36846.6 61125.3 99726.7
median 72988.3 0 1285.45 48490.3 79118.4 128068
mean 76909.1 5619.79 3365.87 49509.6 85894.8 135404
thirdQtile 57674 0 0 36846.6 61125.3 99726.7
max 205400 114388 64036.7 133848 300412 402790

OK, so it looks like the average salary is about 86k, and it ranges up to 300k with some hefty overtime pay. Let's see if we can understand what is going on.

Visualizing data

  • Table.select creates a new table consisting of the specified list of columns.
  • Table.hist plots a histogram of each of the columns in a table. It can either overlay the histograms or show them separately. Here we have specified the number of bins

In [18]:
berkeley_sal_2011.select(["Base Pay", 
                          "Overtime Pay", 
                          "Total Pay Benefits"]).hist(overlay=False,normed=False,
                                                      bins=40)


Interesting. Base pay is bimodal. Most employees get no overtime, but there is a looong tale. Let's look at the individual level. Who's at the top?


In [19]:
berkeley_sal_2011.sort('Total Pay Benefits', descending=True)


Out[19]:
Employee Name Job Title Base Pay Overtime Pay Other Pay Total Benefits Total Pay Total Pay Benefits
HOWARD H NONOGUCHI POLICE SERGEANT $132,540.85 $114,387.97 $53,483.56 $102,377.48 $300,412.38 $402,789.86
DAVID A FRANKEL POLICE LIEUTENANT $159,094.73 $38,995.01 $41,465.57 $124,819.29 $239,555.31 $364,374.60
MICHAEL K MEEHAN POLICE CHIEF $205,400.00 $0.00 $7,380.00 $124,814.56 $212,780.00 $337,594.56
ERIK M UPSON POLICE CAPTAIN $182,382.48 $0.00 $19,346.55 $133,848.06 $201,729.03 $335,577.09
KEVIN M SCHOFIELD POLICE LIEUTENANT $159,094.73 $31,284.18 $20,132.52 $119,134.15 $210,511.43 $329,645.58
CYNTHIA HARRIS POLICE CAPTAIN $182,382.48 $0.00 $21,884.00 $121,365.25 $204,266.48 $325,631.73
ANDREW R GREENWOOD POLICE CAPTAIN $159,094.73 $7,668.11 $34,550.65 $123,852.11 $201,313.49 $325,165.60
RANDOLPH FILES POLICE LIEUTENANT $159,094.73 $28,364.65 $19,671.10 $117,449.09 $207,130.48 $324,579.57
EDWARD A SPILLER POLICE LIEUTENANT $134,457.24 $36,225.22 $38,738.16 $111,729.65 $209,420.62 $321,150.27
JOHN R TARASCIO FIRE LIEUTENANT $117,198.12 $87,476.09 $27,504.05 $82,069.44 $232,178.26 $314,247.70

... (1427 rows omitted)

So where does the $alary go? First, how many employees?

Table.num_rows returns just what you'd think. The number of rows. Which in this case is the number of employees on the city payroll.


In [20]:
berkeley_sal_2011.num_rows


Out[20]:
1437

Grouping and Sorting Table data

  • Table.drop creates a new Table without some columns. It is like select, but you don't have to name everythng you want.
  • Table.group aggregates data by grouping all the rows that contain a common value in one (or more) columns. Here we group in "Job Title" summing the entries in all other columns for each group. We placed a column full of 1 to get a count, while summing salaries and such.
  • Table.sort sorts the rows in a Table by a column - just like sort in Excel.

In [21]:
# lose the individual names
job_titles = berkeley_sal_2011.drop("Employee Name") 
# Build a handy column full of 1s
job_titles["Title"] = 1
# Group by title summing the number of rows per
by_title = job_titles.group("Job Title", sum)  
# Sort by the number of employees per title
ordered_by_title = by_title.sort('Title sum', descending = True) 
# let's see what we get
ordered_by_title


Out[21]:
Job Title Base Pay sum Overtime Pay sum Other Pay sum Total Benefits sum Total Pay sum Total Pay Benefits sum Title sum
POLICE OFFICER 1.26079e+07 1.66885e+06 1.22694e+06 9.36767e+06 1.55037e+07 2.48713e+07 131
OFFICE SPECIALIST II 3.09984e+06 4202.74 -213202 1.88603e+06 2.89084e+06 4.77687e+06 56
FIREFIGHTER 3.53733e+06 593383 670533 2.38227e+06 4.80125e+06 7.18351e+06 54
SOLID WASTE WORKER 2.07557e+06 422455 -5278.96 1.66431e+06 2.49275e+06 4.15706e+06 36
FIRE APPARATUS OPERATOR 3.80306e+06 541058 757143 2.56267e+06 5.10126e+06 7.66393e+06 36
POLICE SERGEANT 4.29433e+06 796218 596785 3.21102e+06 5.68734e+06 8.89836e+06 33
SOLID WASTE TRUCK DRIVER 2.1416e+06 338808 63332.1 1.76164e+06 2.54374e+06 4.30539e+06 32
OFFICE SPECIALIST III 1.95138e+06 23228.8 31125.6 1.12598e+06 2.00574e+06 3.13172e+06 30
PUBLIC SAFETY DISPATCHER II 1.83488e+06 455170 134222 1.04205e+06 2.42427e+06 3.46632e+06 26
PARKING ENFORCEMENT OFFICER 1.48252e+06 201141 39177.2 1.02214e+06 1.72283e+06 2.74498e+06 26

... (295 rows omitted)


In [22]:
ordered_by_title.num_rows


Out[22]:
305

Wow, 305 Job Titles for 1437 employees!


In [23]:
"{0:.3} employees per Job Code".format(berkeley_sal_2011.num_rows/ordered_by_title.num_rows)


Out[23]:
'4.71 employees per Job Code'

Plotting data

  • Table.plot plots each of the columns in a table, either on separate charts or overlayed on a single chart. Optionally one of the columns can be specified as the horizontal axis and all others plotted against this.

In [24]:
ordered_by_title.select(['Title sum','Total Pay Benefits sum']).sort('Title sum').plot(overlay=False)


How about that, a few job categories have most of the employes and most of the spend, but it is far from uniform. Let's look a little deeper. Which categories consume most of the budget?


In [25]:
by_title.sort('Total Pay Benefits sum', descending = True)


Out[25]:
Job Title Base Pay sum Overtime Pay sum Other Pay sum Total Benefits sum Total Pay sum Total Pay Benefits sum Title sum
POLICE OFFICER 1.26079e+07 1.66885e+06 1.22694e+06 9.36767e+06 1.55037e+07 2.48713e+07 131
POLICE SERGEANT 4.29433e+06 796218 596785 3.21102e+06 5.68734e+06 8.89836e+06 33
FIRE APPARATUS OPERATOR 3.80306e+06 541058 757143 2.56267e+06 5.10126e+06 7.66393e+06 36
FIREFIGHTER 3.53733e+06 593383 670533 2.38227e+06 4.80125e+06 7.18351e+06 54
FIRE LIEUTENANT 2.71831e+06 502590 439075 1.72013e+06 3.65997e+06 5.3801e+06 24
OFFICE SPECIALIST II 3.09984e+06 4202.74 -213202 1.88603e+06 2.89084e+06 4.77687e+06 56
SOLID WASTE TRUCK DRIVER 2.1416e+06 338808 63332.1 1.76164e+06 2.54374e+06 4.30539e+06 32
SOLID WASTE WORKER 2.07557e+06 422455 -5278.96 1.66431e+06 2.49275e+06 4.15706e+06 36
PUBLIC SAFETY DISPATCHER II 1.83488e+06 455170 134222 1.04205e+06 2.42427e+06 3.46632e+06 26
OFFICE SPECIALIST III 1.95138e+06 23228.8 31125.6 1.12598e+06 2.00574e+06 3.13172e+06 30

... (295 rows omitted)


In [26]:
by_title.sort('Total Pay Benefits sum', descending = True).row(0)


Out[26]:
Row(Job Title='POLICE OFFICER', Base Pay sum=12607875.889999993, Overtime Pay sum=1668851.7199999997, Other Pay sum=1226939.47, Total Benefits sum=9367668.2600000016, Total Pay sum=15503667.079999996, Total Pay Benefits sum=24871335.339999992, Title sum=131)

In [27]:
by_title.select(('Job Title', 'Total Pay Benefits sum')).sort('Total Pay Benefits sum', descending=True)


Out[27]:
Job Title Total Pay Benefits sum
POLICE OFFICER 2.48713e+07
POLICE SERGEANT 8.89836e+06
FIRE APPARATUS OPERATOR 7.66393e+06
FIREFIGHTER 7.18351e+06
FIRE LIEUTENANT 5.3801e+06
OFFICE SPECIALIST II 4.77687e+06
SOLID WASTE TRUCK DRIVER 4.30539e+06
SOLID WASTE WORKER 4.15706e+06
PUBLIC SAFETY DISPATCHER II 3.46632e+06
OFFICE SPECIALIST III 3.13172e+06

... (295 rows omitted)

As is often the case in the real world, the categorization used for operations is not directly useful for analysis. We often need to build categories in order to get a handle on what's going on.

What do all those job titles look like


In [28]:
ordered_by_title['Job Title']


Out[28]:
array(['POLICE OFFICER', 'OFFICE SPECIALIST II', 'FIREFIGHTER',
       'SOLID WASTE WORKER', 'FIRE APPARATUS OPERATOR', 'POLICE SERGEANT',
       'SOLID WASTE TRUCK DRIVER', 'OFFICE SPECIALIST III',
       'PUBLIC SAFETY DISPATCHER II', 'PARKING ENFORCEMENT OFFICER',
       'LIBRARY ASSISTANT', 'FIRE LIEUTENANT', 'ACCOUNTING OFF SPEC III',
       'LIBRARY AIDE', 'LIBRARIAN II', 'LIBRARY SPECIALIST II', 'LABORER',
       'ASSOCIATE MANAGEMENT ANALYST', 'SKILLED LABORER',
       'BUILDING MAINTENANCE MECHANIC', 'LANDSCAPE GARDENER',
       'COMMUNITY SERVICE OFFICER', 'PUBLIC HEALTH NURSE',
       'RECREATION ACTIVITY LEADER', 'PSYCH SOC WKR II',
       'LEGISLATIVE ASSISTANT', 'COMMUNITY HLTH WRKR SPECIALIST',
       'SENIOR MANAGEMENT ANALYST', 'POLICE LIEUTENANT',
       'COMMUNITY SERVS SP I', 'SUPERVISING LIBRARY ASSISTANT',
       'SUPERVISING LIBRARIAN', 'RENT BOARD COMMISSIONER', 'FIRE CAPTAIN',
       'CUST SERVS SPEC III', 'APPLICATIONS PROG/ANA II',
       'ADMINISTRATIVE SECRETARY', 'SEWER MAINTENANCE ASST SUPV',
       'MECHANIC', 'ELECTRICIAN', 'COUNCILMEMBER',
       'ASSISTANT MANAGEMENT ANALYST', 'RECREATION COORDINATOR',
       'MENTAL HLTH CLIN II', 'INFORMATION SYSTEMS SPECIALIST',
       'ENGINEERING INSPECTOR', 'TRACTOR TRAILER DRIVER',
       'SCHOOL BOARD DIRECTOR', 'PUBLIC WORKS SUPERVISOR',
       'PRINCIPAL PLANNER', 'JANITOR', 'HEALTH SERVICES PROGRAM SPECIA',
       'DEPUTY CITY ATTY III', 'COMMUNITY SERVS SP III',
       'ASSOCIATE PLANNER', 'SUPERVISING PUBLIC SAFETY DISP',
       'SENIOR SYSTEMS ANALYST', 'SENIOR SERVICE ASSISTANT',
       'REG ENVIRONMENTAL HEALTH SPEC', 'PERMIT SPECIALIST',
       'PARKING METER MECHANIC', 'MENTAL HEALTH PROGRAM SUPERVIS',
       'LANDSCAPE EQUIPMENT OPERATOR', 'INFORMATION SYSTEMS SUPPORT TE',
       'FIELD REPRESENTATIVE', 'COMMUNITY SERVS SP II',
       'COMMUNITY SERVICE OFFICER SUPV', 'COMMUNITY DEVELOP PROJCT COORD',
       'BHA HOUSING SPECIALIST', 'ASSOCIATE CIVIL ENGINEER',
       'ADMINISTRATIVE ASSISTANT', 'ADMIN & FISCAL SVS MGR',
       'SERVICE TECHNICIAN', 'SENIOR PLANNER',
       'PARKING METER MAINTENANCE WORK', 'PARAMEDIC SUPERVISOR I',
       'OFFICE SPECIALIST SUPERVISOR', 'MECHANICAL SWEEPER OPERATOR',
       'MARINA ASSISTANT', 'LANDSCAPE GARDENER SUPERVISOR',
       'HAZARDOUS MAT SP II', 'FORESTRY CLIMBER',
       'BUILDING INSPECTOR II (CERT)', 'ASSISTANT FIRE CHIEF',
       'ANIMAL CONTROL OFFICER', 'ACCOUNTING OFF SPEC SUPERV',
       'WEIGHMASTER', 'TRAFFIC MAINT WKR I', 'TOOL LENDING SPECIALIST',
       'SOLID WASTE SUPERVISOR', 'SENIOR SOLID WASTE SUPERVISOR',
       'SENIOR LIBRARIAN', 'SENIOR LEGAL SECRETARY',
       'SENIOR LANDSCAPE GARDENER', 'SENIOR INFORMATION SYSTEMS SPE',
       'SENIOR HEALTH SERV PROG SPECIA', 'SENIOR FORESTRY CLIMBER',
       'SENIOR COMMUNITY HEALTH SPECIA', 'SENIOR ACCOUNTANT',
       'REGISTERED NURSE', 'POLICE CAPTAIN', 'MENTAL HEALTH CLINICAL SUPV',
       'LIBRARY SPECIALIST I', 'LEAD ELECTRICIAN',
       'HOUSING INSPECTOR (CERTIFIED)', 'CONSTRUCTION EQUIPMENT OPERATO',
       'COMMUNITY HEALTH WORKER', 'COMMUNICATIONS TECHNICIAN',
       'CODE ENFORCEMENT OFFICER II', 'CENTRAL SERVICES AIDE',
       'BUILDING MAINTENANCE SUPERVISO', 'AUDITOR II',
       'ASSOCIATE HUMAN RESOURCES ANAL', 'ASSISTANT TO THE MAYOR',
       'ASSISTANT RECREATION COORDINAT', 'ASSISTANT PLANNER',
       'ASSISTANT MENTAL HEALTH CLINIC', 'ANIMAL SERVICES ASSISTANT',
       'ACCOUNTING TECHNICIAN', 'VECTOR CONTROL TECHNICIAN',
       'TRAFFIC MAINT WKR II', 'TRAFFIC ENGINEERING ASSISTANT',
       'SUPERVISING PUBLIC HEALTH NURS', 'SUPERVISING CIVIL ENGINEER',
       'SUPERVISING BUILDING INSPECTOR', 'STAFF ATTORNEY I',
       'SPORTS OFFICIAL', 'SOLID WASTE LOADER OPERATOR',
       'SENIOR PUBLIC WORKS SUPERVISOR', 'SENIOR FIELD REPRESENTATIVE',
       'SENIOR ENVIRONMENTAL HEALTH SP', 'SENIOR BUYER',
       'SENIOR BUILDING PLANS ENGINEER', 'SENIOR BUILDING INSPECTOR',
       'SENIOR AUDITOR', 'REVENUE COLLECTION MANAGER',
       'RECREATION PROGRAM SUPERVISOR', 'PSYCHIATRIST SUPERVISOR',
       'PSYCHIATRIST III', 'PARKING ENFORCEMENT SUPERVISOR',
       'MINI BUS DRIVER', 'MID-LEVEL PRACTITIONER', 'MECHANIC SUPERVISOR',
       'MANAGER OF HOUSING & COMM SRVC', 'LIBRARY SERVICES MANAGER',
       'HUMAN RESOURCES TECHNICIAN', 'HEARING EXAMINER',
       'HEALTH SERVICES SUPERVISOR', 'FIRE PREVENTION INSPECTOR',
       'DRAFTING TECHNICIAN', 'DISABILITY SERVICES SPECIALIST',
       'CUSTOMER SERVICES SUPERVISOR', 'CRIME SCENE SUPERVISOR',
       'CONTAINER MAINTENANCE WELDER', 'CONCRETE FINISHER',
       'CLINICAL PSYCHOLOGIST', 'CITY CLERK', 'CHIEF OF PARTY',
       'BHA OFFICE ASSISTANT II', 'BHA OFFICE ASSISTANT I',
       'BATTALION CHIEF', 'ASSISTANT PUBLIC WORKS ENGINEE',
       'ASSISTANT CIVIL ENGINEER (REG)', 'ASSISTANT ARCHITECT',
       'AQUATICS FACILITIES SUPERVISOR', 'APPLICATIONS PROG/ANA I',
       'ACCOUNTANT II', 'ACCOUNTANT I', "WORKERS' COMPENSATION ANALYST",
       'WELDER MECHANIC', 'WATERSHED RESOURCES SPECIALIST',
       'WATERFRONT MANAGER', 'WAREHOUSE OPERATIONS SPECIALIS',
       'TRANSPORTATION MANAGER', 'TRAINING OFFICER',
       'TRAFFIC MAINTENANCE SUPERVISOR', 'SYSTEMS ACCOUNTANT',
       'SURVEY TECHNICIAN', 'SUPERVISING TRAFFIC ENGINEER',
       'STAFF ATTORNEY III', 'SOLID WASTE/RECYCLING MANAGER',
       'SENIOR SERVICE AIDE', 'SENIOR PSYCH SOC WORKER',
       'SENIOR PERMIT SPECIALIST', 'SENIOR LANDSCAPE GARDENER SUPE',
       'SENIOR HUMAN RESOURCES ANALYST', 'SENIOR HEALTH MANAGEMENT ANALY',
       'SENIOR GROUNDSKEEPER', 'SENIOR FORESTRY SUPERVISOR',
       'SENIOR EQUIPMENT SUPERVISOR', 'SENIOR ELECTRICAL SUPERVISOR',
       'SENIOR DRAFTING TECHNICIAN', 'SENIOR CITIZEN CENTER DIRECTOR',
       'SENIOR BUILDING PLANS EXAMINER', 'SENIOR BUILDING MTC SUPERVISOR',
       'SECRETARY TO THE CITY MANAGER', 'ROSARIAN',
       'REVENUE DEVELOPMENT SPECIALIST', 'RECYCLING PROGRAM MANAGER',
       'RECREATION & YOUTH SVCS MANAGE', 'RECORDS MANAGER',
       'RECORDS ASSISTANT', 'REAL PROPERTY ADMINISTRATOR',
       'PUBLIC WORKS MAINTENANCE SUPER', 'PUBLIC SAFETY BUSINESS MANAGER',
       'POLICE REVIEW COMMISSION OFFIC', 'POLICE REVIEW COMMISSION INVES',
       'POLICE CHIEF', 'PERMIT CENTER COORDINATOR', 'PARKS SUPERINTENDENT',
       'PARKING SERVICES MANAGER', 'PARKING MTR MTC & COLLECT SUPV',
       'PARKING ENFORCEMENT MANAGER', 'PARALEGAL',
       'OCCUPATIONAL HEALTH/SAFETY SPE', 'OCCUPATIONAL HEALTH & SAFETY C',
       'MECHANIC LEAD', 'MEALSITE COORDINATOR',
       'MANAGER, FAM HLTH & NRS SERVIC', 'MANAGER OF MENTAL HEALTH SERVI',
       'MANAGER OF ENVIRONMENTAL HEALT', 'MANAGER OF ENGINEERING',
       'MANAGER OF AGING SERVICES', 'LIBRARY LITERACY PROGRAM COORD',
       'LIBRARY INFO SYS ADMINISTRATOR', 'LEGAL OFFICE SUPERVISOR',
       'LEAD COMMUNICATIONS TECHNICIAN', 'LANDSCAPE ARCHITECT',
       'LAND USE PLANNING MANAGER', 'JANITOR SUPERVISOR',
       'INFORMATION SYSTEMS MANAGER', 'HUMAN RESOURCES MANAGER',
       'HOUSING INSPECTOR SUPERVISOR', 'HOUSING INSPECTOR',
       'HEALTH PLNG, EDUC & PROM SUPV', 'HEALTH OFFICER (CERT)',
       'HEALTH NUTRITION PROGRAM COORD', 'HAZARDOUS MATERIALS MANAGER',
       'HARBORMASTER', 'GENERAL SERVICES MANAGER', 'FORESTRY TECHNICIAN',
       'FORESTRY CLIMBER SUPERVISOR', 'FIRE CHIEF',
       'FIRE AND LIFE-SAFETY PLANS EXA', 'FACILITIES MAINTENANCE SUPERIN',
       'EXECUTIVE DIRECTOR RENT BOARD', 'EQUIPMENT SUPERINTENDENT',
       'ENVIRONMENTAL COMPLIANCE SPECI', 'ENERGY PROGRAM MANAGER',
       'EMPLOYMENT PROGRAMS ADMINISTRA', 'EMERGENCY SERVICES COORDINATOR',
       'ELECTRICAL PARTS TECHNICIAN', 'EEO AND DIVERSITY OFFICER',
       'ECONOMIC DEVELOPMENT MANAGER', 'ECONOMIC DEVELOP PROJECT COORD',
       'DRAFTING AIDE', 'DIRECTOR/HLTH, HSG & COMM SERV',
       'DIRECTOR OF PUBLIC WORKS', 'DIRECTOR OF PLANNING',
       'DIRECTOR OF LIBRARY SERVICES', 'DIRECTOR OF INFORMATION TECHNO',
       'DIRECTOR OF HUMAN RESOURCES', 'DIRECTOR OF FINANCE',
       'DEPUTY FIRE MARSHAL', 'DEPUTY FIRE CHIEF',
       'DEPUTY DIRECTOR OF PUBLIC WORK', 'DEPUTY DIRECTOR OF PLANNING',
       'DEPUTY DIRECTOR OF LIBRARY SER', 'DEPUTY DIRECTOR OF HEALTH',
       'DEPUTY DIR/HLTH, HSG & COM SER', 'DEPUTY CITY MANAGER',
       'DEPUTY CITY CLERK', 'DEPUTY CITY AUDITOR/PAYRL MAN',
       'CUSTOMER SERVICE MANAGER', 'CRIME ANALYST',
       'COMMUNICATIONS MANAGER', 'CODE ENFORCEMENT SUPERVISOR',
       'CIVIC ARTS COORDINATOR', 'CITY MANAGER', 'CITY AUDITOR',
       'CITY ATTORNEY', 'CIRCULATION SERVICES MANAGER', 'BUYER',
       'BUILDING INSPECTOR II', 'BUILDING AND SAFETY MANAGER',
       'BUDGET MANAGER', 'BHA PROPERTY MANAGER', 'BHA MANAGEMENT ANALYST',
       'BHA FINANCE MANAGER', 'BHA EXECUTIVE DIRECTOR',
       'BHA EXECUTIVE ASSISTANT', 'BHA ACCOUNTANT', 'BENEFITS SPECIALIST',
       'AUDITOR I', 'AUDIT MANAGER', 'ASSOCIATE TRAFFIC ENGINEER',
       'ASSISTANT TRAFFIC ENGINEER', 'ASSISTANT TO THE CITY MANAGER',
       'ASSISTANT CITY ATTORNEY', 'ARCHITECT', 'AQUATICS SPECIALIST II',
       'ANIMAL SERVICES MANAGER', 'ADMINISTRATIVE STAFF ASSISTANT',
       'ADMINISTRATIVE HEARING EXAMINE', 'ACCOUNTING MANAGER'], 
      dtype='<U30')

In [29]:
categories = {
    'Police': ["POLICE"], 
    'Fire': ["FIRE"], 
    'Animal Control':["ANIMAL"], 
    'Health': ["HEALTH", "PSYCH", "HLTH"],
    'Library': ['LIBRARY','LIBRARIAN'],
    'Offical' : ['MAYOR','COUNCIL', 'COMMISSIONER', 'CITY MANAGER'],
    'Trades' :["ELECTRICIAN","MECHANIC", "ENGINEER"],
    'Parking' : ["PARKING"],
    'Recreation' : ["RECREATION", "AQUATICS"],
    'Gardener' : ["GARDEN"],
    "Labor" : ["LABOR", "JANITOR"],
    'Community': ["COMMUNITY"],
    'Admin' : ["ADMIN"],
    'Traffic' : ["TRAFFIC"],
    'Accounting' : ["ACCOUNT"],
    'Dispatch' : ["DISPATCH"],
    'Waste' : ["WASTE", "SEWER"],
    'Analyst' : ["ANALYS"],
    'Office' : ["OFFICE "],
    'Legal' : ['LEGISLAT', 'ATTORN', 'ATTY'],
    'IT' : ["PROG", "INFORMATION SYSTEMS"],
    'School' : ["SCHOOL"],
    'Architect' : ["ARCHITECT"],
    'Planner' : ["PLANNER", "PERMIT"]
    }

In [30]:
categories


Out[30]:
{'Accounting': ['ACCOUNT'],
 'Admin': ['ADMIN'],
 'Analyst': ['ANALYS'],
 'Animal Control': ['ANIMAL'],
 'Architect': ['ARCHITECT'],
 'Community': ['COMMUNITY'],
 'Dispatch': ['DISPATCH'],
 'Fire': ['FIRE'],
 'Gardener': ['GARDEN'],
 'Health': ['HEALTH', 'PSYCH', 'HLTH'],
 'IT': ['PROG', 'INFORMATION SYSTEMS'],
 'Labor': ['LABOR', 'JANITOR'],
 'Legal': ['LEGISLAT', 'ATTORN', 'ATTY'],
 'Library': ['LIBRARY', 'LIBRARIAN'],
 'Offical': ['MAYOR', 'COUNCIL', 'COMMISSIONER', 'CITY MANAGER'],
 'Office': ['OFFICE '],
 'Parking': ['PARKING'],
 'Planner': ['PLANNER', 'PERMIT'],
 'Police': ['POLICE'],
 'Recreation': ['RECREATION', 'AQUATICS'],
 'School': ['SCHOOL'],
 'Trades': ['ELECTRICIAN', 'MECHANIC', 'ENGINEER'],
 'Traffic': ['TRAFFIC'],
 'Waste': ['WASTE', 'SEWER']}

Applying a function to create a new column

  • table.apply: applies a function to every element in a column.

One of the best examples of high-order functions and tables is in categorizing data. As is often the case, we create a new column with the results


In [31]:
def categorize (title) : 
    for category, keywords in categories.items():
        for word in keywords :
            if title.find(word) >= 0 : return category
    return 'Other'

In [32]:
berkeley_sal_2011['Category'] = berkeley_sal_2011.apply(categorize, 'Job Title')
berkeley_sal_2011


Out[32]:
Employee Name Job Title Base Pay Overtime Pay Other Pay Total Benefits Total Pay Total Pay Benefits Category
HOWARD H NONOGUCHI POLICE SERGEANT $132,540.85 $114,387.97 $53,483.56 $102,377.48 $300,412.38 $402,789.86 Police
DAVID A FRANKEL POLICE LIEUTENANT $159,094.73 $38,995.01 $41,465.57 $124,819.29 $239,555.31 $364,374.60 Police
MICHAEL K MEEHAN POLICE CHIEF $205,400.00 $0.00 $7,380.00 $124,814.56 $212,780.00 $337,594.56 Police
ERIK M UPSON POLICE CAPTAIN $182,382.48 $0.00 $19,346.55 $133,848.06 $201,729.03 $335,577.09 Police
KEVIN M SCHOFIELD POLICE LIEUTENANT $159,094.73 $31,284.18 $20,132.52 $119,134.15 $210,511.43 $329,645.58 Police
CYNTHIA HARRIS POLICE CAPTAIN $182,382.48 $0.00 $21,884.00 $121,365.25 $204,266.48 $325,631.73 Police
ANDREW R GREENWOOD POLICE CAPTAIN $159,094.73 $7,668.11 $34,550.65 $123,852.11 $201,313.49 $325,165.60 Police
RANDOLPH FILES POLICE LIEUTENANT $159,094.73 $28,364.65 $19,671.10 $117,449.09 $207,130.48 $324,579.57 Police
EDWARD A SPILLER POLICE LIEUTENANT $134,457.24 $36,225.22 $38,738.16 $111,729.65 $209,420.62 $321,150.27 Police
JOHN R TARASCIO FIRE LIEUTENANT $117,198.12 $87,476.09 $27,504.05 $82,069.44 $232,178.26 $314,247.70 Fire

... (1427 rows omitted)


In [33]:
# lose the individual names
job_categories = berkeley_sal_2011.drop("Employee Name") 
job_categories["Cat"] = 1
by_categories = job_categories.group("Category", sum)
by_categories.sort("Total Pay Benefits sum", descending=True).show()


Category Job Title sum Base Pay sum Overtime Pay sum Other Pay sum Total Benefits sum Total Pay sum Total Pay Benefits sum Cat sum
Police 1.92611e+07 2.65889e+06 2.14624e+06 1.42824e+07 2.40663e+07 3.83486e+07 180
Other 1.83977e+07 672446 187563 1.11731e+07 1.92577e+07 3.04308e+07 229
Fire 1.25994e+07 2.07651e+06 2.11749e+06 8.20288e+06 1.67934e+07 2.49963e+07 133
Waste 5.5753e+06 1.04136e+06 78009.7 4.46347e+06 6.69467e+06 1.11581e+07 85
Health 6.74255e+06 18549.2 -30277.7 3.66507e+06 6.73082e+06 1.03959e+07 82
Trades 5.86076e+06 180840 53476.1 4.01883e+06 6.09507e+06 1.01139e+07 72
Library 5.41883e+06 0 227391 3.24732e+06 5.64622e+06 8.89354e+06 115
Office 5.58432e+06 29529.8 -200899 3.32454e+06 5.41295e+06 8.73749e+06 95
Analyst 3.86264e+06 32003.6 2533.19 2.14191e+06 3.89718e+06 6.03908e+06 44
IT 3.77262e+06 26664.8 -12701.8 2.04422e+06 3.78658e+06 5.83081e+06 45
Community 3.4199e+06 298152 7434.05 2.01225e+06 3.72549e+06 5.73773e+06 46
Accounting 3.00249e+06 4309.24 -19776.9 1.73983e+06 2.98702e+06 4.72685e+06 41
Labor 2.3298e+06 125721 104040 1.91929e+06 2.55956e+06 4.47885e+06 41
Parking 2.01935e+06 278233 50714.8 1.41648e+06 2.3483e+06 3.76478e+06 35
Dispatch 1.83488e+06 455170 134222 1.04205e+06 2.42427e+06 3.46632e+06 26
Planner 1.98058e+06 4648.72 -34218.9 1.12239e+06 1.95101e+06 3.07341e+06 26
Legal 1.97144e+06 0 -41261.6 1.05224e+06 1.93018e+06 2.98242e+06 22
Gardener 1.5244e+06 57200.3 20040.2 1.16652e+06 1.60164e+06 2.76816e+06 23
Admin 1.60162e+06 2039.79 -24695.7 885405 1.57896e+06 2.46437e+06 22
Recreation 1.35895e+06 4154.77 52986.2 850647 1.4161e+06 2.26674e+06 27
Offical 1.01081e+06 0 41329 509139 1.05214e+06 1.56128e+06 24
Animal Control 518299 13787.1 -14270.6 370493 517815 888308 8
Traffic 364004 95436.1 -1345.97 264984 458094 723078 6
Architect 416699 0 -7264.66 226738 409435 636172 4
School 90000.3 0 0 3181.75 90000.3 93182.1 6

As is often the case working with real data, we often need to iterate a bit to get what we want out of it. With all those titles, a lot of stuff is likely to end up as other.

Here we have a little iterative process to get enough of the job titles categorized


In [34]:
job_categories.where('Category', 'Other')


Out[34]:
Job Title Base Pay Overtime Pay Other Pay Total Benefits Total Pay Total Pay Benefits Category Cat
EXECUTIVE DIRECTOR RENT BOARD $184,801.21 $0.00 $5,544.03 $93,605.21 $190,345.24 $283,950.45 Other 1
BATTALION CHIEF $149,372.86 $27,545.70 $5,411.42 $93,113.17 $182,329.98 $275,443.15 Other 1
BATTALION CHIEF $145,023.46 $18,852.08 $8,344.71 $90,142.27 $172,220.25 $262,362.52 Other 1
DIRECTOR OF HUMAN RESOURCES $174,364.83 $0.00 $0.00 $76,678.68 $174,364.83 $251,043.51 Other 1
DIRECTOR OF PUBLIC WORKS $164,355.82 $0.00 $177.69 $84,332.51 $164,533.51 $248,866.02 Other 1
DEPUTY DIRECTOR OF PLANNING $158,918.82 $0.00 $-1,780.30 $77,309.98 $157,138.52 $234,448.50 Other 1
DIRECTOR OF FINANCE $156,754.73 $0.00 $-1,188.80 $76,864.00 $155,565.93 $232,429.93 Other 1
PARAMEDIC SUPERVISOR I $129,398.10 $10,431.35 $11,142.74 $76,303.27 $150,972.19 $227,275.46 Other 1
DIRECTOR OF INFORMATION TECHNO $159,075.80 $0.00 $-3,059.15 $70,498.10 $156,016.65 $226,514.75 Other 1
TRANSPORTATION MANAGER $145,319.51 $0.00 $0.00 $80,416.90 $145,319.51 $225,736.41 Other 1

... (219 rows omitted)


In [35]:
job_categories.where('Category', 'Other').group('Job Title',sum).sort('Cat sum', descending=True)


Out[35]:
Job Title Base Pay sum Overtime Pay sum Other Pay sum Total Benefits sum Total Pay sum Total Pay Benefits sum Category sum Cat sum
CUST SERVS SPEC III 567235 0 -8073.36 353256 559162 912417 9
TRACTOR TRAILER DRIVER 429296 76876.1 13723 396282 519896 916178 6
PUBLIC WORKS SUPERVISOR 472999 87905.1 14995.3 406405 575899 982305 6
SUPERVISING PUBLIC SAFETY DISP 444562 91647.4 34080.9 273332 570290 843623 5
SENIOR SERVICE ASSISTANT 176693 204.64 3049.97 122739 179948 302686 5
LANDSCAPE EQUIPMENT OPERATOR 331190 24327.5 19436.8 253140 374954 628094 5
FIELD REPRESENTATIVE 316729 28094 2391.98 192536 347215 539751 5
BHA HOUSING SPECIALIST 378306 0 -18795.5 211412 359511 570923 5
SERVICE TECHNICIAN 254333 160.49 12174.8 214641 266668 481310 4
PARAMEDIC SUPERVISOR I 440441 24608.4 73589.9 267868 538639 806507 4

... (113 rows omitted)


In [36]:
job_categories.where('Category', 'Other').group('Job Title',sum).sort('Total Pay Benefits sum', descending=True)


Out[36]:
Job Title Base Pay sum Overtime Pay sum Other Pay sum Total Benefits sum Total Pay sum Total Pay Benefits sum Category sum Cat sum
PUBLIC WORKS SUPERVISOR 472999 87905.1 14995.3 406405 575899 982305 6
TRACTOR TRAILER DRIVER 429296 76876.1 13723 396282 519896 916178 6
CUST SERVS SPEC III 567235 0 -8073.36 353256 559162 912417 9
SUPERVISING PUBLIC SAFETY DISP 444562 91647.4 34080.9 273332 570290 843623 5
PARAMEDIC SUPERVISOR I 440441 24608.4 73589.9 267868 538639 806507 4
LANDSCAPE EQUIPMENT OPERATOR 331190 24327.5 19436.8 253140 374954 628094 5
BHA HOUSING SPECIALIST 378306 0 -18795.5 211412 359511 570923 5
FIELD REPRESENTATIVE 316729 28094 2391.98 192536 347215 539751 5
BATTALION CHIEF 294396 46397.8 13756.1 183255 354550 537806 2
SERVICE TECHNICIAN 254333 160.49 12174.8 214641 266668 481310 4

... (113 rows omitted)

So no job title left has more than 10 employees in it, but some have quite a bit of cost. We could go back and add more entries to our category table and iterate a bit. The important thing is that we create new tables, we don't clobber old ones.

Well this shows the challenge in managing budget pretty nicely. Most of the money is spent in a few job categories. But then there are still over 200 employees in a zillion other categories that are stile the #2 spend.


In [37]:
by_categories.sort('Total Pay Benefits sum', descending=True).barh('Category', select=['Total Pay Benefits sum', 'Cat sum'], overlay=False)


So let's try to understand the police category a bit more.


In [38]:
police = job_categories.where('Category', 'Police')
police


Out[38]:
Job Title Base Pay Overtime Pay Other Pay Total Benefits Total Pay Total Pay Benefits Category Cat
POLICE SERGEANT $132,540.85 $114,387.97 $53,483.56 $102,377.48 $300,412.38 $402,789.86 Police 1
POLICE LIEUTENANT $159,094.73 $38,995.01 $41,465.57 $124,819.29 $239,555.31 $364,374.60 Police 1
POLICE CHIEF $205,400.00 $0.00 $7,380.00 $124,814.56 $212,780.00 $337,594.56 Police 1
POLICE CAPTAIN $182,382.48 $0.00 $19,346.55 $133,848.06 $201,729.03 $335,577.09 Police 1
POLICE LIEUTENANT $159,094.73 $31,284.18 $20,132.52 $119,134.15 $210,511.43 $329,645.58 Police 1
POLICE CAPTAIN $182,382.48 $0.00 $21,884.00 $121,365.25 $204,266.48 $325,631.73 Police 1
POLICE CAPTAIN $159,094.73 $7,668.11 $34,550.65 $123,852.11 $201,313.49 $325,165.60 Police 1
POLICE LIEUTENANT $159,094.73 $28,364.65 $19,671.10 $117,449.09 $207,130.48 $324,579.57 Police 1
POLICE LIEUTENANT $134,457.24 $36,225.22 $38,738.16 $111,729.65 $209,420.62 $321,150.27 Police 1
POLICE LIEUTENANT $159,094.73 $4,244.54 $26,276.73 $119,238.12 $189,616.00 $308,854.12 Police 1

... (170 rows omitted)

How do the pay labels spread across the force?

We can look at histograms by pay label. First all toegether and then broken apart.


In [39]:
police.select(paylabels).hist(bins=30,normed=False)



In [40]:
police.select(paylabels).hist(bins=30,normed=False, overlay=False)


Base pay seems to chunk into categories, perhaps by job title.

Most members of the force do little overtime, but a few do a lot!

How many are in each Job Title?


In [41]:
police.group('Job Title')


Out[41]:
Job Title count
POLICE CAPTAIN 3
POLICE CHIEF 1
POLICE LIEUTENANT 10
POLICE OFFICER 131
POLICE REVIEW COMMISSION INVES 1
POLICE REVIEW COMMISSION OFFIC 1
POLICE SERGEANT 33

In [42]:
# We can actually get all the data by title
police.select(['Job Title','Base Pay', 'Overtime Pay']).group('Job Title', collect=lambda x:x)


Out[42]:
Job Title Base Pay Overtime Pay
POLICE CAPTAIN [ 182382.48 182382.48 159094.73] [ 0. 0. 7668.11]
POLICE CHIEF [ 205400.] [ 0.]
POLICE LIEUTENANT [ 159094.73 159094.73 159094.73 134457.24 159094.73 ... [ 38995.01 31284.18 28364.65 36225.22 4244.54 103 ...
POLICE OFFICER [ 114929.67 114929.67 114929.67 114929.67 114929.67 ... [ 65218.2 78285.37 58174.37 45539.99 49006.25 5099 ...
POLICE REVIEW COMMISSION INVES [ 87663.01] [ 0.]
POLICE REVIEW COMMISSION OFFIC [ 0.] [ 0.]
POLICE SERGEANT [ 132540.85 132540.85 132540.85 132540.85 136357.55 ... [ 114387.97 39658.67 50117.44 41593.35 10401.66 ...

We can't just pivot by Job Title because we don't have a uniform number of rows, but what we can do is for pivot and bin (or histogram) so we can see the distribution of a column by job title.

Sure enough. Officers cluster around 100-120k, sergeants at 130-140k, but there's a little overlap.


In [43]:
police.pivot_bin('Job Title', 'Base Pay', bins=np.arange(0,200000,10000)).show()


bin POLICE CAPTAIN POLICE CHIEF POLICE LIEUTENANT POLICE OFFICER POLICE REVIEW COMMISSION INVES POLICE REVIEW COMMISSION OFFIC POLICE SERGEANT
0 0 0 0 15 0 1 0
10000 0 0 0 0 0 0 0
20000 0 0 0 1 0 0 0
30000 0 0 0 2 0 0 0
40000 0 0 0 1 0 0 0
50000 0 0 0 0 0 0 0
60000 0 0 0 0 0 0 0
70000 0 0 0 1 0 0 0
80000 0 0 0 0 1 0 0
90000 0 0 0 6 0 0 0
100000 0 0 0 24 0 0 0
110000 0 0 0 81 0 0 5
120000 0 0 0 0 0 0 1
130000 0 0 2 0 0 0 27
140000 0 0 0 0 0 0 0
150000 1 0 7 0 0 0 0
160000 0 0 1 0 0 0 0
170000 0 0 0 0 0 0 0
180000 2 0 0 0 0 0 0
190000 0 0 0 0 0 0 0

In [44]:
police.pivot_bin('Job Title', 'Base Pay', bins=np.arange(0,200000,10000)).bar('bin')



In [45]:
police.pivot_bin('Job Title', 'Overtime Pay', bins=np.arange(0,200000,10000)).bar('bin')



In [46]:
police.pivot_bin('Job Title', 'Total Pay Benefits', bins=np.arange(0,420000,10000)).bar('bin')



In [47]:
fire = job_categories.where('Category','Fire')
fire.select(paylabels).hist(bins=30)



In [48]:
fire.group('Job Title')


Out[48]:
Job Title count
ASSISTANT FIRE CHIEF 4
DEPUTY FIRE CHIEF 1
DEPUTY FIRE MARSHAL 1
FIRE AND LIFE-SAFETY PLANS EXA 1
FIRE APPARATUS OPERATOR 36
FIRE CAPTAIN 9
FIRE CHIEF 1
FIRE LIEUTENANT 24
FIRE PREVENTION INSPECTOR 2
FIREFIGHTER 54

In [49]:
fire.pivot_bin('Job Title', 'Total Pay Benefits', bins=np.arange(0,420000,10000)).bar('bin')


Let's compare the 2011 data with more recent 2013 data.


In [50]:
raw_berkeley_sal_2013 = Table.read_table("./data/City_of_Berkeley_Employee_Salaries_-_2013.csv")
raw_berkeley_sal_2013


Out[50]:
Employee Name Job Title Base Pay Overtime Pay Other Pay Benefits Total Pay Total Pay & Benefits Year Notes Agency
Romeo C Moscardon ENGINEERING INSPECTOR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 01/01/2013 12:00:00 AM nan Berkeley
Robert A Buell MECHANICAL SWEEPER OPERATOR $60082.90 $0.00 $-60046.57 $0.00 $36.33 $36.33 01/01/2013 12:00:00 AM nan Berkeley
Patricia Pitre' ASSISTANT RECREATION COORDINAT $5221.20 $0.00 $-5164.41 $0.00 $56.79 $56.79 01/01/2013 12:00:00 AM nan Berkeley
Robert C Norwood SKILLED LABORER $61032.40 $0.00 $-60674.72 $111.81 $357.68 $469.49 01/01/2013 12:00:00 AM nan Berkeley
Jeremy M Alonzo LIBRARY ASSISTANT $779.56 $0.00 $280.20 $241.91 $1059.76 $1301.67 01/01/2013 12:00:00 AM nan Berkeley
Leticia S Murillo OFFICE SPECIALIST II $1692.42 $0.00 $-224.37 $0.00 $1468.05 $1468.05 01/01/2013 12:00:00 AM nan Berkeley
Martin Manqueros FIRE APPARATUS OPERATOR $62825.70 $0.00 $-62635.84 $1625.60 $189.86 $1815.46 01/01/2013 12:00:00 AM nan Berkeley
Kent R Murray OFFICE SPECIALIST SUPERVISOR $15282.55 $0.00 $-15008.94 $1606.08 $273.61 $1879.69 01/01/2013 12:00:00 AM nan Berkeley
Pete Gomez POLICE OFFICER $544.59 $0.00 $1328.69 $570.85 $1873.28 $2444.13 01/01/2013 12:00:00 AM nan Berkeley
Norma J Foster COMMUNITY HLTH WRKR SPECIALIST $0.00 $0.00 $3461.74 $0.00 $3461.74 $3461.74 01/01/2013 12:00:00 AM nan Berkeley

... (1393 rows omitted)

Well, the data base changed. It picked up a few columns over the years. And we need to convert the salary strings to numbers so we can do analysis on them. All in one go...


In [51]:
berkeley_sal_2013 = raw_berkeley_sal_2013.drop(['Year','Notes','Agency'])
berkeley_sal_2013


Out[51]:
Employee Name Job Title Base Pay Overtime Pay Other Pay Benefits Total Pay Total Pay & Benefits
Romeo C Moscardon ENGINEERING INSPECTOR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Robert A Buell MECHANICAL SWEEPER OPERATOR $60082.90 $0.00 $-60046.57 $0.00 $36.33 $36.33
Patricia Pitre' ASSISTANT RECREATION COORDINAT $5221.20 $0.00 $-5164.41 $0.00 $56.79 $56.79
Robert C Norwood SKILLED LABORER $61032.40 $0.00 $-60674.72 $111.81 $357.68 $469.49
Jeremy M Alonzo LIBRARY ASSISTANT $779.56 $0.00 $280.20 $241.91 $1059.76 $1301.67
Leticia S Murillo OFFICE SPECIALIST II $1692.42 $0.00 $-224.37 $0.00 $1468.05 $1468.05
Martin Manqueros FIRE APPARATUS OPERATOR $62825.70 $0.00 $-62635.84 $1625.60 $189.86 $1815.46
Kent R Murray OFFICE SPECIALIST SUPERVISOR $15282.55 $0.00 $-15008.94 $1606.08 $273.61 $1879.69
Pete Gomez POLICE OFFICER $544.59 $0.00 $1328.69 $570.85 $1873.28 $2444.13
Norma J Foster COMMUNITY HLTH WRKR SPECIALIST $0.00 $0.00 $3461.74 $0.00 $3461.74 $3461.74

... (1393 rows omitted)


In [52]:
berkeley_sal_2013.set_format(berkeley_sal_2013.labels[2:], CurrencyFormatter)


Out[52]:
Employee Name Job Title Base Pay Overtime Pay Other Pay Benefits Total Pay Total Pay & Benefits
Romeo C Moscardon ENGINEERING INSPECTOR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Robert A Buell MECHANICAL SWEEPER OPERATOR $60,082.90 $0.00 $-60,046.57 $0.00 $36.33 $36.33
Patricia Pitre' ASSISTANT RECREATION COORDINAT $5,221.20 $0.00 $-5,164.41 $0.00 $56.79 $56.79
Robert C Norwood SKILLED LABORER $61,032.40 $0.00 $-60,674.72 $111.81 $357.68 $469.49
Jeremy M Alonzo LIBRARY ASSISTANT $779.56 $0.00 $280.20 $241.91 $1,059.76 $1,301.67
Leticia S Murillo OFFICE SPECIALIST II $1,692.42 $0.00 $-224.37 $0.00 $1,468.05 $1,468.05
Martin Manqueros FIRE APPARATUS OPERATOR $62,825.70 $0.00 $-62,635.84 $1,625.60 $189.86 $1,815.46
Kent R Murray OFFICE SPECIALIST SUPERVISOR $15,282.55 $0.00 $-15,008.94 $1,606.08 $273.61 $1,879.69
Pete Gomez POLICE OFFICER $544.59 $0.00 $1,328.69 $570.85 $1,873.28 $2,444.13
Norma J Foster COMMUNITY HLTH WRKR SPECIALIST $0.00 $0.00 $3,461.74 $0.00 $3,461.74 $3,461.74

... (1393 rows omitted)


In [53]:
berkeley_sal_2013["Total Pay & Benefits"]


Out[53]:
array([  0.00000000e+00,   3.63300000e+01,   5.67900000e+01, ...,
         3.20466220e+05,   3.35633730e+05,   3.39017880e+05])

In [54]:
berkeley_sal_2013.sort('Total Pay & Benefits',descending=True)


Out[54]:
Employee Name Job Title Base Pay Overtime Pay Other Pay Benefits Total Pay Total Pay & Benefits
David A Frankel POLICE LIEUTENANT $159,939.00 $25,105.79 $53,355.02 $100,618.07 $238,399.81 $339,017.88
Peter J Hong POLICE SERGEANT $133,244.28 $77,554.04 $38,799.69 $86,035.72 $249,598.01 $335,633.73
Andrew R Greenwood POLICE CAPTAIN $183,350.44 $0.00 $33,669.70 $103,446.08 $217,020.14 $320,466.22
Michael K Meehan POLICE CHIEF $205,400.00 $0.00 $5,800.00 $105,435.68 $211,200.00 $316,635.68
Erik M Upson POLICE CAPTAIN $183,350.44 $0.00 $28,921.43 $103,879.17 $212,271.87 $316,151.04
Edward A Spiller POLICE LIEUTENANT $159,939.00 $5,767.03 $45,103.22 $97,314.23 $210,809.25 $308,123.48
Jennifer A Louis POLICE SERGEANT $133,244.28 $43,337.74 $43,037.26 $87,121.74 $219,619.28 $306,741.02
Randolph Files POLICE LIEUTENANT $159,939.00 $27,566.38 $26,039.70 $91,512.60 $213,545.08 $305,057.68
Cynthia Harris POLICE CAPTAIN $183,350.44 $0.00 $25,135.61 $93,382.23 $208,486.05 $301,868.28
Christine S Daniel CITY MANAGER $224,999.84 $0.00 $0.00 $76,802.03 $224,999.84 $301,801.87

... (1393 rows omitted)

Isn't that interesting. They seem to have gotten their overtime under control. Was that management, end of the occupy movement, something else? Let's do a bit of comparison.

First we need to do some clean up and get labels we can deal with.


In [55]:
b2011 = berkeley_sal_2011.select(["Employee Name", "Job Title", "Total Pay Benefits"])
b2011.relabel('Total Pay Benefits', "Total 2011")
b2011.sort('Total 2011', descending=True)


Out[55]:
Employee Name Job Title Total 2011
HOWARD H NONOGUCHI POLICE SERGEANT $402,789.86
DAVID A FRANKEL POLICE LIEUTENANT $364,374.60
MICHAEL K MEEHAN POLICE CHIEF $337,594.56
ERIK M UPSON POLICE CAPTAIN $335,577.09
KEVIN M SCHOFIELD POLICE LIEUTENANT $329,645.58
CYNTHIA HARRIS POLICE CAPTAIN $325,631.73
ANDREW R GREENWOOD POLICE CAPTAIN $325,165.60
RANDOLPH FILES POLICE LIEUTENANT $324,579.57
EDWARD A SPILLER POLICE LIEUTENANT $321,150.27
JOHN R TARASCIO FIRE LIEUTENANT $314,247.70

... (1427 rows omitted)


In [56]:
b2013 = berkeley_sal_2013.select(["Employee Name", "Job Title", "Total Pay & Benefits"])
b2013.relabel('Job Title','Title 2013')
b2013.relabel("Total Pay & Benefits", "Total 2013")
b2013.sort('Total 2013', descending=True)


Out[56]:
Employee Name Title 2013 Total 2013
David A Frankel POLICE LIEUTENANT $339,017.88
Peter J Hong POLICE SERGEANT $335,633.73
Andrew R Greenwood POLICE CAPTAIN $320,466.22
Michael K Meehan POLICE CHIEF $316,635.68
Erik M Upson POLICE CAPTAIN $316,151.04
Edward A Spiller POLICE LIEUTENANT $308,123.48
Jennifer A Louis POLICE SERGEANT $306,741.02
Randolph Files POLICE LIEUTENANT $305,057.68
Cynthia Harris POLICE CAPTAIN $301,868.28
Christine S Daniel CITY MANAGER $301,801.87

... (1393 rows omitted)

Snap! They decided that case was a good idea for proper nouns. Let's go back to the old way.


In [57]:
b2013['Employee Name'] = b2013.apply(str.upper, 'Employee Name')
b2013


Out[57]:
Employee Name Title 2013 Total 2013
ROMEO C MOSCARDON ENGINEERING INSPECTOR $0.00
ROBERT A BUELL MECHANICAL SWEEPER OPERATOR $36.33
PATRICIA PITRE' ASSISTANT RECREATION COORDINAT $56.79
ROBERT C NORWOOD SKILLED LABORER $469.49
JEREMY M ALONZO LIBRARY ASSISTANT $1,301.67
LETICIA S MURILLO OFFICE SPECIALIST II $1,468.05
MARTIN MANQUEROS FIRE APPARATUS OPERATOR $1,815.46
KENT R MURRAY OFFICE SPECIALIST SUPERVISOR $1,879.69
PETE GOMEZ POLICE OFFICER $2,444.13
NORMA J FOSTER COMMUNITY HLTH WRKR SPECIALIST $3,461.74

... (1393 rows omitted)

Now we can put the two tables together to see what happened with employees who were around in both years. Here we get to use another powerful operations on tables.

  • Table.join: joins two tables together using a column of each that contains common values.

Here we have the employee names in each table. The join will give us the title and salary in both years for those employees in both tables, i.e., working for the city in both years


In [58]:
b11_13 = b2011.join('Employee Name', b2013)
b11_13


Out[58]:
Employee Name Job Title Total 2011 Title 2013 Total 2013
AARON E SAGE SENIOR PLANNER 153752 SENIOR PLANNER 158669
AARON M LEE ASSISTANT FIRE CHIEF 291049 DEPUTY FIRE CHIEF 245273
AARON P DIEKEN TRAFFIC MAINT WKR I 108753 TRAFFIC MAINT WKR I 99871.6
AARON R BAKER BUILDING MAINTENANCE MECHANIC 115985 BUILDING MAINTENANCE SUPERVISO 106721
AARON T LOWE CUST SERVS SPEC III 88239.9 CUST SERVS SPEC III 92845
ABDUL WAYNE RECREATION ACTIVITY LEADER 50784.1 RECREATION ACTIVITY LEADER 50320.4
ABIGAIL T GREGOR PSYCH SOC WKR II 114602 PSYCH SOC WKR II 110186
ABRAHAM ROMAN ASSISTANT FIRE CHIEF 282085 ASSISTANT FIRE CHIEF 242650
ABRAXAS K SEALE OFFICE SPECIALIST III 102195 OFFICE SPECIALIST III 102207
ADADU YEMANE ASSOCIATE CIVIL ENGINEER 187277 ASSOCIATE CIVIL ENGINEER 178986

... (1310 rows omitted)

Let's add a column with increase in total pay.


In [59]:
b11_13["Increase"] =b11_13['Total 2013'] - b11_13['Total 2011']

In [60]:
b11_13.sort('Increase', "decr").select('Increase').plot()


On the tails we have people who joined part way through 2011 or left part way through 2013.


In [61]:
b11_13.stats(summary_ops)


Out[61]:
statistic Employee Name Job Title Total 2011 Title 2013 Total 2013 Increase
min AARON E SAGE ACCOUNTANT I 0 ACCOUNTANT I 0 -276596
firstQtile 100220 97441.9 -12927.5
median 128828 125980 -4898.45
mean 136065 134084 -1981.19
thirdQtile 100220 97441.9 -12927.5
max ZOE A PEIRCE WORKERS' COMPENSATION ANALYST 364375 WORKERS' COMPENSATION ANALYST 339018 251371

Well that's interesting. Total compensation seems to have dropped. Did the budget actually go down?


In [62]:
sum2011 = np.sum(berkeley_sal_2011['Total Pay Benefits'])
"${:,}".format(int(sum2011))


Out[62]:
'$194,576,175'

In [63]:
sum2013 = np.sum(berkeley_sal_2013['Total Pay & Benefits'])
"${:,}".format(int(sum2013))


Out[63]:
'$181,102,667'

In [64]:
"${:,}".format(int(sum2013-sum2011))


Out[64]:
'$-13,473,508'

In [65]:
"{:.1%}".format((sum2013-sum2011)/sum2011)


Out[65]:
'-6.9%'

Look at that.


In [66]:
np.sum(berkeley_sal_2011['Overtime Pay'])


Out[66]:
8075636.5499999998

In [67]:
np.sum(berkeley_sal_2013['Overtime Pay'])


Out[67]:
8444424.5299999993

Let's see who got promoted or demoted


In [68]:
b11_13.where(b11_13['Job Title'] != b11_13['Title 2013']).sort('Total 2013', descending=True).show()


Employee Name Job Title Total 2011 Title 2013 Total 2013 Increase
AVERY L WEBB BATTALION CHIEF 262363 DEPUTY FIRE CHIEF 285924 23561.1
GILBERT K DONG DEPUTY FIRE CHIEF 288721 FIRE CHIEF 276889 -11831.1
PAUL A CAVAGNARO FIRE CAPTAIN 235611 BATTALION CHIEF 261926 26314.8
AARON M LEE ASSISTANT FIRE CHIEF 291049 DEPUTY FIRE CHIEF 245273 -45776
FREDERICK S FERRIS RECREATION & YOUTH SVCS MANAGE 190546 DIRECTOR OF PRKS/RECREATION/WF 216606 26060.3
PEGGY J GIBBONS DEPUTY DIRECTOR OF HEALTH 218221 DEPUTY DIRECTOR OF PRKS/REC/WF 211818 -6403.77
MATTHEW W EINSPAHR FIREFIGHTER 173599 FIRE APPARATUS OPERATOR 169536 -4063.1
DAVID A LOPEZ SENIOR BUILDING PLANS EXAMINER 1174.27 ASSIST BUILDING & SAFETY MGR 157577 156402
ROLANDO C VILLAREAL SENIOR ENVIRONMENTAL HEALTH SP 149484 ENVIRONMENTAL HEALTH SUPERVISO 150115 631.47
DENISE L BROWN RECREATION PROGRAM SUPERVISOR 130432 RECREATION & YOUTH SVCS MANAGE 149925 19492.6
DANIELLE K HABR ASSOCIATE MANAGEMENT ANALYST 145932 SENIOR MANAGEMENT ANALYST 147289 1357.12
BEN K KWAN REVENUE DEVELOPMENT SPECIALIST 126519 REVENUE DEVELOPMENT SUPERVISOR 145565 19046.1
ERNEST D JUNG BENEFITS SPECIALIST 130412 ASSOCIATE HUMAN RESOURCES ANAL 139669 9257.14
MATTHEW J MCGINLEY PSYCH SOC WKR II 137679 SENIOR PSYCH SOC WORKER 139161 1482.13
DAVID H MONTES CONCRETE FINISHER 137540 SEWER MAINTENANCE ASST SUPV 135957 -1582.95
JAY C OGDEN REG ENVIRONMENTAL HEALTH SPEC 131094 SENIOR ENVIRONMENTAL HEALTH SP 126631 -4462.48
STACEY S MARSTON ASSISTANT MANAGEMENT ANALYST 124853 ASSOCIATE MANAGEMENT ANALYST 124377 -476.04
DONALD R COLBERT MECHANIC 130687 MECHANIC SUPERVISOR 122686 -8001.39
HERMAN L CLEVELAND SKILLED LABORER 111720 MECHANICAL SWEEPER OPERATOR 111580 -139.8
RON A RESTANI SKILLED LABORER 117048 SEWER MAINTENANCE ASST SUPV 111150 -5898.24
MARICAR C DUPAYA ACCOUNTING OFF SPEC III 108189 ASSISTANT MANAGEMENT ANALYST 107460 -728.3
AARON R BAKER BUILDING MAINTENANCE MECHANIC 115985 BUILDING MAINTENANCE SUPERVISO 106721 -9264.32
DIEGO CHAVEZ LABORER 114633 CONCRETE FINISHER 104683 -9949.3
CHRISTEEN K ONIKI ACCOUNTING OFF SPEC III 97677.2 ASSISTANT MANAGEMENT ANALYST 103478 5800.81
GISELA V GONZALEZ ACCOUNTING OFF SPEC III 112197 ADMINISTRATIVE ASSISTANT 97402.3 -14794.7
JOSEPH E ESPINO CONSTRUCTION EQUIPMENT OPERATO 97496.9 LABORER 93630.1 -3866.79
RAYMOND F WESTPHAL OFFICE SPECIALIST II 93637.8 ACCOUNTING OFF SPEC III 90532.9 -3104.9
TESSA RUDNICK INFORMATION SYSTEMS SUPPORT TE 163.94 APPLICATIONS PROG/ANA I 82723.5 82559.6
GERALDINE A CARRANZA OFFICE SPECIALIST II 93896.8 ACCOUNTING OFF SPEC III 70210 -23686.8
TERRY J GUNDERSON OCCUPATIONAL HEALTH & SAFETY C 2867.25 OCCUPATIONAL HEALTH & SAFETY O 24823 21955.7
ALLYSON S NAKAYAMA COMMUNITY SERVICE OFFICER 124682 PSYCH SOC WKR II 9767.53 -114914

In [69]:
b11_13.where(b11_13['Job Title'] == b11_13['Title 2013']).sort('Increase', descending=True).show()


Employee Name Job Title Total 2011 Title 2013 Total 2013 Increase
ERIC A ANGSTADT DIRECTOR OF PLANNING 3048.89 DIRECTOR OF PLANNING 254419 251371
PHILLIP L HARRINGTON DEPUTY DIRECTOR OF PUBLIC WORK 2802.78 DEPUTY DIRECTOR OF PUBLIC WORK 205655 202853
TIMOTHY GARDNER POLICE OFFICER 5599.34 POLICE OFFICER 204043 198443
MATTHEW J VALLE POLICE OFFICER 3692.92 POLICE OFFICER 199297 195604
CHRISTOPHER M SCOTT POLICE OFFICER 5623.11 POLICE OFFICER 193510 187887
PAUL J TILLBERG POLICE OFFICER 1547.85 POLICE OFFICER 186427 184879
MICHAEL V STEFANAC FIREFIGHTER 604 FIREFIGHTER 177802 177198
MICHAEL R DRAGOVICH FIREFIGHTER 2652.51 FIREFIGHTER 173269 170616
DEJUAN M TURNER FIREFIGHTER 2825.54 FIREFIGHTER 170019 167193
C ESSEX Q COMBONG POLICE OFFICER 1515.6 POLICE OFFICER 167087 165572
JEREMY R SNYDER POLICE OFFICER 1258.91 POLICE OFFICER 165875 164616
RAVEN RECORD FIREFIGHTER 2651.1 FIREFIGHTER 167244 164593
DEREK M RADEY POLICE OFFICER 2889.32 POLICE OFFICER 164621 161731
SHANA J AMENAGHAWON ADMIN & FISCAL SVS MGR 391.74 ADMIN & FISCAL SVS MGR 162101 161710
ARON D BELVEAL POLICE OFFICER 2909.95 POLICE OFFICER 164575 161665
TERRY M BLOUNT PRINCIPAL PLANNER 3249.93 PRINCIPAL PLANNER 164790 161540
NEIL J EGBERT PUBLIC SAFETY DISPATCHER II 740.02 PUBLIC SAFETY DISPATCHER II 161406 160666
LEVON THAXTON II FIREFIGHTER 2651.1 FIREFIGHTER 159667 157016
ANDRES BEJARANO POLICE OFFICER 13615.1 POLICE OFFICER 169914 156298
LUCINDA K SIMPSON POLICE REVIEW COMMISSION OFFIC 1249.08 POLICE REVIEW COMMISSION OFFIC 156796 155547
EVAN T LANE FIREFIGHTER 2644.2 FIREFIGHTER 158056 155412
EVAN J THATCHER FIREFIGHTER 479.5 FIREFIGHTER 155075 154595
JULIAN H CHRISTY FIREFIGHTER 2652.51 FIREFIGHTER 155457 152804
NICHOLAS LAM FIREFIGHTER 2652.51 FIREFIGHTER 154534 151882
RICHARD J FISCHER FIREFIGHTER 479.5 FIREFIGHTER 151881 151401
NIDAL K MUSTAFA KANAAN FIREFIGHTER 2651.1 FIREFIGHTER 153987 151336
DEREK C POWELL FIREFIGHTER 479.5 FIREFIGHTER 147496 147016
MELANIE L JONES ADMIN & FISCAL SVS MGR 89.05 ADMIN & FISCAL SVS MGR 146441 146352
JASON A MUNIZ POLICE OFFICER 13635.7 POLICE OFFICER 159290 145655
OWEN P SIMS FIREFIGHTER 2651.1 FIREFIGHTER 147908 145257
WILLA NG PRINCIPAL PLANNER 1435.54 PRINCIPAL PLANNER 142050 140615
RONALD V RANADA ASSISTANT CIVIL ENGINEER (REG) 2550.04 ASSISTANT CIVIL ENGINEER (REG) 141032 138482
KARL A BUSCHE HAZARDOUS MAT SP II 1997.31 HAZARDOUS MAT SP II 136959 134962
ANWAN D BAKER SUPERVISING LIBRARIAN 302.58 SUPERVISING LIBRARIAN 133629 133327
SARAH DENTAN LIBRARY SERVICES MANAGER 32219.8 LIBRARY SERVICES MANAGER 164397 132177
HAYDEN HSU ASSOCIATE MANAGEMENT ANALYST 635.24 ASSOCIATE MANAGEMENT ANALYST 129776 129141
MEGAN L SCHAEFER POLICE OFFICER 648.98 POLICE OFFICER 128918 128269
ROBERT S HERRERA III WELDER MECHANIC 587.86 WELDER MECHANIC 127292 126704
MIGUEL O SALAZAR POLICE OFFICER 62849.5 POLICE OFFICER 189220 126370
MATTHEW C TANNER CHIEF OF PARTY 970.96 CHIEF OF PARTY 126226 125255
JAMIE D PERKINS POLICE OFFICER 82984.4 POLICE OFFICER 206575 123590
CHRISTOPHER G INAMI POLICE OFFICER 3800.9 POLICE OFFICER 125717 121916
JAYLON K DE BRUIN POLICE OFFICER 648.98 POLICE OFFICER 120266 119617
AMANDA L MYERS SUPERVISING LIBRARIAN 41.31 SUPERVISING LIBRARIAN 117391 117350
VICTOR N PINTO CORREIA PARKING ENFORCEMENT MANAGER 827.41 PARKING ENFORCEMENT MANAGER 118002 117175
JAMIE N LUCERO POLICE OFFICER 44978.2 POLICE OFFICER 162124 117146
ANGELA M BETTI PSYCH SOC WKR II 824.31 PSYCH SOC WKR II 116451 115626
MECOLE L TATE HUMAN RESOURCES TECHNICIAN 751.75 HUMAN RESOURCES TECHNICIAN 115402 114650
JUAN C PEREZ POLICE OFFICER 648.98 POLICE OFFICER 111127 110478
COLLEEN D ANDREETTA ENGINEERING INSPECTOR 2325.44 ENGINEERING INSPECTOR 109814 107488
ZHONG TAN TRAFFIC ENGINEERING ASSISTANT 794.43 TRAFFIC ENGINEERING ASSISTANT 107817 107023
GREGORY E BROVOLD BUILDING INSPECTOR II (CERT) 45071.9 BUILDING INSPECTOR II (CERT) 150316 105244
JEREMIAH D LOSER FIREFIGHTER 2630.24 FIREFIGHTER 107582 104952
IAN F KESTERSON FORESTRY CLIMBER 400.58 FORESTRY CLIMBER 103803 103402
ERIN E NETZ PUBLIC SAFETY DISPATCHER II 57570.5 PUBLIC SAFETY DISPATCHER II 154902 97332
PALOMAR SANCHEZ COMMUNITY SERVS SP I 957.7 COMMUNITY SERVS SP I 95173.9 94216.2
SHANITRA N ROAN PERMIT SPECIALIST 373.88 PERMIT SPECIALIST 93053.4 92679.6
SALLY C NOTTHOFF-ZARNOWI SENIOR PLANNER 11822 SENIOR PLANNER 97605.9 85783.9
GREGORY F MICHALCZYK POLICE OFFICER 68853.4 POLICE OFFICER 150723 81869.7
GRACE Y ENG RECORDS ASSISTANT 543.58 RECORDS ASSISTANT 81601.5 81057.9
ANDREW J FRANKEL POLICE OFFICER 135118 POLICE OFFICER 211069 75950.6
KRISTIN K HUNZIKER LEGISLATIVE ASSISTANT 662.28 LEGISLATIVE ASSISTANT 75164.7 74502.5
VLAD A KAPLUN INFORMATION SYSTEMS SUPPORT TE 18272.1 INFORMATION SYSTEMS SUPPORT TE 90566 72293.9
TOMAS FLORES ASSISTANT RECREATION COORDINAT 7429.16 ASSISTANT RECREATION COORDINAT 77902.3 70473.1
SARAH C LANA EMERGENCY SERVICES COORDINATOR 58448.7 EMERGENCY SERVICES COORDINATOR 126977 68528.8
BRIAN H KELLY FIREFIGHTER 3315.79 FIREFIGHTER 65644.9 62329.1
JEFFREY A CHU POLICE SERGEANT 221991 POLICE SERGEANT 283796 61805.4
JANET P DIERSEN PARKING ENFORCEMENT OFFICER 36784.2 PARKING ENFORCEMENT OFFICER 96219.7 59435.5
LEE V ERBY COMMUNITY SERVICE OFFICER 133737 COMMUNITY SERVICE OFFICER 191353 57616.7
SANDRA F PHILLIPS COMMUNITY SERVICE OFFICER 162806 COMMUNITY SERVICE OFFICER 212997 50190.5
CARDELLA PREE OFFICE SPECIALIST II 31009.1 OFFICE SPECIALIST II 80277.3 49268.2
JOY K HAN SENIOR SERVICE ASSISTANT 24420.8 SENIOR SERVICE ASSISTANT 73396 48975.1
HARRIET M RICHARDSON AUDIT MANAGER 128844 AUDIT MANAGER 177554 48709.2
JOHNNY P BOWIE FIREFIGHTER 125702 FIREFIGHTER 174053 48350.6
VALERIE D ROBINSON RECREATION ACTIVITY LEADER 66454.9 RECREATION ACTIVITY LEADER 113307 46851.7
RACHEL D VALENZUELA PARAMEDIC SUPERVISOR I 146359 PARAMEDIC SUPERVISOR I 192632 46273.5
GABRIELA P FERNANDEZ LIBRARY ASSISTANT 15.14 LIBRARY ASSISTANT 46251.3 46236.2
JEFFREY F JOHNS PSYCHIATRIST SUPERVISOR 215083 PSYCHIATRIST SUPERVISOR 259502 44419.1
CHANEE N FRANKLIN STAFF ATTORNEY I 98743.9 STAFF ATTORNEY I 142791 44046.6
MARGARITA ZAMORA ESMAILI SENIOR HUMAN RESOURCES ANALYST 127114 SENIOR HUMAN RESOURCES ANALYST 170715 43601.4
DAMON M BROWN FIREFIGHTER 171391 FIREFIGHTER 214267 42876.4
JANET M DONG ACCOUNTING OFF SPEC III 70746 ACCOUNTING OFF SPEC III 111179 40433.3
ZARINA S KHAN LIBRARY SPECIALIST II 53091.1 LIBRARY SPECIALIST II 93351 40259.9
MOYSES C GARCIA FIREFIGHTER 131970 FIREFIGHTER 170344 38373.9
DEBORAH Y CARTON LIBRARIAN II 81751 LIBRARIAN II 118338 36587
MELISSA L ROMAN ASSISTANT RECREATION COORDINAT 35.49 ASSISTANT RECREATION COORDINAT 36482.4 36447
HENRYANNE BROWN COMMUNITY SERVICE OFFICER SUPV 183731 COMMUNITY SERVICE OFFICER SUPV 219757 36026.3
MARK L NUMAINVILLE CITY CLERK 172557 CITY CLERK 206335 33777.8
MICHAEL JOH S CRICKMORE FIREFIGHTER 129459 FIREFIGHTER 163224 33765.3
MARIANNE DAVIS MENTAL HEALTH CLINICAL SUPV 121038 MENTAL HEALTH CLINICAL SUPV 154575 33537.7
BRENDA LOGAN COMMUNITY SERVICE OFFICER 156875 COMMUNITY SERVICE OFFICER 189461 32586.8
LEAH R SALOMON FIREFIGHTER 125578 FIREFIGHTER 158139 32560.9
MICHAEL S SULLIVAN FIRE APPARATUS OPERATOR 201529 FIRE APPARATUS OPERATOR 233639 32110
AIMEE B MUELLER ADMINISTRATIVE STAFF ASSISTANT 68444.6 ADMINISTRATIVE STAFF ASSISTANT 100450 32005.6
WILLIAM J NEWSON SPORTS OFFICIAL 59590.5 SPORTS OFFICIAL 91113.9 31523.4
MICHELLE E DETRICK FIREFIGHTER 126753 FIREFIGHTER 158086 31332.8
WAYNE A MUNSON SPORTS OFFICIAL 67427 SPORTS OFFICIAL 97852.8 30425.8
ASHLEY A GOERGEN POLICE OFFICER 2233.38 POLICE OFFICER 32377.4 30144
AMBER M RAYON-JUSTIN OFFICE SPECIALIST II 44914.6 OFFICE SPECIALIST II 74927.2 30012.7
PATTHAMAVAD SINNANG LIBRARY AIDE 0 LIBRARY AIDE 29941.7 29941.7
TAMARA Y LOPES PUBLIC SAFETY DISPATCHER II 118395 PUBLIC SAFETY DISPATCHER II 148085 29690.1
KATHLEEN M LESLIE PSYCH SOC WKR II 90028.4 PSYCH SOC WKR II 119675 29646.5
PETER J HONG POLICE SERGEANT 305990 POLICE SERGEANT 335634 29644
DEBRA A GONZALEZ ADMINISTRATIVE SECRETARY 77146 ADMINISTRATIVE SECRETARY 106722 29575.6
NATHAN PATRICK POLICE OFFICER 173847 POLICE OFFICER 203406 29559.1
SARAH M REYNOSO ASSISTANT CITY ATTORNEY 199986 ASSISTANT CITY ATTORNEY 229347 29361.3
JENNIFER A LOUIS POLICE SERGEANT 277747 POLICE SERGEANT 306741 28994.1
TANYA A MOORE COMMUNITY SERVS SP III 130003 COMMUNITY SERVS SP III 158960 28957.3
DON L BROWN DISABILITY SERVICES SPECIALIST 91929.5 DISABILITY SERVICES SPECIALIST 120769 28839.3
PATRICIA I SUBIA COMMUNITY SERVICE OFFICER 101263 COMMUNITY SERVICE OFFICER 129842 28578.8
FRANCIS X LANDRUM POLICE SERGEANT 235869 POLICE SERGEANT 264335 28466.9
TYRONE J MCCLAIN PUBLIC SAFETY DISPATCHER II 190756 PUBLIC SAFETY DISPATCHER II 218506 27749.3
LEON MCDANIELS JR COMMUNITY SERVICE OFFICER 112439 COMMUNITY SERVICE OFFICER 139872 27432.8
KEVIN VANDER ENDE FIRE APPARATUS OPERATOR 203779 FIRE APPARATUS OPERATOR 231062 27282.4
ZOE A PEIRCE FIREFIGHTER 123831 FIREFIGHTER 151007 27175.9
STEPHEN A JONES SEWER MAINTENANCE ASST SUPV 120158 SEWER MAINTENANCE ASST SUPV 147146 26988.2
ROSEANN C THOMSEN DEPUTY CITY CLERK 134797 DEPUTY CITY CLERK 160578 25780.9
LILIA A FLORES LIBRARY ASSISTANT 22552.7 LIBRARY ASSISTANT 48159.2 25606.5
ANGEL MUNOZ INFORMATION SYSTEMS SPECIALIST 101489 INFORMATION SYSTEMS SPECIALIST 127006 25517.7
LAWRENCE J MORRIS LIBRARY SPECIALIST II 70858.2 LIBRARY SPECIALIST II 95728 24869.8
JOSEPH R LEDOUX POLICE OFFICER 218515 POLICE OFFICER 243257 24742.6
FERNANDO R LAVIN SENIOR SYSTEMS ANALYST 144912 SENIOR SYSTEMS ANALYST 168993 24080.5
PETER LEE POLICE OFFICER 221990 POLICE OFFICER 245497 23507.4
JUAN DELEON LIBRARY ASSISTANT 52508.1 LIBRARY ASSISTANT 75826.8 23318.7
NILS P MOE ASSISTANT TO THE MAYOR 109527 ASSISTANT TO THE MAYOR 132464 22937.1
JUAN R CASTILLE LIBRARY ASSISTANT 49588 LIBRARY ASSISTANT 72422.1 22834
ANDREA L TALLEY MANAGER OF AGING SERVICES 129797 MANAGER OF AGING SERVICES 152491 22693.5
MARY C KUSMISS POLICE SERGEANT 242476 POLICE SERGEANT 265092 22615.7
REBECCA RODRIGUEZ COMMUNITY HLTH WRKR SPECIALIST 70138.1 COMMUNITY HLTH WRKR SPECIALIST 92665.9 22527.8
FRANCISCO L MUNIZ SOLID WASTE WORKER 137958 SOLID WASTE WORKER 159732 21774.5
SABEEN KHAN LIBRARY AIDE 27606.5 LIBRARY AIDE 48927.5 21321.1
ISOBEL M SCHNEIDER LIBRARIAN II 95468.7 LIBRARIAN II 116732 21262.9
CANITHA WALKER LIBRARY AIDE 27695.3 LIBRARY AIDE 48128.2 20432.9
CARMEN M ROBINSON PUBLIC SAFETY DISPATCHER II 116790 PUBLIC SAFETY DISPATCHER II 136958 20168
GARY L ALPERT LIBRARY SPECIALIST I 77112.1 LIBRARY SPECIALIST I 97005.6 19893.5
KELLY D WALLACE DEPUTY DIR/HLTH, HSG & COM SER 186844 DEPUTY DIR/HLTH, HSG & COM SER 206688 19844
SHAN W JOHNSON POLICE OFFICER 223279 POLICE OFFICER 243038 19759.1
JASON M COLLIER POLICE OFFICER 165158 POLICE OFFICER 184862 19704.4
LEO M LOPEZ LIBRARY AIDE 24300.8 LIBRARY AIDE 43926.9 19626
CHRISTOPHER S FLORES POLICE OFFICER 184508 POLICE OFFICER 203328 18819.9
SYLVESTER GOOSBY SENIOR GROUNDSKEEPER 91161.1 SENIOR GROUNDSKEEPER 109914 18752.6
TAHIRA WARNER OFFICE SPECIALIST II 60973.8 OFFICE SPECIALIST II 79665.8 18692
FLORENCE BLACKMON PARKING ENFORCEMENT OFFICER 95395.3 PARKING ENFORCEMENT OFFICER 113421 18026.1
JUDITH K APPEL SCHOOL BOARD DIRECTOR 0 SCHOOL BOARD DIRECTOR 18000.1 18000.1
MIA K TEXTOR RECREATION ACTIVITY LEADER 44762.4 RECREATION ACTIVITY LEADER 62227 17464.6
JOHNNY L SHELTON SOLID WASTE WORKER 140924 SOLID WASTE WORKER 158330 17405.9
JOSEPH JOINTER SOLID WASTE WORKER 108162 SOLID WASTE WORKER 125163 17000.4
COREY M BOLD POLICE OFFICER 192973 POLICE OFFICER 209603 16629.7
CALVIN W FONG ASSISTANT TO THE MAYOR 138952 ASSISTANT TO THE MAYOR 155472 16519.2
CLAUDETTE R BIEMERET SENIOR AUDITOR 122515 SENIOR AUDITOR 139011 16496.1
NORLINH S STUBBS INFORMATION SYSTEMS SPECIALIST 111266 INFORMATION SYSTEMS SPECIALIST 127692 16426
SAULO VILLATORO SENIOR SERVICE ASSISTANT 83700.3 SENIOR SERVICE ASSISTANT 100100 16399.6
THANH V THAI APPLICATIONS PROG/ANA I 106928 APPLICATIONS PROG/ANA I 122911 15983.7
STEVEN B MESSINGER SENIOR BUILDING INSPECTOR 140090 SENIOR BUILDING INSPECTOR 155960 15870.1
RAECHELL T CARR SOLID WASTE WORKER 114172 SOLID WASTE WORKER 129994 15822.4
KIMBERLY A REEVE SUPERVISING PUBLIC SAFETY DISP 172649 SUPERVISING PUBLIC SAFETY DISP 188451 15802.1
CHRISTINE S DANIEL CITY MANAGER 286020 CITY MANAGER 301802 15781.5
KIMBERLY J LEMAY RECREATION COORDINATOR 101477 RECREATION COORDINATOR 117145 15668.4
EDUARDO J TAN PUBLIC SAFETY DISPATCHER II 152645 PUBLIC SAFETY DISPATCHER II 168189 15543.1
JAMI M NAPIER RECORDS MANAGER 139498 RECORDS MANAGER 154913 15415.1
CHRISTOPHER L CALHOUN COMMUNITY SERVICE OFFICER 108264 COMMUNITY SERVICE OFFICER 122968 14703.3
JUDY J HUNT RENT BOARD COMMISSIONER 0 RENT BOARD COMMISSIONER 14362.7 14362.7
TERESA L VARGAS ACCOUNTING OFF SPEC III 102012 ACCOUNTING OFF SPEC III 116131 14119
PAMELA J MEYER SENIOR COMMUNITY HEALTH SPECIA 90427.1 SENIOR COMMUNITY HEALTH SPECIA 104491 14063.6
YVETTE KATUALA MENTAL HEALTH PROGRAM SUPERVIS 150035 MENTAL HEALTH PROGRAM SUPERVIS 163724 13688.8
CLEVON G BOATMAN PUBLIC SAFETY DISPATCHER II 145200 PUBLIC SAFETY DISPATCHER II 158303 13102.6
DANNY J WALKER SOLID WASTE TRUCK DRIVER 129761 SOLID WASTE TRUCK DRIVER 142813 13051.8
MARY MAGDAL K MATAMBANADZO OFFICE SPECIALIST II 36648.8 OFFICE SPECIALIST II 49571.4 12922.5
JONATHAN C ESMENJAUD LIBRARY ASSISTANT 25887.1 LIBRARY ASSISTANT 38785.2 12898.2
SAM K LAW FIRE AND LIFE-SAFETY PLANS EXA 178179 FIRE AND LIFE-SAFETY PLANS EXA 190940 12761.2
KATHERINE L BROWN HEALTH SERVICES PROGRAM SPECIA 110178 HEALTH SERVICES PROGRAM SPECIA 122776 12597.8
KEVIN W KLEPPE POLICE OFFICER 174827 POLICE OFFICER 187412 12585
DAVID A LINDENAU POLICE SERGEANT 282770 POLICE SERGEANT 295209 12438.5
PRIMITIVO SUAREZ-WOLFE ASSISTANT ARCHITECT 155441 ASSISTANT ARCHITECT 167671 12230.6
RAYLENE EZIKE LIBRARY ASSISTANT 43156.1 LIBRARY ASSISTANT 55267.1 12110.9
RAYNA T JOHNSON SUPERVISING PUBLIC SAFETY DISP 157238 SUPERVISING PUBLIC SAFETY DISP 169275 12037.5
JOHN BAUR LIBRARIAN II 104235 LIBRARIAN II 116202 11967.3
DAYNA K HOLZ LIBRARIAN II 111213 LIBRARIAN II 123008 11795.1
ANDREA M MULLARKEY SENIOR LIBRARIAN 106428 SENIOR LIBRARIAN 117949 11520.8
JOSHUA M SMITH POLICE OFFICER 175515 POLICE OFFICER 187023 11507.7
KHA R SOK LIBRARY AIDE 27815.3 LIBRARY AIDE 39285 11469.7
DANA A WESTMORELAND SENIOR INFORMATION SYSTEMS SPE 131023 SENIOR INFORMATION SYSTEMS SPE 142492 11468.5
ARMIN R ARETHNA LIBRARIAN II 112105 LIBRARIAN II 123458 11353.5
SAMUEL R WILEY LANDSCAPE GARDENER SUPERVISOR 136517 LANDSCAPE GARDENER SUPERVISOR 147848 11330.9
JANE M MICALLEF DIRECTOR/HLTH, HSG & COMM SERV 222253 DIRECTOR/HLTH, HSG & COMM SERV 233488 11234.8
ARNOLD ZERMENO SEWER MAINTENANCE ASST SUPV 128653 SEWER MAINTENANCE ASST SUPV 139855 11202.2
JOSEPH O AYANKOYA SENIOR SOLID WASTE SUPERVISOR 182822 SENIOR SOLID WASTE SUPERVISOR 194016 11194.6
GREG L POWELL SENIOR PLANNER 143450 SENIOR PLANNER 154625 11174.3
JAMES E EDWARDS RECREATION ACTIVITY LEADER 68082.2 RECREATION ACTIVITY LEADER 79121.9 11039.7
AMBER M DAVIS COMMUNITY HLTH WRKR SPECIALIST 82790.4 COMMUNITY HLTH WRKR SPECIALIST 93627.7 10837.3
LYNNE S BOURGAULT DEPUTY CITY ATTY III 210121 DEPUTY CITY ATTY III 220864 10743.1
STEPHEN T BURCHAM POLICE OFFICER 230474 POLICE OFFICER 241108 10634.1
CECELIA BOOKER ACCOUNTING OFF SPEC SUPERV 123226 ACCOUNTING OFF SPEC SUPERV 133836 10610.1
VIRGINIA N COOKE OFFICE SPECIALIST II 73601.2 OFFICE SPECIALIST II 84178.8 10577.6
DAVID E ABEL HUMAN RESOURCES MANAGER 193521 HUMAN RESOURCES MANAGER 203853 10331.9
JAMES F THOMPSON FIRE PREVENTION INSPECTOR 127211 FIRE PREVENTION INSPECTOR 137324 10112.9
SARAH L MURRAY PUBLIC SAFETY DISPATCHER II 137078 PUBLIC SAFETY DISPATCHER II 147070 9992.63
HENRY OYEKANMI GENERAL SERVICES MANAGER 166490 GENERAL SERVICES MANAGER 176261 9770.93
RAQUEL P MOLINA ASSOCIATE MANAGEMENT ANALYST 105731 ASSOCIATE MANAGEMENT ANALYST 115252 9520.38
GUILLERMO A CAMPOS OFFICE SPECIALIST II 91936.6 OFFICE SPECIALIST II 101356 9419.46
MATTHEW J SIEGEL STAFF ATTORNEY I 127955 STAFF ATTORNEY I 137336 9381.43
IVAN L LAPIDUS SENIOR SYSTEMS ANALYST 148195 SENIOR SYSTEMS ANALYST 157557 9361.93
BERNARDINO M BRICENO LANDSCAPE GARDENER 99840.9 LANDSCAPE GARDENER 109024 9183.39
YOLANDA F NASSERIPOURTOWSI COMMUNITY SERVS SP I 93591.3 COMMUNITY SERVS SP I 102691 9099.37
ETHELL L WILSON POLICE OFFICER 219699 POLICE OFFICER 228772 9073.2
JUAN S BARBOZA FIREFIGHTER 196895 FIREFIGHTER 205801 8905.61
SEAN M MOLLER PSYCH SOC WKR II 126522 PSYCH SOC WKR II 135372 8850.53
SHARON R THYGESEN INFORMATION SYSTEMS MANAGER 177369 INFORMATION SYSTEMS MANAGER 186149 8780.22
WILLIAM A ROGERS DEPUTY CITY MANAGER 245152 DEPUTY CITY MANAGER 253763 8610.88
LA VERTTA R SHERMAN SUPERVISING PUBLIC SAFETY DISP 165349 SUPERVISING PUBLIC SAFETY DISP 173870 8520.73
DENNIS E FOLEY FIRE LIEUTENANT 207004 FIRE LIEUTENANT 215516 8512.5
AMY Y LEE APPLICATIONS PROG/ANA II 134900 APPLICATIONS PROG/ANA II 143393 8492.63
CARMEN PEREZ RECREATION ACTIVITY LEADER 83369.5 RECREATION ACTIVITY LEADER 91833.8 8464.3
DIANE L HAYES ASSOCIATE MANAGEMENT ANALYST 117764 ASSOCIATE MANAGEMENT ANALYST 126035 8271.36
MORGAN L JACOBS-LANGLOIS FIREFIGHTER 183427 FIREFIGHTER 191525 8098.77
KHIN N CHIN ASSOCIATE MANAGEMENT ANALYST 148840 ASSOCIATE MANAGEMENT ANALYST 156922 8082.22
VICTORIA A LOPEZ PUBLIC HEALTH NURSE 133964 PUBLIC HEALTH NURSE 142040 8075.58
ANGELA M MCGOWEN LIBRARY SPECIALIST II 68519 LIBRARY SPECIALIST II 76531.1 8012.11
JUDITH A IZZO MENTAL HEALTH CLINICAL SUPV 142172 MENTAL HEALTH CLINICAL SUPV 150150 7977.33
HEATHER M MURPHY REVENUE COLLECTION MANAGER 151456 REVENUE COLLECTION MANAGER 159396 7939.99
PAUL V KAUSHAL ASSISTANT CIVIL ENGINEER (REG) 157334 ASSISTANT CIVIL ENGINEER (REG) 165166 7831.7
MELANIE E BEASLEY OFFICE SPECIALIST II 87274 OFFICE SPECIALIST II 95087.1 7813.08
ISABEL CARRASCO OFFICE SPECIALIST III 100278 OFFICE SPECIALIST III 108044 7765.48
PATRICIA A DALY OFFICE SPECIALIST II 79602.7 OFFICE SPECIALIST II 87262.2 7659.51
ANN A DEL ROSARIO AUDITOR II 119995 AUDITOR II 127599 7603.76
BE T TRAN ASSOCIATE PLANNER 127618 ASSOCIATE PLANNER 135204 7585.66
RICKY B JACKSON SOLID WASTE TRUCK DRIVER 142104 SOLID WASTE TRUCK DRIVER 149621 7517.01
ERNESTO RODRIGUEZ SENIOR SYSTEMS ANALYST 165915 SENIOR SYSTEMS ANALYST 173349 7433.77
NICOLAS C ROMERO FIREFIGHTER 169775 FIREFIGHTER 177179 7403.96
AMY H KUO LIBRARIAN II 81300.4 LIBRARIAN II 88280.6 6980.11
KRISTY L VAN HERICK DEPUTY CITY ATTY III 204678 DEPUTY CITY ATTY III 211468 6789.62
JENNIFER S COGLEY COMMUNITY SERVS SP III 127091 COMMUNITY SERVS SP III 133880 6788.1
KEVIN D HOUSTON PUBLIC SAFETY DISPATCHER II 151777 PUBLIC SAFETY DISPATCHER II 158547 6769.27
ALLISON M PRETTO ASSOCIATE MANAGEMENT ANALYST 70594 ASSOCIATE MANAGEMENT ANALYST 77265.9 6671.86
ALEJANDRO SOTO-VIGIL LEGISLATIVE ASSISTANT 92128.4 LEGISLATIVE ASSISTANT 98790.3 6661.87
ROGER E RUSHING SENIOR BUILDING INSPECTOR 156158 SENIOR BUILDING INSPECTOR 162735 6577.01
SUZANNE RIDEL HEALTH SERVICES PROGRAM SPECIA 111116 HEALTH SERVICES PROGRAM SPECIA 117617 6500.16
MARCUS A JACKSON LABORER 108832 LABORER 115322 6490.29
PAMELA N GRAY LEGISLATIVE ASSISTANT 18416.6 LEGISLATIVE ASSISTANT 24887.9 6471.32
JOHN R HERSHBERGER BUILDING INSPECTOR II (CERT) 141216 BUILDING INSPECTOR II (CERT) 147569 6352.92
DANIEL R GREEN FIRE LIEUTENANT 215644 FIRE LIEUTENANT 221988 6343.84
PATRICIA A THOMAS COMMUNITY SERVS SP II 125420 COMMUNITY SERVS SP II 131546 6125.76
VERNON J BRIGGS OFFICE SPECIALIST III 89745.4 OFFICE SPECIALIST III 95869.6 6124.14
MARK L SOMONTAN FIRE APPARATUS OPERATOR 233987 FIRE APPARATUS OPERATOR 240001 6014.12
BRADLEY H RUDOLPH BUILDING INSPECTOR II (CERT) 138841 BUILDING INSPECTOR II (CERT) 144833 5992.66
CORINNA T BURRELL LIBRARY AIDE 29222.9 LIBRARY AIDE 35159.3 5936.45
JOANNA K RUDY LEGAL OFFICE SUPERVISOR 119237 LEGAL OFFICE SUPERVISOR 125098 5861.28
DEVIN L HOGAN POLICE OFFICER 174924 POLICE OFFICER 180735 5811.59
ASA G DODSWORTH RENT BOARD COMMISSIONER 13995.5 RENT BOARD COMMISSIONER 19754.5 5758.95
ROSARIO M RICHE REVENUE COLLECTION MANAGER 167255 REVENUE COLLECTION MANAGER 172974 5719.02
ANDRES PEREZ SKILLED LABORER 106492 SKILLED LABORER 112122 5630.31
MONI T LAW COMMUNITY SERVS SP II 134928 COMMUNITY SERVS SP II 140341 5412.97
NANCY K NJISSANG MENTAL HEALTH PROGRAM SUPERVIS 147975 MENTAL HEALTH PROGRAM SUPERVIS 153365 5389.81
SAMUEL E SHIELDS LIBRARY AIDE 35739.8 LIBRARY AIDE 41032.6 5292.82
ASHANTI R PRESLEY LIBRARY ASSISTANT 47516.3 LIBRARY ASSISTANT 52772.2 5255.88
ALEXANDER ROSHAL BUILDING AND SAFETY MANAGER 197540 BUILDING AND SAFETY MANAGER 202766 5226.1
PATRICK EMMONS SUPERVISING BUILDING INSPECTOR 164945 SUPERVISING BUILDING INSPECTOR 169891 4945.43
MATTHEW T MCGEE POLICE OFFICER 190840 POLICE OFFICER 195775 4935.02
AARON E SAGE SENIOR PLANNER 153752 SENIOR PLANNER 158669 4916.94
ELIZABETH R GREENE SENIOR PLANNER 137102 SENIOR PLANNER 141889 4786.91
RORY A DEAN-EVANS OFFICE SPECIALIST III 85902.1 OFFICE SPECIALIST III 90544.9 4642.87
AARON T LOWE CUST SERVS SPEC III 88239.9 CUST SERVS SPEC III 92845 4605.14
SHARON R SMOTHERS ACCOUNTING OFF SPEC III 115458 ACCOUNTING OFF SPEC III 120062 4604.28
JOEL ESPINOSA-GONZAL SKILLED LABORER 122330 SKILLED LABORER 126897 4566.93
ESTHER M CORNELIUS ACCOUNTING OFF SPEC III 99117.2 ACCOUNTING OFF SPEC III 103549 4431.79
THOMAS N WILLIAMS ANIMAL SERVICES ASSISTANT 90897.4 ANIMAL SERVICES ASSISTANT 95309.7 4412.24
APASJAMIA L FIGUEROA PUBLIC SAFETY DISPATCHER II 138409 PUBLIC SAFETY DISPATCHER II 142754 4344.95
ELEANOR G LEARD BUILDING INSPECTOR II 143506 BUILDING INSPECTOR II 147801 4295.15
VERONICA A RODRIGUES POLICE OFFICER 234004 POLICE OFFICER 238165 4161.49
EMMA COLEMAN LIBRARIAN II 66521.1 LIBRARIAN II 70537.1 4016.03
REBECCA L WEBB CUST SERVS SPEC III 92838.5 CUST SERVS SPEC III 96774.6 3936.08
RIGOBERTO MARQUEZ LABORER 96201.3 LABORER 100111 3910.08
DOROTHY M FISHER PUBLIC SAFETY DISPATCHER II 183767 PUBLIC SAFETY DISPATCHER II 187599 3831.8
SANDRA F BAILES HOUSING INSPECTOR 129600 HOUSING INSPECTOR 133273 3673.07
TASHA N TERVALON HEALTH SERVICES SUPERVISOR 159297 HEALTH SERVICES SUPERVISOR 162958 3660.44
PETE J ZAVATTERO SOLID WASTE WORKER 102807 SOLID WASTE WORKER 106418 3611.51
STEVEN D RIGGS DEPUTY FIRE MARSHAL 195017 DEPUTY FIRE MARSHAL 198608 3590.66
KRISTEN S LEE COMMUNITY SERVS SP III 159091 COMMUNITY SERVS SP III 162592 3500.48
TONY F ENTES PUBLIC WORKS SUPERVISOR 155951 PUBLIC WORKS SUPERVISOR 159445 3494.78
MARCELA S SABIN COMMUNITY HLTH WRKR SPECIALIST 86871.9 COMMUNITY HLTH WRKR SPECIALIST 90362.5 3490.61
SUSAN M FERRERA PARKS SUPERINTENDENT 168652 PARKS SUPERINTENDENT 172142 3490.12
DAVID W MARBLE POLICE OFFICER 243645 POLICE OFFICER 247123 3478.45
JASON B FERGUSON SENIOR INFORMATION SYSTEMS SPE 142994 SENIOR INFORMATION SYSTEMS SPE 146455 3460.79
KATE J CLAYTON HEALTH SERVICES SUPERVISOR 162450 HEALTH SERVICES SUPERVISOR 165887 3437.45
RAENA A FURLOW OFFICE SPECIALIST II 92094.7 OFFICE SPECIALIST II 95509.4 3414.76
CLAUDINE M ASBAGH ASSISTANT PLANNER 105910 ASSISTANT PLANNER 109263 3352.94
JOSEPH MCCARTHY PARAMEDIC SUPERVISOR I 222495 PARAMEDIC SUPERVISOR I 225801 3306.02
AGNES A CELIS ACCOUNTING TECHNICIAN 120740 ACCOUNTING TECHNICIAN 124021 3281.01
ROMEO F HERRERA HOUSING INSPECTOR (CERTIFIED) 141600 HOUSING INSPECTOR (CERTIFIED) 144866 3265.94
OLIVER A BROWN JR PARKING ENFORCEMENT OFFICER 98958.6 PARKING ENFORCEMENT OFFICER 102048 3089.65
TIMOTHY P MAC ISAAC FIRE LIEUTENANT 197337 FIRE LIEUTENANT 200369 3031.92
CORNELIUS A DE SNOO ENERGY PROGRAM MANAGER 104599 ENERGY PROGRAM MANAGER 107626 3027.11
MATTHEW BROWN STAFF ATTORNEY III 211363 STAFF ATTORNEY III 214175 2811.92
TENLI YAVNEH MENTAL HEALTH PROGRAM SUPERVIS 148693 MENTAL HEALTH PROGRAM SUPERVIS 151493 2800.67
DUSTIN F MORILLAS POLICE OFFICER 206010 POLICE OFFICER 208805 2794.82
BYRON NORRIS POLICE REVIEW COMMISSION INVES 132513 POLICE REVIEW COMMISSION INVES 135254 2740.79
KENNETH C PLANTE INFORMATION SYSTEMS SUPPORT TE 102625 INFORMATION SYSTEMS SUPPORT TE 105360 2734.37
CHRIS YAM-S CHU SOLID WASTE WORKER 145608 SOLID WASTE WORKER 148311 2702.82
ANTHONY P CERLETTI POLICE OFFICER 216117 POLICE OFFICER 218707 2589.46
JOHN M GAYTON SOLID WASTE TRUCK DRIVER 166550 SOLID WASTE TRUCK DRIVER 169014 2464.29
AMY M DAVIDSON SENIOR MANAGEMENT ANALYST 146553 SENIOR MANAGEMENT ANALYST 148973 2420.38
OFELIA M VEGA RECREATION ACTIVITY LEADER 55485.3 RECREATION ACTIVITY LEADER 57831.9 2346.58
ANNA M WANKEL FIRE APPARATUS OPERATOR 171661 FIRE APPARATUS OPERATOR 173969 2308
HECTOR G VIVEROS SOLID WASTE WORKER 116855 SOLID WASTE WORKER 119125 2270.35
MARY A LOPEZ OCCUPATIONAL HEALTH/SAFETY SPE 109447 OCCUPATIONAL HEALTH/SAFETY SPE 111700 2253.14
SAMELLA L STOVER OFFICE SPECIALIST II 91036.1 OFFICE SPECIALIST II 93229 2192.88
MARCUS D VELOSO OFFICE SPECIALIST II 82960 OFFICE SPECIALIST II 85066.2 2106.16
VILMA M GARCIA OFFICE SPECIALIST II 94607.5 OFFICE SPECIALIST II 96713.1 2105.55
LARON D ALFORD SKILLED LABORER 131711 SKILLED LABORER 133810 2099.1
JONATHAN E FISCHER FIRE APPARATUS OPERATOR 208643 FIRE APPARATUS OPERATOR 210701 2058.02
JUDITH C IGLEHART ASSISTANT TO THE MAYOR 2745.65 ASSISTANT TO THE MAYOR 4801.95 2056.3
BARBARA M GREGORY SUPERVISING PUBLIC HEALTH NURS 168437 SUPERVISING PUBLIC HEALTH NURS 170386 1948.72
VICTOR E QUILICI FIRE APPARATUS OPERATOR 212245 FIRE APPARATUS OPERATOR 214188 1943.25
JEFFREY S DIEP REG ENVIRONMENTAL HEALTH SPEC 132382 REG ENVIRONMENTAL HEALTH SPEC 134051 1669.03
ANTOINETTE B STETZENMEYER REG ENVIRONMENTAL HEALTH SPEC 129820 REG ENVIRONMENTAL HEALTH SPEC 131474 1653.9
LYNDA A DAILEY MANAGER, FAM HLTH & NRS SERVIC 182700 MANAGER, FAM HLTH & NRS SERVIC 184327 1627.79
ESTELA M ARANDA OFFICE SPECIALIST III 112194 OFFICE SPECIALIST III 113804 1609.87
ROBERT J MARON LANDSCAPE GARDENER SUPERVISOR 114565 LANDSCAPE GARDENER SUPERVISOR 116145 1579.9
JOY K SHIOSHITA SUPERVISING LIBRARIAN 134717 SUPERVISING LIBRARIAN 136289 1572.12
LIOUDMILA V GLAZKOVA DRAFTING TECHNICIAN 104926 DRAFTING TECHNICIAN 106486 1560.41
KEITH K MORIN ASSISTANT MANAGEMENT ANALYST 117685 ASSISTANT MANAGEMENT ANALYST 119219 1533.74
MAYA E WILSON CUSTOMER SERVICES SUPERVISOR 115450 CUSTOMER SERVICES SUPERVISOR 116981 1530.86
CLAUDIA S ALLEN OFFICE SPECIALIST II 88559.7 OFFICE SPECIALIST II 89975.9 1416.21
SETH S JOHAL TRACTOR TRAILER DRIVER 176004 TRACTOR TRAILER DRIVER 177381 1377.09
GEORGE E PACK LABORER 98038.3 LABORER 99415.2 1376.9
LAURA N MCKINNEY DEPUTY CITY ATTY III 190650 DEPUTY CITY ATTY III 192020 1370.23
VALENTINA A EDWARDS SUPERVISING PUBLIC SAFETY DISP 181186 SUPERVISING PUBLIC SAFETY DISP 182495 1309.01
BALBINDER S JOHAL MECHANIC SUPERVISOR 159741 MECHANIC SUPERVISOR 160951 1209.63
JEREMY M ALONZO LIBRARY ASSISTANT 136.76 LIBRARY ASSISTANT 1301.67 1164.91
STEVEN R PARKER PUBLIC SAFETY DISPATCHER II 167700 PUBLIC SAFETY DISPATCHER II 168844 1143.73
TERRENCE A KALAHAR COMMUNITY SERVS SP I 93627.6 COMMUNITY SERVS SP I 94718.8 1091.23
BRIAN K MCGRATH SENIOR INFORMATION SYSTEMS SPE 157848 SENIOR INFORMATION SYSTEMS SPE 158937 1088.81
ARLINDA F BROWN OFFICE SPECIALIST II 92967.9 OFFICE SPECIALIST II 93950.7 982.81
PATRICE L PAUL PUBLIC HEALTH NURSE 124779 PUBLIC HEALTH NURSE 125757 977.56
MARNA R SCHWARTZ COMMUNITY SERVS SP I 63476.6 COMMUNITY SERVS SP I 64410.2 933.59
JULIE A CORKER-SLIVINSKI OFFICE SPECIALIST III 96205.2 OFFICE SPECIALIST III 97108.9 903.71
ROXANA ANDRADE-LIZARZAB ADMINISTRATIVE SECRETARY 115500 ADMINISTRATIVE SECRETARY 116373 873.5
MARIA M GUERRERO COMMUNITY HLTH WRKR SPECIALIST 105407 COMMUNITY HLTH WRKR SPECIALIST 106193 785.94
EVELYN S CHAN ASSOCIATE CIVIL ENGINEER 117629 ASSOCIATE CIVIL ENGINEER 118387 758.16
TAMLYN S BRIGHT ADMINISTRATIVE SECRETARY 107718 ADMINISTRATIVE SECRETARY 108456 737.68
YEWANDE S WEY CUST SERVS SPEC III 91667.5 CUST SERVS SPEC III 92389.7 722.27
LIEF W BURSELL ASSISTANT PLANNER 118305 ASSISTANT PLANNER 118891 586.12
HERIBERTO E DIAZ POLICE OFFICER 199012 POLICE OFFICER 199569 556.45
ALICE M LA PIERRE ASSOCIATE MANAGEMENT ANALYST 137536 ASSOCIATE MANAGEMENT ANALYST 138090 554.56
NGA T TRINH LIBRARY ASSISTANT 54032.5 LIBRARY ASSISTANT 54567.3 534.85
GINSI K BRYANT RECREATION COORDINATOR 95487.7 RECREATION COORDINATOR 95953.8 466.09
AFSANA BLEDSOE PUBLIC SAFETY DISPATCHER II 145135 PUBLIC SAFETY DISPATCHER II 145596 460.65
SHANNON B SMITH PUBLIC SAFETY DISPATCHER II 138453 PUBLIC SAFETY DISPATCHER II 138843 390.81
GLORIA R QUERUBIN PUBLIC SAFETY DISPATCHER II 145228 PUBLIC SAFETY DISPATCHER II 145582 354.2
LISA A STEPHENS RENT BOARD COMMISSIONER 20658.3 RENT BOARD COMMISSIONER 20963.1 304.77
LESLIE D HARRIS OFFICE SPECIALIST III 93095.2 OFFICE SPECIALIST III 93391.2 295.96
TIMOTHY R BURROUGHS COMMUNITY SERVS SP III 146251 COMMUNITY SERVS SP III 146543 292.16
ROBIN T SHROPSHIRE OFFICE SPECIALIST II 98100.9 OFFICE SPECIALIST II 98368.2 267.3
MICHELINE BEAM MENTAL HEALTH CLINICAL SUPV 147644 MENTAL HEALTH CLINICAL SUPV 147904 259.48
AHSAN A KAZMI ASSISTANT TRAFFIC ENGINEER 158707 ASSISTANT TRAFFIC ENGINEER 158948 241.5
MILAGROS P SERNA ACCOUNTING OFF SPEC SUPERV 112869 ACCOUNTING OFF SPEC SUPERV 113100 230.61
ELISA GALLEGOS-JACKSON PUBLIC HEALTH NURSE 156159 PUBLIC HEALTH NURSE 156386 226.54
TAOUFIK ABALIL CENTRAL SERVICES AIDE 62062.1 CENTRAL SERVICES AIDE 62287.7 225.57
DAVID L FOGARTY ECONOMIC DEVELOP PROJECT COORD 168762 ECONOMIC DEVELOP PROJECT COORD 168957 194.23
SHAMIKA COLE OFFICE SPECIALIST II 97259.1 OFFICE SPECIALIST II 97448.6 189.46
YOLANDA LEON-WILLARD OFFICE SPECIALIST II 107190 OFFICE SPECIALIST II 107248 57.53
EVE E FRANKLIN ADMINISTRATIVE SECRETARY 106314 ADMINISTRATIVE SECRETARY 106357 43.31
DAVID A BLAKE RENT BOARD COMMISSIONER 14252.1 RENT BOARD COMMISSIONER 14275.5 23.42
ABRAXAS K SEALE OFFICE SPECIALIST III 102195 OFFICE SPECIALIST III 102207 11.92
RENITA G TERRY PARKING ENFORCEMENT OFFICER 107211 PARKING ENFORCEMENT OFFICER 107196 -14.75
KADIA R CORDIER OFFICE SPECIALIST III 115945 OFFICE SPECIALIST III 115896 -49.05
GREGORY S HEIDENREICH BUILDING INSPECTOR II (CERT) 134260 BUILDING INSPECTOR II (CERT) 134184 -76.37
MARIAN S DUNN OFFICE SPECIALIST II 90880.2 OFFICE SPECIALIST II 90771.8 -108.33
JI W CHUNG COMMUNITY SERVS SP I 108468 COMMUNITY SERVS SP I 108340 -127.53
CHARLENE A WASHINGTON LEGISLATIVE ASSISTANT 79918.6 LEGISLATIVE ASSISTANT 79786.9 -131.72
HARVENA D ODEN-TRACY OFFICE SPECIALIST II 92425.6 OFFICE SPECIALIST II 92282.4 -143.23
DANA M FORTIER PARKING METER MAINTENANCE WORK 99713.7 PARKING METER MAINTENANCE WORK 99557.5 -156.22
RONNIE HENDERSON LABORER 113458 LABORER 113276 -182.03
RHONDA R LARKS PUBLIC SAFETY DISPATCHER II 137681 PUBLIC SAFETY DISPATCHER II 137480 -201.01
BRIAN M LEBLANC PARKING METER MECHANIC 98108.9 PARKING METER MECHANIC 97884.4 -224.49
JESSE B TOWNLEY RENT BOARD COMMISSIONER 13557.7 RENT BOARD COMMISSIONER 13314.4 -243.34
PAMELA W WEBSTER RENT BOARD COMMISSIONER 13557.7 RENT BOARD COMMISSIONER 13264.4 -293.34
MARCUS D DINKINS POLICE OFFICER 208779 POLICE OFFICER 208484 -295.13
ANDREA N CARDOZA CRIME SCENE SUPERVISOR 122622 CRIME SCENE SUPERVISOR 122298 -324.3
ALLISON S GRAHAM-EALY OFFICE SPECIALIST III 120049 OFFICE SPECIALIST III 119712 -336.93
ANTHONY R ALCUTT ASSISTANT MENTAL HEALTH CLINIC 101260 ASSISTANT MENTAL HEALTH CLINIC 100920 -340
JAMES A WICKER COMMUNITY SERVS SP II 132182 COMMUNITY SERVS SP II 131825 -357.25
RICK D BETTI SURVEY TECHNICIAN 110847 SURVEY TECHNICIAN 110437 -409.68
BEVERLY J BOLDEN OFFICE SPECIALIST II 95005.2 OFFICE SPECIALIST II 94578 -427.22
ABDUL WAYNE RECREATION ACTIVITY LEADER 50784.1 RECREATION ACTIVITY LEADER 50320.4 -463.71
EARL B PRYOR FIELD REPRESENTATIVE 138778 FIELD REPRESENTATIVE 138307 -471.93
ATHENA D ADDISON OFFICE SPECIALIST III 113552 OFFICE SPECIALIST III 113071 -480.62
BARRY K FUTTERMAN LIBRARY ASSISTANT 47344.7 LIBRARY ASSISTANT 46840.3 -504.43
ALICIA R PANGANIBAN ACCOUNTING OFF SPEC III 110042 ACCOUNTING OFF SPEC III 109531 -511.56
ANDRE D KIDD OFFICE SPECIALIST II 83598.1 OFFICE SPECIALIST II 83080.6 -517.41
WESLEY J GAGE SOLID WASTE TRUCK DRIVER 103945 SOLID WASTE TRUCK DRIVER 103414 -530.66
JEFFREY L BUELL COMMUNITY SERVS SP I 91505.6 COMMUNITY SERVS SP I 90954.5 -551.14
DANIEL B UNGER MENTAL HLTH CLIN II 111965 MENTAL HLTH CLIN II 111408 -556.08
RUDY C TAYLOR OFFICE SPECIALIST II 87817.9 OFFICE SPECIALIST II 87236.1 -581.8
LINDA D ROSS MENTAL HLTH CLIN II 130294 MENTAL HLTH CLIN II 129702 -592.18
JENNIE M KWONG PUBLIC SAFETY DISPATCHER II 139542 PUBLIC SAFETY DISPATCHER II 138943 -598.68
DANITA R HARDAWAY ASSOCIATE MANAGEMENT ANALYST 150069 ASSOCIATE MANAGEMENT ANALYST 149435 -633.38
KAREN J HEMPHILL SCHOOL BOARD DIRECTOR 18636.4 SCHOOL BOARD DIRECTOR 18000.1 -636.35
JOSHUA R DANIELS SCHOOL BOARD DIRECTOR 18636.4 SCHOOL BOARD DIRECTOR 18000.1 -636.35
EFREN L RAMOS ASSOCIATE MANAGEMENT ANALYST 131927 ASSOCIATE MANAGEMENT ANALYST 131286 -641.47
HERIBERTO L PAREDES TRACTOR TRAILER DRIVER 154019 TRACTOR TRAILER DRIVER 153375 -643.63
ANDREA L BATES OFFICE SPECIALIST II 84331.6 OFFICE SPECIALIST II 83642.8 -688.81
MARTHA M NASH PARALEGAL 112454 PARALEGAL 111752 -702.17
MAXWELL G ANDERSON COUNCILMEMBER 46135.6 COUNCILMEMBER 45395.6 -740.06
MARIA M PEREZ COMMUNITY HLTH WRKR SPECIALIST 106969 COMMUNITY HLTH WRKR SPECIALIST 106193 -776.17
YVETTE GAN SECRETARY TO THE CITY MANAGER 126091 SECRETARY TO THE CITY MANAGER 125262 -828.74
NIKOS A KASTMILER POLICE OFFICER 194230 POLICE OFFICER 193378 -852.11
MATTHEW D NICHOLS PRINCIPAL PLANNER 171116 PRINCIPAL PLANNER 170245 -870.88
JOEL F FRESNIDO OFFICE SPECIALIST II 104967 OFFICE SPECIALIST II 104088 -879.08
CATHY-JAYNE D REVOCAL OFFICE SPECIALIST II 78821.5 OFFICE SPECIALIST II 77930 -891.53
RICHARD ANDERSON SOLID WASTE SUPERVISOR 168744 SOLID WASTE SUPERVISOR 167835 -908.11
KATHERINE G NICOLOSI OFFICE SPECIALIST II 89727.3 OFFICE SPECIALIST II 88793.5 -933.76
JACQUELYNN Y KIEL OFFICE SPECIALIST II 91176.6 OFFICE SPECIALIST II 90203.4 -973.17
BEATRIZ LEYVA-CUTLER SCHOOL BOARD DIRECTOR 18636.4 SCHOOL BOARD DIRECTOR 17653.9 -982.51
SUSAN E WENGRAF COUNCILMEMBER 47114.7 COUNCILMEMBER 46126.9 -987.76
ALEXANDRA A DEITCH OFFICE SPECIALIST II 88396 OFFICE SPECIALIST II 87405.9 -990.03
KIRK L WHITFIELD INFORMATION SYSTEMS SUPPORT TE 105013 INFORMATION SYSTEMS SUPPORT TE 103987 -1026.06
GEORGE H BROWN TRAFFIC MAINT WKR II 126270 TRAFFIC MAINT WKR II 125235 -1034.53
VONNDRIA D FROST OFFICE SPECIALIST II 92384.9 OFFICE SPECIALIST II 91349.9 -1034.99
RICHARD A MASTICK LIBRARY ASSISTANT 47113.1 LIBRARY ASSISTANT 46065.9 -1047.23
BLANCA L WONG OFFICE SPECIALIST II 87431.3 OFFICE SPECIALIST II 86352.7 -1078.56
LAURIE CAPITELLI COUNCILMEMBER 46541 COUNCILMEMBER 45431.2 -1109.87
MICHAEL A DIXON JANITOR 105505 JANITOR 104379 -1125.95
KRISS WORTHINGTON COUNCILMEMBER 40949.1 COUNCILMEMBER 39818.7 -1130.41
SHEILA LEW LIBRARY AIDE 40565.2 LIBRARY AIDE 39394.6 -1170.58
LAURIE PEOPLES PUBLIC HEALTH NURSE 146178 PUBLIC HEALTH NURSE 144960 -1218.17
JESSE H GRANT POLICE OFFICER 266246 POLICE OFFICER 265015 -1230.95
PETER S BAILEY LIBRARY AIDE 33029.7 LIBRARY AIDE 31797.9 -1231.77
ANDREW B CLOUGH DIRECTOR OF PUBLIC WORKS 248866 DIRECTOR OF PUBLIC WORKS 247628 -1237.82
TOCOSA ONEA PSYCH SOC WKR II 123633 PSYCH SOC WKR II 122372 -1261.1
ERIN M YATTAW LIBRARY AIDE 31965.1 LIBRARY AIDE 30629.6 -1335.48
CYNTHIA T WOO LIBRARY SPECIALIST II 78540.4 LIBRARY SPECIALIST II 77140.8 -1399.54
CRYSTAL D BREWER OFFICE SPECIALIST II 84618.3 OFFICE SPECIALIST II 83207.6 -1410.67
THELMA B BREWER ADMINISTRATIVE ASSISTANT 122303 ADMINISTRATIVE ASSISTANT 120858 -1444.92
LEOPOLDO R REYES AUDITOR II 140266 AUDITOR II 138804 -1462.04
ANISSA F LOVE OFFICE SPECIALIST II 83970.9 OFFICE SPECIALIST II 82498.9 -1472.1
ANNA M ALBANESE ACCOUNTING OFF SPEC III 95289.2 ACCOUNTING OFF SPEC III 93814.1 -1475.16
SHEILA M SOO ASSISTANT MANAGEMENT ANALYST 113826 ASSISTANT MANAGEMENT ANALYST 112254 -1572.6
LAQUANA PATRICK OFFICE SPECIALIST II 99066 OFFICE SPECIALIST II 97421.9 -1644.05
JIA JING L PAN DRAFTING TECHNICIAN 114772 DRAFTING TECHNICIAN 113074 -1698.01
SUZANNE R ROMBILAS OFFICE SPECIALIST II 88393.2 OFFICE SPECIALIST II 86688.9 -1704.27
JOSEPH A ALVAREZ LIBRARY ASSISTANT 54367.6 LIBRARY ASSISTANT 52647.8 -1719.88
PATRICIA A DONALD RECREATION COORDINATOR 129483 RECREATION COORDINATOR 127745 -1738.8
JENNY D SEAY ACCOUNTING OFF SPEC III 110846 ACCOUNTING OFF SPEC III 109040 -1805.62
SCOTT J BRITT SKILLED LABORER 112559 SKILLED LABORER 110750 -1808.58
LINDA R MAIO COUNCILMEMBER 35588.3 COUNCILMEMBER 33772.9 -1815.37
IAN H ZAKRZEWSKI PARAMEDIC SUPERVISOR I 210378 PARAMEDIC SUPERVISOR I 208554 -1824.37
LETICIA HERNANDEZ OFFICE SPECIALIST III 113409 OFFICE SPECIALIST III 111553 -1855.62
DIANA C AIKENHEAD ENGINEERING INSPECTOR 151193 ENGINEERING INSPECTOR 149335 -1857.06
CHRISTINE S MORROW OFFICE SPECIALIST II 86831.1 OFFICE SPECIALIST II 84913 -1918.17
SHERI S JACKSON CUSTOMER SERVICES SUPERVISOR 104498 CUSTOMER SERVICES SUPERVISOR 102566 -1932.42
JESS E SCHWARCK COMMUNITY SERVICE OFFICER 114320 COMMUNITY SERVICE OFFICER 112375 -1945.69
CONNIE C HUI ACCOUNTING OFF SPEC III 101666 ACCOUNTING OFF SPEC III 99680.6 -1985.37
JESSE L ARREGUIN COUNCILMEMBER 41814.2 COUNCILMEMBER 39818.7 -1995.56
ARTHUR R GREGORIAN OFFICE SPECIALIST II 98425.2 OFFICE SPECIALIST II 96381.9 -2043.32
CHRISTINE R HANSEN LIBRARY ASSISTANT 45528.1 LIBRARY ASSISTANT 43455.1 -2072.97
SANDRA LEWIS ACCOUNTING TECHNICIAN 109079 ACCOUNTING TECHNICIAN 106979 -2099.79
DEBRA R SANDERSON LAND USE PLANNING MANAGER 203772 LAND USE PLANNING MANAGER 201646 -2125.71
LILA CRUTCHFIELD MID-LEVEL PRACTITIONER 102164 MID-LEVEL PRACTITIONER 100016 -2148.3
DONNA LASALA DIRECTOR OF INFORMATION TECHNO 226515 DIRECTOR OF INFORMATION TECHNO 224358 -2157.05
MICHAEL R AYERS TRACTOR TRAILER DRIVER 137540 TRACTOR TRAILER DRIVER 135379 -2161.53
DWAYNE WALTERS LANDSCAPE EQUIPMENT OPERATOR 125920 LANDSCAPE EQUIPMENT OPERATOR 123711 -2209.19
ROBERT B YOUNG TOOL LENDING SPECIALIST 75153.2 TOOL LENDING SPECIALIST 72925.2 -2228.04
CAROL J PATTERSON COMMUNITY SERVS SP II 132062 COMMUNITY SERVS SP II 129826 -2236.75
GORDON J WOZNIAK COUNCILMEMBER 32708.5 COUNCILMEMBER 30468.1 -2240.37
JOSHUA E LACHMAN LIBRARIAN II 129869 LIBRARIAN II 127627 -2241.81
WARREN J MIDDLETON SUPERVISING LIBRARY ASSISTANT 108656 SUPERVISING LIBRARY ASSISTANT 106397 -2258.6
DANIEL J EZEKIEL SENIOR PSYCH SOC WORKER 148748 SENIOR PSYCH SOC WORKER 146471 -2277.26
MARSHA K COOK SENIOR PERMIT SPECIALIST 126146 SENIOR PERMIT SPECIALIST 123865 -2281.36
PATRICIA H NAGAMOTO LIBRARY SPECIALIST II 62417.3 LIBRARY SPECIALIST II 60102.2 -2315.12
KATHALEEN GREGOVICH SENIOR BUYER 129493 SENIOR BUYER 127156 -2336.94
SHELLIE HILL OFFICE SPECIALIST II 92567.6 OFFICE SPECIALIST II 90230.3 -2337.22
JOSE A DUCOS SENIOR HEALTH MANAGEMENT ANALY 148969 SENIOR HEALTH MANAGEMENT ANALY 146629 -2339.83
DARCY E JOJOLA INFORMATION SYSTEMS SPECIALIST 131846 INFORMATION SYSTEMS SPECIALIST 129471 -2375.68
ANDREA WOOD PUBLIC HEALTH NURSE 153282 PUBLIC HEALTH NURSE 150900 -2382.67
ROGELIO B MARQUINA SENIOR SOLID WASTE SUPERVISOR 168319 SENIOR SOLID WASTE SUPERVISOR 165928 -2391.21
BERTHA M BROWN RECREATION COORDINATOR 106149 RECREATION COORDINATOR 103741 -2408.7
DUC VAN TRAN LIBRARY ASSISTANT 47263.9 LIBRARY ASSISTANT 44843.1 -2420.79
ILAN EYMAN LIBRARIAN II 125776 LIBRARIAN II 123342 -2433.49
ANNA AVELLAR LEGISLATIVE ASSISTANT 68164 LEGISLATIVE ASSISTANT 65705.3 -2458.72
NATHAN F DAHL CODE ENFORCEMENT OFFICER II 123960 CODE ENFORCEMENT OFFICER II 121491 -2468.7
LILLIAN J ALLEN-STEPHENS MEALSITE COORDINATOR 41449.2 MEALSITE COORDINATOR 38970.6 -2478.55
GREGORY L DANIEL CODE ENFORCEMENT SUPERVISOR 155278 CODE ENFORCEMENT SUPERVISOR 152799 -2479.43
MEGAN M MCARDLE LIBRARY SERVICES MANAGER 162536 LIBRARY SERVICES MANAGER 160049 -2486.7
LINDA MCDONALD LIBRARY SPECIALIST II 76223.9 LIBRARY SPECIALIST II 73725.9 -2497.94
NOAH J ROSENTHAL LIBRARY ASSISTANT 47072.9 LIBRARY ASSISTANT 44572.7 -2500.25
JOHN RODAL T ZOTOMAYOR ACCOUNTING OFF SPEC III 97185.9 ACCOUNTING OFF SPEC III 94683.2 -2502.7
FELICIA A KEENAN OFFICE SPECIALIST III 98388.4 OFFICE SPECIALIST III 95856.8 -2531.64
JUAN C RAMOS SOLID WASTE WORKER 135561 SOLID WASTE WORKER 133005 -2556.31
DAVID E ROBINSON SEWER MAINTENANCE ASST SUPV 145276 SEWER MAINTENANCE ASST SUPV 142594 -2681.59
COLLEEN F FAWLEY LIBRARY SPECIALIST II 99975.3 LIBRARY SPECIALIST II 97279.6 -2695.71
ALEXANDER J AMOROSO PRINCIPAL PLANNER 172375 PRINCIPAL PLANNER 169655 -2720.3
RICHARD CHEW LIBRARY AIDE 50321.2 LIBRARY AIDE 47584.9 -2736.3
DELFINA M GEIKEN EMPLOYMENT PROGRAMS ADMINISTRA 156832 EMPLOYMENT PROGRAMS ADMINISTRA 154063 -2768.8
CYNTHIA F HALL OFFICE SPECIALIST SUPERVISOR 115712 OFFICE SPECIALIST SUPERVISOR 112934 -2777.45
BRENDA M JONES ADMINISTRATIVE SECRETARY 111690 ADMINISTRATIVE SECRETARY 108911 -2778.87
DISSARAE D GUITON ACCOUNTING OFF SPEC SUPERV 108897 ACCOUNTING OFF SPEC SUPERV 106069 -2827.75
MICHELE M MCKENZIE LIBRARIAN II 63307.5 LIBRARIAN II 60476 -2831.48
ENER N CUEVA ASSOCIATE MANAGEMENT ANALYST 151304 ASSOCIATE MANAGEMENT ANALYST 148450 -2853.89
RAYMOND A PISANO SUPERVISING PUBLIC HEALTH NURS 177423 SUPERVISING PUBLIC HEALTH NURS 174546 -2877.54
WAYMAN J BLOCKER SKILLED LABORER 123063 SKILLED LABORER 120134 -2928.82
VIVIANA VIGIL SUPERVISING LIBRARY ASSISTANT 114946 SUPERVISING LIBRARY ASSISTANT 112005 -2941.64
ARGELIA RAYOS COMMUNITY HLTH WRKR SPECIALIST 83072.5 COMMUNITY HLTH WRKR SPECIALIST 80112 -2960.52
JOSEPH K COLLIGNON OFFICE SPECIALIST SUPERVISOR 123796 OFFICE SPECIALIST SUPERVISOR 120826 -2969.6
JOSE J GUZMAN SOLID WASTE WORKER 132150 SOLID WASTE WORKER 129168 -2981.83
YUKO M LEONG PUBLIC HEALTH NURSE 148642 PUBLIC HEALTH NURSE 145654 -2988.1
JOHNIE B KINDLE ANIMAL CONTROL OFFICER 106764 ANIMAL CONTROL OFFICER 103775 -2989.96
JANET M BERREMAN HEALTH OFFICER (CERT) 258075 HEALTH OFFICER (CERT) 255056 -3018.84
BABALWA I KWANELE MENTAL HLTH CLIN II 75338.9 MENTAL HLTH CLIN II 72319.4 -3019.55
PAMELA J SIPCHEN REGISTERED NURSE 133402 REGISTERED NURSE 130364 -3038.18
DEBRA L WARD ASSOCIATE MANAGEMENT ANALYST 143382 ASSOCIATE MANAGEMENT ANALYST 140342 -3040.56
CRISTI A DELGADO APPLICATIONS PROG/ANA II 136718 APPLICATIONS PROG/ANA II 133654 -3063.27
ROSEMERY E MEDINA LIBRARY AIDE 32580.1 LIBRARY AIDE 29516.7 -3063.47
AVOTCJA L JONES PERMIT SPECIALIST 111592 PERMIT SPECIALIST 108526 -3065.82
MARITZA G MARTINEZ OFFICE SPECIALIST III 98933.4 OFFICE SPECIALIST III 95856.8 -3076.63
BARBARA M BENT LIBRARY AIDE 37276.3 LIBRARY AIDE 34185.3 -3090.99
MICHAEL H MARCHANT PSYCH SOC WKR II 137976 PSYCH SOC WKR II 134861 -3114.27
TERESITA E CATALYA ACCOUNTANT II 127730 ACCOUNTANT II 124603 -3126.93
GARY M TRIPLETT SENIOR FIELD REPRESENTATIVE 104464 SENIOR FIELD REPRESENTATIVE 101327 -3136.99
CYNTHIA P MCCLELLAN ASSISTANT MANAGEMENT ANALYST 114385 ASSISTANT MANAGEMENT ANALYST 111213 -3172.43
EUN AH LIM-STANGL OFFICE SPECIALIST II 97765.6 OFFICE SPECIALIST II 94578 -3187.55
YOLANDA P GORMAN ACCOUNTING OFF SPEC III 109999 ACCOUNTING OFF SPEC III 106805 -3194.31
GLENN INGERSOLL LIBRARY SPECIALIST II 52303.5 LIBRARY SPECIALIST II 49094.5 -3208.92
SILVIA D DUENAS LIBRARY ASSISTANT 38813.2 LIBRARY ASSISTANT 35572.9 -3240.32
UMA R PAUL SUPERVISING LIBRARY ASSISTANT 114675 SUPERVISING LIBRARY ASSISTANT 111430 -3244.97
MARCUS L BELL INFORMATION SYSTEMS SPECIALIST 132620 INFORMATION SYSTEMS SPECIALIST 129372 -3248.11
ROGER W ASTERINO COMMUNITY DEVELOP PROJCT COORD 144558 COMMUNITY DEVELOP PROJCT COORD 141308 -3250.35
BRENDA L DELATORRE ACCOUNTING OFF SPEC III 110263 ACCOUNTING OFF SPEC III 107003 -3260.2
SHIOK LIM LIBRARIAN II 132485 LIBRARIAN II 129167 -3317.74
CAROLYN E PETTIGREW ANIMAL CONTROL OFFICER 97507.1 ANIMAL CONTROL OFFICER 94185.9 -3321.16
FELICIA N GRAHAM OFFICE SPECIALIST III 105789 OFFICE SPECIALIST III 102457 -3331.47
GLORIA G OCAMPO ACCOUNTANT I 118587 ACCOUNTANT I 115254 -3332.22
TOM W DUFOUR LIBRARIAN II 62746.7 LIBRARIAN II 59406.2 -3340.51
SERGIO R MARTINEZ COMMUNITY HLTH WRKR SPECIALIST 109591 COMMUNITY HLTH WRKR SPECIALIST 106193 -3397.67
CHRISTINA C QUESADA ACCOUNTING OFF SPEC III 110220 ACCOUNTING OFF SPEC III 106805 -3415.23
EVA F BRADFORD CLINICAL PSYCHOLOGIST 71664.1 CLINICAL PSYCHOLOGIST 68237.3 -3426.81
SUSANA Y KHOO ACCOUNTING OFF SPEC III 111998 ACCOUNTING OFF SPEC III 108555 -3443.01
BARON D COPE RECREATION ACTIVITY LEADER 45166 RECREATION ACTIVITY LEADER 41714.7 -3451.36
STACEY L JOHNSON ASSOCIATE MANAGEMENT ANALYST 150499 ASSOCIATE MANAGEMENT ANALYST 147033 -3465.91
JAMES A WELLS II RECREATION ACTIVITY LEADER 48910.3 RECREATION ACTIVITY LEADER 45431.7 -3478.52
GWENDOLYN A AARON OFFICE SPECIALIST III 109164 OFFICE SPECIALIST III 105680 -3483.51
ROWELLA M ALDANA CUST SERVS SPEC III 110295 CUST SERVS SPEC III 106805 -3490.42
SAM J ZHANG SUPERVISING LIBRARY ASSISTANT 112341 SUPERVISING LIBRARY ASSISTANT 108848 -3492.67
CHRISTINA F FRANCO OFFICE SPECIALIST III 111975 OFFICE SPECIALIST III 108466 -3509.55
JACOB S RUSSELL INFORMATION SYSTEMS SUPPORT TE 115286 INFORMATION SYSTEMS SUPPORT TE 111756 -3529.44
JAMES E FINDLEY LIBRARY SPECIALIST II 89582.4 LIBRARY SPECIALIST II 86047.3 -3535.05
JUDY E SHELTON RENT BOARD COMMISSIONER 14383.7 RENT BOARD COMMISSIONER 10835.8 -3547.95
JESSE M KEEGAN LIBRARY SPECIALIST I 93337.2 LIBRARY SPECIALIST I 89746.2 -3591.04
LEA J RIVERA OFFICE SPECIALIST II 98183.4 OFFICE SPECIALIST II 94578 -3605.38
MADILYN A JACKSON OFFICE SPECIALIST III 105455 OFFICE SPECIALIST III 101849 -3605.71
DINA T QUAN SENIOR HEALTH SERV PROG SPECIA 132064 SENIOR HEALTH SERV PROG SPECIA 128435 -3629.06
MARGARET S EDWARDS ASSOCIATE HUMAN RESOURCES ANAL 139220 ASSOCIATE HUMAN RESOURCES ANAL 135582 -3637.47
KATHY D SLATER LIBRARY ASSISTANT 83732 LIBRARY ASSISTANT 80086.4 -3645.69
ERIC KEYS DRAFTING AIDE 59797.9 DRAFTING AIDE 56150.4 -3647.54
WILLIAM G FLORES CONSTRUCTION EQUIPMENT OPERATO 118785 CONSTRUCTION EQUIPMENT OPERATO 115130 -3655.36
KARIN L SOE-LAI SUPERVISING LIBRARY ASSISTANT 113356 SUPERVISING LIBRARY ASSISTANT 109676 -3680.58
JEREMY R LATHROP POLICE OFFICER 230962 POLICE OFFICER 227262 -3700.45
SAMUEL L CLEMONS III SUPERVISING LIBRARY ASSISTANT 106587 SUPERVISING LIBRARY ASSISTANT 102877 -3709.48
MELINDA A JACOB OFFICE SPECIALIST II 85792.3 OFFICE SPECIALIST II 82076.6 -3715.73
GINA Y CHAN OFFICE SPECIALIST III 101663 OFFICE SPECIALIST III 97933.5 -3729.46
SANDRA Y HUNTER COMMUNITY HLTH WRKR SPECIALIST 94652.2 COMMUNITY HLTH WRKR SPECIALIST 90916.4 -3735.73
BRIAN J LACKEY BUILDING MAINTENANCE MECHANIC 125038 BUILDING MAINTENANCE MECHANIC 121273 -3765.05
WILLIAM C COBB CUST SERVS SPEC III 99610.9 CUST SERVS SPEC III 95844.1 -3766.82
KARIN P TRAN OFFICE SPECIALIST III 98786 OFFICE SPECIALIST III 95011.7 -3774.33
THAO H TRAN PSYCHIATRIST III 133091 PSYCHIATRIST III 129308 -3782.66
MELODY A SORENSEN SENIOR DRAFTING TECHNICIAN 119715 SENIOR DRAFTING TECHNICIAN 115926 -3789.79
HAROLD S BENNETT RECREATION COORDINATOR 119988 RECREATION COORDINATOR 116196 -3792.09
HEATHER L WILLIS OFFICE SPECIALIST II 87438.1 OFFICE SPECIALIST II 83642.8 -3795.31
SHERRY L AUSTIN LIBRARY SPECIALIST I 93337.2 LIBRARY SPECIALIST I 89512.8 -3824.43
DAVID J HOWD LIBRARIAN II 131460 LIBRARIAN II 127627 -3832.97
LINDA SAKAMOTO-JAHNKE LIBRARY LITERACY PROGRAM COORD 126991 LIBRARY LITERACY PROGRAM COORD 123146 -3844.76
MARCA L LAMORE ASSISTANT MANAGEMENT ANALYST 117063 ASSISTANT MANAGEMENT ANALYST 113218 -3845.3
ERIC J KNUDSEN LIBRARY ASSISTANT 66160.1 LIBRARY ASSISTANT 62311.1 -3848.91
KEM M LOONG PUBLIC WORKS MAINTENANCE SUPER 172657 PUBLIC WORKS MAINTENANCE SUPER 168803 -3854.18
EMELITA R BERSONDA ACCOUNTING OFF SPEC III 100068 ACCOUNTING OFF SPEC III 96204.9 -3863.39
RAUL M CHAN ACCOUNTING OFF SPEC III 99726.7 ACCOUNTING OFF SPEC III 95856.7 -3870.03
SINCLAIR G SAVAGE SKILLED LABORER 103623 SKILLED LABORER 99750.5 -3872.24
RUSSELL A KEYS SUPERVISING LIBRARY ASSISTANT 100161 SUPERVISING LIBRARY ASSISTANT 96276.3 -3885
RAMONA J BENSON SENIOR COMMUNITY HEALTH SPECIA 105168 SENIOR COMMUNITY HEALTH SPECIA 101274 -3894.7
MATTHEW T COTTERILL TRAFFIC ENGINEERING ASSISTANT 108396 TRAFFIC ENGINEERING ASSISTANT 104495 -3900.79
JOHNNY YEE COMMUNITY SERVS SP I 113503 COMMUNITY SERVS SP I 109584 -3918.55
JOSE T VANG FIELD REPRESENTATIVE 108271 FIELD REPRESENTATIVE 104332 -3939.36
LAWRENCE M SASAKI OFFICE SPECIALIST II 86625.8 OFFICE SPECIALIST II 82678.8 -3947.05
TERESA A BERKELEY-SIMMONS BUDGET MANAGER 200640 BUDGET MANAGER 196680 -3959.81
TEDDY KEBEDE PUBLIC HEALTH NURSE 160326 PUBLIC HEALTH NURSE 156362 -3964.1
STEVE R REGO POLICE OFFICER 275008 POLICE OFFICER 270990 -4018.51
YANHONG XIE ACCOUNTANT II 128644 ACCOUNTANT II 124603 -4041.12
ANNE M BURNS ASSOCIATE PLANNER 140732 ASSOCIATE PLANNER 136651 -4080.81
KELVIN A GIBBS POLICE OFFICER 183996 POLICE OFFICER 179884 -4112.2
ETHAN A SERFLING FIRE APPARATUS OPERATOR 196202 FIRE APPARATUS OPERATOR 192050 -4151.97
PAUL J CHURCH DISABILITY SERVICES SPECIALIST 135849 DISABILITY SERVICES SPECIALIST 131666 -4183.23
ELISIA A MCKEEVER PARKING ENFORCEMENT OFFICER 96639.4 PARKING ENFORCEMENT OFFICER 92417 -4222.46
BRENT A NELSON HOUSING INSPECTOR SUPERVISOR 156593 HOUSING INSPECTOR SUPERVISOR 152363 -4229.69
LISA HESSELGESSER LIBRARY SPECIALIST II 60080.2 LIBRARY SPECIALIST II 55850.2 -4230.03
LELAND S JOHNSON MENTAL HLTH CLIN II 128068 MENTAL HLTH CLIN II 123834 -4233.79
NAVDEEP MEHTA APPLICATIONS PROG/ANA II 145968 APPLICATIONS PROG/ANA II 141727 -4241.07
DEBORAH C SEGAL LIBRARY ASSISTANT 53632 LIBRARY ASSISTANT 49379 -4253.06
LINDA SALAS ASSISTANT ARCHITECT 146883 ASSISTANT ARCHITECT 142616 -4266.2
SERENA NOVA OFFICE SPECIALIST II 75061.8 OFFICE SPECIALIST II 70776.4 -4285.35
STEPHANIE J POLIZZIANI POLICE OFFICER 201675 POLICE OFFICER 197379 -4295.61
VIJAY NAND SUPERVISING LIBRARY ASSISTANT 100470 SUPERVISING LIBRARY ASSISTANT 96111 -4358.78
TAMRA E BROWN CUST SERVS SPEC III 100239 CUST SERVS SPEC III 95861 -4378.04
LYNN D BLANKENSHIP BUYER 119621 BUYER 115226 -4394.98
CARL WAYNE B LAGANDAON OFFICE SPECIALIST III 99238.2 OFFICE SPECIALIST III 94832 -4406.26
ABIGAIL T GREGOR PSYCH SOC WKR II 114602 PSYCH SOC WKR II 110186 -4415.14
GLADYS M GRAY PARKING ENFORCEMENT OFFICER 108742 PARKING ENFORCEMENT OFFICER 104302 -4440.06
PAMELA C EMBRY SENIOR MANAGEMENT ANALYST 174943 SENIOR MANAGEMENT ANALYST 170485 -4458.5
THERESA F SHIPP OFFICE SPECIALIST III 106209 OFFICE SPECIALIST III 101731 -4478.58
SHERREN L STYLES ADMINISTRATIVE ASSISTANT 118673 ADMINISTRATIVE ASSISTANT 114181 -4491.43
ERIC M BRENMAN SENIOR MANAGEMENT ANALYST 163968 SENIOR MANAGEMENT ANALYST 159471 -4496.95
MARIFE ELMORE HUMAN RESOURCES TECHNICIAN 116656 HUMAN RESOURCES TECHNICIAN 112150 -4505.63
CHARLES O BUTLER MINI BUS DRIVER 93296.4 MINI BUS DRIVER 88789.2 -4507.24
DARREL L JOHNSON SOLID WASTE TRUCK DRIVER 119841 SOLID WASTE TRUCK DRIVER 115324 -4516.77
REYNALDO V GARCIA ACCOUNTANT I 112820 ACCOUNTANT I 108280 -4539.82
KATHLEEN FINNEY LIBRARIAN II 133608 LIBRARIAN II 129056 -4552.16
ADRIENNE L MILLOW OFFICE SPECIALIST II 91707.5 OFFICE SPECIALIST II 87152.4 -4555.1
ESTHER A SUAREZ LIBRARY ASSISTANT 51354.2 LIBRARY ASSISTANT 46789.5 -4564.65
ANDREW J SCHNEIDER RECYCLING PROGRAM MANAGER 168249 RECYCLING PROGRAM MANAGER 163672 -4577.23
JACQUELYN D MORGAN COMMUNITY SERVS SP II 138336 COMMUNITY SERVS SP II 133754 -4582.12
STEPHEN SCHOONOVER OFFICE SPECIALIST II 94817.9 OFFICE SPECIALIST II 90230.3 -4587.56
NICOLAS L TRAYLOR COMMUNITY SERVS SP III 164220 COMMUNITY SERVS SP III 159627 -4592.77
VANESSA ALBERT COMMUNITY HLTH WRKR SPECIALIST 98475.2 COMMUNITY HLTH WRKR SPECIALIST 93859.9 -4615.3
THOMAS C SYTO POLICE OFFICER 244991 POLICE OFFICER 240372 -4618.51
MARK P EHRMAN BUILDING MAINTENANCE MECHANIC 122605 BUILDING MAINTENANCE MECHANIC 117983 -4622.19
DEBORAH JORDAN SENIOR CITIZEN CENTER DIRECTOR 124887 SENIOR CITIZEN CENTER DIRECTOR 120263 -4623.7
WENDY P WONG ASSISTANT PUBLIC WORKS ENGINEE 151922 ASSISTANT PUBLIC WORKS ENGINEE 147292 -4630.93
MATTHEW J OREBIC DEPUTY CITY ATTY III 229610 DEPUTY CITY ATTY III 224953 -4656.51
ROBERT R WHITEHEAD COMMUNITY SERVICE OFFICER 133271 COMMUNITY SERVICE OFFICER 128604 -4666.86
ANDREW R GREENWOOD POLICE CAPTAIN 325166 POLICE CAPTAIN 320466 -4699.38
GERALD W JOHNSON MINI BUS DRIVER 89832.6 MINI BUS DRIVER 85127.1 -4705.48
MARCELLIS L ASHLEY RECREATION ACTIVITY LEADER 51626.2 RECREATION ACTIVITY LEADER 46879.2 -4747.07
RODOLFO TAPIA LIBRARY ASSISTANT 86616.2 LIBRARY ASSISTANT 81842.5 -4773.68
ERIK S KEENE POLICE OFFICER 184856 POLICE OFFICER 180072 -4784.83
KATHY CHEN LIBRARY ASSISTANT 44246.9 LIBRARY ASSISTANT 39460.6 -4786.31
WILLIAM V KEHOE BATTALION CHIEF 275443 BATTALION CHIEF 270649 -4793.7
DEBRA M EVANS ADMINISTRATIVE SECRETARY 116821 ADMINISTRATIVE SECRETARY 112019 -4801.69
WANDA W WILLIAMS ADMINISTRATIVE SECRETARY 125041 ADMINISTRATIVE SECRETARY 120232 -4809.92
VERNON R SCOTT JANITOR 115489 JANITOR 110660 -4828.12
ANN M HOTTA LIBRARIAN II 75920.6 LIBRARIAN II 71040.3 -4880.23
AMORY B LANGMO FIREFIGHTER 181895 FIREFIGHTER 176978 -4916.67
MARY F SPENCER PUBLIC HEALTH NURSE 149051 PUBLIC HEALTH NURSE 144113 -4938.37
JASON A DICKINSON CIRCULATION SERVICES MANAGER 150916 CIRCULATION SERVICES MANAGER 145968 -4948.25
RYAN D LAU LEGISLATIVE ASSISTANT 94501.9 LEGISLATIVE ASSISTANT 89549 -4952.94
BARBARA A WHITE HEALTH SERVICES PROGRAM SPECIA 138238 HEALTH SERVICES PROGRAM SPECIA 133275 -4963.19
MICHAEL K WOO DEPUTY CITY ATTY III 228972 DEPUTY CITY ATTY III 224002 -4970.14
CLARENCE J KOONTZ APPLICATIONS PROG/ANA II 146853 APPLICATIONS PROG/ANA II 141879 -4974.01
MIGUEL A SOSA SOLID WASTE WORKER 119540 SOLID WASTE WORKER 114543 -4997.27
MATTHEW E SHOGREN SENIOR LANDSCAPE GARDENER 127260 SENIOR LANDSCAPE GARDENER 122249 -5010.31
DANIEL R MONTGOMERY POLICE SERGEANT 269202 POLICE SERGEANT 264184 -5017.71
BRIAN K MC KENZIE PARKING METER MAINTENANCE WORK 119809 PARKING METER MAINTENANCE WORK 114760 -5049.91
CHRISTINE E WARREN FIRE LIEUTENANT 157308 FIRE LIEUTENANT 152243 -5064.9
RAMA S MURTY SENIOR MANAGEMENT ANALYST 168633 SENIOR MANAGEMENT ANALYST 163557 -5075.94
ADAM BRONER TOOL LENDING SPECIALIST 79886.1 TOOL LENDING SPECIALIST 74760.4 -5125.7
MARVIN D BUCKLEY RECREATION ACTIVITY LEADER 92251.9 RECREATION ACTIVITY LEADER 87120.5 -5131.41
SHERRI L DEGNAN SENIOR BUYER 118811 SENIOR BUYER 113652 -5158.95
EDWIN P YANG APPLICATIONS PROG/ANA II 146002 APPLICATIONS PROG/ANA II 140831 -5171.19
LETICIA CENDEJAS LIBRARY SPECIALIST II 100471 LIBRARY SPECIALIST II 95279.3 -5191.32
GREGORY C MCKEAN SUPERVISING LIBRARIAN 143364 SUPERVISING LIBRARIAN 138169 -5194.71
LUCILLE S PARKS-BROWN SENIOR LEGAL SECRETARY 118972 SENIOR LEGAL SECRETARY 113775 -5196.8
DONNA L CORBEIL DIRECTOR OF LIBRARY SERVICES 262080 DIRECTOR OF LIBRARY SERVICES 256869 -5211.12
WILLIE C NELSON LABORER 106943 LABORER 101728 -5214.88
LESLIE S ROME OFFICE SPECIALIST III 101690 OFFICE SPECIALIST III 96469.2 -5220.31
JOSEPH C GERMONO REG ENVIRONMENTAL HEALTH SPEC 139470 REG ENVIRONMENTAL HEALTH SPEC 134248 -5221.42
ASHRAF SOUSSA APPLICATIONS PROG/ANA II 146646 APPLICATIONS PROG/ANA II 141422 -5223.87
MATTHEW H SHIU CENTRAL SERVICES AIDE 93214.2 CENTRAL SERVICES AIDE 87985.4 -5228.82
DARYL J SMITH PARKING ENFORCEMENT OFFICER 103667 PARKING ENFORCEMENT OFFICER 98436.8 -5230.09
LESLIE M MENDEZ ASSOCIATE PLANNER 144906 ASSOCIATE PLANNER 139667 -5238.26
MARK J ZEMBSCH DEPUTY CITY ATTY III 224227 DEPUTY CITY ATTY III 218988 -5239.25
DENNIS H DANG ADMIN & FISCAL SVS MGR 168435 ADMIN & FISCAL SVS MGR 163182 -5252.61
JANE C ORTEGA OFFICE SPECIALIST II 92670.7 OFFICE SPECIALIST II 87405.9 -5264.75
RUBEN TORRES TRAFFIC MAINT WKR II 118996 TRAFFIC MAINT WKR II 113697 -5299.21
CHARLES E SANCHEZ ELECTRICAL PARTS TECHNICIAN 141620 ELECTRICAL PARTS TECHNICIAN 136320 -5300.83
YASSIR CHADLY AQUATICS SPECIALIST II 47254.9 AQUATICS SPECIALIST II 41912.1 -5342.86
WANDA DROUILLARD ASSISTANT MANAGEMENT ANALYST 127995 ASSISTANT MANAGEMENT ANALYST 122644 -5350.97
CARMELLA REJWAN ARCHITECT 173601 ARCHITECT 168208 -5393.32
ELIZABETH M THORMAN APPLICATIONS PROG/ANA II 157911 APPLICATIONS PROG/ANA II 152504 -5406.13
WING K LOUIE LIBRARY ASSISTANT 52898.8 LIBRARY ASSISTANT 47491.2 -5407.61
LENNARD DAVIS III SOLID WASTE WORKER 109638 SOLID WASTE WORKER 104230 -5408.53
LAWRENCE FONTENO CENTRAL SERVICES AIDE 88860.2 CENTRAL SERVICES AIDE 83437.7 -5422.54
LIBRADO E NUNEZ SENIOR COMMUNITY HEALTH SPECIA 109836 SENIOR COMMUNITY HEALTH SPECIA 104401 -5434.89
MYRNA ORTIZ-SOMMER AUDITOR I 112542 AUDITOR I 107098 -5443.44
THOMAS A MATSUOKA SOLID WASTE TRUCK DRIVER 131835 SOLID WASTE TRUCK DRIVER 126386 -5448.96
ROGER L MILLER SENIOR MANAGEMENT ANALYST 152887 SENIOR MANAGEMENT ANALYST 147394 -5492.94
DEBORAH B CHERNIN PRINCIPAL PLANNER 172853 PRINCIPAL PLANNER 167348 -5504.95
PHILIP D RAYMENT COMMUNICATIONS TECHNICIAN 125618 COMMUNICATIONS TECHNICIAN 120112 -5505.46
MIGUEL F MARTINEZ SOLID WASTE WORKER 114137 SOLID WASTE WORKER 108612 -5524.41
PERLA D TIONG SENIOR MANAGEMENT ANALYST 160815 SENIOR MANAGEMENT ANALYST 155277 -5538.22
ROGER M MASON TRAFFIC MAINTENANCE SUPERVISOR 158482 TRAFFIC MAINTENANCE SUPERVISOR 152941 -5541.54
MARCIE E BURRELL ANIMAL CONTROL OFFICER 103316 ANIMAL CONTROL OFFICER 97753 -5563.23
WALTER H VANDERNALD III BUILDING MAINTENANCE MECHANIC 122615 BUILDING MAINTENANCE MECHANIC 117042 -5572.43
RAINBOW SCHWARTZ COMMUNITY HEALTH WORKER 46798 COMMUNITY HEALTH WORKER 41215 -5583
RAUL PINEDA LANDSCAPE GARDENER 125876 LANDSCAPE GARDENER 120281 -5594.35
MARGARET S HIGGINS REGISTERED NURSE 137464 REGISTERED NURSE 131822 -5642.45
THOMAS G HARTMAN LEAD ELECTRICIAN 168270 LEAD ELECTRICIAN 162614 -5655.39
YVETTE M PLEASENT LIBRARY SPECIALIST II 102157 LIBRARY SPECIALIST II 96479.8 -5677.15
SHARON CHESTANG-ROBINSO OFFICE SPECIALIST II 89981.1 OFFICE SPECIALIST II 84278.8 -5702.37
ROBERTO A VALENCIA SOLID WASTE WORKER 113875 SOLID WASTE WORKER 108169 -5705.55
HERBERT KING SENIOR LANDSCAPE GARDENER 122710 SENIOR LANDSCAPE GARDENER 117004 -5706.04
MERIDITH E LEAR HAZARDOUS MAT SP II 159672 HAZARDOUS MAT SP II 153965 -5707.09
SHARON B CROSBY PERMIT CENTER COORDINATOR 178070 PERMIT CENTER COORDINATOR 172350 -5720.28
MARGE ANN C VROOMAN WORKERS' COMPENSATION ANALYST 155401 WORKERS' COMPENSATION ANALYST 149628 -5773.83
FRANK W MARIETTI SENIOR AUDITOR 161056 SENIOR AUDITOR 155276 -5780.11
MICHAEL F LOYOLA SENIOR ELECTRICAL SUPERVISOR 169046 SENIOR ELECTRICAL SUPERVISOR 163266 -5780.9
DANIEL H GALLAGHER SENIOR FORESTRY SUPERVISOR 158710 SENIOR FORESTRY SUPERVISOR 152911 -5798.88
ANTHONY J SANCHEZ LEGISLATIVE ASSISTANT 85314.3 LEGISLATIVE ASSISTANT 79515.1 -5799.25
JENIFER B SHURSON ASSOCIATE HUMAN RESOURCES ANAL 151311 ASSOCIATE HUMAN RESOURCES ANAL 145507 -5803.54
PATRICK K MCCULLOUGH COMMUNICATIONS TECHNICIAN 181413 COMMUNICATIONS TECHNICIAN 175590 -5822.64
DARNELL S BRADD SOLID WASTE TRUCK DRIVER 130905 SOLID WASTE TRUCK DRIVER 125069 -5836.24
KYLE T WHITE POLICE OFFICER 204599 POLICE OFFICER 198756 -5843.03
PHILIP L HARPER-COTTON RECREATION PROGRAM SUPERVISOR 135465 RECREATION PROGRAM SUPERVISOR 129517 -5947.95
DANETTE L PERRY PARKING SERVICES MANAGER 159450 PARKING SERVICES MANAGER 153461 -5988.36
DALIBOR JOHN FIREFIGHTER 189895 FIREFIGHTER 183895 -6000.42
RICHARD H SHURN SKILLED LABORER 106796 SKILLED LABORER 100790 -6006.87
JOHN F SMITH SOLID WASTE TRUCK DRIVER 145089 SOLID WASTE TRUCK DRIVER 139050 -6039.24
LUCIE KROCIL PUBLIC SAFETY DISPATCHER II 139396 PUBLIC SAFETY DISPATCHER II 133353 -6043.79
KAREN M HUCKEBY PUBLIC SAFETY DISPATCHER II 174336 PUBLIC SAFETY DISPATCHER II 168271 -6065.53
MICHAEL A ROSHAL ENGINEERING INSPECTOR 143820 ENGINEERING INSPECTOR 137748 -6071.16
AUDREY S CAZDEN AQUATICS FACILITIES SUPERVISOR 92768.9 AQUATICS FACILITIES SUPERVISOR 86694.6 -6074.34
CARLOS E ROBLES SOLID WASTE WORKER 119133 SOLID WASTE WORKER 113044 -6088.8
JAVIER H BARDALES HEALTH SERVICES PROGRAM SPECIA 140739 HEALTH SERVICES PROGRAM SPECIA 134649 -6090.28
MARJORIE A CURTIS HOUSING INSPECTOR (CERTIFIED) 137454 HOUSING INSPECTOR (CERTIFIED) 131343 -6111.33
MARK E GILBERT APPLICATIONS PROG/ANA II 150032 APPLICATIONS PROG/ANA II 143915 -6117.11
DENNIS T FEGGANS EEO AND DIVERSITY OFFICER 160302 EEO AND DIVERSITY OFFICER 154153 -6148.79
TYRE B MILLS III FIRE APPARATUS OPERATOR 221358 FIRE APPARATUS OPERATOR 215191 -6167.12
JOCELYN W NIP SENIOR ACCOUNTANT 149682 SENIOR ACCOUNTANT 143504 -6178.05
BENJAMIN CARDOZA POLICE SERGEANT 251558 POLICE SERGEANT 245328 -6229.63
RITA A DE LUCCHI CRIME ANALYST 149537 CRIME ANALYST 143299 -6238.03
REBEKAH D LOWE SENIOR SYSTEMS ANALYST 168482 SENIOR SYSTEMS ANALYST 162220 -6261.59
JAMES R FANNING FIREFIGHTER 203222 FIREFIGHTER 196930 -6292.1
MITCHELL J RADIN MENTAL HLTH CLIN II 143871 MENTAL HLTH CLIN II 137528 -6342.47
ANDREW B RATEAVER POLICE LIEUTENANT 300123 POLICE LIEUTENANT 293774 -6349.02
KATRINA L HOLMES INFORMATION SYSTEMS SPECIALIST 125885 INFORMATION SYSTEMS SPECIALIST 119512 -6373.1
HUMBERTO BETANCES FORESTRY CLIMBER SUPERVISOR 138819 FORESTRY CLIMBER SUPERVISOR 132437 -6381.23
KIRK R RIVERA PARKING ENFORCEMENT OFFICER 110388 PARKING ENFORCEMENT OFFICER 103998 -6390.16
HORACE LAWRENCE SOLID WASTE WORKER 108745 SOLID WASTE WORKER 102299 -6445.87
KENNETH W ETHERINGTON SOLID WASTE/RECYCLING MANAGER 211014 SOLID WASTE/RECYCLING MANAGER 204565 -6448.43
DANIEL M AKAGI ASSOCIATE CIVIL ENGINEER 172814 ASSOCIATE CIVIL ENGINEER 166339 -6475.31
KENNETH BLAKE LIBRARY ASSISTANT 44062.2 LIBRARY ASSISTANT 37550.7 -6511.55
DEBORAH MCINTYRE ADMINISTRATIVE SECRETARY 117781 ADMINISTRATIVE SECRETARY 111252 -6529.01
DEBRA A SHORTER-JONES PUBLIC HEALTH NURSE 159520 PUBLIC HEALTH NURSE 152967 -6552.63
RUSH A JACKSON POLICE OFFICER 229968 POLICE OFFICER 223292 -6676.15
JORDAN J HARRISON ASSOCIATE PLANNER 136524 ASSOCIATE PLANNER 129815 -6709.57
MARCIA D BROWN-MACHEN SENIOR HEALTH SERV PROG SPECIA 134392 SENIOR HEALTH SERV PROG SPECIA 127676 -6716.18
STANLEY M LIBED POLICE OFFICER 223167 POLICE OFFICER 216431 -6736.38
WENDY M HYMAN LIBRARIAN II 68611.8 LIBRARIAN II 61870.3 -6741.51
SIU Y LOO SENIOR ACCOUNTANT 163165 SENIOR ACCOUNTANT 156416 -6749.9
SCOTT L ARNOLD PARKING ENFORCEMENT OFFICER 104176 PARKING ENFORCEMENT OFFICER 97407.5 -6768.14
STEVEN C NORIEGA PARKING METER MECHANIC 106897 PARKING METER MECHANIC 100095 -6802.15
GAIL FELDMAN SENIOR MANAGEMENT ANALYST 155494 SENIOR MANAGEMENT ANALYST 148663 -6831.08
MICHAEL J VECCHIO ASSOCIATE TRAFFIC ENGINEER 185443 ASSOCIATE TRAFFIC ENGINEER 178570 -6873
KEVIN M WHITE FIRE LIEUTENANT 225289 FIRE LIEUTENANT 218402 -6887.08
KAREN A KLATT HEALTH SERVICES PROGRAM SPECIA 133410 HEALTH SERVICES PROGRAM SPECIA 126514 -6896.57
TAMIKA GRIFFIN ACCOUNTING OFF SPEC III 105903 ACCOUNTING OFF SPEC III 99006.1 -6896.97
BRIAN H ALEXANDER FIRE APPARATUS OPERATOR 236807 FIRE APPARATUS OPERATOR 229904 -6902.3
SENH D LO BUILDING MAINTENANCE MECHANIC 130341 BUILDING MAINTENANCE MECHANIC 123424 -6916.39
JUMAANE J JONES POLICE OFFICER 204577 POLICE OFFICER 197644 -6932.87
BRIAN J EVANS FIRE CAPTAIN 215502 FIRE CAPTAIN 208535 -6967.59
TAD TRAVIS FIREFIGHTER 229984 FIREFIGHTER 223010 -6974.06
ELIZABETH N SCHIFF TRAINING OFFICER 143567 TRAINING OFFICER 136552 -7014.92
DREW J MILAN OFFICE SPECIALIST II 81615.7 OFFICE SPECIALIST II 74586.2 -7029.45
KATHERINE J LEE HEARING EXAMINER 170390 HEARING EXAMINER 163334 -7056.26
YICK K LO SENIOR ACCOUNTANT 163676 SENIOR ACCOUNTANT 156606 -7069.9
MARLA BRIGNARDELLO ACCOUNTING OFF SPEC III 102287 ACCOUNTING OFF SPEC III 95209.4 -7077.49
LOLITA M CUEVA ASSISTANT MANAGEMENT ANALYST 120409 ASSISTANT MANAGEMENT ANALYST 113286 -7123.09
CHRISTOPHER D WAITE POLICE OFFICER 218614 POLICE OFFICER 211461 -7152.58
S L SHIOZAKI LIBRARY AIDE 49027.8 LIBRARY AIDE 41786.8 -7241.01
ANTONIO CRUZ SOLID WASTE WORKER 151526 SOLID WASTE WORKER 144281 -7244.78
BRIAN B ZANDIPOUR DEPUTY CITY AUDITOR/PAYRL MAN 207616 DEPUTY CITY AUDITOR/PAYRL MAN 200333 -7282.76
WILLIAM H IVIE EQUIPMENT SUPERINTENDENT 176540 EQUIPMENT SUPERINTENDENT 169202 -7337.41
MANUEL M RAMIREZ MANAGER OF ENVIRONMENTAL HEALT 186708 MANAGER OF ENVIRONMENTAL HEALT 179359 -7348.87
ANGEL F ENTES TOOL LENDING SPECIALIST 74662 TOOL LENDING SPECIALIST 67306.5 -7355.46
JAMES J HYNES ASSISTANT TO THE CITY MANAGER 189110 ASSISTANT TO THE CITY MANAGER 181625 -7485.03
DEBRA L HUTTON HEARING EXAMINER 184336 HEARING EXAMINER 176834 -7501.82
JON L PETTUS SOLID WASTE TRUCK DRIVER 139842 SOLID WASTE TRUCK DRIVER 132260 -7582.14
DAVID P GOODALE SERVICE TECHNICIAN 108408 SERVICE TECHNICIAN 100816 -7591.57
MIA D MEDLIN COMMUNITY SERVICE OFFICER SUPV 141207 COMMUNITY SERVICE OFFICER SUPV 133615 -7592.02
LEE N GLOVER-HOLLOWAY PARKING ENFORCEMENT OFFICER 103328 PARKING ENFORCEMENT OFFICER 95689.9 -7638.06
JAY W ELLIOTT COMMUNITY SERVICE OFFICER 127556 COMMUNITY SERVICE OFFICER 119905 -7650.67
LILIA HERNANDEZ COMMUNITY HLTH WRKR SPECIALIST 109530 COMMUNITY HLTH WRKR SPECIALIST 101845 -7684.79
BLYTHE A LUCERO AQUATICS FACILITIES SUPERVISOR 99125.6 AQUATICS FACILITIES SUPERVISOR 91409.2 -7716.42
HARVEY L JOHNSON REG ENVIRONMENTAL HEALTH SPEC 143366 REG ENVIRONMENTAL HEALTH SPEC 135630 -7736.12
RYAN M ANDERSEN POLICE OFFICER 234794 POLICE OFFICER 227050 -7743.47
DONNA TESHIMA MENTAL HLTH CLIN II 126126 MENTAL HLTH CLIN II 118355 -7770.79
VINCENT W CHEN ASSOCIATE CIVIL ENGINEER 186350 ASSOCIATE CIVIL ENGINEER 178571 -7779.76
PAMELA M JOHNSON ASSISTANT PLANNER 127893 ASSISTANT PLANNER 120075 -7818.06
JOHNATHAN K WALKER PARKING ENFORCEMENT OFFICER 96401 PARKING ENFORCEMENT OFFICER 88581.6 -7819.33
NABIL A AL-HADITHY HAZARDOUS MATERIALS MANAGER 194649 HAZARDOUS MATERIALS MANAGER 186820 -7828.74
MOLLY K MCCOY LIBRARY SPECIALIST II 104915 LIBRARY SPECIALIST II 97039.1 -7876.12
NANCYANN F LERMA CUST SERVS SPEC III 109398 CUST SERVS SPEC III 101522 -7876.55
DARRYL G MOORE COUNCILMEMBER 47292.1 COUNCILMEMBER 39391.8 -7900.27
LYNNE E OHLSON PUBLIC SAFETY BUSINESS MANAGER 177064 PUBLIC SAFETY BUSINESS MANAGER 169126 -7938.2
MICHAEL M YANEZ SOLID WASTE TRUCK DRIVER 126978 SOLID WASTE TRUCK DRIVER 119036 -7941.13
JAMES R GEISSINGER FIRE APPARATUS OPERATOR 233426 FIRE APPARATUS OPERATOR 225476 -7949.65
NGAN M TAM ACCOUNTING MANAGER 194114 ACCOUNTING MANAGER 186113 -8000.97
ALONZO BURNHAM PARKING METER MAINTENANCE WORK 114275 PARKING METER MAINTENANCE WORK 106272 -8003.45
STANLEY J ZUKOWSKI FIRE APPARATUS OPERATOR 228161 FIRE APPARATUS OPERATOR 220149 -8011.91
MAGGIE M CHENG SENIOR LEGAL SECRETARY 121526 SENIOR LEGAL SECRETARY 113458 -8068.38
RICKY L HAMILTON JANITOR 102859 JANITOR 94778.1 -8081.31
RAYMOND DAI BUILDING MAINTENANCE MECHANIC 115035 BUILDING MAINTENANCE MECHANIC 106940 -8094.87
MICHAEL H ILVESTA LANDSCAPE GARDENER 107446 LANDSCAPE GARDENER 99338.7 -8107.55
KATHERINE M HARR RENT BOARD COMMISSIONER 21429.9 RENT BOARD COMMISSIONER 13314.4 -8115.57
JAMES R GLENN ASSISTANT MENTAL HEALTH CLINIC 94110.7 ASSISTANT MENTAL HEALTH CLINIC 85990.7 -8119.98
CANDICE L SCHOTT ACCOUNTING TECHNICIAN 101093 ACCOUNTING TECHNICIAN 92961.3 -8131.9
RONALD J RHEM SOLID WASTE WORKER 118345 SOLID WASTE WORKER 110187 -8158.35
JOHNNY B TOLLIVER SOLID WASTE TRUCK DRIVER 128115 SOLID WASTE TRUCK DRIVER 119955 -8160.36
CARLO JUAN G TERUEL FIREFIGHTER 186519 FIREFIGHTER 178356 -8163.08
MELVIN L SUTTON LANDSCAPE EQUIPMENT OPERATOR 132853 LANDSCAPE EQUIPMENT OPERATOR 124674 -8178.5
RENEE PETTUS-ADDISON WEIGHMASTER 134442 WEIGHMASTER 126256 -8185.55
KATINA L JESUITAS PARKING ENFORCEMENT OFFICER 110861 PARKING ENFORCEMENT OFFICER 102655 -8206.34
JOHN R MANN WATERFRONT MANAGER 174273 WATERFRONT MANAGER 166057 -8215.9
HAMID MOSTOWFI SUPERVISING TRAFFIC ENGINEER 211886 SUPERVISING TRAFFIC ENGINEER 203650 -8236.45
ALEC D PATTISON SENIOR FORESTRY CLIMBER 131359 SENIOR FORESTRY CLIMBER 123118 -8240.8
REEVE J BATTLE ASSISTANT PUBLIC WORKS ENGINEE 161635 ASSISTANT PUBLIC WORKS ENGINEE 153365 -8270.41
ADADU YEMANE ASSOCIATE CIVIL ENGINEER 187277 ASSOCIATE CIVIL ENGINEER 178986 -8291.4
GEOFFERY A FIEDLER HAZARDOUS MAT SP II 158677 HAZARDOUS MAT SP II 150382 -8295.25
ROBERT B RITTENHOUSE POLICE SERGEANT 247111 POLICE SERGEANT 238664 -8446.6
ALICIA D ABRAMSON LIBRARY INFO SYS ADMINISTRATOR 168877 LIBRARY INFO SYS ADMINISTRATOR 160406 -8471.01
DOWELL L STANDLEY FIREFIGHTER 189251 FIREFIGHTER 180693 -8558.15
PEMA LHAKEY LIBRARY AIDE 45685.7 LIBRARY AIDE 37124.8 -8560.89
SEAMEW H CHEN COMMUNICATIONS TECHNICIAN 161697 COMMUNICATIONS TECHNICIAN 153075 -8621.81
PERLITA PAYNE OFFICE SPECIALIST II 89976.9 OFFICE SPECIALIST II 81331.3 -8645.68
BRENDA J VELASQUEZ COMMUNICATIONS MANAGER 120942 COMMUNICATIONS MANAGER 112266 -8676.62
FELICIA E ANDERSON OFFICE SPECIALIST III 113108 OFFICE SPECIALIST III 104391 -8716.69
MICHAEL L YU POLICE OFFICER 181694 POLICE OFFICER 172925 -8768.98
JOSEPH E KELLY POLICE OFFICER 197525 POLICE OFFICER 188742 -8783.35
KHOI D NGUYEN BUILDING MAINTENANCE MECHANIC 128076 BUILDING MAINTENANCE MECHANIC 119285 -8791.18
JAMES A LIBERATORE FIREFIGHTER 189771 FIREFIGHTER 180980 -8791.49
DORI P TIEU FIREFIGHTER 192764 FIREFIGHTER 183953 -8810.83
LORIN W JENSEN SUPERVISING CIVIL ENGINEER 203922 SUPERVISING CIVIL ENGINEER 195083 -8838.11
ANDRES T HERRERA SOLID WASTE WORKER 115539 SOLID WASTE WORKER 106685 -8853.55
KENYON A BURNS PARKING ENFORCEMENT OFFICER 102170 PARKING ENFORCEMENT OFFICER 93300.2 -8869.56
FRANCINE N ORTEGA PSYCH SOC WKR II 128343 PSYCH SOC WKR II 119463 -8880.4
AARON P DIEKEN TRAFFIC MAINT WKR I 108753 TRAFFIC MAINT WKR I 99871.6 -8881.84
SHERALYN R PADUA POLICE OFFICER 193243 POLICE OFFICER 184346 -8897.12
ROBERT L HICKS DIRECTOR OF FINANCE 232430 DIRECTOR OF FINANCE 223519 -8911.35
KENNETH N EMEZIEM SUPERVISING CIVIL ENGINEER 197444 SUPERVISING CIVIL ENGINEER 188497 -8947.73
BERNARD HAYES WEIGHMASTER 125924 WEIGHMASTER 116964 -8959.92
RICKY M DAVIS SOLID WASTE SUPERVISOR 139509 SOLID WASTE SUPERVISOR 130505 -9004.39
GWENDOLYN Y BROWN POLICE OFFICER 240650 POLICE OFFICER 231643 -9006.98
CESAR C MELERO POLICE SERGEANT 274009 POLICE SERGEANT 264999 -9009.49
MATTHEW C HECKENLIVELY PARKING ENFORCEMENT OFFICER 96457.8 PARKING ENFORCEMENT OFFICER 87445.4 -9012.34
TERESA N ALBRO LIBRARY SPECIALIST II 64602.5 LIBRARY SPECIALIST II 55567.2 -9035.29
NORA B HALE LIBRARIAN II 127634 LIBRARIAN II 118541 -9092.74
FARID JAVANDEL TRANSPORTATION MANAGER 225736 TRANSPORTATION MANAGER 216558 -9178.65
ANDRES DIAZ ISLAS CONTAINER MAINTENANCE WELDER 101452 CONTAINER MAINTENANCE WELDER 92245.9 -9206.01
JERRY L COOK PARKING ENFORCEMENT OFFICER 109064 PARKING ENFORCEMENT OFFICER 99752.8 -9310.79
THOMAS J CURTIN POLICE SERGEANT 276633 POLICE SERGEANT 267244 -9388.36
DEIRDRE A CERKANOWICZ LIBRARY SPECIALIST II 55598.7 LIBRARY SPECIALIST II 46209.4 -9389.33
COLIN M ARNOLD FIRE APPARATUS OPERATOR 178743 FIRE APPARATUS OPERATOR 169350 -9393.45
JUAN CAMACHO BUILDING MAINTENANCE MECHANIC 128890 BUILDING MAINTENANCE MECHANIC 119464 -9426.49
ADRIAN P MERRY ENGINEERING INSPECTOR 144790 ENGINEERING INSPECTOR 135319 -9470.93
RAY J YOUNG SERVICE TECHNICIAN 129189 SERVICE TECHNICIAN 119715 -9473.84
KERK A ROSS PUBLIC WORKS SUPERVISOR 149818 PUBLIC WORKS SUPERVISOR 140288 -9529.92
MARY ANN MERKER CIVIC ARTS COORDINATOR 140796 CIVIC ARTS COORDINATOR 131256 -9540.4
KEVIN M LEWIS SENIOR PUBLIC WORKS SUPERVISOR 151030 SENIOR PUBLIC WORKS SUPERVISOR 141484 -9546.27
DOMINIC S MORENO MARINA ASSISTANT 106666 MARINA ASSISTANT 97091.3 -9574.8
STUART K SWANSON LANDSCAPE GARDENER SUPERVISOR 134301 LANDSCAPE GARDENER SUPERVISOR 124698 -9603.01
CARRIE A ESTADT HAZARDOUS MAT SP II 147094 HAZARDOUS MAT SP II 137453 -9641.74
LAWRENCE ANDERSON LABORER 96214.5 LABORER 86534.4 -9680.12
JULIO A BERMUDEZ BUILDING MAINTENANCE MECHANIC 115299 BUILDING MAINTENANCE MECHANIC 105591 -9707.6
VAL L DIZITSER SENIOR BUILDING PLANS ENGINEER 197834 SENIOR BUILDING PLANS ENGINEER 188094 -9740
JOHN E CROCHET JR TRACTOR TRAILER DRIVER 150541 TRACTOR TRAILER DRIVER 140764 -9776.54
JAMES M GORDON LANDSCAPE EQUIPMENT OPERATOR 117841 LANDSCAPE EQUIPMENT OPERATOR 108050 -9790.8
MICHELLE F CRANE ASSOCIATE PLANNER 146543 ASSOCIATE PLANNER 136709 -9833.76
LOURDES P CHANG COMMUNITY DEVELOP PROJCT COORD 143412 COMMUNITY DEVELOP PROJCT COORD 133564 -9847.67
MARCUS D FIELDS POLICE OFFICER 203676 POLICE OFFICER 193824 -9852.18
MONIQUE R FROST PUBLIC SAFETY DISPATCHER II 159171 PUBLIC SAFETY DISPATCHER II 149302 -9868.19
VALERIE J NELSON INFORMATION SYSTEMS SPECIALIST 137238 INFORMATION SYSTEMS SPECIALIST 127345 -9892.79
TODD C SABINS POLICE SERGEANT 296987 POLICE SERGEANT 287073 -9913.82
TAY C WOODS SOLID WASTE WORKER 104590 SOLID WASTE WORKER 94661.8 -9928.13
JENNY P CHEW SYSTEMS ACCOUNTANT 179682 SYSTEMS ACCOUNTANT 169746 -9936.57
FAWN K DOWNS MENTAL HEALTH PROGRAM SUPERVIS 174615 MENTAL HEALTH PROGRAM SUPERVIS 164662 -9953.02
JOSE MARTINEZ SOLID WASTE TRUCK DRIVER 152949 SOLID WASTE TRUCK DRIVER 142884 -10065.4
ALFREDO J GONGORA MARINA ASSISTANT 110380 MARINA ASSISTANT 100250 -10130
WILLIAM W LIANG SOLID WASTE WORKER 105825 SOLID WASTE WORKER 95688.8 -10136.2
THOMAS B DODGE SENIOR FORESTRY CLIMBER 114462 SENIOR FORESTRY CLIMBER 104268 -10194.3
JOSE L MATA CONCRETE FINISHER 131363 CONCRETE FINISHER 121123 -10240
SAFIYA K LEWIS LANDSCAPE GARDENER 108814 LANDSCAPE GARDENER 98495.9 -10318
RICHARD A NAVARRO PUBLIC WORKS SUPERVISOR 168325 PUBLIC WORKS SUPERVISOR 157996 -10328.8
ERISTEO M SANCHEZ JANITOR 91881.5 JANITOR 81521 -10360.5
JAMES J KELEKIAN EXECUTIVE DIRECTOR RENT BOARD 283950 EXECUTIVE DIRECTOR RENT BOARD 273578 -10372.7
CAROL J PETERS MID-LEVEL PRACTITIONER 87626.7 MID-LEVEL PRACTITIONER 77221.7 -10404.9
ROBERT E JOHNSON TRACTOR TRAILER DRIVER 153593 TRACTOR TRAILER DRIVER 143188 -10405.5
JAMES T WILLIAMS MECHANICAL SWEEPER OPERATOR 128341 MECHANICAL SWEEPER OPERATOR 117905 -10436.3
MANUEL HECTOR SENIOR MANAGEMENT ANALYST 159514 SENIOR MANAGEMENT ANALYST 149027 -10486.7
RYAN D MCCANN CUST SERVS SPEC III 106622 CUST SERVS SPEC III 96108.6 -10512.9
CARLOS R RODRIGUEZ FIREFIGHTER 187280 FIREFIGHTER 176761 -10519.4
TRACY L HILL MECHANICAL SWEEPER OPERATOR 129354 MECHANICAL SWEEPER OPERATOR 118768 -10585.7
JACOB I SEVERAL LANDSCAPE GARDENER 114937 LANDSCAPE GARDENER 104341 -10596.1
JUAN J MENDIOLA CONTAINER MAINTENANCE WELDER 113987 CONTAINER MAINTENANCE WELDER 103387 -10599.5
STANLEY J FERNANDEZ FIRE PREVENTION INSPECTOR 188991 FIRE PREVENTION INSPECTOR 178388 -10602.4
WINSTON F GILCHRIST LABORER 118710 LABORER 108049 -10661
AMELIA M FUNGHI COMMUNITY SERVS SP I 119596 COMMUNITY SERVS SP I 108930 -10665.7
GERALD I LOVE CODE ENFORCEMENT OFFICER II 142012 CODE ENFORCEMENT OFFICER II 131315 -10697.3
STEVE A HAMMILL LANDSCAPE GARDENER 122620 LANDSCAPE GARDENER 111914 -10705.5
JERRY L BROWN SOLID WASTE TRUCK DRIVER 126386 SOLID WASTE TRUCK DRIVER 115618 -10767.3
LEVI L HARDWICK SOLID WASTE TRUCK DRIVER 133364 SOLID WASTE TRUCK DRIVER 122551 -10812.4
DARYL B BRAND MENTAL HLTH CLIN II 143570 MENTAL HLTH CLIN II 132754 -10815.5
EARL B ELZY SEWER MAINTENANCE ASST SUPV 146371 SEWER MAINTENANCE ASST SUPV 135529 -10841.6
ANGELA R NELSON MARINA ASSISTANT 95190.1 MARINA ASSISTANT 84330.9 -10859.3
SANDRA K DAVIS PARKING ENFORCEMENT OFFICER 127621 PARKING ENFORCEMENT OFFICER 116758 -10863.2
ROCHELL B BLEDSOE POLICE OFFICER 226995 POLICE OFFICER 216114 -10880.7
CHARLENE Y HAYASHIDA OFFICE SPECIALIST III 102745 OFFICE SPECIALIST III 91858.9 -10886.3
JOHN J CONTI FIRE APPARATUS OPERATOR 193593 FIRE APPARATUS OPERATOR 182707 -10886.3
DANIELLE HALL COMMUNITY HEALTH WORKER 90513.1 COMMUNITY HEALTH WORKER 79591 -10922.1
SUSAN R HUISH SUPERVISING LIBRARY ASSISTANT 105413 SUPERVISING LIBRARY ASSISTANT 94464.9 -10948.4
MARVIN L COSPER SOLID WASTE WORKER 106111 SOLID WASTE WORKER 95134.9 -10975.7
HAROLD E SUAN ENGINEERING INSPECTOR 137797 ENGINEERING INSPECTOR 126800 -10996.3
WARREN G DAVIS FIRE CAPTAIN 271670 FIRE CAPTAIN 260604 -11065.9
GARY C LAWSON LABORER 102123 LABORER 91019.2 -11104
JOHN A HURTADO PUBLIC WORKS SUPERVISOR 179867 PUBLIC WORKS SUPERVISOR 168751 -11116.4
JITENDRA B SINGH POLICE OFFICER 220540 POLICE OFFICER 209415 -11124.8
WILLIAM C EDWARDS ELECTRICIAN 166696 ELECTRICIAN 155568 -11128.5
PETE MAUL SOLID WASTE LOADER OPERATOR 153323 SOLID WASTE LOADER OPERATOR 142170 -11152.9
PETER T REED FIRE APPARATUS OPERATOR 197583 FIRE APPARATUS OPERATOR 186345 -11237.4
ANN-MARIE P HOGAN CITY AUDITOR 220611 CITY AUDITOR 209344 -11266.8
TONY Y PANG CONSTRUCTION EQUIPMENT OPERATO 129992 CONSTRUCTION EQUIPMENT OPERATO 118699 -11293.1
DANTE A MARTINEZ SOLID WASTE TRUCK DRIVER 107831 SOLID WASTE TRUCK DRIVER 96535.4 -11295.8
JAMAL L CUNNINGHAM TRAFFIC MAINT WKR I 114728 TRAFFIC MAINT WKR I 103406 -11322.5
CHRISTOPHER L BONAVENTURE POLICE OFFICER 231290 POLICE OFFICER 219924 -11365.2
JENNIFER A TATE POLICE SERGEANT 257320 POLICE SERGEANT 245936 -11384.5
BRIAN A MATHIS POLICE OFFICER 224660 POLICE OFFICER 213272 -11388.2
DOUGLAS K MCDONALD SENIOR LANDSCAPE GARDENER SUPE 171184 SENIOR LANDSCAPE GARDENER SUPE 159728 -11455.9
SAMANTHA M SPEELMAN POLICE OFFICER 206645 POLICE OFFICER 195157 -11487.5
IAN A PAYNE SOLID WASTE WORKER 115679 SOLID WASTE WORKER 104181 -11497.2
ANN R HARDINGER HARBORMASTER 134922 HARBORMASTER 123264 -11658.7
LYESHA GARRETT PARKING ENFORCEMENT OFFICER 110989 PARKING ENFORCEMENT OFFICER 99224.8 -11764.4
JOHN LEWIS POLICE OFFICER 234489 POLICE OFFICER 222712 -11777.6
FRISBIE D GOODALL SKILLED LABORER 115800 SKILLED LABORER 103960 -11839.7
MELVIN R HOLMES SOLID WASTE WORKER 108602 SOLID WASTE WORKER 96732 -11870
KEIR S RANKIN FIRE LIEUTENANT 200977 FIRE LIEUTENANT 189082 -11895.2
SCOTT V NGUYEN LANDSCAPE GARDENER 126889 LANDSCAPE GARDENER 114978 -11910.9
JEFFREY R THOMAS SENIOR BUILDING PLANS ENGINEER 192413 SENIOR BUILDING PLANS ENGINEER 180435 -11977.3
EFRAIN GONZALEZ WEIGHMASTER 130102 WEIGHMASTER 118113 -11989.1
FOSTER C GOREE ANIMAL SERVICES ASSISTANT 100126 ANIMAL SERVICES ASSISTANT 88047.4 -12079
PAMELA M BOLAND SENIOR LANDSCAPE GARDENER 110638 SENIOR LANDSCAPE GARDENER 98543.2 -12094.9
RON A MASON SOLID WASTE TRUCK DRIVER 127424 SOLID WASTE TRUCK DRIVER 115307 -12116.6
GREGORIO GONZALEZ SOLID WASTE TRUCK DRIVER 138297 SOLID WASTE TRUCK DRIVER 126178 -12119
JANET E CUSICK PUBLIC HEALTH NURSE 151778 PUBLIC HEALTH NURSE 139656 -12122.1
ANTHONY T PIPPINS SOLID WASTE WORKER 130673 SOLID WASTE WORKER 118475 -12198
TOMMIE O TOLER JANITOR 91216.3 JANITOR 78994.9 -12221.5
RONALD G BRILL BUILDING MAINTENANCE MECHANIC 121870 BUILDING MAINTENANCE MECHANIC 109621 -12249.1
BRUCE D MAZUR SERVICE TECHNICIAN 115618 SERVICE TECHNICIAN 103300 -12318
MICHAEL J CAPLAN ECONOMIC DEVELOPMENT MANAGER 188982 ECONOMIC DEVELOPMENT MANAGER 176610 -12371.6
BRIAN K MCDONALD SOLID WASTE TRUCK DRIVER 127190 SOLID WASTE TRUCK DRIVER 114799 -12390.9
JOSEPH E OKIES POLICE SERGEANT 257440 POLICE SERGEANT 245043 -12396.8
TRACY L RANDLE PARKING ENFORCEMENT OFFICER 111774 PARKING ENFORCEMENT OFFICER 99338.2 -12436.2
ERIC M ANDERSON ASSOCIATE PLANNER 131640 ASSOCIATE PLANNER 119201 -12439.4
ROLANDO S VARGAS MECHANIC 140292 MECHANIC 127841 -12451.2
JEAN P COSTES MECHANIC 149620 MECHANIC 137155 -12465.4
CHRISTINA E PINKNEY PARKING ENFORCEMENT OFFICER 114641 PARKING ENFORCEMENT OFFICER 102169 -12472.6
ANDREW E KING MANAGER OF HOUSING & COMM SRVC 172525 MANAGER OF HOUSING & COMM SRVC 160046 -12479.2
JENNIFER S WILSON POLICE SERGEANT 231215 POLICE SERGEANT 218657 -12557.7
MICHELLE M PEDRO LANDSCAPE GARDENER 106453 LANDSCAPE GARDENER 93887.7 -12565.7
CRAIG W LINDENAU POLICE SERGEANT 298539 POLICE SERGEANT 285886 -12653.3
LOUIS CORNELIUS LABORER 101610 LABORER 88939.9 -12669.7
BAIRD R BARTON CHIEF OF PARTY 153062 CHIEF OF PARTY 140290 -12772.9
KENNETH D STEPHENS SR SOLID WASTE TRUCK DRIVER 127869 SOLID WASTE TRUCK DRIVER 115064 -12805.4
BRIAN S KISHIYAMA POLICE OFFICER 220462 POLICE OFFICER 207643 -12819.7
STEPHEN M LINK POLICE OFFICER 199873 POLICE OFFICER 187033 -12840.3
MICHAEL E SHUKEN FIREFIGHTER 185142 FIREFIGHTER 172282 -12859.3
STEVEN P DOUGLAS BUILDING MAINTENANCE SUPERVISO 146303 BUILDING MAINTENANCE SUPERVISO 133394 -12908.6
HUGO N MELARA JANITOR 98571 JANITOR 85651.7 -12919.3
FREDERICK DOUGLAS SOLID WASTE TRUCK DRIVER 132259 SOLID WASTE TRUCK DRIVER 119307 -12952.4
STEVEN A FLEMING POLICE OFFICER 229589 POLICE OFFICER 216595 -12993.6
JACK V DARROW LANDSCAPE GARDENER 112119 LANDSCAPE GARDENER 99114.2 -13005.1
RICHARD A CORCORAN ELECTRICIAN 173314 ELECTRICIAN 160290 -13024.1
EDWARD A SPILLER POLICE LIEUTENANT 321150 POLICE LIEUTENANT 308123 -13026.8
ANA C BABER POLICE OFFICER 207155 POLICE OFFICER 194068 -13086.8
ALONZO CHESS LANDSCAPE GARDENER SUPERVISOR 147480 LANDSCAPE GARDENER SUPERVISOR 134327 -13152.6
ARISTEO J RAMIREZ LANDSCAPE GARDENER 105499 LANDSCAPE GARDENER 92330.9 -13168.5
ROSEMARY FONSECA COMMUNITY HEALTH WORKER 85003.1 COMMUNITY HEALTH WORKER 71803.6 -13199.5
JESUS U RIVERA WAREHOUSE OPERATIONS SPECIALIS 122496 WAREHOUSE OPERATIONS SPECIALIS 109279 -13217.2
DARREN R BOBROSKY FIRE LIEUTENANT 202134 FIRE LIEUTENANT 188902 -13231.1
CHARLES CAMPOS LANDSCAPE GARDENER 117662 LANDSCAPE GARDENER 104352 -13309.6
JERALD E FORD SOLID WASTE TRUCK DRIVER 143610 SOLID WASTE TRUCK DRIVER 130297 -13312.4
BRANDON C SMITH POLICE OFFICER 211267 POLICE OFFICER 197920 -13347.5
RICHARD E MARIN POLICE OFFICER 215595 POLICE OFFICER 202202 -13393.1
JAY J DORNBURG LABORER 99669.1 LABORER 86146 -13523.1
RACHEL A MACNEILLY SUPERVISING LIBRARIAN 147990 SUPERVISING LIBRARIAN 134437 -13552.3
ELIZABETH A STERNER SENIOR HEALTH SERV PROG SPECIA 142328 SENIOR HEALTH SERV PROG SPECIA 128764 -13563.9
TIMOTHY D KAPLAN POLICE OFFICER 216811 POLICE OFFICER 203236 -13574.1
APRIL L STEVENSON ANIMAL CONTROL OFFICER 112042 ANIMAL CONTROL OFFICER 98357.4 -13684.6
BILLI L ROMAIN COMMUNITY SERVS SP III 159191 COMMUNITY SERVS SP III 145487 -13704.1
HUGO R ORDAZ POLICE OFFICER 216458 POLICE OFFICER 202690 -13767.5
DAVID C BARTALINI POLICE OFFICER 212328 POLICE OFFICER 198547 -13781.8
LEAH T WILSON SCHOOL BOARD DIRECTOR 18636.4 SCHOOL BOARD DIRECTOR 4846.17 -13790.2
ROBYN C FUENTES POLICE OFFICER 192754 POLICE OFFICER 178902 -13852.1
RYAN K MURRAY POLICE OFFICER 211660 POLICE OFFICER 197694 -13966
JEFFREY L EGEBERG MANAGER OF ENGINEERING 237024 MANAGER OF ENGINEERING 223045 -13978.5
ALAN BERN LIBRARIAN II 137474 LIBRARIAN II 123485 -13988.7
DAVID S MCPARTLAND FIREFIGHTER 195928 FIREFIGHTER 181923 -14005
TIMOTHY V MASSEY BUILDING MAINTENANCE MECHANIC 117260 BUILDING MAINTENANCE MECHANIC 103243 -14017.6
FERMIN RODRIGUEZ FORESTRY CLIMBER 122979 FORESTRY CLIMBER 108957 -14021.6
NIKKI A HOVIS FIELD REPRESENTATIVE 95511 FIELD REPRESENTATIVE 81450.5 -14060.5
LUTHER WEST SOLID WASTE SUPERVISOR 164060 SOLID WASTE SUPERVISOR 149966 -14094.1
TIMOTHY C GORNE ANIMAL SERVICES ASSISTANT 96473.7 ANIMAL SERVICES ASSISTANT 82331.1 -14142.6
ALAN H DUNN POLICE OFFICER 229166 POLICE OFFICER 214996 -14169.8
JOSE E AREAS LANDSCAPE GARDENER 111848 LANDSCAPE GARDENER 97678 -14169.8
HUNG C NGUYEN LABORER 124214 LABORER 109946 -14267.8
AMELIA M TAVISTOCK LIBRARY ASSISTANT 51056.4 LIBRARY ASSISTANT 36769.8 -14286.7
LESLIE F DOZIER COMMUNITY SERVICE OFFICER 119281 COMMUNITY SERVICE OFFICER 104964 -14317
WILLIAM A THOMPSON MECHANIC LEAD 170048 MECHANIC LEAD 155692 -14356.8
THOMAS N SUTTLES LANDSCAPE GARDENER 115368 LANDSCAPE GARDENER 100955 -14413.9
FREDRICK L WILLIAMS SOLID WASTE TRUCK DRIVER 120521 SOLID WASTE TRUCK DRIVER 106048 -14473.6
RICHARD P RESAVY MECHANIC 151355 MECHANIC 136862 -14493.2
DAVID E BEESLEY ELECTRICIAN 151155 ELECTRICIAN 136633 -14522
CARL A BOSCOE PARKING ENFORCEMENT OFFICER 110346 PARKING ENFORCEMENT OFFICER 95777.6 -14568.4
DAVID C MCRAY BUILDING MAINTENANCE MECHANIC 141919 BUILDING MAINTENANCE MECHANIC 127339 -14579.3
JOHN R TARASCIO FIRE LIEUTENANT 314248 FIRE LIEUTENANT 299597 -14650.9
JOHN VERELLO MECHANIC 126136 MECHANIC 111325 -14810.4
MELVIN PONDER SOLID WASTE WORKER 131739 SOLID WASTE WORKER 116919 -14819.7
ADAM M COOKE FIRE APPARATUS OPERATOR 193486 FIRE APPARATUS OPERATOR 178563 -14922.8
DEON G CATLETT LABORER 99103.7 LABORER 84153.2 -14950.6
MARC R MESTROVICH FIRE APPARATUS OPERATOR 197169 FIRE APPARATUS OPERATOR 182210 -14958.9
JUAN C MENDOZA BUILDING MAINTENANCE MECHANIC 126509 BUILDING MAINTENANCE MECHANIC 111490 -15018.8
ANTHONY HALL III FIREFIGHTER 209604 FIREFIGHTER 194516 -15087.3
CLAYTON BOATWRIGHT BUILDING MAINTENANCE MECHANIC 130544 BUILDING MAINTENANCE MECHANIC 115455 -15088.8
ELGIN L MCINTOSH POLICE OFFICER 235359 POLICE OFFICER 220258 -15101.4
BETSY E REEVES FORESTRY TECHNICIAN 147817 FORESTRY TECHNICIAN 132558 -15259.2
DWAIN F HELM MECHANIC 146264 MECHANIC 130950 -15314.2
ADAN GONZALEZ LABORER 103143 LABORER 87792.6 -15350.7
MATTHEW MORIZONO POLICE LIEUTENANT 308854 POLICE LIEUTENANT 293470 -15384.3
MATTHEW B MEREDITH POLICE OFFICER 230455 POLICE OFFICER 215057 -15398
ALAN W ROBERDS POLICE OFFICER 217534 POLICE OFFICER 202121 -15412.7
SCOTT M CASTLE POLICE OFFICER 236146 POLICE OFFICER 220667 -15479
BERNADETTE A LOPES OFFICE SPECIALIST III 98243.6 OFFICE SPECIALIST III 82715.9 -15527.8
KENNETH B TU POLICE OFFICER 205648 POLICE OFFICER 190117 -15530.7
MITCHELL D COLLINS POLICE OFFICER 228650 POLICE OFFICER 213083 -15567.3
EVANGELINE G VILLAGOMEZ FIELD REPRESENTATIVE 97357.4 FIELD REPRESENTATIVE 81728.1 -15629.3
STEPHEN A JANIK PSYCH SOC WKR II 120320 PSYCH SOC WKR II 104655 -15665.1
VICTORIA SCHLEPP OFFICE SPECIALIST III 105161 OFFICE SPECIALIST III 89488.7 -15671.8
FRANCISCO G MELENDEZ SENIOR FORESTRY CLIMBER 124772 SENIOR FORESTRY CLIMBER 108982 -15789.6
SAMANTHA A BAKER PARKING MTR MTC & COLLECT SUPV 154924 PARKING MTR MTC & COLLECT SUPV 139125 -15799.2
ZACHARY D COWAN CITY ATTORNEY 277050 CITY ATTORNEY 261213 -15837.2
DOUGLAS L SCOTT JANITOR SUPERVISOR 128907 JANITOR SUPERVISOR 113013 -15893.8
JACK A FRIEDMAN POLICE SERGEANT 249255 POLICE SERGEANT 233329 -15926.6
VICTOR M PAEZ SKILLED LABORER 131560 SKILLED LABORER 115563 -15997.8
RANDALL W MCCOY SKILLED LABORER 120196 SKILLED LABORER 104189 -16007.1
TRACY HAASE ELECTRICIAN 138310 ELECTRICIAN 122302 -16008.4
KYL C FLEMING FIREFIGHTER 211457 FIREFIGHTER 195320 -16137.3
LIONEL BRACKINS SOLID WASTE TRUCK DRIVER 145458 SOLID WASTE TRUCK DRIVER 129056 -16402.3
JONATHAN M PIQUE FIRE APPARATUS OPERATOR 193228 FIRE APPARATUS OPERATOR 176757 -16470.9
SEAN M TINNEY POLICE OFFICER 213195 POLICE OFFICER 196680 -16515.3
WILLIAM B PACE BUILDING MAINTENANCE MECHANIC 133094 BUILDING MAINTENANCE MECHANIC 116482 -16612
KENNETH K JOHNSTON BUILDING MAINTENANCE SUPERVISO 159884 BUILDING MAINTENANCE SUPERVISO 143270 -16614.3
EDWARD G MILANO FORESTRY CLIMBER 132171 FORESTRY CLIMBER 115503 -16668.4
JAMES E FIELDS SOLID WASTE WORKER 114307 SOLID WASTE WORKER 97632.6 -16673.9
TIM A LENNON BUILDING MAINTENANCE MECHANIC 145101 BUILDING MAINTENANCE MECHANIC 128364 -16737.1
ARTHUR B BOADO ROSARIAN 119081 ROSARIAN 102262 -16818.6
DARREN M KACALEK POLICE OFFICER 282073 POLICE OFFICER 265197 -16875.9
JUSTIN A IRONSIDE FIRE APPARATUS OPERATOR 231340 FIRE APPARATUS OPERATOR 214303 -17036.8
KEVIN A REECE POLICE SERGEANT 290780 POLICE SERGEANT 273739 -17041
SEAN B ROSS POLICE SERGEANT 281637 POLICE SERGEANT 264564 -17072.4
WAYNE C ANDERSON SENIOR SOLID WASTE SUPERVISOR 194851 SENIOR SOLID WASTE SUPERVISOR 177705 -17146.5
JESUS F SANDOVAL PUBLIC WORKS SUPERVISOR 164325 PUBLIC WORKS SUPERVISOR 147126 -17198.7
EDWARD G SILVA SENIOR EQUIPMENT SUPERVISOR 156811 SENIOR EQUIPMENT SUPERVISOR 139608 -17203
GEORGE B DANIELSON SENIOR PUBLIC WORKS SUPERVISOR 160911 SENIOR PUBLIC WORKS SUPERVISOR 143678 -17232.4
PAULA M HAMMONDS POLICE OFFICER 198160 POLICE OFFICER 180895 -17264.9
RICARDO V MORALES SOLID WASTE TRUCK DRIVER 135566 SOLID WASTE TRUCK DRIVER 118225 -17340.4
DARRIN J RAFFERTY POLICE OFFICER 252526 POLICE OFFICER 235129 -17396.5
ALICIA M ESCAMILLA-MCNIE COMMUNITY SERVICE OFFICER SUPV 128393 COMMUNITY SERVICE OFFICER SUPV 110957 -17436.1
CATHERINE C JAMISON COMMUNITY SERVICE OFFICER SUPV 143503 COMMUNITY SERVICE OFFICER SUPV 125925 -17578.6
DAVID A GABRINER FIRE APPARATUS OPERATOR 193552 FIRE APPARATUS OPERATOR 175972 -17579.6
ARTURO ROSALES MECHANIC 147681 MECHANIC 130088 -17592.1
CLEOPHAS FORT PARKING ENFORCEMENT OFFICER 123083 PARKING ENFORCEMENT OFFICER 105462 -17621
JOHN R ETTARE POLICE OFFICER 213426 POLICE OFFICER 195728 -17697.4
JENNIFER M VASQUEZ ASSOCIATE MANAGEMENT ANALYST 139641 ASSOCIATE MANAGEMENT ANALYST 121824 -17816.3
LATARGIE V PERNELL OFFICE SPECIALIST III 127588 OFFICE SPECIALIST III 109761 -17826.8
BENJAMIN S WYNN COMMUNITY SERVICE OFFICER 129415 COMMUNITY SERVICE OFFICER 111575 -17840.2
FREDERICK J HALL LABORER 112188 LABORER 94300.9 -17886.9
GREGORY A LUCHINI SOLID WASTE TRUCK DRIVER 138286 SOLID WASTE TRUCK DRIVER 120275 -18011.6
FRANCISCO J PADILLA FORESTRY CLIMBER 135826 FORESTRY CLIMBER 117791 -18035.1
SCOTT N SALAS POLICE OFFICER 232758 POLICE OFFICER 214550 -18208.9
GREGORY A MARWICK LEAD COMMUNICATIONS TECHNICIAN 173638 LEAD COMMUNICATIONS TECHNICIAN 155304 -18334.3
SUSAN S LEE POLICE OFFICER 235222 POLICE OFFICER 216720 -18502.4
CUAUHTEMOC VARGAS COMMUNITY SERVICE OFFICER 135552 COMMUNITY SERVICE OFFICER 117013 -18539.1
RUBEN GARCIA SOLID WASTE TRUCK DRIVER 148240 SOLID WASTE TRUCK DRIVER 129503 -18737.2
MARILYN C BROOKS ACCOUNTING OFF SPEC SUPERV 151091 ACCOUNTING OFF SPEC SUPERV 132334 -18756.8
HERMAN G SCOTT TRAFFIC MAINT WKR I 95848.2 TRAFFIC MAINT WKR I 77045 -18803.2
JOHNNIE W MYERS MECHANIC 148511 MECHANIC 129676 -18834.5
PATRICK C EVANS SERVICE TECHNICIAN 128095 SERVICE TECHNICIAN 109244 -18851.5
KATHERINE L NAVARRETE PARKING ENFORCEMENT OFFICER 95724 PARKING ENFORCEMENT OFFICER 76820.4 -18903.6
CESAR PEREZ SOLID WASTE WORKER 117444 SOLID WASTE WORKER 98522.8 -18921.3
ZI H YANG SOLID WASTE LOADER OPERATOR 170409 SOLID WASTE LOADER OPERATOR 151422 -18987.7
LOREN S CHASE FIRE APPARATUS OPERATOR 206629 FIRE APPARATUS OPERATOR 187498 -19131.4
BERNARD A BAUTISTA SOLID WASTE WORKER 117328 SOLID WASTE WORKER 98161.2 -19166.5
DARRELL OWENS SEWER MAINTENANCE ASST SUPV 152157 SEWER MAINTENANCE ASST SUPV 132851 -19306.5
RICHARD M GUZMAN FIRE CAPTAIN 297274 FIRE CAPTAIN 277886 -19387.8
ERIK M UPSON POLICE CAPTAIN 335577 POLICE CAPTAIN 316151 -19426.1
RANDOLPH FILES POLICE LIEUTENANT 324580 POLICE LIEUTENANT 305058 -19521.9
CALVIN W METTLER FIREFIGHTER 184352 FIREFIGHTER 164829 -19523.2
VICTOR P MARTINEZ POLICE OFFICER 208293 POLICE OFFICER 188754 -19538.9
KRISTI J CHOI ASSOCIATE MANAGEMENT ANALYST 127806 ASSOCIATE MANAGEMENT ANALYST 108191 -19614.8
WILLIAM C BILLAU FIRE LIEUTENANT 201368 FIRE LIEUTENANT 181670 -19698.3
RICHARD R GARCIA LANDSCAPE GARDENER 106102 LANDSCAPE GARDENER 86348.3 -19753.8
CASIMIRO PIERANTONI POLICE OFFICER 230709 POLICE OFFICER 210940 -19768.7
DONNA L MCCRACKEN ASSISTANT FIRE CHIEF 270006 ASSISTANT FIRE CHIEF 250172 -19834.2
NATHANIEL GIRARD FIRE LIEUTENANT 259802 FIRE LIEUTENANT 239916 -19885.7
MICHAEL R DURBIN POLICE SERGEANT 281063 POLICE SERGEANT 261170 -19893
NUALA J RUDDELL REGISTERED NURSE 132376 REGISTERED NURSE 112397 -19978.8
MICHAEL A HUERTA POLICE OFFICER 215541 POLICE OFFICER 195503 -20037.8
ROBERT W LAWRENCE FIRE APPARATUS OPERATOR 229240 FIRE APPARATUS OPERATOR 209166 -20073.9
PATRICK D REGAN LIBRARY AIDE 53761.3 LIBRARY AIDE 33489.4 -20271.9
ALFONSO L MUNOZ FIRE APPARATUS OPERATOR 229370 FIRE APPARATUS OPERATOR 208731 -20638.8
VICTORIA S CREWS POLICE OFFICER 208104 POLICE OFFICER 187345 -20759.2
CLIFFORD E BROOME FIRE APPARATUS OPERATOR 227140 FIRE APPARATUS OPERATOR 206341 -20799.1
JASON B ADAMS FIREFIGHTER 197595 FIREFIGHTER 176719 -20876.3
KEVIN S BOONE FIRE APPARATUS OPERATOR 208559 FIRE APPARATUS OPERATOR 187636 -20922.9
MICHAEL K MEEHAN POLICE CHIEF 337595 POLICE CHIEF 316636 -20958.9
MANUEL ESPINOSA SOLID WASTE TRUCK DRIVER 140689 SOLID WASTE TRUCK DRIVER 119408 -21281.4
J CARMEN G RODRIGUEZ LANDSCAPE GARDENER 122030 LANDSCAPE GARDENER 100611 -21418.3
MICHAEL E MCKINNEY PARKING METER MECHANIC 135362 PARKING METER MECHANIC 113917 -21445.7
JEROME D COBERT POLICE OFFICER 222423 POLICE OFFICER 200967 -21455.9
JESSYCA A NABOZNY POLICE OFFICER 236969 POLICE OFFICER 215377 -21592
SKYLER G RAMEY POLICE OFFICER 216877 POLICE OFFICER 195225 -21651.5
GREG J LOUZAO FIREFIGHTER 219354 FIREFIGHTER 197650 -21703.9
DAN N THIGPEN SOLID WASTE WORKER 122491 SOLID WASTE WORKER 100782 -21708.9
NICOLE L DRAKE LEGISLATIVE ASSISTANT 95041.6 LEGISLATIVE ASSISTANT 73281 -21760.7
NAFEZ H SARI SOLID WASTE WORKER 135125 SOLID WASTE WORKER 113259 -21865.6
ROSS H KASSEBAUM POLICE OFFICER 216530 POLICE OFFICER 194578 -21952.6
JOHN N BARRETT TRACTOR TRAILER DRIVER 144481 TRACTOR TRAILER DRIVER 122334 -22147.4
JENNIFER R COATS POLICE OFFICER 246998 POLICE OFFICER 224681 -22316.8
GLENN G PON POLICE OFFICER 243790 POLICE OFFICER 221453 -22336.7
JEFFREY W MORINO FIRE LIEUTENANT 240238 FIRE LIEUTENANT 217776 -22461.8
KAREN PARROFF FIRE CAPTAIN 253239 FIRE CAPTAIN 230675 -22564.2
EVELYN DUENAS LIBRARY AIDE 45955.6 LIBRARY AIDE 23328.8 -22626.7
JAIME VALENCIA PUBLIC WORKS SUPERVISOR 164019 PUBLIC WORKS SUPERVISOR 141257 -22761.8
BRIAN C HARRYMAN FIRE CAPTAIN 267589 FIRE CAPTAIN 244563 -23026
RICO ROLLERI POLICE LIEUTENANT 288677 POLICE LIEUTENANT 265629 -23047.7
HAUWA E AHMED ASSISTANT MENTAL HEALTH CLINIC 125172 ASSISTANT MENTAL HEALTH CLINIC 102017 -23154.8
MELISSA A KELLY POLICE OFFICER 231589 POLICE OFFICER 208340 -23248.6
WILLIAM A COCKE POLICE OFFICER 224807 POLICE OFFICER 201324 -23483.8
JOHN D SNELL FIRE APPARATUS OPERATOR 223820 FIRE APPARATUS OPERATOR 200324 -23496.5
CHERYL A WARNER MARINA ASSISTANT 97628.9 MARINA ASSISTANT 74118.6 -23510.3
PETERPAUL CIANCIULLI FIRE APPARATUS OPERATOR 207632 FIRE APPARATUS OPERATOR 184073 -23559.2
CYNTHIA HARRIS POLICE CAPTAIN 325632 POLICE CAPTAIN 301868 -23763.4
PATRICIA J DELALUNA POLICE SERGEANT 257782 POLICE SERGEANT 233352 -24430.4
DAVID SPRAGUE-LIVINGST FIRE LIEUTENANT 209058 FIRE LIEUTENANT 184551 -24506.8
ALEXANDER K MCDOUGALL POLICE OFFICER 220664 POLICE OFFICER 195975 -24689.1
BENJAMIN K PHELPS POLICE OFFICER 220152 POLICE OFFICER 195450 -24702.4
BARRY R JENNINGS APPLICATIONS PROG/ANA II 157193 APPLICATIONS PROG/ANA II 132451 -24742.3
EMILY J MURPHY POLICE SERGEANT 260629 POLICE SERGEANT 235785 -24843.5
CHRIS A KALDUNSKI LEAD ELECTRICIAN 189545 LEAD ELECTRICIAN 164650 -24895.7
MELANIE BYNES ADMINISTRATIVE ASSISTANT 126604 ADMINISTRATIVE ASSISTANT 101673 -24930.8
STEPHANIE L COLE POLICE OFFICER 233408 POLICE OFFICER 208468 -24939.4
SCOTT M MCKINNEY FIRE LIEUTENANT 213812 FIRE LIEUTENANT 188857 -24954.2
JAMES E WALLACE LANDSCAPE EQUIPMENT OPERATOR 129768 LANDSCAPE EQUIPMENT OPERATOR 104731 -25036.7
JOHN C KELLY LABORER 120207 LABORER 95096.8 -25110
DAVID A FRANKEL POLICE LIEUTENANT 364375 POLICE LIEUTENANT 339018 -25356.7
JOHN W HARRIS LEAD ELECTRICIAN 184002 LEAD ELECTRICIAN 158450 -25552.3
TRACIE A LUI POLICE OFFICER 214781 POLICE OFFICER 188970 -25810.7
MICHAEL A FELLOWS PARKING METER MECHANIC 127835 PARKING METER MECHANIC 101879 -25956.2
ROBERT D SMITH FIRE LIEUTENANT 232576 FIRE LIEUTENANT 206603 -25973
NORMA MARTINEZ-CARO POLICE OFFICER 225333 POLICE OFFICER 199310 -26022.7
ALYSON L HART POLICE LIEUTENANT 294292 POLICE LIEUTENANT 268227 -26064.9
BYRON E WHITE POLICE OFFICER 211926 POLICE OFFICER 185601 -26324.3
PATRICK D ANDERSON POLICE OFFICER 237116 POLICE OFFICER 210652 -26464.1
JEREMY J HILT PARKING METER MECHANIC 119986 PARKING METER MECHANIC 93201.5 -26784.5
CRUSETTA A COOPER PARKING ENFORCEMENT OFFICER 118354 PARKING ENFORCEMENT OFFICER 91479.2 -26874.7
ELIZABETH D GARCIA COMMUNITY DEVELOP PROJCT COORD 131024 COMMUNITY DEVELOP PROJCT COORD 104102 -26921.9
KEVIN M NEFF POLICE OFFICER 213208 POLICE OFFICER 186270 -26938.4
EARL E EMELSON POLICE OFFICER 221836 POLICE OFFICER 194558 -27277.5
DAVID K REECE POLICE LIEUTENANT 289110 POLICE LIEUTENANT 261432 -27678.1
SPENCER FOMBY II POLICE SERGEANT 294209 POLICE SERGEANT 266402 -27806.6
MIKE E PARSONS POLICE OFFICER 245471 POLICE OFFICER 217595 -27876.5
ZHENG H KUANG SOLID WASTE WORKER 164179 SOLID WASTE WORKER 135032 -29147
CYNTHIA M SHAW OFFICE SPECIALIST II 92541.3 OFFICE SPECIALIST II 63387.1 -29154.2
RASHAWN D CUMMINGS POLICE OFFICER 246487 POLICE OFFICER 217319 -29167.5
TIMOTHY S ELWELL FIREFIGHTER 216473 FIREFIGHTER 187151 -29321.2
ROSELYN C JUNG POLICE OFFICER 226336 POLICE OFFICER 196632 -29704
JOHN A LENNY POLICE OFFICER 265794 POLICE OFFICER 236001 -29793
DION M WILLIAMS FIRE APPARATUS OPERATOR 213174 FIRE APPARATUS OPERATOR 183136 -30037.8
TRACY S SHAUL PUBLIC SAFETY DISPATCHER II 135949 PUBLIC SAFETY DISPATCHER II 105088 -30860.9
EARL HOOKER SOLID WASTE WORKER 103306 SOLID WASTE WORKER 72421.5 -30884.2
ANGELA F HAWK POLICE SERGEANT 241004 POLICE SERGEANT 210057 -30947.5
JEFF A SHANNON POLICE OFFICER 224736 POLICE OFFICER 193355 -31380.9
DAVID A BRANNIGAN FIRE LIEUTENANT 234925 FIRE LIEUTENANT 203267 -31658
MICHAEL A BRYANT SOLID WASTE TRUCK DRIVER 142781 SOLID WASTE TRUCK DRIVER 110893 -31887.7
ANTONIO C LEE LABORER 116233 LABORER 84125.6 -32107.2
WENDY L COSIN DEPUTY DIRECTOR OF PLANNING 234448 DEPUTY DIRECTOR OF PLANNING 202314 -32134
JILL A MARTINUCCI LEGISLATIVE ASSISTANT 82378.1 LEGISLATIVE ASSISTANT 50113.7 -32264.4
KANDI D GILL FIRE APPARATUS OPERATOR 218008 FIRE APPARATUS OPERATOR 185089 -32918.4
RUDY L VALENCIA FIREFIGHTER 217490 FIREFIGHTER 184442 -33048.3
ANITA WOODRUFF ASSOCIATE MANAGEMENT ANALYST 138374 ASSOCIATE MANAGEMENT ANALYST 105100 -33273.7
PATRICIA H HEFFRON LIBRARY SPECIALIST II 56560.5 LIBRARY SPECIALIST II 23210.9 -33349.5
YANNI C RHO PSYCHIATRIST III 85550.1 PSYCHIATRIST III 51488.5 -34061.6
REGINALD DAVIS SOLID WASTE TRUCK DRIVER 151685 SOLID WASTE TRUCK DRIVER 117353 -34332.4
VAN DU N HUYNH POLICE SERGEANT 236278 POLICE SERGEANT 201118 -35159.6
TODD A LOWMAN FIRE APPARATUS OPERATOR 222641 FIRE APPARATUS OPERATOR 186813 -35828.5
GERALDINE S EWART SUPERVISING LIBRARIAN 143737 SUPERVISING LIBRARIAN 107437 -36300.1
DESHAUNE R EVANS CUSTOMER SERVICE MANAGER 69791.2 CUSTOMER SERVICE MANAGER 33356.3 -36434.9
SHALLON L ALLEN ASSOCIATE MANAGEMENT ANALYST 143780 ASSOCIATE MANAGEMENT ANALYST 106835 -36944.8
LUIS H MESONES POLICE OFFICER 251529 POLICE OFFICER 214513 -37016
KEVIN M SCHOFIELD POLICE LIEUTENANT 329646 POLICE LIEUTENANT 292612 -37033.4
JOEL G DEL ROSARIO POLICE OFFICER 225491 POLICE OFFICER 188426 -37064.1
EVANGELINA GARCIA COMMUNITY SERVS SP I 103269 COMMUNITY SERVS SP I 65797.1 -37471.8
EDWARD D GALVAN POLICE OFFICER 235986 POLICE OFFICER 198260 -37726
CHRISTIAN O STINES POLICE SERGEANT 267448 POLICE SERGEANT 229700 -37747.6
STEPHANIE E HUDSON PARKING ENFORCEMENT SUPERVISOR 116987 PARKING ENFORCEMENT SUPERVISOR 78529.2 -38457.5
KRISTIN E TUCKER FIREFIGHTER 204529 FIREFIGHTER 165889 -38639.9
MAURICIO A PINEDA SKILLED LABORER 113347 SKILLED LABORER 74543.2 -38803.5
ABRAHAM ROMAN ASSISTANT FIRE CHIEF 282085 ASSISTANT FIRE CHIEF 242650 -39434.9
MELANIE C TURNER POLICE OFFICER 223150 POLICE OFFICER 183613 -39536.9
CHRISTOPHER J MORGAN FIRE APPARATUS OPERATOR 241183 FIRE APPARATUS OPERATOR 201190 -39992.7
CHARLES H WONG FIRE CAPTAIN 285455 FIRE CAPTAIN 245264 -40191.5
JOHN E FORNEY FIRE APPARATUS OPERATOR 243782 FIRE APPARATUS OPERATOR 203374 -40408.3
KELLIE EAST-BRATT FIRE LIEUTENANT 204045 FIRE LIEUTENANT 163535 -40509.8
EUGENE Y TAYLOR FIRE APPARATUS OPERATOR 238027 FIRE APPARATUS OPERATOR 196037 -41990.6
SHIRA J WARREN POLICE OFFICER 212060 POLICE OFFICER 170064 -41996.8
FREDERICK R ZACKERY LABORER 96262.6 LABORER 53916.4 -42346.2
JOANN L EVANGELISTA HEALTH PLNG, EDUC & PROM SUPV 128811 HEALTH PLNG, EDUC & PROM SUPV 86445.1 -42366.3
KEITH B MAY FIRE LIEUTENANT 269375 FIRE LIEUTENANT 226705 -42670.8
BRANDON L MASON PARKING METER MAINTENANCE WORK 120961 PARKING METER MAINTENANCE WORK 77649.1 -43311.6
DORENE N MONROE ASSOCIATE MANAGEMENT ANALYST 140965 ASSOCIATE MANAGEMENT ANALYST 97286 -43679.1
RICHARD E CARRILLO APPLICATIONS PROG/ANA I 128394 APPLICATIONS PROG/ANA I 84458.7 -43935.5
ANTHONY F NUNES FIREFIGHTER 283167 FIREFIGHTER 239139 -44027.8
ANGELINA R LOPEZ-LEVY COMMUNITY SERVICE OFFICER 112733 COMMUNITY SERVICE OFFICER 67422 -45311.3
SCOTT W HALL FIRE LIEUTENANT 267549 FIRE LIEUTENANT 221721 -45828.3
BRIAN D WILSON POLICE SERGEANT 272059 POLICE SERGEANT 226221 -45837.6
DERRICK E SULLIVAN SOLID WASTE TRUCK DRIVER 137940 SOLID WASTE TRUCK DRIVER 91918.9 -46021.5
DAVID M WHITE POLICE SERGEANT 282004 POLICE SERGEANT 235562 -46442.6
GWENDOLYN A LADELL OFFICE SPECIALIST II 95573.7 OFFICE SPECIALIST II 49091.6 -46482.1
RICHARD ROBINSON MECHANICAL SWEEPER OPERATOR 128739 MECHANICAL SWEEPER OPERATOR 81487.6 -47251.7
BRYAN D WAGGONNER POLICE OFFICER 249002 POLICE OFFICER 200616 -48386.3
NICOLE L KELLY ADMINISTRATIVE ASSISTANT 108891 ADMINISTRATIVE ASSISTANT 60343.5 -48547.9
SHANI LEONARDS SUPERVISING LIBRARIAN 152228 SUPERVISING LIBRARIAN 103570 -48657.7
RUDOLPH L WILSON ELECTRICIAN 157936 ELECTRICIAN 109010 -48926.1
MARLA J CLARK PARKING ENFORCEMENT SUPERVISOR 132860 PARKING ENFORCEMENT SUPERVISOR 83477.2 -49383.2
ANDREA J MOSS LIBRARIAN II 95756.9 LIBRARIAN II 46360 -49396.9
DEREK A DIMAGGIO VECTOR CONTROL TECHNICIAN 101224 VECTOR CONTROL TECHNICIAN 51744.8 -49479
JENNIFER E LANDSBERG FIREFIGHTER 215439 FIREFIGHTER 165871 -49568
WILL MARSTON LIBRARIAN II 117257 LIBRARIAN II 65453.7 -51803.6
ERNIE KAWANA POLICE OFFICER 259221 POLICE OFFICER 207316 -51905
JAMES F MILSTEAD ELECTRICIAN 150736 ELECTRICIAN 97448.8 -53287.3
PATRICK E TETSALL FIRE LIEUTENANT 218698 FIRE LIEUTENANT 164443 -54255.4
ANN W MILEY ADMINISTRATIVE HEARING EXAMINE 135616 ADMINISTRATIVE HEARING EXAMINE 80882.2 -54733.8
JAMES T STREET SKILLED LABORER 103712 SKILLED LABORER 48316.9 -55395.6
RODOLFO HERNANDEZ PSYCH SOC WKR II 129488 PSYCH SOC WKR II 73578.2 -55909.9
ANTHONY M BARLOW FIREFIGHTER 193924 FIREFIGHTER 135801 -58123.4
LINDA J BASS OFFICE SPECIALIST II 90468.9 OFFICE SPECIALIST II 32013.9 -58454.9
FAMCHOY K SAECHAO PUBLIC SAFETY DISPATCHER II 187123 PUBLIC SAFETY DISPATCHER II 128192 -58930.5
ELIZABETH J BROWN ENVIRONMENTAL COMPLIANCE SPECI 130780 ENVIRONMENTAL COMPLIANCE SPECI 70893.2 -59887
KEAUANNA M MACKEY OFFICE SPECIALIST III 89892.9 OFFICE SPECIALIST III 29603 -60289.8
URBANO A ESTRELLAS SENIOR SERVICE AIDE 69162.7 SENIOR SERVICE AIDE 6180.9 -62981.8
KATHERINE R SMITH POLICE SERGEANT 284750 POLICE SERGEANT 221562 -63188.2
MARCELLA A BROWN ACCOUNTING OFF SPEC III 95529.2 ACCOUNTING OFF SPEC III 32059.7 -63469.5
DOUGLAS F SMITH DEPUTY DIRECTOR OF LIBRARY SER 208926 DEPUTY DIRECTOR OF LIBRARY SER 143357 -65568.5
TERRI V GESER COMMUNITY DEVELOP PROJCT COORD 120016 COMMUNITY DEVELOP PROJCT COORD 52703.5 -67312.5
DOROTHY L JOHNSON OFFICE SPECIALIST II 87034.1 OFFICE SPECIALIST II 19511.5 -67522.6
NORMA J FOSTER COMMUNITY HLTH WRKR SPECIALIST 71859.5 COMMUNITY HLTH WRKR SPECIALIST 3461.74 -68397.7
LYLE L LEDWARD POLICE OFFICER 279249 POLICE OFFICER 209905 -69343.3
BRADLEY C RICARDS LANDSCAPE ARCHITECT 160248 LANDSCAPE ARCHITECT 87248.3 -72999.2
LIONELL F DOZIER II POLICE OFFICER 303845 POLICE OFFICER 230655 -73189.9
CHRISTIAN T VAN LUEN FIREFIGHTER 283421 FIREFIGHTER 209650 -73770.8
ALCENIA A WYNN COMMUNITY SERVICE OFFICER 114372 COMMUNITY SERVICE OFFICER 34920.6 -79451.8
CELYCE J LYONS PUBLIC SAFETY DISPATCHER II 155985 PUBLIC SAFETY DISPATCHER II 74569.6 -81415.2
AKILI BANJO PARKING ENFORCEMENT OFFICER 119327 PARKING ENFORCEMENT OFFICER 36324 -83003.2
ROBERT C NORWOOD SKILLED LABORER 85177.7 SKILLED LABORER 469.49 -84708.2
HERBERT L MILLER LANDSCAPE EQUIPMENT OPERATOR 121713 LANDSCAPE EQUIPMENT OPERATOR 36404.8 -85308.1
DAVID J ROWL HOUSING INSPECTOR (CERTIFIED) 133329 HOUSING INSPECTOR (CERTIFIED) 47455 -85873.6
PAUL K BROADWAY SOLID WASTE TRUCK DRIVER 135156 SOLID WASTE TRUCK DRIVER 47424.5 -87731.2
PETER L BJELDANES POLICE OFFICER 305963 POLICE OFFICER 211541 -94422.3
AMY L MOORE CLINICAL PSYCHOLOGIST 116205 CLINICAL PSYCHOLOGIST 20827.8 -95377.6
LARRY D FRAZIER ELECTRICIAN 194220 ELECTRICIAN 98530.3 -95689.4
SIDNEY COULTER PERMIT SPECIALIST 111574 PERMIT SPECIALIST 9544.97 -102029
CURTIS D COULTER COMMUNITY SERVICE OFFICER SUPV 158546 COMMUNITY SERVICE OFFICER SUPV 53742.1 -104803
CHARLOTTE A FREDRIKSEN ASSISTANT MANAGEMENT ANALYST 123485 ASSISTANT MANAGEMENT ANALYST 16599.8 -106885
HARMINDAR K SRAN SENIOR ENVIRONMENTAL HEALTH SP 150313 SENIOR ENVIRONMENTAL HEALTH SP 40588.2 -109725
DAVID A VASS PUBLIC SAFETY DISPATCHER II 149834 PUBLIC SAFETY DISPATCHER II 38861.8 -110972
KENT R MURRAY OFFICE SPECIALIST SUPERVISOR 114254 OFFICE SPECIALIST SUPERVISOR 1879.69 -112375
MARK E CALDWELL FIREFIGHTER 277210 FIREFIGHTER 162706 -114504
ROBERT A BUELL MECHANICAL SWEEPER OPERATOR 115077 MECHANICAL SWEEPER OPERATOR 36.33 -115041
IONATANA IEREMIA SEWER MAINTENANCE ASST SUPV 175043 SEWER MAINTENANCE ASST SUPV 58499.6 -116543
ADRIAN SMITH SEWER MAINTENANCE ASST SUPV 148337 SEWER MAINTENANCE ASST SUPV 31404.5 -116932
MARGARET CROSS PUBLIC HEALTH NURSE 130863 PUBLIC HEALTH NURSE 13792.2 -117071
JEFFREY T LUNA POLICE OFFICER 253150 POLICE OFFICER 130839 -122312
HALLIE A LLAMAS REAL PROPERTY ADMINISTRATOR 183091 REAL PROPERTY ADMINISTRATOR 56038.1 -127053
SANDRA L LAWSON ADMIN & FISCAL SVS MGR 163758 ADMIN & FISCAL SVS MGR 36624.2 -127133
ROXANN T CHAMBERS PSYCH SOC WKR II 137638 PSYCH SOC WKR II 6636.63 -131001
RAYMOND A STITH MECHANIC SUPERVISOR 154885 MECHANIC SUPERVISOR 20574.9 -134310
ROMEO C MOSCARDON ENGINEERING INSPECTOR 136891 ENGINEERING INSPECTOR 0 -136891
LISA K MALEK-ZADEH ADMIN & FISCAL SVS MGR 168502 ADMIN & FISCAL SVS MGR 28333.9 -140169
JOHN W FITCH ASSISTANT FIRE CHIEF 249904 ASSISTANT FIRE CHIEF 96099.1 -153804
DIANE E DELANEY POLICE LIEUTENANT 300400 POLICE LIEUTENANT 142692 -157707
KATHRYN HOOVER ALEXANDER MANAGER OF HOUSING & COMM SRVC 191178 MANAGER OF HOUSING & COMM SRVC 8557.42 -182621
MARTIN MANQUEROS FIRE APPARATUS OPERATOR 209952 FIRE APPARATUS OPERATOR 1815.46 -208137
LESLIE R PUTNAM FIRE CAPTAIN 307479 FIRE CAPTAIN 53827 -253652
DEBRA R PRYOR FIRE CHIEF 299043 FIRE CHIEF 22446.9 -276596

Perhaps we might want to look at the relationship of these two variables. That leads to another useful operator

  • Table.scatter: does a scatter plot of columns against one columns

In [70]:
b11_13.scatter('Total 2011', 'Total 2013')


Summary

This notebook has provided a introduction to many of the concepts and features in datascience tables in the context of a fairly complete example on open public data.

  • Creating tables: Table.read_table - reads a file or url into a Table. It is primarily used for csv files. Tables can also be created from local data structures by constructing a tables with Table() and filling it using with_columns or with_rows.
  • Accessing columns, rows, and elements of table.
  • Cleaning up raw tables and setting formatters for table displays.
  • Getting descriptive statistics with stats to sumarize the columns in a table.
  • Working with portions of a table using select to select columns where to filter rows, drop to select all but the specified columns.
  • Visualizing data with hist, plot, barh, bar, and scatter.
  • Sorting tables with sort using columns as keys.
  • Grouping entries in tables using group, where groups are defined by rows with common values in a specified collection of columns; the values in the remaining columns are then aggregated using a collection function. The identity collector all all the values in a group to be collected into a list.
  • Applying functions to all the elements of a column of a table, using apply
  • Distributing columns of a table using pivot_bin where each unique set of values in a specified collection of columns serves as a "key" which is a column name in the result. Values in the remaining columns are binned to produce the rows in the result. This is used when the number of entries for each key varies. Where there is a single value for each key, pivot can be used.