RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)

[So the Heroes Fall]

Tried it again and it still didn't work. Oh well.

[bgwah]

Dave,
It seems that the tables for everyone else's submissions do indeed work, but mine do not! I've compared my files with Alcon's and neither of us can figure out what is wrong.

When I click the tables for my pages, it gives me this message:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/www/users/leip/RESULTS/data.php on line 803

Do you know what could be wrong?

[Grad Students are the Worst]

Dave, if you can, would you mind changing this to 1976?  I'm not sure there is an easy way of doing it.

And this to 2002, if it isn't too much trouble.

[Grad Students are the Worst]

I've finished all of the do-able Washington election offices back to 1972 (click here).

Other elected offices in Washington:  Commissioner of Public Lands, Insurance Commissioner and Superintendent of Public Instruction (the last of which is non-partisan).

Also, I notice that as it stands, red is being used for "yes" and green for "no" on initiative maps.  Isn't it generally the other way around, with "green" signifying success/go, etc.?

It would also be nice to have a way of adding more than five initiatives, since we always have a half-dozen or so (often more) initiatives and almost never anything else.  We also have "House Joint Resolutions" and "Senate Joint Resolutions" that are voted on.  The way the initiatives are added - with each getting its own identical "Initiative" header with the year below - is going to be changed, I assume, so I'll go on the working assumption that the initiative function is not finished.

EDIT:

It also appears to error out when there's only one candidate receiving a vote.

(Also added more to the initiative part above.)

[Rob]

And this to 2002, if it isn't too much trouble.

This map should also be changed to 2002- for some reason, I entered it in the wrong year. I also slightly misspelled the Democrat's first name as "Byran" instead of Bryan. 

Also note that this map was an attempt to correct the original map, which has the correct year and candidate spellings... but also reversed numbers in Athens County.

One of these maps should be deleted; the other should be fixed. My attempts to override the existing data have only resulted in error messages, so... can you help?

[Dave Leip]

I've finished all of the do-able Washington election offices back to 1972 (click here).

Also, I notice that as it stands, red is being used for "yes" and green for "no" on initiative maps.  Isn't it generally the other way around, with "green" signifying success/go, etc.?

(Also added more to the initiative part above.)

This was an error on my part that I made late last night.  Thanks.  Yes is green and No is red.

[Dave Leip]

I've finished all of the do-able Washington election offices back to 1972 (click here).

(Also added more to the initiative part above.)

Way to go Alcon!  Great enthusiasm!  Keep it up!

[Vasall des Midas]

These contests will also show up in the state election page, such as: here
Thanks,
Dave  

What links to this page? ie, how to access it without either going to this thread on the forum first or bookmarking the address? ie, how would I find it if I didn't know it existed?

EDIT: I love all of you. Just needed to get that off my chest.

[Dave Leip]

The state election page is linked at the bottom of each election page, such as South Carolina Governor 2002.  Its called "<state name> Election Results Home".  You also can select them from the pull-down menu at the bottom: Choose another Office.

They link doesn't exist in the frame version at the moment - I'll add that to the list of things to do.
Dave

[Dave Leip]

Dave, if you can, would you mind changing this to 1976?  I'm not sure there is an easy way of doing it.

And this to 2002, if it isn't too much trouble.

Corrections completed.

[Dave Leip]

And this to 2002, if it isn't too much trouble.

This map should also be changed to 2002- for some reason, I entered it in the wrong year. I also slightly misspelled the Democrat's first name as "Byran" instead of Bryan. 

Also note that this map was an attempt to correct the original map, which has the correct year and candidate spellings... but also reversed numbers in Athens County.

One of these maps should be deleted; the other should be fixed. My attempts to override the existing data have only resulted in error messages, so... can you help?

The best way to correct for these is to over-write the data with the correct data.  Can you describe for me the errors?  You should only need to check the two boxes on the bottom of the entry form to over-write file and over-write data.

Thanks,
Dave

[Rob]

The best way to correct for these is to over-write the data with the correct data.  Can you describe for me the errors?  You should only need to check the two boxes on the bottom of the entry form to over-write file and over-write data.

I was receiving this message:

