Each redistricting dataset merges the electoral data the SWDB collected and processed over the preceding decade with the most current census data (PL94-171). The result is a census block level dataset that allows for longitudinal analysis of electoral data over time on the same unit of analysis. Electoral data consist of the Statements of Vote (SOV) and Statements of Registration (SOR) for each statewide election. These data are collected from the Registrars of Voters for each of the 58 California counties with each election.
The SWDB collects the Statement of Vote and the Statement of Registration along with various geography files from each of the 58 counties for every statewide election. The Statement of Vote is a precinct level dataset and precincts in California change frequently between elections. The goal of the SWDB is to make election data available that can be compared over time, on the same unit of analysis – a precinct, a census block or a census tract.
Conversion and assignment files are used for translating data from one geographic unit of analysis to another.
Assignment files are used to assign one geographic unit to another when there is no overlap between the geographic units. Assignment files generally have two columns, one column indicating the geographic unit to be assigned and the second column containing its corresponding assignment to the other geographic unit.
An example of one of our most commonly used assignment files is our block to district assignment file. This file contains the census block numbers and their corresponding assignment to a given set of districts such as Assembly, Congressional, Senate, or the Board of Equalization districts. This is possible because census blocks do not cross district lines and as such they are either wholly within a given district or they are not.
Conversion files become necessary when there is overlap between geographies and as a result a geographic unit can not be wholly assigned to another as it is only partially contained within another geographic unit. In this case, its neccesary to 'translate' the geography from one geographic unit to another. Therefore conversion files will have a third column indicating the ratio of the geographic unit contained with in the other.
For instance, census tracts will often only be partially contained within a given census place. In this case, a census place to census tract conversion file can tell you what portion or ratio of a census tract is contained with a given census place. These ratios can be determined using either the census block population of the tract contained with the census place or the percentage of area of the tract contained with in the census place.
2011 Legislative Districts to Census Geography, Zip codes and Other Areas
2001 and 1991 Legislative Districts to Census Geography, Zip codes and Other Areas
2010 - 2002 Precinct Conversion Files: Precinct boundaries change with every election. The precinct conversion files available on the Precinct Geography and Conversion pages are used for merging precinct data to other geographic areas such as census blocks and cities.
2000 - 1992 Precinct Conversion Files
We would love to help. Please leave us a message and we will get right back to you: