There aren't many in California. I think the issue is that the state funded institutions such as UC have budgetary restrictions to starting new degrees. I heard the CSU institutions was approved to start offering them but that news has been out for a while and still no CSU campus have announced a DNP program. As of now, all DNP programs in California are offered by private institutions. San Francisco only has one program at USF. Sam Merritt in Oakland might actually have one.
I think a lot will depend on the budget from Sacramento. New programs generally require additional faculty. When my University was developing our DNP in 2006, we were assured additional faculty lines. 6 years later not only have there been no additional faculty but budgets have been cut by 20%. California's state higher education budgets have been even more impacted.