Error: Candidate 1 name entered in the form, but has 0 total vote. Check that data file columns match candidate numbers.

Error: Candidate 2 name entered in the form, but has 0 total vote. Check that data file columns match candidate numbers.

Apparently there was a tiny error in the data, but I removed it: final corrected map

Now that's fixed, is there any way to remove this map completely? It was a dumb mistake on my part to put in the wrong year, and there's no reason for this to stay on the Atlas.

[Dave Leip]

Jesus - there was a very obscure bug in the script that was causing the data not to be loaded if there was no Democratic candidate.  This caused your Idaho election submissions to fail.  They should now work.  As for the data.php errors, this looks to be on my end (related to the office).  I'll work on the script to show this correctly.
Thanks!!
Dave

[Dave Leip]

Now that's fixed, is there any way to remove this map completely? It was a dumb mistake on my part to put in the wrong year, and there's no reason for this to stay on the Atlas.

Upload the correct data
http://www.sos.state.oh.us:80/SOS/ElectionsVoter/results2006.aspx?Section=1844

[Dave Leip]

Another Thought - hold off for a short time on Initiative/state-wide questions.  I have some additional thoughts on how to present/store this info.

[Rob]

Upload the correct data

Done.

[Sibboleth]

Great stuff

[So the Heroes Fall]

Another Thought - hold off for a short time on Initiative/state-wide questions.  I have some additional thoughts on how to present/store this info.

Ha, I only read this after doing the North Dakota Referendum on a Lottery. Oh well.

[Dave Leip]

Another Thought - hold off for a short time on Initiative/state-wide questions.  I have some additional thoughts on how to present/store this info.

I've updated the script to modify how we handle initiatives, etc.  I've added a text field to place the name of the initiative (e.g. Amendment #1, Proposition 41, etc.)  I've changed the script to automatically place "Yes" and "No" in the right "Candidate" fields when an initiative or referendum is selected.  I've added a new table to keep track of the initiative names.  Here are two examples that I uploaded:

SC 2004 Amendment #2
SC 2004 Amendment #1

Note that the changes remove the name of the initiative from the "candidate" field.  I included the text of the initiative in the "Note 1" field and the explanation of the initiative in the "Note 2" field.

Let me know what you think.
Dave

[Grad Students are the Worst]

Very nice, Dave.

Jesus is going to do the initiatives now.  He is.  This is an affirmative statement, because he will do them.

While I collapse asleep.

[nclib]

Dave, good work!

Is there a page of composite maps contributions? If so, can it be linked from the forum?

I was thinking of making some maps comparing Presidential/Senatorial/Gubernatorial results by county. The source, of course, would be the Atlas. How would I tackle this?

[Grad Students are the Worst]

Quick additional bug report: graphs of initiatives don't work out so well.

Also, a very odd sort order here.  That also has happened on a good number of the other ones...the counties are in a weird semi-alphabetical order.

[Dave Leip]

Thanks Alcon.  I've removed the blue bars from the initiative data graph pages and resorted the county data in the data pages according to fips (this is an interesting problem: fips codes are not entirely in alphabetical order, so I don't sort the data in the tables I have created.  When the php grabs the mysql data without sort, they do so in order they appear in the table.  In our new table, what happens is when rows are deleted, new data is entered in an irregular fashion - I don't know any details as to why or what the algorithm looks like - but it causes the odd ordering when the php grabs the data).

[Dave Leip]

Dave, good work!

Is there a page of composite maps contributions? If so, can it be linked from the forum?

I was thinking of making some maps comparing Presidential/Senatorial/Gubernatorial results by county. The source, of course, would be the Atlas. How would I tackle this?

Thanks!  Its a great team effort!  Already 111 new contests with county maps on the site! in only three days!

The list of contributions is located here.  I'll be adding this link from other parts of the site as it matures.

You can see a great composite of maps for contests by state - for example: Washington 1980

Enjoy,
Dave

[So the Heroes Fall]

For my MN Secretary of State 2002 table, I can't sort it in any order other than the default. I get this:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/www/users/leip/RESULTS/data.php on line 1014

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/www/users/leip/RESULTS/data.php on line 1371