Forsyth County

Board of Election Electronic Election Returns Service

Documentation Update date: 11/04/97

Prepared by Herman Schmid, FC MIS Department

This information is relevant only for the 1997 Municipal General Election of 11/04/97. Differing file sets and procedures are used in each primary and election so please refer to the appropriate documentation on the related world wide web page or ftp directory.

The Forsyth County MIS department works closely with the Forsyth County Board of Elections to provide LIVE election results (updated about every 15 minutes) during the election and a permanent archive of the official results when they become available after the election. The information is freely and publicly available in two ways:

1) via a World Wide Web page accessed through the Forsyth County Home Page at

http://www.co.forsyth.nc.us/

or directly at

http://www.co.forsyth.nc.us/boe/boe.htm

The WWW page presentation has been constructed to allow convenient access for anyone with a suitable www browser that supports HTML v2.0 or higher.

2) via the Forsyth County ftp server.

Connections to the server are provided via the WWW pages listed above or directly at ftp://ftp.co.forsyth.nc.us in the /pub/Election directory.

 

The ftp server provides all the files and programs used in the creation of the election return web pages. The files and program elements can be useful to anyone who might wish to process election data for their own purposes. There are three file elements:

    1. The raw data files. The raw ascii data files are produced from a data export module of the larger software system used to tabulate election results. This larger system was created by the Business Records Corporation (BRC).
    2. Using the raw data files, the FC MIS department uses Microsoft Access to process the data and create the web pages. The reports, querys and procedures used in the provided MS Access database are not represented to be a finished product whatsoever, but are simply a set of tools our staff changes and uses as appropriate to produce the required end result - web pages. Even the web pages generated by the system sometimes must be manually changed to fit the presentation needs. Therefore all files are provided on an "as is" basis and no completeness or service levels are implied or guaranteed. The database can be useful to 1) allow you to import the summary and precinct detail raw data into MS Access data tables and 2) serve as an example on creating html code from MS Access.

 

These files listed below contain either documentation, raw data, html output or the MS Access database used to process the raw data into output data.

documentation.* (Documentation file)

This file. Provided in MS Word, text and html formats.

Raw data files (ascii data, fixed column format):

sum.asc Election results summary records

det.asc Detailed precinct results records

See the MS Access table layouts below for field information.

Import drive and path specifications must be corrected in certain macros "Transfer Text" action.

MS Access v7.0 database files:

results.mdb

The database contains Macros and file import specifications to import the raw data files.

The precinct table in the database is used in the current processing.

BOE VOTE COUNT Table - Summary results table

Name

Type

Size

Race Nbr

Text

4

Candidate Nbr

Text

3

Eligible Precs

Text

4

Votes

Text

5

Counted Prec

Text

4

Party

Text

3

District Type

Text

3

District Code

Text

4

Race

Text

56

Candidate

Text

38

Race Type

Text

25

BOE VOTE COUNT DETAIL Table - Precinct detail results table

Name

Type

Size

Race Nbr

Text

4

Candidate Nbr

Text

3

Precinct nbr

Text

4

Votes

Number (Long)

4

Party

Text

10

Race

Text

56

Candidate

Text

38

Precinct name

Text

25

Precincts file: Numbers must match those in detail file for each election or detail processing will not work!! Precinct names used in presentation are taken from the Precinct file! The Participating Field must be updated each election!

Name

Type

Size

ID

Number (Long)

4

Precinct nbr

Text

50

Precinct name

Text

50

Precinct address

Text

50

Participating?

Yes/No

1

 

 

 

Output

File names are fully discretionary. In fact, the MS Access database asks for the file name. (Note that the MS Access creation of these files depends on using a printer defined as Generic Text and routed to a file. ) The names used below are only to mesh with FCís Board of Elections www page references). Browsers used must support TABLE views (html v2.0).

sum.htm HTML formatted results summary report

detail.htm HTML formatted results precinct detail report (large file).

999.htm When Official results are put out, some days AFTER the election, individual files are created for each precinct as a replacement for the large detail.htm above to facilitate web access. The 999 is where the number of each precinct is used for the filesí names.

precinct.htm HTML formatted reporting precincts report. This file is replaced the next day with one that individually accesses each detail precinct file.

Special notes:

An acronym is need for this system. Donít bother submitting the obviously discarded candidate from the name at document top. ;-)

email comments to:

Kathie Cooper, Director of Elections, Forsyth County

k_cooper@co.forsyth.nc.us

Herman Schmid, MIS department, Forsyth County

schmid@co.forsyth.nc.us