Voter Power Database Report

Voter Power Database report

1.Database management report:

------

Recommendations about design and implementation of our database needs. Multiple lists need managing. Need to able to import and export data between users systems. This means standardization of file layouts and other programmer type functions. We'll probably exchange info in comma delimited text files and keep them in the users individual databases, requiring import routines that intercept duplicates. We want to make it 'smart' and replace fields as necessary, check dates for which record is more current, etc.

It would be best to have a 'main' database with copies sent to those with a requirement, ie- Stormy wants a list. Stormy would send back updates and the 'main' would keep her updated from other users updates to the 'main'.

* Current Data Definitions

list of TABLEs currently in the application. They are described in detail below.

ACTIVIST.DBF / Number of data records: 64 / WHERE, NAME, ADDR info + PREV
FLIERVOL.DBF / Number of data records: 1012 / Basic WHERE and NAME, ADDR info
LASTNAME.DBF / Number of data records: 766 / Basic WHERE and NAME, ADDR info
METRO.DBF / Number of data records: 2480 / WHERE, NAME, ADDR info + PREV
REG6-26.DBF / Number of data records: 0
REG5-25.DBF / Number of data records: 87 / WHERE, NAME, ADDR info + PREV
REGIOFF.DBF / Number of data records: 1867 / WHERE, NAME, ADDR info + PREV
REGIVOTE.DBF / Number of data records: 5877 / WHERE, NAME, ADDR info + PREV
ZIPS.DBF / Number of data records: 486
ZREGIVOT.DBF / Number of data records: 5868 / WHERE, NAME, ADDR info + PREV
Number of tables: 10 / Total number of data records: 18507

Development thots of Beau and Perry:

------

Prime objectives in development is:

a. Easy for any user. Means extra programming and documenting – each and every procedure no matter how simple sounding. Push button (GUI) & turn-key systems; ease of operation. Menu driven systems, Big buttons w/ description of function performed. Lotsa help on the screens. Lowest common user denominator. Editing (dates, numbers) logic.

b. Easy for any programmer. Means extra time. Well documented and designed (naming conventions, data dictionaries) for 'turnover' purposes; ie- any programmer semi familiar w/ the language should be able to pick it up. This is partly handled by making it a menu driven, user friendly flow. Also means - CHANGE CONTROL; very important if/when multiple people working on the parts. Production and development levels so that changes are made and tested, then applied. Backout procedures.

We should maintain A good list of the data and functions, related program modules and the locations. System inventory. Documentation!

* Requested Data Definitions

requested TABLEs, per (JS) 3/1/99

