Title

Statewide Database Diagram


Diagram 1

This diagram illustrates the naming scheme for conversion files in the SWDB. These conversion files are available here.

image

Precinct Conversion File Types:

Alpha Indicators Precinct Conversion Capability
PB 1990 Census Blocks => SR
PC 1990 City => SR
PD RR => SR
PE 1990 City => RG
PF 1990 City => RR
PG RR => RG
PR RR => SR
PS SR => RG
PT SR => RR
PU RR => SV
PV SV => SR
PW [SR => RR ; SR => RG]
PX RG => RG (cross election)
PZ SR => SR (cross election)

Definitions:

RG = Original Registration Precincts (designated by County Registrar)

RR = Registration Precincts (geographic unit constructed for statistical merging purposes by SWDB)

SV = Original Voting Precincts (designated by County Registrar)

SR = Consolidated Precinct (geographic unit constructed for statistical merging purposes by SWDB)

1990 City = City Area (designated by US Census Department)

1990 Census Blocks = Census Blocks (designated by US Census Department)

1990 Census Tracts = Census Tracts (designated by US Census Department)

"Cross Election" = moving between election years, i.e. from 1994 geography to 1996 geography

Other Conversion File Types:

Name Conversion Capability
RR-G92-BL-C90_AD##.CNV RRG92 => 1990 Census Blocks
RR-G92-BL-C90_CY##.CNV RRG92 => 1990 Census Blocks

Naming Convention: "origin unit"-"election and year" -"destination unit"_"coverage".CNV

Definitions:

"##" = wildcard symbol

1990 Census Blocks = Census Blocks (designated by US Census Department)

RR = Registration Precincts (geographic unit constructed for statistical merging purposes by SWDB)

Diagram 2

This diagram illustrates the relationship between different types of precincts you may find in our datasets.

image

Precinct Types:

RG = Original Registration Precincts (created by County Registrar of Voters)

RR = Registration Precincts (created as part of the SWDB merging process)

SV = Original Voting Precincts (see 1)

SR = Consolidated Precinct (see 2)

These are links to pages explaining "Geographic Hierarchy for the 1990 Decennial Census" and "Small Area Census Geography in the 1990 Census." These pages were drawn from the Geographic Area Reference Manual, Chapter 2, pages 7 and 9. This document is available on the census Web site at www.census.gov.



Overall precinct relationship

The counties have registration (RG) and Voting or consolidated (SV) precincts as well as ballot groups for each election. Registration statistics are reported by RG precinct and election results are reported by SV precinct and/or ballot group (ABSPREC). The counties also report the grouping of RG precincts in SV precinct and Ballot group (although the ballot group reporting is inconsistent and incomplete).

The counties also provide maps or gis files showing registration precinct geography, but the geographic representations do not necessarily match the RG precincts for one or more of the following reasons.

  • 1. Zero voter precincts not included in tabular data.
  • 2. County has precinct and subprecinct RG precincts and consolidations, but maps don't show subprecinct geography.
  • 3. County has alpha-split precincts; Separate RG precincts with common geography, voters separated alphabetically.
  • 4. Unexplained inconsistency or incomplete maps.

We create map precincts (MPREC) to reflect the geography as consistently as possible. RR precincts are aggregations of RG precinct (tabular data) into MPRECs (geographic). (Generally speaking Map Precincts are RR precs)

Because the resulting RR precincts may include RG precincts that are consolidated into different SV precincts we create a geographic consolidation know variously as SS or SR precincts to contain whole RR and SV precincts.



Diagram 3: A simple diagram of nesting

image

The SR precincts are the level at which precinct election results can be given a geographic representation.