Socrata is a growing outfit that manages DBs for cities and non-profits.  This guy did a nice how-to page of his work with Socrata, and we thank him.

https://thomaslevine.com/!/socrata-summary/

Peter Harkins, at his blog Push CX, suggests “Three rules for data base creation and management“:

1. All Fields Become Optional
   

2. All Relationships Become Many-to-Many
   

3. Chatter Always Expands
   

   ---

Hats off to MICHAEL MANSUR and RICK MONTGOMERY of The Kansas City Star for taking on a tough — and often controversial challenge — of trying to measure the quality of services provided by city government.  The discipline/methodology underlying “Our Tax Dollars at Work” is broadly called “performance measurement” in government, “forensic accounting” in the business world.  What we see as a sub-set, or, perhaps, a sibling, methodology was employed for this study, “Data Envelopment Analysis (DEA).” 

Mansur and Montgomery are on the right track with these stories, but unfortunately, the online presentation falls short.  For example, ofttimes (well, typically) rankings are displayed, but in no obvious order, neither alphabetical by city nor rank order of scores.  Furthermore, the pages don't supply any information that tells the reader if a low score is desireable or a high one.  This is a case where good infographics and/or visual statistics could make for a much better telling of the tale.

That said, keep on keepin' on, gents.  It's this type of work that, in the long run, will help citizens conclude that good journalism is crucial to the democratic process.

• Scores for each service, listed by city
• Data that was used in The Star's measurement and how the cities scored
• Combining services enhances public safety
• Technology, planning can help speed justice
• Dividing law enforcement units for best results