1. Contributors; / full $ history so if aggregate > $50 = reporting, etc.
2. Voters; (from Regis) / Name, Addr, DoB, Political Party, Phone
3. Volunteers; / history of how they helped.
4. Patients; / Condition (desc, ICD9#, etc.), caregiver, willing to do media
5. Doctors; / willing to recommend mmj … y/n/m, docm sent, protesters sent … etc. / info reporting stamps – who, date/time, via (phone, letter)
6. Media; / history of coverage
7. Orgns; / sister organizations – AAL, NORML, OMR, MPP, DPF, WHEN, Lindesmith
8. Advertisers; / Ad bitmap, financial history. / newspapaers, et al.
9. Legislators;
10. Other Public Officials / (cops, d/a's, other enemies of the people)

also …

1. Want to break down voters by precinct and district. Must get info from state services. They will prove info on disk for a fee.

2. and on ...

First 'table' in our database should be -

------

1.Contacts

------

Name / Numbers / eMail / Notes
Amy Klare /
Anti-Prohibition Lg /
Barry Joe Stull /
Chris Rich / c.441-2224 /
Curt Wagoner /
Dan Koozer /
Dave Fratello /
David Fidanque /
Ed Copeland / 239-8930
Ed Glick /
Ethan Nadelmann /
Floyd Prozanski / has introduced a hemp bill!
Fred Oerther /
Geoff Sugarman /
George Eighmey /
Gerry Kulp / 541-899-1452 / / (Hemp Club So Ore U)
Jack Herer / 818-988-6210 /
Jo Ann Bowman
John Sajo / 541-670-3382 /
Kate Brown
Kevin Zeese /
Laird Funk /
Lee Berger / 287-4688 /
Michael Kleinman / 512-478-3946, Fax.512-478-5915 /
Michael Rose / 235-6808, Work.221-1792 /
OMR hotline / 877-600-6767 / toll free #
Perry Stripling / 691-2898 / / Norml/pdx
Rick Bayer /
Rik Huhtanen /
Rob Killian / chief petitioner for prop 692 in Washington State.
Robert Harris /
Sandee Burbank /
Shawn Miller / 772-0233
Stephen Principal /
Stormy Ray / (541) 889-3876, .or.(541) 881-0171 /
Terry "T.D." Miller / 777-9088, Cell.706-8064 / / Norml/pdx
Tod Mikuriya /
Tony Leger / (360) 694-9353 /
Voter Power office / 503-736-0907 / / 3950 SE Hawthorne Portland OR 97214

Example of City to County table. Used to lookup when only City is given and County not provided.

City / County
Adams / Umatilla County
Adel / Lake County
Adrian / Malheur County
Arch Cape / Clatsop County
Arlington / Gilliam County
Arock / Malheur County
Ashland / Jackson County
Ashwood / Jefferson County
Astoria / Clatsop County
Athena / Umatilla County
Aumsville / Marion County
Aurora / Marion County
Azalea / Douglas County
Baker City / Baker County
Bandon / Coos County
Banks / Washington County
Bates / Grant County
Beaverton / Washington County
Bend / Deschutes County
Blachly / Lane County
Black Butte Ranch / Deschutes County
Blodgett / Benton County
Blue River / Lane County
Bly / Klamath County
Boardman / Morrow County
Boardman / Mount Hood county
Bonanza / Klamath County
Boring / Clackamas County
Bridal Veil / Multnomah County
Bridgeport / Baker County
Brightwood / Clackamas County
Broadbent / Coos County
Brogan / Malheur County
Brookings / Curry County
Brooks / Marion County
Brothers / Deschutes County
Brownsville / Linn County
Burns / Harney County
Butte Falls / Jackson County
Woodburn / Marion County
Yachats / Lincoln County
Yamhill / Yamhill County
Yoncalla / Douglas County

Example of Media data. Source is primarily the Blue Book from the State of Oregon. Pulled from a web site, then converted from text to individual fields of data.

(see attached) Media

Example of Organization data. Source is primarily the the internet, from High Times. Pulled from a web site, then converted from text to individual fields of data.

(see attached) Orgns

Current application TABLEs - detail definitions

10 tables

ACTIVIST.DBF / Number of data records: 64
FLIERVOL.DBF / Number of data records: 1012
LASTNAME.DBF / Number of data records: 766
METRO.DBF / Number of data records: 2480
REG6-26.DBF / Number of data records: 0
REG5-25.DBF / Number of data records: 87
REGIOFF.DBF / Number of data records: 1867
REGIVOTE.DBF / Number of data records: 5877
ZIPS.DBF / Number of data records: 486
ZREGIVOT.DBF / Number of data records: 5868

Structure for table: C:\NORML\DB\VPWR\ACTIVIST.DBF

Number of data records: 64

Field / Field Name / Type / Width Dec / Index Collate / Nulls
1 / WHERE / Character / 11 / No
2 / EVENT / Character / 20 / No
3 / LASTNAME / Character / 20 / Asc Machine / No
4 / FIRSTNAME / Character / 20 / No
5 / MIDNAME / Character / 15 / No
6 / RESADDR / Character / 30 / No
7 / CITY / Character / 15 / Asc Machine / No
8 / STATE / Character / 2 / No
9 / ZIP / Character / 10 / Asc Machine / No
10 / MAILADDR / Character / 25 / No
11 / MAILCITY / Character / 15 / No
12 / MAILZIP / Character / 10 / No
13 / DOB / Date / 8 / No
14 / PARTY / Character / 3 / No
15 / PARTYOTHER / Character / 10 / No
16 / DATE_REG / Date / No
17 / COUNTY / Character / 10 / No
18 / PHONE / Character / 14 / No
19 / REG_PREV / Logical / 1 / No
20 / PREV_NAME / Character / 30 / No
21 / PREV_CNTY / Character / 10 / No
22 / PREV_STATE / Character / 2 / No
23 / PREV_ADDR / Character / 45 / No
24 / PERM_ABSEN / Logical / 1 / No
25 / WILL_SIGN / Logical / 1 / No
26 / MAIL_LIST / Logical / 1 / No
27 / HOW_VOTE / Logical / 1 / No
28 / COMMENTS / Memo / 4 / No
29 / FEEL / Date / 8 / No
30 / USCITIZEN / Logical / 1 / No
** Total ** / 352

Structure for table: C:\NORML\DB\VPWR\FLIERVOL.DBF

Number of data records: 1012

Field / Field Name / Type / Width Dec / Index Collate / Nulls
1 / WHERE / Character / 11 / Asc Machine / No
2 / LASTNAME / Character / 20 / Asc Machine / No
3 / FIRSTNAME / Character / 20 / No
4 / MIDNAME / Character / 1 / No
5 / RESADDR / Character / 30 / No
6 / CITY / Character / 15 / Asc Machine / No
7 / STATE / Character / 2 / No
8 / ZIP / Character / 10 / Asc Machine / No
9 / DATE_CONT / Date / 8 / No
10 / COUNTY / Character / 10 / No
11 / PHONE / Character / 14 / No
12 / FAX / Character / 14 / No
13 / EMAIL / Character / 30 / Asc Machine / No
14 / YARD_SIGN / Logical / 1 / No
15 / MAIL_LIST / Logical / 1 / No
16 / VOL_LABOR / Logical / 1 / No
17 / COMMENTS / Memo / 4 / No
18 / HOW_VOL / Character / 25 / No
19 / DONATE_AMT / Numeric / 7 / 2 / No
** Total ** / 225

Structure for table: C:\NORML\DB\VPWR\LASTNAME.DBF

Number of data records: 766

Field / Field Name / Type / Width Dec / Index Collate / Nulls
1 / WHERE / Character / 11 / No
2 / LASTNAME / Character / 20 / No
3 / FIRSTNAME / Character / 20 / No
4 / MIDNAME / Character / 1 / No
5 / RESADDR / Character / 30 / No
6 / CITY / Character / 15 / No
7 / STATE / Character / 2 / No
8 / ZIP / Character / 10 / No
9 / DATE_CONT / Date / 8 / No
10 / COUNTY / Character / 10 / No
11 / PHONE / Character / 14 / No
12 / FAX / Character / 14 / No
13 / EMAIL / Character / 20 / No
14 / YARD_SIGN / Logical / 1 / No
15 / MAIL_LIST / Logical / 1 / No
16 / VOL_LABOR / Logical / 1 / No
17 / COMMENTS / Memo / 4 / No
18 / HOW_VOL / Character / 25 / No
19 / DONATE_AMT / Numeric / 7 / 2 / No
** Total ** / 215

Structure for table: C:\NORML\DB\VPWR\METRO.DBF

Number of data records: 2480

Field / Field Name / Type / Width Dec / Index Collate / Nulls
1 / WHERE / Character / 11 / No
2 / EVENT / Character / 20 / No
3 / LASTNAME / Character / 20 / No
4 / FIRSTNAME / Character / 20 / No
5 / MIDNAME / Character / 15 / No
6 / RESADDR / Character / 30 / No
7 / CITY / Character / 15 / No
8 / STATE / Character / 2 / No
9 / ZIP / Character / 10 / No
10 / MAILADDR / Character / 25 / No
11 / MAILCITY / Character / 15 / No
12 / MAILZIP / Character / 10 / No
13 / DOB / Date / 8 / No
14 / PARTY / Character / 3 / No
15 / PARTYOTHER / Character / 10 / No
16 / DATE_REG / Date / 8 / No
17 / COUNTY / Character / 10 / No
18 / PHONE / Character / 14 / No
19 / REG_PREV / Logical / 1 / No
20 / PREV_NAME / Character / 30 / No
21 / PREV_CNTY / Character / 10 / No
22 / PREV_STATE / Character / 2 / No
23 / PREV_ADDR / Character / 45 / No
24 / PERM_ABSEN / Logical / 1 / No
25 / WILL_SIGN / Logical / 1 / No
26 / MAIL_LIST / Logical / 1 / No
27 / HOW_VOTE / Logical / 1 / No
28 / COMMENTS / Memo / 4 / No
29 / FEEL / Date / 8 / No
30 / USCITIZEN / Logical / 1 / No
31 / EMAIL / Character / 60 / No
** Total / 412

Structure for table: C:\NORML\DB\VPWR\REG6-26.DBF

Number of data records: 0

Structure for table: C:\NORML\DB\VPWR\REG5-25.DBF

Number of data records: 87

Field / Field Name / Type / Width Dec / Index Collate / Nulls
1 / WHERE / Character / 11 / No
2 / EVENT / Character / 20 / No
3 / LASTNAME / Character / 20 / No
4 / FIRSTNAME / Character / 20 / No
5 / MIDNAME / Character / 15 / No
6 / RESADDR / Character / 30 / No
7 / CITY / Character / 15 / No
8 / STATE / Character / 2 / No
9 / ZIP / Character / 10 / No
10 / MAILADDR / Character / 25 / No
11 / MAILCITY / Character / 15 / No
12 / MAILZIP / Character / 10 / No
13 / DOB / Date / 8 / No
14 / PARTY / Character / 3 / No
15 / DATE_REG / Date / 8 / No
16 / COUNTY / Character / 10 / No
17 / PHONE / Character / 14 / No
18 / REG_PREV / Logical / 1 / No
19 / PREV_NAME / Character / 30 / No
20 / PREV_CNTY / Character / 10 / No
21 / PREV_STATE / Character / 2 / No
22 / PREV_ADDR / Character / 45 / No
23 / PERM_ABSEN / Logical / 1 / No
24 / WILL_SIGN / Logical / 1 / No
25 / MAIL_LIST / Logical / 1 / No
26 / HOW_VOTE / Logical / 1 / No
27 / COMMENTS / Memo / 4 / No
28 / FEEL / Date / 8 / No
29 / USCITIZEN / Logical / 1 / No
30 R / PARTYOTHE / Character / 10 / No
** Total ** / 352

Structure for table: C:\NORML\DB\VPWR\REGIOFF.DBF

Number of data records: 1867

Field / Field Name / Type / Width Dec / Index Collate / Nulls
1 / WHERE / Character / 11 / Asc Machine / No
2 / EVENT / Character / 20 / No
3 / LASTNAME / Character / 20 / Asc Machine / No
4 / FIRSTNAME / Character / 20 / No
5 / MIDNAME / Character / 15 / No
6 / RESADDR / Character / 30 / No
7 / CITY / Character / 15 / No
8 / STATE / Character / 2 / No
9 / ZIP / Character / 10 / Asc Machine / No
10 / MAILADDR / Character / 25 / No
11 / MAILCITY / Character / 15 / No
12 / MAILZIP / Character / 10 / No
13 / DOB / Date / No
14 / PARTY / Character / 3 / No
15 / PARTYOTHER / Character / 10 / No
16 / DATE_REG / Date / 8 / No
17 / COUNTY / Character / 10 / No
18 / PHONE / Character / 14 / No
19 / REG_PREV / Logical / 1 / No
20 / PREV_NAME / Character / 30 / No
21 / PREV_CNTY / Character / 10 / No
22 / PREV_STATE / Character / 2 / No
23 / PREV_ADDR / Character / 45 / No
24 / PERM_ABSEN / Logical / 1 / No
25 / WILL_SIGN / Logical / 1 / No
26 / MAIL_LIST / Logical / 1 / No
27 / HOW_VOTE / Logical / 1 / No
28 / COMMENTS / Memo / 4 / No
29 / FEEL / Date / 8 / No
30 / USCITIZEN / Logical / 1 / No
31 / EMAIL / Character / 60 / No
** Total ** / 412

Structure for table: C:\NORML\DB\VPWR\REGIVOTE.DBF

Number of data records: 5877

Field / Field Name / Type / Width Dec / Index Collate / Nulls
1 / WHERE / Character / 11 / Asc Machine / No
2 / EVENT / Character / 20 / Asc Machine / No
3 / LASTNAME / Character / 20 / Asc Machine / No
4 / FIRSTNAME / Character / 20 / No
5 / MIDNAME / Character / 15 / No
6 / RESADDR / Character / 30 / No
7 / CITY / Character / 15 / No
8 / STATE / Character / 2 / No
9 / ZIP / Character / 10 / Asc Machine / No
10 / MAILADDR / Character / 25 / No
11 / MAILCITY / Character / 15 / No
12 / MAILZIP / Character / 10 / No
13 / DOB / Date / 8 / No
14 / PARTY / Character / 3 / No
15 / PARTYOTHER / Character / 10 / No
16 / DATE_REG / Date / 8 / No
17 / COUNTY / Character / 10 / No
18 / PHONE / Character / 14 / No
19 / REG_PREV / Logical / 1 / No
20 / PREV_NAME / Character / 30 / No
21 / PREV_CNTY / Character / 10 / No
22 / PREV_STATE / Character / 2 / No
23 / PREV_ADDR / Character / 45 / No
24 / PERM_ABSEN / Logical / 1 / No
25 / WILL_SIGN / Logical / 1 / No
26 / MAIL_LIST / Logical / 1 / No
27 / HOW_VOTE / Logical / 1 / No
28 / COMMENTS / Memo / 4 / No
29 / FEEL / Date / 8 / No
30 / USCITIZEN / Logical / 1 / No
31 / EMAIL / Character / 60 / Asc Machine / No
** Total ** / 412

Structure for table: C:\NORML\DB\VPWR\ZIPS.DBF

Number of data records: 486

Field / Field Name / Type / Width Dec / Index Collate / Nulls
1 / CITY / Character / 20 / No
2 / STATE / Character / 2 / No
3 / ZIPCODE / Character / 5 / Asc Machine / No
4 / AREA / Character / 3 / No
5 / COUNTY / Character / 15 / No
** Total ** / 46

Structure for table: C:\NORML\DB\VPWR\ZREGIVOT.DBF

Number of data records: 5868

C:\NORML\Orgs\VpowerDB.doc1as of: 01/01/19