Time series animation of homicides in Oakland I built with data from 1995 to 2012. View in 720HD or it’s all fuzz. What stands out to me especially is the spread of murders into the northern parts of the city and up above the 580….
Author: spjika
Code for America Fellowship launch in Oakland
Got to be part of the presser for the fellows today, celebrating the start of their placement in Oakland City Hall for their Code for America work. High hopes for what these three can achieve and for the path they can help us lay out for innovation and openness in local government!

The city team and the fellows

Jen Pahlka of CfA

Eddie Tejeda of OpenOakland, CfA alum and BlightStatus
Years of life lost: the huge cost on our country.
From my public health background I appreciate this take on gun violence- this part of the story has not been in the national discourse but it’s a very real problem- for every victim we lose a productive* member of our society who could have gone on to do good things, bring in income, pay taxes, support families. The years of life lost to gun violence is truly staggering.
http://guns.periscopic.com/

*No, I’m not ignorant of the fact that many shot are thugs and may not have had a positive life trajectory. But that doesn’t mean we can consider their lives as no loss. They have families and friends and many in the game turn their lives around. Don’t dismiss people because they are not living the straight and narrow “like the rest of us”. We all count. We all have mothers.
Where are all the raised black voices? Harry Belafonte Speaks on Gun Control in Acceptance Speech @ NAACP Image Awards | Feb 1, 2013 (by James E. Wright) (Source: https://www.youtube.com/)
Fun with FOIA – Public Records games in California
It’s a good day for open public data in Oakland today. And a slightly confusing one too.
The City of Oakland launched their new open public data system- a one stop website where you can find public records, GIS data, city data and more: http://data.oaklandnet.com
It’s just launched so not every conceivable dataset is available just yet, but this is a great start and a good sign that Oakland is slowly getting it that open government is not just good government, it’s also smart government. This is slow in coming, it feels like a long time back that I first started hounding city councilors and staff about considering open data in Oakland, but we got there!
And this new data is just in time for our next event- for International Open Data Day! We’re hosting a hackathon at the 81st Ave Library in Oakland, sign up now to get your data hack on with other great peeps who love this city and love data: http://opendataday.openoakland.org
So that’s the good part about open public data today, now for the strange part.
Property ownership data is public record. Your name and ownership data, property value and all that. You can even map it out nice and easy online. 
As soon as the Oakland site went live I got inquiries about parcel data. It wasn’t there strangely, so I sent people to the County site, and someone complained fairly that there were no owner records available. Strange. So I sent them a link to our community run data catalog which has our complete Assessor’s Secured Roll. Easy. Collaboration and communication, nice.
Well, nice until a clever reporter type pointed out the wonders of the California Government Code Section 6254.21:
(a) No state or local agency shall post the home address or telephone number of any elected or appointed official on the Internet without first obtaining the written permission of that individual.
Ahhhh, that would explain the missing name fields. Government agencies cannot publish addresses of electeds. So instead of maintaining a long list of those names to scrub form data files, they just presumably remove the entire name field? Interesting.
Even more ominous is the following:
(b) No person shall knowingly post the home address or telephone number of any elected or appointed official, or of the official's residing spouse or child, on the Internet knowing that person is an elected or appointed official and intending to cause imminent great bodily harm that is likely to occur or threatening to cause imminent great bodily harm to that individual.
Luckily I don’t know anyone who would want to cause harm, but the following section c goes on to describe that if an elected official writes to you, you have 48 hours to remove that info and you cannot transmit it in anyway ever again. Sure. Easy.
The screwed up part of all this is that for $25 you can walk into the county assessor’s office and buy a copy of the Secured Roll on DVD (cost of reproduction seems fine) and you have all the elected officials records, names and all.
So once again our laws, our practices and our technology are all out of wack. Government is prohibited from posting info online but can issue the file to anyone with no questions. Residents may post the content as long as they are nice. So given that I am of good intent only, it appears that I may legally post to the interwebs these data. Which I shall do.
Oh how I love you California.
Note- In California we don’t really use FOIA- our state and local gov is covered by the Public Records Act or PRA. Federal gov and some states are covered under FOIA. Just to be educational and correct. I did recall writing this above but Firefox did crash on me and wipe my entire post, in the rewrites I often get sloppy… oops.
Oakland Unseen: Iron Chef films toughest show yet in West Oakland food desert
I’m not sure if I should be laughing or crying, I feel like both reading this. I’m really glad this is a satire piece, but then maybe I’m wrong and this is for reals. Either way the point is legit.
Iron Chef America contestants are known for having to creatively overcome difficult cooking challenges, such as making a dessert with eel. But few episodes have been as difficult as having to make gourmet dishes using only ingredients found in the West Oakland food desert.
Oakland Unseen: Iron Chef films toughest show yet in West Oakland food desert
In ten words or less, sugar is both toxic and abused. Every substance that is both toxic and abused at the same time requires both personal intervention, which, for lack of a better word, we can call ‘rehab,’ or societal intervention [which], for lack of a better word, we call ‘a tax.’ Same thing we do with alcohol and tobacco.
According to Dr. Robert Lustig, a pediatric endocrinologist at UC San Francisco, it’s a dangerous trend. The mass consumption of sugar via soda affects the human body much like drugs and tobacco. Lustig also argued that education alone is not enough to fight sugar addiction.
From the EBX article on how Big Soda played the Race baiting game to defeat the soda tax.
Nikon’s Not So Great D600 Servicing
I upgraded to a full frame DSLR late last year, a very significant expense for my photography business but a good decision base don my needs- mostly for larger prints of fine art landscape work. At first it was a fantastic piece of gear, one small ergonomic balls-up on the tips of your right fingers- they get pinched ever so slightly by a non rounded curve, but otherwise it’s a wonderful camera.
Until it isn’t. Shooting at a 49ers game for fun I found my 20mm AF-D f2.8 lens wasn’t auto-focusing anymore, wiggled, jiggled and no luck. Went to manual mode. Weird. Later I put on a 80-200mm AF-D f2.8 Nikkor lens and it wouldn’t focus either. Messed with switches from M-A, no luck. Put on a 300mm AF-S f4 and it was all candy. Strange.
Tested it more at home the next day and realized that all my favorite AF-D lenses (between 7-10 years old) would no longer auto-focus on the body. But they did work fine on my D7000 still. Crap. They all work manually only. Not so great for shooting weddings or sports but fine for landscapes I guess?
So, send it off to Nikon less than 45 days old. Not a great feeling. This is a big investment for anyone and to have out of the box failure is bad, worse if you use that product to make money from.
Two weeks go by and Nikon sends it back into the third week, repaired. Major Repairs according to their ticket. Major part replacement. Comforting. But repaired by Nikon experts. So all good.
Except it wasn’t. First wedding after getting it back, slap on a 50mm for some portrait shots and bam, no focus. At a wedding. Luckily, oh so luckily I wasn’t the official photographer at this one – obviously I would have checked all my gear first if I was. But the “repair” was not so much a repair as I’d expected. Now thoroughly pissed and not ok with the thought of such an expensive bit of equipment spending another 2+ weeks with Nikon and not able to be used.
I asked Nikon to issue a shipping label as this was not just a warranty repair but a repair caused by their own negligence and failure to perform. After back and forthing it took them over a week to issue a shipping label. Process apparently. I should have eaten the shipping cost myself and not lost the extra week with no camera working. Lesson learned.
I told Nikon that a repair at this point was completely unacceptable, that I have no faith that they can and will do the job properly or that the camera can indeed be fixed as they supposedly did this job last time and resulted in a dead camera afterwards. In this situation you have to acknowledge your customers and they fact that they rely on your products to make a living or to work effectively. If your products require more time in the factory than in your customers hands being used then you have a serious problem, one that affects your customers goodwill and income. One that drives them to Canon or Olympus. But instead of acknowledging these basics of customer relationship, Nikon is refusing to replace or refund my purchase.
So obviously now I’ve gone from a big fan of Nikon gear for over 15 years to a seriously disappointed and angry customer desperate to get a working body for his $2,000. If this had happened a tad sooner I could have simply returned it to Adorama, but that option of relying on good customer service is gone, and now I’m at the mercy of Nikon and their promise that they are able to fix what they failed to fix once before, and I’m left with a $2,000 hole in my business account and no working product to show for it again. Oh, and that bad taste in my mouth.
Thanks Nikon, way to not respect your customers.
Lessig Blog, v2: Prosecutor as bully
(Some will say this is not the time. I disagree. This is the time when every mixed emotion needs to find voice.)
Since his arrest in January, 2011, I have known more about the events that began this spiral than I have wanted to know. Aaron consulted me as a friend and lawyer. He…
Opening Government: Oakland’s First CityCamp
I recently co-founded an organization called OpenOakland with former Code for America fellow Eddie Tejeda. One of our passions was that we both believe that government can and should be much more than a vending machine. Those of us in OpenOakland (all 20+ volunteers) dig the idea of government as a platform: a platform that supports safe communities, job growth, excellent schools, strategic business development, and innovation. When our government operates more collaboratively and genuinely engages with our communities (as opposed to acting as a barrier), it facilitates so much more that can benefit our communities. Too many, this is a new concept, but we believe that it matters how we perceive our governments. It’s no secret that
current local governments have a ton of changing to do, but it’s unlikely that these changes will come about swiftly without all of us being involved and engaged and supporting our government staff and leaders to make these changes.
Instead of lamenting from the sidelines, how can we support this change? Several years ago some brilliant people created an opensource brand called CityCamp– the idea was that concerned citizens, technologists and government never really get the chance to get together, share successes, be exposed to new, innovative technology, share struggles and openly converse and build relationships with no hidden agendas and with no vendor pitches. For OpenOakland, running a CityCamp was a clear way for us to move our mission forward- we exist to support open, agile and engaged government. So on December 1st we held the first ever CityCamp Oakland, inside city hall and actually based in council chambers. We welcomed 121 local technology professionals, government staff from almost every city department and community members to a full day’s unconference.

As an unconference, a CityCamp gives those attending the opportunity to set the agenda themselves, we asked registered guests to suggest ideas on a new platform the City has adopted recently called EngageOakland.com. This approach not only gives people a sense of empowerment that they can create the sessions they want to lead or participate in, it also gives us and our attendees a great way to continue conversations beyond the day using the same web platform for discussion and sharing. We helped seed the ideas with a few topics of interest to OpenOakland members and started the day with over 30 ideas to consider. The topics were refined through attendees voting on each idea- in the end we held 16 different sessions throughout city hall.
The session topics covered issues from open data, a GIS/spatial roundtable discussion, pubic safety data, freedom of information (FOIA) requests, civics 101, diversity and the digital divide and Oaklandwiki.org (a local wiki built by OpenOakland to allow Oaklanders to tell their own stories about their community). While there is a level of initial discomfort for many people, this open format of event does lend itself to unpredictable conversations that could never happen in other settings and also supports a level of openness and candidness that is both rare and valuable. Can you think of another setting where city staff would spend an hour discussing the limitations and issues of publicly available crime data or the problems in the current FOIA process? With no unspoken agenda, no forced engagement requirement that town hall meetings carry and no threat of repercussion, we all participated in some rich conversations and came away inspired and encouraged.
Some take-aways were significant and some were minor, but all were things that are only possible in a safe, respectful environment that this event helped to create. Take for example the city staffer who learned that saving data as a PDF is actually a barrier to others being able to easily access and make use of the data, that the habit they considered as helpful was not, and by saving as raw data formats they could enable others to also use these data. This is no earth changing lesson, but it illustrates the value in communication and of sharing frustrations without adopting a blaming or accusatory approach.

This event demonstrated how powerful communication and open engagement really are, and the attendees illustrated to those of us in the Open Government movement just how important it is that we can provide more environments like this to allow for better collaboration in future. The real test of any social or civic change is that of time, and so it remains to be seen how lasting the impacts of this CityCamp will be. I’m optimistic that we are on the right track here, that positive, supportive approaches can help to transform our city governments into the 21st century institutions we need them to be. One city staffer wrote that “We can look forward to a whole new push in communications, data, transparency, ease of access because of these people’s (OpenOakland) efforts to work, partner with us and join in to the larger civic conversation”. We even have excited city staff wanting to take part in OpenOakland now- some initial proof that the concept of a Code for America Brigade really does meet a local need!
Some of the guests were dubious about this format and carried some serious distrust of city staff into the day. As someone who has tussled with the city publicly I could sympathize with them, however we were stunned to see the impact of open conversations with city staff as peers on some of these hard edged residents. I truly believe that these type of events can go a long way to healing some of our past wounds and to opening up doors to not only better collaboration, but to informed engagement on our part. The typical closed door, gatekeeper approach maintained by many departments does nothing to encourage goodwill or trust. It does in fact encourage distrust and doubt about the intentions and capabilities of that office which cannot have any positive results for either the agency or the public it serves. From an outside perspective we hear about all the dumb, corrupt things that city officials do, but when we talk in person about things we have a common interest in I find my respect for city staff increases as I learn about more of the great things they are doing or are trying to do.
One of the city staff in attendance provided this perspective on the civic hacker community:
“they are our new age city advocates – just like our tried and true volunteers who wear vests and bring shovels, these new style digital folks, use an iPad, the cloud and zeros & ones to engage the citizenry, help govt get the word out, make things easier- faster-better! They are committed to Oakland, and are generous with their skills and amazing abilities and know how”.

If you think that this kind of event would benefit your city I’d encourage you to consider hosting one- opensource is not just a concept that promotes “free” software, it applies to ideas too- as an opensource idea, anyone is free to hold a CityCamp and to reuse this brand and this idea- after all, cities are one of the earliest examples of us sharing communally- we share our libraries and roads, why not share great ideas too! This is one of the most powerful concepts in urban society- if an idea or a project works in one place, why not reuse it elsewhere? This is the core of opensource technology and it’s the core of OpenOakland also. But that’s another story.
Original story posted here: sunlightfoundation.com/blog/2013/01/11/opening-government-oaklands-first-citycamp/

