Code for North Carolina

Making our community a better place to live, work, and play through technology.

Code for [My Town]

Latest Project Activity

Alex Lemann School Navigator Update #24

We met today and got a lot done, including:

  • Major SES/Emailing improvements (Colin)
  • Updated School Profile & Survey Form Templates (Alex + Sarah)
  • Fixed creating new schools in the admin (Jeremy)
  • Fixed huge security hole in API permissions (Jeremy)
  • Fixed Submit Date for new surveys (me)
  • Created a new Resend Survey admin action (me)
  • Updates to the school profile (Victor)
  • Developer documentation improvements for running front-end + backend locally (Colin)
  • Added Jeremy to production server (Jeremy + Colin)
  • Setup default field values in survey/profile for specific fields depending on type of school (Victor)

Outstanding items for launch: More QA & Testing!

There's a sample schools: You can set your email to the principal email. Send yourself a survey. Fill it out. We will be using that sample school as a demo in our meeting next Tuesday at 9am….

Sarah, Colin, and Jeremy also had a productive meeting with DPS this week. Here are the notes:

We will be at the meeting of school principals next week to demo the project and ask for everyone to fill out the survey.

Ron Stebelton Affordable Housing (Data Hub) Update #10

  • Added a new graph for the ACS Gross Rent Percent Household Income ** The graphs were pretty cluttered ** Experimented with line, bar, stacked bar ** Experimented with rolling some of the data up ** Was pretty easy for Ron to manipulate the data and show visualizations locally

  • Worked with Sarah to bring her up to speed on the project and bounced ideas around with her to see if we could come up with a good way to show the data

  • Sarah had a great question - "What story do we want to tell?"

NEXT STEPS: * Need to be able to have others run the site locally * Need to deploy the site hosted externally * Need get a good grasp on the visualizations we want

Adam Martin Affordable Housing (Data Hub) Update #9

  • Created new, simpler application stack for exploring data (moved away from SF housing hub template)
  • Created Slack Channel for better remote, real time communications
  • Scheduled SME interviews with Karen Lado (Durham Aff Housing Consultant) & had call with Shoshana (Commercial Real Estate Professional)
  • Proved dynamic usage of Durham Portal data
  • Established process
  • Onboarded Jen H - Welcome!

Next Steps

  • Get current app hosted on GH pages (Ron)
  • Documenting latest app version in Github (Ron)
  • Create well-formed data for some new graphs (Ben)
  • Discuss strategy/priorities with Karen Lado (Adam)
  • Give UI feedback (Jen)

Jeremy Freeman School Navigator Update #23

  • reviewed UI on touch/phone (Rosa)
  • reviewed state test data consolidated by David
  • tested production app and noted issues with WG Pearson shape file (Will)
  • worked on NC teaching working conditions survey data cleaning
  • more work on school profile survey design (Sarah)

Dane Summers Bike Safety Application Update #14

We worked on fleshing out the 'user contributed data' milestone:

  • Brian worked on analyzing data - he's been working on a shiny app of the analysis (the clustering table at the bottom is pretty interesting):
  • Dane & Peter worked an adding more data to the map; added more tickets to the system.
  • Dane reached out to the NCDOT about updates to the data; he is going to follow up with them about obtaining a bulk dataset of pedestrian accidents.

Adam Martin School Navigator Update #22

  • Migrated data from schools to the new School Profiles
  • Created automated email survey tool to send to school principles to collect school profile data not currently available
  • Collected feedback form User Design professional and made edits (Thanks Rosa!)
  • 75% finished pulling NC DPI School Teacher Working Conditions Survey data

Colin Copeland Open Data Policing NC Update #4

Alejandra, Dylan, and Colin discussed mapping ideas for the Fayetteville data:

  • Race of stops compared to block demographics by census blocks
    • Determine if percentage is reasonable
    • Color/intensity indicates if area is over/under represented
    • Problem: commuters may not live in that census block
  • For a given stop cause that is typically inappropriate, color blocks based on relative percentage of types over stops in that block
    • Problem: highlights more busy roads

Adam Martin School Navigator Update #21

  • Alex and Sarah met with the Durham Charter Collaborative (which is board members and principals from Durham's charter schools) last week and they were very excited about the site. They all agreed to complete the survey once it's ready.
  • Sarah is reaching out to a handful of administrators from the 3 types of schools to get their feedback on the profile and confirm that we're not a) using the wrong language/categorizations anywhere b) asking for unrealistic info c) get their buy-in. So far so good.
  • Onboarded Melissa - who made her first commit - Awesome!
  • Victor cleaned up new survey form HTML & setup django environment
  • Jeremy reviewed NC Teacher Satisfaction survey data

Ron Stebelton Affordable Housing (Data Hub) Update #8

The relative path issue for the css and links looks like it is now resolved on both the local and

There is still an issue with the graphs not showing on, but they are showing up locally.