Home → New Client Setups → Special Clients → CompleteGov: Contra Costa County Board of Supervisors
4.3. CompleteGov: Contra Costa County Board of Supervisors
The Contra Costa Board of Supervisors (CID 10025) consists of 5 districts, each with their own CompleteGov database. Some were converted from Constituent Services and others started with a voter file import instead. The contract included an initial email append and annual data matching. The districts were converted gradually from late 2012 to mid 2013 and each district has its own preferences. So, take note of the details by district below.
The primary contact for all districts is Ed Woo (Ed.Woo@doit.cccounty.us / 925-408-9997). He is a very nice guy, but can be difficult to get a hold of and our emails frequently go to spam. I've been trying for 4 months to have him send an authorization letter needed before we can proceed with the next voter file purchase for 2014. Basically, their county registrar is very strict regarding use of data. So, each year he will need to send a letter confirming Aristotle's relationship with them to get the data on their behalf. (See attached example.) After he sends it back to us, we forward the letter on to Trent Matheson to initiate a new purchase.
IMPORTANT NOTE: When importing voter information, make sure to ignore election history and set the Party value for ALL records to "N/A". They are not allowed to see that information in the board of supervisor databases. I've attached the original import SQL for District 4 as an example. Also, keep in mind the mailing addresses are often inconsistent and need close review post-import since the Address Block logic (@AB_ parameters) isn't perfect.
gov_CCCBOS1
- No voter data has been appended. It was a straight conversion from CS. When in CS, they had a separate dataset for the full voter file. But, the new contract only allowed them one dataset and they have opted to not mix the two.
gov_CCCBOS2
- Spouses are used for householding instead of auto-householding.
- Import was a mix of CS and a voter file.
gov_CCCBOS3
- Initial import was from a voter file, not CS.
- Email append job was never completed. Check with Amy Peterzell for more information, but she was unable to get email language approval from that district.
gov_CCCBOS4
- Initial import was from a voter file, not CS.
gov_CCCBOS5
- Initial import was from a voter file, not CS. (They were previous CS users, but decided to import from a clean voter file rather than use the old CS data.)
Their contracts are located here: \\hqs-file1\P_Drive\CONTRACTS\10025 CONTRA COSTA COUNTY SUPERVISOR