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.

# 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__

'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.

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.

# 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

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.

raw_berkeley_sal_2011['Base Pay']

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

Some prefer the selectors - column and row

raw_berkeley_sal_2011.column('Overtime Pay')

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.

raw_berkeley_sal_2011.rows[0]

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')

raw_berkeley_sal_2011.row(0).item('Base Pay')

'$132540.85'

raw_berkeley_sal_2011.row(0)[2]

'$132540.85'

raw_berkeley_sal_2011.row(0).asdict()

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')])

raw_berkeley_sal_2011.rows[0: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

paylabels = raw_berkeley_sal_2011.labels[2:]
paylabels

('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.

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.

berkeley_sal_2011.set_format(paylabels, CurrencyFormatter)
berkeley_sal_2011

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.

berkeley_sal_2011['Base Pay']

array([ 132540.85,  159094.73,  205400.  , ...,       0.  ,       0.  ,
             0.  ])

max(berkeley_sal_2011['Total Pay Benefits'])

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

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)

berkeley_sal_2011.select(paylabels).stats(ops=summary_ops)

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

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?

berkeley_sal_2011.sort('Total Pay Benefits', descending=True)

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.

berkeley_sal_2011.num_rows

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.

# 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 

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)

ordered_by_title.num_rows

305

Wow, 305 Job Titles for 1437 employees!

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

'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.

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?

by_title.sort('Total Pay Benefits sum', descending = True)

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)

by_title.sort('Total Pay Benefits sum', descending = True).row(0)

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)

by_title.select(('Job Title', 'Total Pay Benefits sum')).sort('Total Pay Benefits sum', descending=True)

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

ordered_by_title['Job Title']

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')

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"]
    }

categories

{'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

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

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

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)

# 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

job_categories.where('Category', 'Other')

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)

job_categories.where('Category', 'Other').group('Job Title',sum).sort('Cat sum', descending=True)

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)

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

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.

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.

police = job_categories.where('Category', 'Police')
police

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.

police.select(paylabels).hist(bins=30,normed=False)

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?

police.group('Job Title')

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

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

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.

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

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

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

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

fire = job_categories.where('Category','Fire')
fire.select(paylabels).hist(bins=30)

fire.group('Job Title')

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

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.

raw_berkeley_sal_2013 = Table.read_table("./data/City_of_Berkeley_Employee_Salaries_-_2013.csv")
raw_berkeley_sal_2013

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...

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

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)

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

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)

berkeley_sal_2013["Total Pay & Benefits"]

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

berkeley_sal_2013.sort('Total Pay & Benefits',descending=True)

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.

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)

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)

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)

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.

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

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

b11_13 = b2011.join('Employee Name', b2013)
b11_13

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.

b11_13["Increase"] =b11_13['Total 2013'] - b11_13['Total 2011']

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.

b11_13.stats(summary_ops)

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?

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

'$194,576,175'

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

'$181,102,667'

"${:,}".format(int(sum2013-sum2011))

'$-13,473,508'

"{:.1%}".format((sum2013-sum2011)/sum2011)

'-6.9%'

Look at that.

np.sum(berkeley_sal_2011['Overtime Pay'])

8075636.5499999998

np.sum(berkeley_sal_2013['Overtime Pay'])

8444424.5299999993

Let's see who got promoted or demoted

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

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

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.