Follow-up from On The Table 2015: Data Integrity for Small Businesses and Small Non-Profits

on-the-table-logoFor On The Table 2015 I met with Heidi Massey and Ben Merriman over coffee and tea in the Loop. My idea for the conversation focused on creating an open consent form template — meaning, a web form users could finish and then export as a Memorandum of Understanding (MOU), a Non-Disclosure Agreement (NDA), or a Data Sharing Agreement (DSA).

The different documents work in different contexts. Except when working with datasets protected by federal law (more on this later), calling an agreement between parties an MOU or a DSA is largely a matter of habit, while an NDA is a legally binding contract that says which types of confidential information should not be disclosed. Within legal limits, there’s nothing stopping you from writing agreements for your organization in the language and structure you prefer. Consider the purpose of the dataset, who has stakes in its integrity, and what might happen to the dataset in the future.

Often boilerplate NDAs and MOUs are kept filed by organizations. An employee, consultant, or another partner adds their details to the agreement. Both parties sign the agreement and each keeps a copy for themselves. The agreement acts as a promise that, essentially, data stays where it belongs. Violations end the data sharing relationship.

Wseedere saw problems with agreements whose force relies on the color of law and a CYA — Cover Your Ass — mentality. So we tried to imagine how the language of the agreements could promote a culture of shared best practices. The conversation followed Heidi’s idea that small nonprofits have more in common with small businesses than they do with very large nonprofits. Here’s a plain English outline for a data agreement which also works like a data integrity check list.

People who are working with shared data should understand:

  • How the data is formatted for use. This means organizing the dataset into simple tables and, for example, by using the same file type, naming conventions, and variable order.
  • The versions of the dataset. An original version of the dataset should be kept unmodified. Changes to the dataset should be made to a copy of the original version and documented in detail. The location of the original version of the dataset should be known but access restricted.
  • How long the data sharing agreement lasts. The dataset’s life cycle—how a dataset gets created, to where it can be transferred, and when, if at all, a dataset is destroyed–is just as important as a straightforward timeline for deliverables.
  • How to keep information confidential. Avoiding accidental violations of the data sharing agreement is easier when everyone who works with the dataset is familiar with its terms of use. It’s possible to define access permissions to datasets by using password protection and defining read/write roles for users. Data cleaning is a crucial part of this process to ensure that personally identifiable information is kept safe.
  • What costs come with sharing the data. This means being clear about who is in charge of updating the dataset, whether there are financial obligations associated with the data sharing process, and knowing risks associated with breaches. Federal law regulates the sharing of datasets about school children (FERPA), medical information (HIPPA), and vulnerable populations (IRBs).
  • Specific use requirements. This is the nitty-gritty of data sharing. Use requirements specify whether a dataset can be shared with third parties, what other data (if any) can be linked to the dataset, and what changes can be made to the dataset.

Ben has written extensively about the consent process as it relates to the genetic material of vulnerable populations. A vulnerable person — say, a prisoner, child, or an indigenous person — consents to give a sample of their genetic material to a researcher for a study. The genetic material gets coded into a machine readable format and aggregated into a dataset with other samples. The researchers publish their study and offer the aggregated dataset to others for study.

Bowser_Tsai

Image from Anne Bowser and Janice Tsai’s “Supporting Ethical Web Research: A New Research Ethics Review”. Copyright held by International World Wide Web Conference Committee: http://dx.doi.org/10.1145/2736277.2741654.

As it stands, though, there is no way for a person to revoke their consent once s/he gives away their genetic material. The dilemma applies not just to genetic material but any dataset that contains sensitive material. We thought people should have a say in what data counts as sensitive. An organization can limit how much data is shared in the first place. There are technical limitations and capacity limitations that stop people “in” datasets from having a voice during the dataset’s full life cycle.

For more information you can go to one of Smart Chicago’s meetups or review a list of informal groups here. The documentation is from last year’s Data Days conference as part of the Chicago School of Data project. There’s a large community in Chicago willing to teach people about data integrity. Check out Heidi’s resource list, which you can access and edit through Google.

Modeling Pension Reform at OpenGov Hack Night

