Vyki Englert vykster

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

Vyki Englert, Product Manager BrightHive, Advisor CityGrows

Online tutorials:

	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

	# 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

	#!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