County				Problem
Contra Costa 07			So there are a ton of registration precincts that exist on the gis map layer they sent us but aren't present in the consolidation file.  
				We're assuming that they are all 0 reg precincts.
				According to the county, they consolidate to the first 7 characters (eg ALHA801-A  is consolidated into ALHA801) so I can create 
				consolidations for them, the problem is that some are also not present in the precinct/district file so I don't know which districts the 
				consolidations will be in.  I've att'd a file that has a list of consolidated precincts and their associated registration precincts that 
				don't appear in the precinct district file.  If they can give us the districts that these precincts fall into, I think I can make this work.
				See file zero_reg_precs_and_consol.txt  ***CORRECTED BASED ON ADDITIONAL COUNTY DATA***
Lassen 18			County was unable to provide an SOV with results split by vbm/poll.  Since there were only 152 out of 6621 voters who voted 
				at the polls (according to SOS) - ***Ran entire SOV as if it were all vbm***
Los Angeles 19			0050001A is a reg precinct that is consolidated into voting precinct 0050001A.  The SOV lists it as having 0 reg and 34 voters
				There are no records in the SOS or county reg file with that precinct.  Brian Ikenaga from L.A. said "Could be many reasons.  
				Depends on how these are issued.  Provisionals, CVR, curbside.  All these ballots are from the BMD.  Tally accounts for all the 
				ballots.  24 of them are provisional."  Treated this like we do for the 999 precincts and ignored error about no associated
				reg records.   ***USED AS IS***
				Also ran into issue with multiple districts assigned to svprecs where district is not active in election.  2300010B, 2300013A,
				2300042A, 3500016A and 5200175A had multiple SDs assigned.  ***Per previous decision, those SDs were set to 0***
Mendocino 23			the voter history file (4-VBM with History File.txt) shows 21469 A and 795 V in the last_voted field.  The SOV shows 21825 A and 423 V.
				Katrina Bartolomie said that they had 337 Provisionals and and 8 CVRs that may have been put in to different categories for the 
				voter history as compared to the SOV ***USED AS IS***
Merced 24			srprec 417 looks to be in SD 4 but voted in SD 14 ***NO RESPONSE FROM COUNTY. USED AS IS*** 
				After running mis-districted precincts, Cecilia found 8 rrprecs (from the rgprec map) that were assigned
				to an incorrect district:on the county’s map:
				rrprec	map	should be in
				BAL02	AD22	AD27
				BAL04	AD27	AD22
				BOR00	AD27	AD22
				FAR01	AD22	AD27
				EUC00	SD04	SD14
				GUN01	AD27	AD22
				GUN02	AD22	AD27
				RAI00	SD04	SD14
				Was corrected in general election ***USED AS IS***
Orange 30			'99999' precinct in SOV is not in consol or prec/dist file and has multiple values for totreg/totvote.  Per Justin Berardino 
				“The 99999 precinct is the accumulation of precincts with turnout of 1-9 ballots cast – to protect the voter’s choice”
				“ The 99999 precinct is the sum of all precincts with 1-9 voters. For Countywide contests, that would be all the precincts with 1-9 
				voters. For the 40th district, for example, it’s only the sum of the precincts in the 40th district with 1-9 voters – which is why it’s 
				less than the countywide contests.”  ***Set districts to all zeros.  Ignored differences in district totals.  Ignored error of no 
				matching rgprecs.  Basically treated like L.A. 999 precincts***
Plumas 32			GIS layer is missing rgprecs
San Francisco 38		County says precinct 9900 no longer exists but it’s in the SOV (0 reg/0 vote).  County says it should have been removed ***REMOVED FROM SOV***
Solano 48			srprec 51690 looks to be in CD 4 but voted in CD 8.  John Gardner, Asst Registrar said “From my cursory review of this, it does appear that we had 
				56190 in the incorrect CD for the June Primary Election.  It looks like this was about 150 voting voters, not sure if that helps/hurts.  Based on the notes
				on the precinct, this was discovered in July, and corrected for the November General Election." ***ASSIGNED TO CD 8 IN SOV AND USED AS IS***
Trinity 53			The voter history file (Voter History File.txt) last_voted field shows 3616 A and 117 V while the SOV shows 3687 A and 53 V.  
				Shanna from county elections says it is probably due to a difference in how they categorized vote method between the SOV and 
				the voter history.  ***USED AS IS***
				Used g22 gis layer for rgprec map since p22 layer was missing precincts