IMG_7951At Chi Hack Night, the Modeling Pension Reform Breakout Group shared their work so far and helped to explain the problem with pensions in Illinois.

The breakout group, led by Ben Galewsky, David Melton, Nathan Pinger, Denis Roarty and Tim Sharko, is comprised of volunteers trying to educate public employees, pensioners, tax payers and policy makers about the math behind pension systems, the current debt, and possible solutions. The group was formed at Chicago’s OpenGov Hack Night as one of the working groups and have been meeting regularly for the past six months.

Here’s the group’s slides and highlight video:

Below, we’ve laid out some key points from the team’s presentation:

The problem with pensions

In the private sector, most companies switched from offering pensions to a 401(k) defined contribution. However, in the public sector the majority of government employees still have a pension. The main difference between a pension and a 401(k) is that with a pension you’re guaranteed a certain monthly income per month and it places the investment risk on the plan provider. With a 401(k) there’s no such guarantee and the employee assumed the investment risk. While pensions are an employee benefit, state workers also pay into the system.

According to the team, the State of Illinois has $111 billion of unfunded liabilities for the five Illinois pension systems: General Assembly Retirement System, Judges Retirement System, State Employee Retirement System,  State Universities Retirement System, and the Teachers Retirement System.

The team stated that in order make up for the shortfall, each Illinois family would have to pay a levy of at least $ 23,000 or a loss of at least $146,000 in retirement savings for every employee and retiree in these five pension plans.

The problem in Illinois became even more difficult in 1970 when the Illinois Constitution was modified to ban Illinois from reducing pension benefits once they’ve been hired by the State. Illinois recently went to a two-tier system to reduce benefits for future employees – but was constitutionally bound to keep things the same for current employees.

The teams stressed that what got the state in trouble wasn’t the stock market tanking or government employees getting raises. It’s that the state skipped their required payments and it compounded the problem. The state has a fixed cost of living allowance (COLA) increase of 3% – and right now that’s compounding at or above inflation. An added complication is that in the Teachers Retirement System, the school districts can set the amount of benefits – but they don’t aren’t responsible for paying the bill.

And the last thing the team says that makes solving pensions difficult is that taxpayers tend to fall asleep when it gets to the nitty-gritty details of pension reform.

Building an understanding of the math

To help residents better understand the pension problem, the team has been building two calculations that model the effects pension reform would have.

The first is a Pension Calculator for pensioners and interested taxpayers to enter their personal information and compare current contributions and benefits to proposed scenarios. The second is a Liability Calculator for taxpayers and policy makers to explore what the state-wide liability looks like under various scenarios.  The calculator is designed to be a  rough model of the pension systems given our limited access to data and actuarial resources.

The calculator let’s users see what effects different pension plans would have.

The team is still working on the calculators, but expects to launch soon.

Currently, the team is working on reverse engineering the State’s actuarial tables that they use to determine how the pensions will look in later years. They have a FOIA request for both the database and the calculations they use.

Getting involved

The team is currently looking for help in getting access to detailed plan data provided to actuaries, access to state actuaries staff and models, javascript developers, UX Designers, help with marketing the tool. They also would like to have input on what is politically and pragmatically feasible and if there are other approaches the team should consider.

You can join them by attending the Chi Hack Night Pension Breakout Group.

Results of the CDOT / Textizen Poll on Placemaking

CDOT Textizen Poster

CDOT Textizen Poster

As part of the CivicWorks Project, we maintain a Textizen instance so that local nonprofits and government agencies can get feedback from residents. Our most recent partnership was with the Chicago Department of Transportation and their placemaking survey.

We wanted to give a few highlights of what we learned doing the survey as well as talk about how your organization can take advantage of Textizen.

Overall Results:

Total number of participants: 2117

English: 1887

Spanish: 220

Total Texts: 13485

Completion Rate: 58.5 %

Age Range: 41% of English respondents were 15-25, 36% were 26-35

Most Active Times: 9am and 7pm

Responses to Select Questions:

I would like to see more _ for Chicago’s streets! (Multiple Choice) [English]
A. Trees & Landscaping 44
B. Seating 13%
C. Public Gathering Spaces 19%
D. Bike Amenities 17%
E. Wider Sidewalks 7%
Which events do you want to see more of in Chicago? (Multiple Choice) [English]
A. Cultural event/art 22%
B. Street Fests 23%
C. Farmer/flea markets 34%
D. Free community services 22%
Cuales eventos le gustaria ver mas en Chicago? (Multiple Choice) (Spanish)
A. Evento cultural/arte 28%
B. Mercados 22%
C. festivales en la calle 29%
D. Servicios comunitarios 21%
How do you mainly get around your neighborhood? (Multiple Choice) (English)
A. Drive 9%
B. Bike 14%
C. Walk 38%
D. Transit 38%
E. Other 1%

Mindmixer Results

The Chicago Department of Transportation also ran a Mindmixer campaign at the same time as the Textizen poll. Mindmixer helps governments get feedback from residents by letting them post ideas on different topics. One of the most popular ideas on this Mindmixer poll was the idea to create a suburban bus station on the empty lot at Michigan and Roosevelt.

The Chicago Department of Transportation will use the results of the campaigns to further develop their Complete Street design guidelines. You can find our more information about the program on the Chicago Department of Transportation website.

Textizen Record set for most participation in a Spanish Language Poll 

This CDOT campaign had the most participation out of any previous Textizen poll with 221 total responses. CDOT achieved this by deploying an equal number of ads and using different photos. CDOT also gave presentations at Spanish speaking audiences to help spread the word.

The campaign also hit several community blogs which helped spread the word throughout different neighborhoods.

Next step: Crunching numbers

The next step for CDOT is to take the Textizen and Surveymonkey results and merge them together. The team will then start to run analysis so they can give better guidance to policy makers. When the CDOT team makes their recommendations for placemaking, the document will likely have a lot of technical information.  CDOT intends to interject results from the survey into their recommendations so that they can tie their results back to people.

To keep up with the progress, you can visit http://www.chicagocompletestreets.org/ for more inforation on CDOT’s efforts.

If you think that Textizen could help you government agency or non-profit, feel free to start a conversation with us here!

Foodborne Chicago is a Top 25 Innovation in Government

Foodborne Chicago Twitter characterToday our product, Foodborne Chicago, was recognized by the Ash Center for Democratic Governance and Innovation. Here’s their writeup:

FoodBorne Chicago
City of Chicago, IL

On March 23, 2013, the Chicago Department of Public Health and the SmartChicago Collaborative launched the FoodBorne Chicago web application with the goal of improving food safety in Chicago. FoodBorne Chicago tracks tweets using a supervised machine-learning algorithm that identifies the keywords of “food poison” within the Chicago area. This tool allows residents to report a food poisoning incident through 311 after the program identifies tweets with possible cases of food poisoning. The team then tweets back a link to submit an online web form where residents can identify where they ate, the date and time they frequented the restaurant, their symptoms, and send it through Open311. The information is sent directly to the Department of Public Health and, if warranted, an inspection team visits the restaurant in question and then lets the resident know the status of the investigation via e-mail. The algorithm gets smarter at identifying related tweets as the team replies to residents that are suspected to have a potential case of food poisoning to report. If several complaints occur together, these clusters can be investigated to prevent further illnesses from developing.

 

And here’s a snip from a press release from Mayor Rahm Emanuel:

The Chicago Department of Public Health (CDPH) has been recognized as a Top 25 program in this year’s Innovations in American Government Awards competition by the Ash Center for Democratic Governance and Innovation at the John F. Kennedy School of Government, Harvard University for its FoodBorne Chicago program.

Two years ago, CDPH and the SmartChicago Collaborative launched the FoodBorne Chicago web application with the goal of improving food safety in Chicago.

“The Department of Public Health and the Department of Innovation and Technology used social media and technology to create a tool that makes food consumption in Chicago safer,” said Mayor Rahm Emanuel. “It is innovative thinking like this that enhances and leverages available resources to make the most impact.”

Summer Job Opportunity: Instructors for Youth-Led Tech Program in Five Chicago Communities

