Department of Water and Power (DWP) Pay Codes

Data since July 1, 2014. This dataset describes the various pay codes which make up the complex compensation of employees of the City's Department of Water and Power (DWP). The Category field indicates which column of the DWP Payroll dataset (https://controllerdata.lacity.org/Payroll/DWP-Payroll/fq29-mxsy) that particular pay code relates to.

Pay codes are governed by the Memorandums of Understanding (MOUs) between the DWP and its labor representatives; State, City and Federal law; and Departmental policy.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"controllerdata-lacity/department-of-water-and-power-dwp-pay-codes-jwzw-nd84\".\"department_of_water_and_power_dwp_pay_codes\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.