vykster

Online tutorials:

• The Odin Project New "paths" based free online curriculumm. http://www.theodinproject.com/

vykster

#!bin/bash

for f in v1-*
do
  x=$(echo $f | tr '[:upper:]' '[:lower:]' | sed 's/v1-//g' | sed 's/\.csv//g')
  echo "Processing $x"
  mkdir $x
  mkdir $x/2014-06-02
  mv $f $x/2014-06-02/v1
done

vykster

# Note this needs to be mapper_id, not import_file_id
MAPPER_TO_COPY = Mapper::Base.find(_ID_)
 
fipz = FipsCode.where(state: '_STATE_').where("county is not null").pluck(:id)
 
files = ImportFile::Voter.where(fips_code_id: fipz)
 
files.each do |file|
  new_mapper = MAPPER_TO_COPY.copy
  new_mapper.fips_code_id = file.fips_code_id

vykster

Run counts on production database,
  group by districts, fips (state? or county?)

        ## Political Info
        'party'
        'registered_at'
        'is_active_voter'
        'is_perm_absentee'

        ## District Info

vykster

Lessons from Grassroots Data Projects in the USA

Google Slides

Prepared for Society 4.0 Thursday November 8th 2018, Melbourne Australia

Vyki Englert, Product Manager BrightHive, Advisor CityGrows

Links for 14 Lessons

• Scope the problem first
• Designer’s indispensable skill: the ability to write and present a solid problem statement