6948480920_6f945ab8f5_kUPDATE: All positions are filled.

The Smart Chicago Collaborative is getting ready to launch “Youth-Led Tech: Summer 2015”, a youth coding school in five locations across the city of Chicago in summer 2015.

We are working to get this program funded through Get IN Chicago, whose mission is to identify, fund and rigorously evaluate evidence-based programs that lead to a sustainable reduction in violence for individuals and communities most affected by violence and poverty. Read more here on our project page and complete this form if you are interested in a position.

In the interest of time, and an acknowledgement that the summer learning season is right about nowish, we are looking to start building staff for this potential program.

We are recruiting seventeen people to take serve as instructors, coordinators, and other key roles. Each of these roles are an 8-week summer job opportunity. The start date is Monday, June 15, 2015, with two weeks of orientation and preparation. Instruction begins Monday, June 29, 2015 and ends on Friday, August 8, 2015, which is the last day of employment. We will perform background checks on all applicants.

The five communities are Austin, Englewood, Humboldt Park, North Lawndale, and Roseland. Here’s are the job descriptions:

Instructor

Instructors lead all instruction at a location. There is one Instructor for each of the five locations. All instruction materials will be provided, with detailed lesson plans to guide your day. A dominant mode of instruction is “kinesthetic learning”, a learning style in which learning takes place by the students carrying out physical activities, rather than listening to a lecture or watching demonstrations.

We practice “youth-led tech”, which means that we teach technology in the context of the needs & priorities of young people. We will train you on the fundamentals of youth-led tech, but experience in working with youth in the context of needs & priorities is a plus.

The main technology we’ll teach is WordPress, a free open-source content management system. Familiarity with WordPress is a plus, and you can become familiar with WordPress very quickly. We will also offer “whet your appetite”- style training in gaming and app development.

Each instructor will be given a lesson plan for each day breaking down activities and explicitly laying out training content. Most of the actual training content will be taken from existing tutorial and instruction that is already available on the Internet in the form of teaching content and development environments. Instructors will also be responsible for documenting the program material so that it can be accessed, downloaded, and reproduced anywhere. Instructors will be responsible for filing daily reports about on-site activity.

In choosing instructors, we value strong classroom management, interest in and aptitude with technology, and the ability to listen to youth voice and make sure it gets heard and represented the the tech we make over the summer. Pay is $20 per hour.

Assistant Instructor

Assistant instructors will help Instructors to teach the material and also have other key responsibilities. These include activities like preparing the location each day (set up chairs, tables, computers), check the wi-fi, temperature, and other ambient details, order and manage lunch and snack, and assist in classroom management throughout the day.

We are seeking 10 Assistant instructors— three instructors for each location. Pay is $15 per hour.

Please apply today and share this opportunity as far and wide as possible. Questions? Contact us.

“Organize!”— Tech Training for New Civic Tech Leaders on National Day of Civic Hacking

logoOne of our three main areas of focus at Smart Chicago is digital skills. In the past three years, we’ve learned a lot of things from our experience running events, building projects, conducting user testing, and writing extensively about civic innovation.

As part of our work around National Day of Civic Hacking, this year we’re going to be focusing our efforts around teaching these digital skills both locally and nationally. As usual, this effort will be led by Christopher Whitaker.

Christopher has written a number of tutorials and guides to help volunteer civic technology groups for the national Hack for Change website.

Here in Chicago, he will run a training camp at Blue1647 for new civic technology leaders centered around the theme of community organizing. (Register here!)  On June 6th,  we’ll be bringing in experts around the city to help train new civic tech leaders on the tools and techniques used to leverage the power of technology to help our neighborhoods. The event is specially set up for people new to civic technology regardless of their technology proficiency. This is a learning event— so bring your questions!

This event will be just one of many National Day of Civic Hacking events happening in Chicago including hackathons happening at the Adler Planetarium, Center for Neighborhood Technologies, the Chicago Public Library’s Maker Lab, and OpenGov Hack Night. We’ll be blogging about these events and more as we get closer to June 6th.

You can register for our event here.