Merger of Statement of the Vote and Registration Precincts

Mergers of the Statement of Vote (SOV) to Registration Precincts (Reg) are done as follows:

RG##AD%%.TYR
RR##AD%%.TYR
SA##AD%%.TYR
SR##AD%%.TYR
SS##AD%%.TYR
SV##AD%%.TYR

Here, the ## is the alphabetic number of the county (1-58), %% is the Assembly District, and TYR is the type of election (T can be either G for General or P for Primary, YR is the year). So, for example, for the 72nd Assembly District in Orange County, there would be six files:

RG30AD72.G92
RR30AD72.G92
SA30AD72.G92
SR30AD72.G92
SS30AD72.G92
SV30AD72.G92

A description of the files follows:

RG file

This has the registration precinct as obtained from the Secretary of State 29-day close of registration tape and the total number of registered voters, also obtained from this file.

Example:

0002016A 710
0002016B 114
0002017A 414
0002017B 928

SV file

This has the SOV precinct the total number of registered voters, and the polling place vote for that SOV precinct. All of this information is obtained from a tape or hardcopy provided by the county.

Example:

0002001N 448 275

SA file

This has precincts which are absentee precincts.

Example:

8000001Y

RR file

This has consolidations between registration precincts made to facilitate the merger of SOV, Reg, and census data. The left-hand column is the precinct which is mapped to the census geography. If a Reg precinct is not in the RR file but is in the RG file then it is mapped to the census geography.

Example:

0002016 0002016A

SS file

This has consolidations between SOV precincts made to facilitate the merger of SOV, Reg, and census data. The left-hand column is the precinct which is mapped to the census geography.

Example:

0002702N 0002701N

SR file

This has consolidations between SOV and Reg precincts. If an SOV precinct is in the left-hand column of the SS file, it will appear in the left-hand column of the SR file. If it is in the right-hand column of the SS file, it may not appear in the left-hand column of the SR file. If the SOV precinct is not in the SS file but is in the SV file, it will appear in the left-hand column of the SR file.

Similarly, if a Reg precinct is in the left-hand column of the RR file, it will appear in the right-hand column of the SR file. If the Reg precinct is in the right-hand column of the RR file, it will not appear in the right-hand column of the SR file. If the Reg precinct is not in the RR file but is in the RG file, it will appear in the right-hand column of the SR file.

Example:

0002702N 0002016

---

This scheme can be conceputalized as follows: SOV precincts are associated with Reg precincts in the SR file. Both SOV precincts and Reg precincts may be consolidated with one another, the SOV precincts in the SS file and the Reg precincts in the RR file. If there is a consolidation, the consolidated precinct is the precinct which is used in the SR file--if not, the precinct from the lower-level file (SV or RG) is used in the SR file. Schematically,

                        SR              
                       /  \             
                      /    \            
                     SS    RR           
                    /        \          
                   /          \         
                  SV          RG

Mergers of census data to the precinct are done to precincts at the RR level, or, if the precinct is not in that file, at the RG file.

Here is an example taken from Butte county, AD 03

       Master Precinct  10000101 totreg from sov, totreg from sor 1137 1137

             SOV precincts and reg in merger

           10000104   793
           10000101   344

             Reg precincts and reg in merger

           0001801   222
           0001851   107
                           0001851A   106
                           0001851B     1
           0001835    16
                           0001835A    16
           0001850   792
                           0001850A   792

The following entries are in the following files: SR04AD03.G92

                10000101 0001801
                10000101 0001835
                10000101 0001851
                10000101 0001850

SS04AD03.G92

                10000101 10000104

RR04AD03.G92

                0001851 0001851A
                0001851 0001851B
                0001835 0001835A
                0001850 0001850A

RG04AD03.G92

                0001801      222
                0001835A      16
                0001850A     792
                0001851A     106
                0001851B       1

SV04AD03.G92

                10000101     344     183
                10000104     793     501

There are five merged files created from this process.

MTYR##%%.TYR
RTYR##%%.TYR
STYR##%%.TYR
SG90##%%.TYR
PL94##%%.TYR