Atlas Forum

About this Site => The Atlas => Topic started by: True Democrat on December 30, 2006, 02:20:47 pm



Title: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: True Democrat on December 30, 2006, 02:20:47 pm
I think we should find a way to keep RBH's maps and maps made by any other member of the forum.  Putting them on the wiki (hopefully with the data) would be a good way for everyone to look at this information.


Title: Re: RBH's Maps
Post by: Bleeding heart conservative, HTMLdon on December 30, 2006, 08:38:56 pm
Definately - we need a way of organizing user-created maps.  I suggested something like that to Alcon a few weeks ago but I didn't want to start doing it without help and without suggestions from the forum at-large.


Title: Re: RBH's Maps
Post by: bgwah on December 30, 2006, 08:44:49 pm
I think we should find a way to keep RBH's maps and maps made by any other member of the forum.  Putting them on the wiki (hopefully with the data) would be a good way for everyone to look at this information.

I've put a lot of my maps on the Wiki. Just ask Dave for an account.


Title: Re: RBH's Maps
Post by: nclib on December 30, 2006, 09:10:18 pm
I think we should find a way to keep RBH's maps and maps made by any other member of the forum.  Putting them on the wiki (hopefully with the data) would be a good way for everyone to look at this information.

I would agree with that.

BTW, is there a way to make county maps like his, without having to use paint?


Title: Re: RBH's Maps
Post by: Dave Leip on January 01, 2007, 07:50:23 pm
Hi all and Happy New Year:

I've got something that you may like here:  I've created a new datatable for other offices/elections that users can contribute through an upload script and generate county maps.  The upload script is still in development and is located here (https://uselectionatlas.org/SCRIPTS/election_upload.php).  Here are the SC 2002 Races for:

Lt. Governor here (https://uselectionatlas.org/RESULTS/state.php?year=2002&fips=45&off=6&f=0)

Sec of State here (https://uselectionatlas.org/RESULTS/state.php?year=2002&fips=45&off=7&f=0)

State Treasurer here (https://uselectionatlas.org/RESULTS/state.php?year=2002&fips=45&off=8&f=0)

Changes to link the pages from the wiki here (https://uselectionatlas.org/WIKI/index.php/South_Carolina)

The form looks intimidating at first, but really not bad once you get used to it.  It requires the entry of the year, candidate names and party, the election type (general, rep primary, dem primary), the state, the office, the source info, possible notes for fusion, etc., and a tab-delimited county data file (there is an excel template linked on the input form page to assist you). 

Important: Data file:
only include lines in the tab-delimited file that contain data (no blank lines or title lines)
the tab-deliminted file must have UNIX return characters (there should be an option in the text editor or possibly excel to set this).
one state at a time and must include the fips and name info as shown in the template.

For Referenda, questions, initiatives, etc., the names would be shown like
"Question 5: Yes" with shortname "Yes"
"Question 5: No" with shortname "No"

There is a bunch more work to do to get the linked pages from the election summary to work properly for these elections (will be forthcoming).  Also, credit will be shown on the state summary page for the contributor.  Other offices can be added.

Please submit feedback (feature requests, bugs, etc.)

Enjoy,
Dave


Title: Re: RBH's Maps
Post by: RBH on January 02, 2007, 12:53:33 am
It only allows you to upload a race once, even if you need to upload it again due to an error.


Title: Re: RBH's Maps
Post by: RBH on January 02, 2007, 01:07:26 am
Hm. Database problems occur with the upload of a 7 candidate Republican primary map for the Kansas Governor's race from 2006.

The map comes up, but none of the other links go to a working page.

Now that's testing the system.


Title: Re: RBH's Maps
Post by: RBH on January 02, 2007, 01:27:58 am
And I did get one map posted:

https://uselectionatlas.org/RESULTS/state.php?year=1998&off=7&elect=0&fips=12&f=0

Although the really really long FL SOS page URL didn't come though.


Title: Re: RBH's Maps
Post by: RBH on January 02, 2007, 01:41:08 am
The messege for when I try to enter corrected data is "Error: This election data is already entered into the database"

And happier days for at least one Texas Democrat:

https://uselectionatlas.org/RESULTS/state.php?year=1994&off=6&elect=0&fips=48&f=0


Title: Re: RBH's Maps
Post by: RBH on January 02, 2007, 02:02:02 am
And a better day for Max Cleland: https://uselectionatlas.org/RESULTS/state.php?year=1994&off=7&elect=0&fips=13&f=0

and for Mike Bowers too: https://uselectionatlas.org/RESULTS/state.php?year=1994&off=9&elect=0&fips=13&f=0

Mahoney was a little known businessman who talked about being a "classic liberal" and wanting the Attorney General to investigate elections.

Dunn was a former legislator who was little known.


Title: Re: RBH's Maps
Post by: RBH on January 02, 2007, 02:43:43 am
Ok, either I did something wrong on this entry, or there's something wrong with the script

https://uselectionatlas.org/RESULTS/state.php?year=1984&off=3&elect=0&fips=21&f=0

The map shows up, the results table doesn't


Title: Re: RBH's Maps
Post by: Alcon on January 02, 2007, 06:22:34 am
Very cool...although I'm a little confused.

I may be doing something entirely wrong, or my software is corrupting the CSV files somehow...but I did them in what I think is the correct format, and I'm still getting failure on everything.  No commas or anything.  I cannot seem to find the place in Excel where the UNIX line character is customised.  RBH, can you help me out here?

I am also getting the inability to upload issue.


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 11:01:23 am
Ok, either I did something wrong on this entry, or there's something wrong with the script

https://uselectionatlas.org/RESULTS/state.php?year=1984&off=3&elect=0&fips=21&f=0

The map shows up, the results table doesn't

Thanks - this was a code error in the State script.  Corrected.


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 11:03:21 am
It only allows you to upload a race once, even if you need to upload it again due to an error.

I've added the ability to over-write the data (if you were the person who entered it).  If you find an error in data that someone else submitted, please post it here, or email me.  This script change deletes all the old data before re-writing it - so be sure that you enter all the info again.


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 11:08:28 am
Very cool...although I'm a little confused.

I may be doing something entirely wrong, or my software is corrupting the CSV files somehow...but I did them in what I think is the correct format, and I'm still getting failure on everything.  No commas or anything.  I cannot seem to find the place in Excel where the UNIX line character is customised.  RBH, can you help me out here?

I am also getting the inability to upload issue.

Hi Alcon,
none of the county data were uploaded - the candidates, sources info show up in the database.  Note, do not use a CSV file, but rather a tab-delimited file.  Try this and let me know if it works.
Thanks,
Dave


Title: Re: RBH's Maps
Post by: RBH on January 02, 2007, 12:52:12 pm
It only allows you to upload a race once, even if you need to upload it again due to an error.

I've added the ability to over-write the data (if you were the person who entered it).  If you find an error in data that someone else submitted, please post it here, or email me.  This script change deletes all the old data before re-writing it - so be sure that you enter all the info again.

I get this messege when I try re-entering info for one race:

"Error: Geographic type Type for Name is not in database. Please check spelling or email Dave

Errors Encountered. Data not entered. Please correct and resubmit."


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 01:18:08 pm
It only allows you to upload a race once, even if you need to upload it again due to an error.

I've added the ability to over-write the data (if you were the person who entered it).  If you find an error in data that someone else submitted, please post it here, or email me.  This script change deletes all the old data before re-writing it - so be sure that you enter all the info again.

I get this messege when I try re-entering info for one race:

"Error: Geographic type Type for Name is not in database. Please check spelling or email Dave

Errors Encountered. Data not entered. Please correct and resubmit."

Hi,
This means that one of the geographic county types is not in my database.  The third column in the data file is the type of geographic unit (State, County, Parish, City are examples).  If any of these does not match an entry in my database (or is misspelled), it will generate this error.  Do you have other names in the list of data? 

It looks like in this case, the top row (label row) is in your data file. Be sure that you have deleted the label row and include only data lines in the file.
Thanks,
Dave


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 02:29:59 pm
Also note: avoid posting Gubernatorial and Senatorial contests in the 1990s as they will be added in bulk soon.
Dave


Title: Re: RBH's Maps
Post by: RBH on January 02, 2007, 02:44:18 pm
Also note: avoid posting Gubernatorial and Senatorial contests in the 1990s as they will be added in bulk soon.
Dave
Texas Tresurer Races are fair game though: https://uselectionatlas.org/RESULTS/state.php?year=1994&off=8&elect=0&fips=48&f=0

Texas data is pretty easy to gather. Nothing like the Mississippi data (the ones that are still on photocopied handwritten precinct returns)


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 02:47:49 pm
  I cannot seem to find the place in Excel where the UNIX line character is customised. 

For new line translation, I use BBEdit (there is also a free version called TextWrangler) from Barebones on the Mac.  For PC/Linux land and MacOS X there is a small utility called flip to convert windows/mac newline characters to UNIX:

http://ccrma-www.stanford.edu/~craig/utility/flip/

Other options from the PC users?
Thanks,
Dave


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 02:59:04 pm
Also note: avoid posting Gubernatorial and Senatorial contests in the 1990s as they will be added in bulk soon.
Dave
Texas Tresurer Races are fair game though: https://uselectionatlas.org/RESULTS/state.php?year=1994&off=8&elect=0&fips=48&f=0

Texas data is pretty easy to gather. Nothing like the Mississippi data (the ones that are still on photocopied handwritten precinct returns)


Yeah, Texas, Florida, Kentucky, South Carolina, Georgia, among others have easily-accessible data for state-wide races in the 1990s/00s and are fast to add using the new script.  And think of all the time saved by not needing to color the counties with Paint ! :)


Title: Re: RBH's Maps
Post by: RBH on January 02, 2007, 04:44:47 pm
I've actually gotten pretty good at coloring Missouri in paint.

Places like Texas and Georgia are massive paints to manually color though.

Looks like Louisiana should be surprisingly easy too, considering that they have 9 different counties starting in St. (but the only other S county is Sabine).

Granted, Louisiana results also include having to creatively re-sort the results due to the table they have.

Missouri's results are also pretty good, although there's some column deleting required. And the initative results have spaces after the number for one column and spaces before the number in the other.

Kansas has their results back to 1990 and the older stuff is in some sort of .exe zip-ish file that just creates an .xls


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 06:44:06 pm
Another tip.  In the data file, be sure to replace any commas in vote numbers (such as 7,900 votes) with "nothing" and not space (needs to be 7900 and not 7 900).  Another way to do this is to format the data in excel as "General" prior to saving as tab-delimited .txt file.

I've also reposted the template xls file to change the formatting of the vote columns to "General"
Thanks,
Dave


Title: Re: RBH's Maps
Post by: bgwah on January 02, 2007, 06:55:07 pm

Error: Geographic type Type for Name is not in database. Please check spelling or email Dave

Check to be sure that the header row has been removed from the data file (data file should only include county, city, and state-level data rows and no column titles)
Errors Encountered. Data not entered. Please correct and resubmit.



I get that error now. I was using OpenOffice before and there was no .txt option, so now I am using Excel and saving it as tab-delimited .txt file and still having trouble.


Title: Re: RBH's Maps
Post by: RBH on January 02, 2007, 07:00:39 pm
Does your file start with the results from a county, and not the listing of what is in which column?

And what I was doing in Excel to get rid of the commas was typing in one uncomma'ed number, and then I'd cover all the numbers, and press 'increase decimal' and it gets rid of the commas.


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 07:09:35 pm

Error: Geographic type Type for Name is not in database. Please check spelling or email Dave

Check to be sure that the header row has been removed from the data file (data file should only include county, city, and state-level data rows and no column titles)
Errors Encountered. Data not entered. Please correct and resubmit.



I get that error now. I was using OpenOffice before and there was no .txt option, so now I am using Excel and saving it as tab-delimited .txt file and still having trouble.

This error means you have extra "stuff" in your data file.  In the case of WA 1972, you have two issues: the column headers are still in the file (first row) and second, all U.S. Counties are in the file when all you want to enter is Washington.  The data file needs to be just the data you are entering, no more, no less.  In your case, the first piece of data in the file needs to be 53001.

What I do is highlight the data from the state I want and copy it to a new blank spreadsheet then simply choose save as tab-delimited text.

I'll think a bit so see if we can make this more versatile.  I'm also now going to try open office and get back to you on its potential.

Thanks.  and thanks for the patience and help here to make this better.
Dave


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 07:17:44 pm
Open Office can save as tab-delimited - you  have to choose csv (.txt) and then in the next step, it gives you a choice for delimit character (choose {tab}).  However, it also requires you to choose a text character (" or ').  These would need to be stripped out of the file (I think).


Title: Re: RBH's Maps
Post by: bgwah on January 02, 2007, 07:19:40 pm
Thanks, I finally got it to work using Excel. I deleted the top row with the party names and all of the other states. The tables don't work, but I think RBH already mentioned that.

https://uselectionatlas.org/RESULTS/state.php?year=1972&off=5&elect=0&fips=53&f=0

The third party button doesn't work either.

For idiots like me using Excel:
-Select all of the data, right-click format cells, and click "number," there is a check-box to turn off automatic commas. You could also try the "general" thing Dave mentioned earlier.
-There is a plus sign to the left of the states that you click to show the counties of that state (Rob :P)
-Delete all states other than the one you entered data for
-Delete the top row where the party names are.
-Save as, save as type tab-delimited .txt


Title: Re: RBH's Maps
Post by: Rob on January 02, 2007, 07:31:32 pm
I made one: Oklahoma Lt. Governor [2006] (https://uselectionatlas.org/RESULTS/state.php?year=2006&off=6&elect=0&fips=40&f=0)

Great feature, Dave!


Title: Re: RBH's Maps
Post by: Shilly on January 02, 2007, 07:50:23 pm
Created one too.

Here it is: https://uselectionatlas.org/RESULTS/state.php?year=2002&off=8&elect=0&fips=17&f=0



Title: Re: RBH's Maps
Post by: bgwah on January 02, 2007, 08:06:34 pm
Tried doing the 2004 Washington Democratic Primary for Governor. The page I got after I hit upload showed the map ( https://uselectionatlas.org/SCRIPTS/gen_county_map.php?year=2004&off=5&elect=1&fips=53 ) but the first link to the summary page took me to the 2004 General Election page, and the rest of the links did not work.


Title: Re: RBH's Maps
Post by: Alcon on January 02, 2007, 08:38:27 pm
Excellent.  I got it to work, with the tables working too...but the "county data by graphs" function seems to error out.


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 08:48:17 pm
Most of the linked pages are still a work in progress to get them to look for the data in the new upload table.  I've also disabled the "Primary" election choice for now until I can get a better handle on presenting the data.  It'll be back.

Another suggestion:
Please limit the "Independent" row for true "independent" candidates (typically a strong showing).  Libertarian, Green, US Taxpayers/Constitution, etc. are better in slots 4, 5, etc.

You can also see the most recent list of contributed election content here (https://uselectionatlas.org/contributions.php)  These contests will also show up in the state election page, such as: here (https://uselectionatlas.org/RESULTS/state.php?fips=53&f=0&off=99)
Thanks,
Dave  


Title: Re: RBH's Maps
Post by: The love that set me free on January 02, 2007, 08:57:51 pm
Wow, I'll probably be addicted all night making Minnesota maps.


Title: Re: RBH's Maps
Post by: Rob on January 02, 2007, 10:22:37 pm
Dave, the green on this initiative map (https://uselectionatlas.org/RESULTS/state.php?year=2004&off=60&elect=0&fips=41&f=0) doesn't appear. I don't know if it was my error or a site glitch.


Title: Re: RBH's Maps
Post by: The love that set me free on January 02, 2007, 10:29:29 pm
Here's my first shot at it: https://uselectionatlas.org/RESULTS/state.php?fips=27&year=2006&f=0&off=9&elect=0

That's the Minnesota AG race this year.

Map works pretty good, so does the tables, but not graphs or individual county data, although appears to be the case with other maps.


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 10:44:35 pm
Another minor bug:

Third-party maps are broken (https://uselectionatlas.org/RESULTS/data.php?year=2000&fips=53&f=0&off=9&elect=0&datatype=county&def=1) (Libertarian broke 10% in Skamania County)

This has been fixed.  If a minor party receives > 5%, they get their own map.


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 10:45:05 pm
Dave, the green on this initiative map (https://uselectionatlas.org/RESULTS/state.php?year=2004&off=60&elect=0&fips=41&f=0) doesn't appear. I don't know if it was my error or a site glitch.

This glitch happend while I was fixing Alcon's bug.  Corrected.


Title: Re: RBH's Maps
Post by: Rob on January 02, 2007, 10:46:32 pm
Thanks. :)


Title: Re: RBH's Maps
Post by: The love that set me free on January 02, 2007, 10:50:18 pm
As practice, I decided to do an easy race in a state with not many counties. So here's AZ Attorney General this year:

https://uselectionatlas.org/RESULTS/state.php?year=2006&off=9&elect=0&fips=4&f=0


Title: Re: RBH's Maps
Post by: Alcon on January 02, 2007, 10:59:45 pm
God bless SoS Sam Reed for putting county results for Washington up back to 1970.

I'll be up all night too.  :P

Thanks again, Dave!


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 11:03:26 pm
Here's my first shot at it: https://uselectionatlas.org/RESULTS/state.php?fips=27&year=2006&f=0&off=9&elect=0

That's the Minnesota AG race this year.

Map works pretty good, so does the tables, but not graphs or individual county data, although appears to be the case with other maps.

Hi,
One error here - the "Write-ins" are listed as being column 10, but the datafile includes them under column 5 - so they don't show up.  I'm going to add a check to the script to catch this.  Also, what is the source of the 633 vote switch?  any idea? a single county data transposed?


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 11:04:27 pm
Don't forget to take your time with the data.  Quality counts!


Title: Re: RBH's Maps
Post by: The love that set me free on January 02, 2007, 11:23:53 pm
Here's my first shot at it: https://uselectionatlas.org/RESULTS/state.php?fips=27&year=2006&f=0&off=9&elect=0

That's the Minnesota AG race this year.

Map works pretty good, so does the tables, but not graphs or individual county data, although appears to be the case with other maps.

Hi,
One error here - the "Write-ins" are listed as being column 10, but the datafile includes them under column 5 - so they don't show up.  I'm going to add a check to the script to catch this.  Also, what is the source of the 633 vote switch?  any idea? a single county data transposed?

I'm not sure, the map is the same was one I made earlier so all the counties got the winner's right unless I made an error in the first one. I'll look through it later and try to find the error. And yes, I made that error with the Write-Ins but it appears they just appeared under a blank table. I'll make sure not to do that on any future ones, on the one I'm doing now I have Write-Ins under column 5 with 4 candidates.


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 11:25:27 pm
As practice, I decided to do an easy race in a state with not many counties. So here's AZ Attorney General this year:

https://uselectionatlas.org/RESULTS/state.php?year=2006&off=9&elect=0&fips=4&f=0

Great!
Feedback:
Arizona is very good with regard to source information: in this case, the title should be "State of Arizona Official Canvass 2006 General Election - November 7, 2006".  I've made this change.
Dave


Title: Re: RBH's Maps
Post by: The love that set me free on January 02, 2007, 11:28:59 pm
OK, I found the error, the totals in Becker county are transposed.


Title: Re: RBH's Maps
Post by: Dave Leip on January 02, 2007, 11:43:36 pm
OK, I found the error, the totals in Becker county are transposed.

Great.  You should be able to over-write the data with the corrected data.  Thanks for checking!  Quality is important in elections :)


Title: Re: RBH's Maps
Post by: RBH on January 02, 2007, 11:54:40 pm
God bless SoS Sam Reed for putting county results for Washington up back to 1970.

I'll be up all night too.  :P

Thanks again, Dave!

Washington has an odd format, at least for the 1980 primary results.


Title: Re: RBH's Maps
Post by: The love that set me free on January 02, 2007, 11:59:55 pm
OK, new data is up, looks good but a minor error: The default format for the table is not in alphabetical order


Title: Re: RBH's Maps
Post by: The love that set me free on January 03, 2007, 01:00:55 am
Tried it again and it still didn't work. Oh well.


Title: Re: RBH's Maps
Post by: bgwah on January 03, 2007, 01:31:12 am
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?


Title: Re: RBH's Maps
Post by: Rob on January 03, 2007, 07:49:18 am
And this (https://uselectionatlas.org/RESULTS/state.php?year=2004&off=6&elect=0&fips=16&f=0) to 2002, if it isn't too much trouble.

This map (https://uselectionatlas.org/RESULTS/state.php?year=2006&off=7&elect=0&fips=39&f=0) 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 (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=39&elect=0&off=7&year=2002), 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? ;)


Title: Re: RBH's Maps
Post by: Dave Leip on January 03, 2007, 08:43:03 am
I've finished all of the do-able Washington election offices back to 1972 (click here (https://uselectionatlas.org/RESULTS/state.php?fips=53&f=0&off=99)).

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.


Title: Re: RBH's Maps
Post by: Dave Leip on January 03, 2007, 08:54:40 am
I've finished all of the do-able Washington election offices back to 1972 (click here (https://uselectionatlas.org/RESULTS/state.php?fips=53&f=0&off=99)).

(Also added more to the initiative part above.)

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


Title: Re: RBH's Maps
Post by: minionofmidas - supplemental forum account on January 03, 2007, 08:58:29 am
These contests will also show up in the state election page, such as: here (https://uselectionatlas.org/RESULTS/state.php?fips=53&f=0&off=99)
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. :)


Title: Re: RBH's Maps
Post by: Dave Leip on January 03, 2007, 09:31:22 am
The state election page is linked at the bottom of each election page, such as South Carolina Governor 2002 (https://uselectionatlas.org/RESULTS/state.php?fips=45&year=2002&f=0&off=5&elect=0).  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


Title: Re: RBH's Maps
Post by: Dave Leip on January 03, 2007, 09:43:12 am
Dave, if you can, would you mind changing this (https://uselectionatlas.org/RESULTS/state.php?fips=53&year=1975&f=0&off=8&elect=0) to 1976?  I'm not sure there is an easy way of doing it.

And this (https://uselectionatlas.org/RESULTS/state.php?year=2004&off=6&elect=0&fips=16&f=0) to 2002, if it isn't too much trouble.

Corrections completed.


Title: Re: RBH's Maps
Post by: Dave Leip on January 03, 2007, 09:46:25 am
And this (https://uselectionatlas.org/RESULTS/state.php?year=2004&off=6&elect=0&fips=16&f=0) to 2002, if it isn't too much trouble.

This map (https://uselectionatlas.org/RESULTS/state.php?year=2006&off=7&elect=0&fips=39&f=0) 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 (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=39&elect=0&off=7&year=2002), 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


Title: Re: RBH's Maps
Post by: Rob on January 03, 2007, 10:33:06 am
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:

Quote
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 (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=39&elect=0&off=7&year=2002)

Now that's fixed, is there any way to remove this map (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=39&elect=0&off=7&year=2006) 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.


Title: Re: RBH's Maps
Post by: Dave Leip on January 03, 2007, 10:49:20 am
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


Title: Re: RBH's Maps
Post by: Dave Leip on January 03, 2007, 10:51:24 am
Now that's fixed, is there any way to remove this map (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=39&elect=0&off=7&year=2006) 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


Title: Re: RBH's Maps
Post by: Dave Leip on January 03, 2007, 11:03:17 am
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.


Title: Re: RBH's Maps
Post by: Rob on January 03, 2007, 12:07:28 pm

Done.


Title: Re: RBH's Maps
Post by: Filuwaúrdjan on January 03, 2007, 12:24:25 pm
Great stuff :)


Title: Re: RBH's Maps
Post by: The love that set me free on January 03, 2007, 01:24:41 pm
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 (https://uselectionatlas.org/RESULTS/state.php?year=2002&off=61&elect=0&fips=38&f=0). Oh well.


Title: Re: RBH's Maps
Post by: Dave Leip on January 03, 2007, 01:29:26 pm
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 (https://uselectionatlas.org/RESULTS/state.php?year=2004&off=61&elect=0&fips=45&f=0)
SC 2004 Amendment #1 (https://uselectionatlas.org/RESULTS/state.php?year=2004&off=60&elect=0&fips=45&f=0)

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


Title: Re: RBH's Maps
Post by: nclib on January 03, 2007, 06:13:38 pm
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?


Title: Re: RBH's Maps
Post by: Dave Leip on January 04, 2007, 09:24:21 am
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).


Title: Re: RBH's Maps
Post by: Dave Leip on January 04, 2007, 09:36:36 am
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 (https://uselectionatlas.org/contributions.php).  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 (https://uselectionatlas.org/RESULTS/comparemaps.php?year=1980&fips=53&f=0&off=5&elect=0&all=1)

Enjoy,
Dave


Title: Re: RBH's Maps
Post by: The love that set me free on January 04, 2007, 02:28:51 pm
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


Title: Re: RBH's Maps
Post by: 2,868,691 on January 04, 2007, 05:21:33 pm
I have data for MS Insurance Commissioner and Agriculture Commissioner, but there's no way to upload those offices.  Is there any way those could be added too?


Title: Re: RBH's Maps
Post by: Alcon on January 05, 2007, 12:19:22 am
Dave - How do you want us to handle years with more than 5 initiatives?

EDIT: Also, there's probably no need to have the Compare County Data by Year feature for initiatives, since it just spits back a table with the same results repeated for every year that there are any initiative results for that state.  Same goes for measures and referendums.


Title: Re: RBH's Maps
Post by: Dave Leip on January 05, 2007, 10:07:28 am
Great Job everyone!  I'm very impressed with enthusiasm!  I appreciate the quality of the effort.

Alcon, I've corrected the items mentioned below.  I've added 4 more initiative/referendum "offices".  I'm going to hold off on commissioners for the moment.   I've also corrected the sort bug in the data table.  The linked scripts from all these pages (except for population) all account for the new tables and should work properly.  Including population, voter registration, ballots cast, etc. requires a significantly larger infrastructure change that I do plan to tackle at some point.

Enjoy!
Dave


Title: Re: RBH's Maps
Post by: Dave Leip on January 05, 2007, 11:06:47 am
I added the date to the source of the 1994 Primary election -
"1994 Democratic Primary Election 3/8/1994"
and changed the source of the runoff from
"1994 Democratic Primary Election" to
"1994 Democratic Primary Runoff Election 4/12/1994" (absence of the word "Runoff" looks like a carry-over error from the previous election upload).  I've also added a note to the 1994 Primary Election:
"With no candidate having received a majority of the vote, a <a href="https://uselectionatlas.org/RESULTS/state.php?f=0&fips=48&elect=6&off=3&year=1994">runoff</a> election between Mattox and Fisher was held in April".





Title: Re: RBH's Maps
Post by: minionofmidas - supplemental forum account on January 05, 2007, 02:59:55 pm
The state election page is linked at the bottom of each election page, such as South Carolina Governor 2002 (https://uselectionatlas.org/RESULTS/state.php?fips=45&year=2002&f=0&off=5&elect=0).  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
Thanks Dave!


Title: Re: RBH's Maps
Post by: minionofmidas - supplemental forum account on January 05, 2007, 04:20:13 pm
New Election:  2006 Texas  Democratic Primary Election Results  (https://uselectionatlas.org/RESULTS/state.php?year=2006&off=3&elect=1&fips=48&f=0)
   
    ()


A tie (in Kimble County, the southernmost of the counties shown in white) between the candidates shown in red and green shows up in the same colour as a county with no votes cast.


Title: Re: RBH's Maps
Post by: Dave Leip on January 05, 2007, 04:42:56 pm
There is another issue - I'll need to add separate election types for "Republican Runoff" and "Democratic Runoff" from "Open Runoff", otherwise there will be a conflict, say between Dem Runoff and Rep Runoff on the same election.  So, please hold off on more runoff elections until I create new election types for them.
Thanks,
Dave


Title: Re: RBH's Maps
Post by: Dave Leip on January 05, 2007, 05:15:23 pm
Ok, that's done.  Go ahead and use the new "Republican Runoff" and "Democratic Runoff" contests.  I love easy changes that expand content.


Title: Re: RBH's Maps
Post by: Dave Leip on January 05, 2007, 05:25:44 pm
RBH - could you please include the date of the election (especially primary, runoff, special) in the source - i.e. for texas, the date is just below the election title: such as "2006 Democratic Party Primary Runoff Election 4/11/2006".  This gives more info on when the election took place.

Also, to all, be careful when you use the back key to enter multiple elections back-to-back to check each of the fields as not to enter incorrect data from the previous entry.
Thanks,
Dave


Title: Re: RBH's Maps
Post by: Dave Leip on January 05, 2007, 11:02:30 pm
New Feature: Comparison of Election Results by office for a given year:  here is Washington 2004 (https://uselectionatlas.org/RESULTS/compare.php?year=2004&fips=53&f=0&off=6&elect=0&type=state&all=1).  These pages are linked in from each state page.
Enjoy!
Dave


Title: Re: RBH's Maps
Post by: Gabu on January 06, 2007, 02:44:42 am
New Feature: Comparison of Election Results by office for a given year:  here is Washington 2004 (https://uselectionatlas.org/RESULTS/compare.php?year=2004&fips=53&f=0&off=6&elect=0&type=state&all=1).  These pages are linked in from each state page.
Enjoy!
Dave

Excellent. :)

Although I noticed that there's a blank column between "yes" and "no", which presumably is the column for where the Republican candidate would be.  Perhaps the table for initiatives should be formatted differently so that only the independent (green) and Democratic (red) columns are present, and in that order.


Title: Re: RBH's Maps
Post by: Filuwaúrdjan on January 06, 2007, 07:08:07 pm
A request; I'd like to see county maps of the 1980 and 1970 Senate races in New York. Anyone got county data for those?


Title: Re: RBH's Maps
Post by: Alcon on January 06, 2007, 07:36:48 pm
A request; I'd like to see county maps of the 1980 and 1970 Senate races in New York. Anyone got county data for those?

I actually think I had those somewhere (someone sent them ages ago), but I can't find them.  I'll look again.

I'm sad.  The Washington Secretary of State page decided to remove the county results-back-to-1970 archive yesterday for no apparent reason.  I'll have to yell at them on Monday.  I was planning to use this weekend to input every initiative since 1970.  :(

Dave, I know this is probably nowhere on the radar, but I have precinct results for minor offices and initiatives for 2004, and some for 2000, that I'm considering compiling.  Same with town/city data.  I can do this if you'd get to them eventually.  If not, that's fine.  Just something to occupy my time with while I'm still bed-ridden.


Title: Re: RBH's Maps
Post by: Dave Leip on January 06, 2007, 11:33:35 pm
In spite of my New York roots, I do not have these elections at this time.

Alcon - are you ill?  If so, hoping for a speedy recovery.  I was actually distracted today by the amazing 72 degree outdoor temperature!  Unbelievable January day here in Boston.

How about working on Oregon?  1996 - present are on-line and I have complete pdf copies of the 1990 and 1994 Official Abstract of Votes from OR.  Did you complete the precinct returns for WA Senate in 2006?

In further news, the 1992 Gubernatorial election results have been uploaded.

Enjoy,
Dave


Title: Re: RBH's Maps
Post by: Alcon on January 07, 2007, 12:51:26 am
In spite of my New York roots, I do not have these elections at this time.

Alcon - are you ill?  If so, hoping for a speedy recovery.  I was actually distracted today by the amazing 72 degree outdoor temperature!  Unbelievable January day here in Boston.

Yeah - I've been sick for months, but I got food poisoning on top of it yesterday.  No fun.  72 degrees sounds pretty nice right now - we might get a rare snow in a few days.

How about working on Oregon?  1996 - present are on-line and I have complete pdf copies of the 1990 and 1994 Official Abstract of Votes from OR.

I'm on it.  :)  It will give me some practise on learning the Oregon county map better too.

Did you complete the precinct returns for WA Senate in 2006?

Cowlitz and Grays Harbor are supposed to be in the mail (holiday season delayed this significantly).  The rest are all in.


Title: Re: RBH's Maps
Post by: Gabu on January 07, 2007, 01:09:04 am
In further news, the 1992 Gubernatorial election results have been uploaded.

Looks good. :)

But I noticed that the mouse-over text for (I believe) MO, NC, VT, and WV all display every candidate as "0".


Title: Re: RBH's Maps
Post by: Rob on January 07, 2007, 01:17:37 am
I'd like to see county maps of the 1980 and 1970 Senate races in New York.

RBH posted 1970 on Atlas some time ago:

(Image Link)

But I noticed that the mouse-over text for (I believe) MO, NC, VT, and WV all display every candidate as "0".

Also (and this is a very minor complaint), the map keys for some states aren't quite accurate. For example, the Utah key doesn't have shadings for the independent candidate and the Louisiana keys display every red/blue shading from >50% to >90%.

Other than those quibbles, great work. :)


Title: Re: RBH's Maps
Post by: ○∙◄☻tπ[╪AV┼cV└ on January 07, 2007, 01:54:38 am
Queens, Westchester, and Tompkins for the Conservative party? That's unreal. Yates sure bucked the Conservative showing in the Finger Lakes.


Title: Re: RBH's Maps
Post by: RBH on January 07, 2007, 03:24:16 am
the difference between making a map and entering data involves the minor parties.

That's why there's gaps in data from 1920 to 1936. The data is there to make a map, but not to totally enter data. Due to third parties and such.

The CQ Database numbers I have has the following results

Queens: Buckley 44, Ottinger 39, Goodell 17
Tompkins: Buckley 46, Goodell 32, Ottinger 22
Westchester: Buckley 45, Ottinger 37, Goodell 18

I forget what happened with Yates, because the results are Buckley 44, Goodell 34, Ottinger 22.

So i'll probably need to correct that.


Title: Re: RBH's Maps
Post by: True Democrat on January 07, 2007, 01:42:16 pm
Why isn't that NY map showing up in the New York Elections home?


Title: Re: RBH's Maps
Post by: Dave Leip on January 07, 2007, 05:15:25 pm
Alcon - Months is not fun with illness - hope for a quick(er) recovery going forward!  Cool about OR, let me know when you are ready for the pdf files of OR Abstracts.

In further news, the 1992 Gubernatorial election results have been uploaded.

Looks good. :)

But I noticed that the mouse-over text for (I believe) MO, NC, VT, and WV all display every candidate as "0".

Thanks - I knew about this one, but decided not to upload the corrected names until I could complete the incumbency info for 1998 and 2002 (which is now done and maps are made!).



Also (and this is a very minor complaint), the map keys for some states aren't quite accurate. For example, the Utah key doesn't have shadings for the independent candidate and the Louisiana keys display every red/blue shading from >50% to >90%.

Other than those quibbles, great work. :)

Thanks very much for pointing these out!  I greatly appreciate when items that seem out-of-the-ordinary are brought to my attention.  They have been corrected  (there is so much data and so many files that are cross-linked/or dependent on one-another that mistakes happen from time to time - and I relish accuracy, so keep-em coming.)


Title: Re: RBH's Maps
Post by: Alcon on January 07, 2007, 06:30:26 pm
Dave,

Thanks!  Feel free to email them now.  I'll get to them either today or very soon, depending on whether I'm lucid enough.  :D


Title: Re: RBH's Maps
Post by: Alcon on January 08, 2007, 01:40:45 am
I have no idea how I managed this (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=41&elect=7&off=3&year=1990). but it should be deleted.


Title: Re: RBH's Maps
Post by: Bacon King on January 08, 2007, 07:06:15 am
I have no idea how I managed this (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=41&elect=7&off=3&year=1990). but it should be deleted.

Hah!


Title: Re: RBH's Maps
Post by: minionofmidas - supplemental forum account on January 08, 2007, 08:27:05 am
I have no idea how I managed this (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=41&elect=7&off=3&year=1990). but it should be deleted.

Hah!
Why is Multnomah showing up in gray when the data have it going for the Democrat? (And yes, I know everything else is wrong too.)


Title: Re: RBH's Maps
Post by: RBH on January 08, 2007, 08:53:37 am
I have no idea how I managed this (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=41&elect=7&off=3&year=1990). but it should be deleted.

Commas in the file, probably.

As for future results, the NY Gov 1994 results should be a lot of fun. Two hints here.

Cuomo wins NYC big (70/28), Pataki wins the rest of the state big (57/35)

The 1990 NY Gov results should be interesting in map form.

Cuomo won every county except the following in 1990.

Rinfret counties: Allegany, Chenango, Cortland, Delaware, Essex, Herkimer, Lewis, Orleans, Schuyler, Seneca, Steuben, Wayne, Yates
London counties: Cayuga, Greene, Hamilton, Oswego, Wyoming

And the CQ database county results didn't include anything from Jefferson or Niagara counties. Preventing a map.


Title: Re: RBH's Maps
Post by: RBH on January 08, 2007, 09:21:48 am
As for 1986 (where Cuomo won 65/32): O'Rourke won Delaware, Greene, Hamilton, Sullivan, and Washington Counties.

Spitzer won 4 of those counties.


Title: Re: RBH's Maps
Post by: Filuwaúrdjan on January 08, 2007, 11:09:55 am
As for future results, the NY Gov 1994 results should be a lot of fun. Two hints here.

Cuomo wins NYC big (70/28), Pataki wins the rest of the state big (57/35)

Dave has that up already:

()



Title: Re: RBH's Maps
Post by: Filuwaúrdjan on January 08, 2007, 11:15:08 am
RBH posted 1970 on Atlas some time ago:

(Image Link)


Cool :)


Title: Re: RBH's Maps
Post by: Dave Leip on January 08, 2007, 11:40:37 am
I have no idea how I managed this (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=41&elect=7&off=3&year=1990). but it should be deleted.

Done - I actually forgot to remind you that the 1990 and 1994 Gubernatorial and Senatorial races in Oregon are already done, just not uploaded - So I removed those contests.
Thanks again for all the great work!

State election results index pages (such as WA (https://uselectionatlas.org/RESULTS/state.php?fips=53&f=0&off=99) have been updated to include other election types (primary, runoff, etc.) and cleaned up so that the initiative and referendum results are below the office results.


Title: Re: RBH's Maps
Post by: Alcon on January 08, 2007, 03:29:34 pm
I have no idea how I managed this (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=41&elect=7&off=3&year=1990). but it should be deleted.

Commas in the file, probably.

Yeah, but it took impressive stupidity on my part to do that AND upload it as the 1990 Senate special election instead of 1994 General AFTER I had uploaded it correctly.  I don't even remember doing it.  :P

Thanks, Dave.


Title: Re: RBH's Maps
Post by: bgwah on January 11, 2007, 07:44:33 pm
Hey Dave,

I've come across 1776-1860 gubernatorial results by county and was considering submitting the data. However, I was wondering if there would be any problems with submitting numbers for such old elections. Particularly, I was wondering if there would be a problem with county boundaries arising from the non-existance of many counties so long ago. For a state like Oregon, most of its counties were not yet in existance by 1860. Would they show up as grey? I know that for older presidential results you seemed to have fixed this problem, showing the county boundaries as they were during the election.

Just wanted to know before I tried.

Thanks.


Title: Re: RBH's Maps
Post by: Dave Leip on January 11, 2007, 10:26:25 pm
Hi Jesus!
Very cool.  A couple of points:
1. please enter only official data (I prefer not to add data for another compilation for two reasons -
a. often candidates are omitted or aggregated and b. official sources have more credibility.)

2. I haven't really started looking at county boundaries for such old elections and I recommend holding off for the time being - there is quite a bit of work to understand the boundary changes, create modified maps, update the shapes database, etc.  Currently, county boundary changes are supported as follows:
Most Ohio Valley States and Northeastern states' county boundaries are unchanged for some time, check the animated county gif (http://www.ac.wwu.edu/~stephan/Animation/us.gif) for an approximate idea for how far back you can go before boundaries change in a given state.

Montana: all since statehood on Presidential years (boundary changes in between may not be supported)
Wyoming: all since 1904 on Presidential years
Kansas: all since 1888
Arizona: all since statehood
California: all since 1892 on Presidential years
Michigan: all since 1884 on Presidential years
Colorado: Changes to Denver in 1988 and Broomfield in 2002
Maine: Changes to Cumberland/Oxford County in 1978
New Mexico: Change in 1984
South Dakota: back to 1920
Virginia: back to 1921
Wisconsin: Change in 1964




Title: Re: RBH's Maps
Post by: bgwah on January 11, 2007, 10:58:19 pm
Hi Jesus!
Very cool.  A couple of points:
1. please enter only official data (I prefer not to add data for another compilation for two reasons -
a. often candidates are omitted or aggregated and b. official sources have more credibility.)

2. I haven't really started looking at county boundaries for such old elections and I recommend holding off for the time being - there is quite a bit of work to understand the boundary changes, create modified maps, update the shapes database, etc.  Currently, county boundary changes are supported as follows:
Most Ohio Valley States and Northeastern states' county boundaries are unchanged for some time, check the animated county gif (http://www.ac.wwu.edu/~stephan/Animation/us.gif) for an approximate idea for how far back you can go before boundaries change in a given state.

Montana: all since statehood on Presidential years (boundary changes in between may not be supported)
Wyoming: all since 1904 on Presidential years
Kansas: all since 1888
Arizona: all since statehood
California: all since 1892 on Presidential years
Michigan: all since 1884 on Presidential years
Colorado: Changes to Denver in 1988 and Broomfield in 2002
Maine: Changes to Cumberland/Oxford County in 1978
New Mexico: Change in 1984
South Dakota: back to 1920
Virginia: back to 1921
Wisconsin: Change in 1964




Oh, well its just a book at the library so if its not accurate enough I won't bother.


Title: Re: RBH's Maps
Post by: RBH on January 12, 2007, 10:09:09 am
Yeah, I figure the county changes may be one thing slowing down Texas maps too.

That, and the claim of no results for El Paso in 1924.


Title: Re: RBH's Maps
Post by: minionofmidas - supplemental forum account on January 12, 2007, 10:16:32 am
What about Los Alamos in the 40s? The last changes before that were in the first quarter of the century.


Title: Re: RBH's Maps
Post by: bgwah on January 12, 2007, 07:28:15 pm
I looked at the book today. It does seem to include minor candidates that received less than 1% of the vote and give its sources which are often official... If you don't want me to use it though, I won't.

Alcon stayed up until 1PM (in the afternoon!) that one night and did all of Washington so I'm just looking for something else to do... :-\


Title: Re: RBH's Maps
Post by: Dave Leip on January 12, 2007, 07:47:44 pm
What about Los Alamos in the 40s? The last changes before that were in the first quarter of the century.

Vielen Dank!  New Mexico boundary changes weren't accounted for in either the shapes database or the mapgen script.  I've added both sets of information, so New Mexico is now complete back to statehood - with a caveat:
Boundary between Socorro/Sierra and Chaves/Roosevelt is different from a couple of different sources in the 1920s.  Anyone with traceable information on the evolution of these two boundaries?
Thanks
Dave


Title: Re: RBH's Maps
Post by: Dave Leip on January 12, 2007, 07:55:06 pm
I looked at the book today. It does seem to include minor candidates that received less than 1% of the vote and give its sources which are often official... If you don't want me to use it though, I won't.

Alcon stayed up until 1PM (in the afternoon!) that one night and did all of Washington so I'm just looking for something else to do... :-

Wow.  I'll have to give the data a double-check... I know what sleep-deprivation can do... but that is some passion!

How about working the WA border states?  Idaho is very easy as the SOS already has data back to the early 90s in spreadsheets.  Montana also has official abstracts posted (I downloaded the spreadhseets a while ago - but they don't seem to be available anymore, so I posted them here (https://uselectionatlas.org/DOC/).  I also obtained 1984, 1988, and 1992 OR Abstracts in pdf form also here (https://uselectionatlas.org/DOC/).  These abstracts are scans and therfore require typing.


Title: Re: RBH's Maps
Post by: Alcon on January 13, 2007, 10:46:58 pm
Dave,

Thanks, but Montana appears to be undownloadable (no permissions).  I'll work on Oregon some more.


Title: Re: RBH's Maps
Post by: Dave Leip on January 14, 2007, 12:06:04 am
That was odd - I've changed permissions to allow all read.  I also posted three pdf versions of the Colorado Official Abstracts that I dug up (1997-99, 2001-02, and 2003-04).
Thanks,
Dave


Title: Re: RBH's Maps
Post by: Alcon on January 14, 2007, 01:12:50 am
Thanks Dave.

Tied results (https://uselectionatlas.org/RESULTS/state.php?year=1996&off=52&elect=0&fips=30&f=0) are still showing up as empty, by the way.  :)  I'm not sure if that's been reported yet...

Montana is going great - the spreadsheet format really helps.


Title: Re: RBH's Maps
Post by: RBH on January 14, 2007, 04:29:12 am
You mean that Owyhee County doesn't like Bears that much?


Title: Re: RBH's Maps
Post by: Alcon on January 14, 2007, 05:43:20 am
You mean that Owyhee County doesn't like Bears that much?

No, they love bears and the environment.

And are the only county to buck every other voting trend on those maps.


Title: Re: RBH's Maps
Post by: Dave Leip on January 14, 2007, 11:14:49 am
Thanks Dave.

Tied results (https://uselectionatlas.org/RESULTS/state.php?year=1996&off=52&elect=0&fips=30&f=0) are still showing up as empty, by the way.  :)  I'm not sure if that's been reported yet...

Montana is going great - the spreadsheet format really helps.

Cool - but - there is a problem...  I should have warned ahead of time (Note that checkbox that asks to verify that the county order is the same in the source as the template spreadsheet).  McCone and Madison counties are reversed in all your entries (excel sorts Mc after Ma, but traditionally, Mc has always been listed before Ma and the fips code supports the latter order).  This is a headache that I am constantly having to deal with - in printed sources, I have to check the order of every printed county name before entering the data... so, I think you'll need to redo...  let me work to create an easier way to change just the data for a race and I'll post another message on this thread when its ready.

I'll also add a red/green tie color.



Title: Re: RBH's Maps
Post by: minionofmidas - supplemental forum account on January 14, 2007, 11:23:10 am
Blue/green too.


Title: Re: RBH's Maps
Post by: Dave Leip on January 14, 2007, 01:28:12 pm
I've now added data update functionality to the upload script: at the bottom of any data page that you contributed, there is a new link "Change Data for this Contest".   This will allow you to upload the new data for that contest without touching any of the other information (candidates, sources, etc.).

Dave


Title: Re: RBH's Maps
Post by: Dave Leip on January 14, 2007, 01:36:20 pm
I also added official publications for AZ (pdf canvasses), Idaho (excel canvasses), and Delaware (pdf scan official results) to the DOC (https://uselectionatlas.org/DOC/) folder.


Title: Re: RBH's Maps
Post by: Alcon on January 14, 2007, 03:56:52 pm
#%@!

Thanks for the change data script.  That will make this a little easier.  :P

EDIT: It will be until later in the day when I have access to the computer with the MT files.  I'll try to make a macro and see if I can swap the two lines automatically, but for now I'll add Delaware.

EDIT 2: The DE 2000 file needs read rights too.  Thanks :)


Title: Re: RBH's Maps
Post by: Dave Leip on January 14, 2007, 04:34:40 pm
I've changed the permissions to allow for write-access.  Note that with Delaware, later years separate out the City of Wilmington from 'Rural New Castle County'.  You'll need to add the two for the New Castle figure.

Also for the DE documents, use the "Document" source choice with the following information:
example: for 1996:
Author: Thomas J. Cook
Author Title: Commissioner of Elections
Author Compiled: prep.
Agency: Delaware Department of Elections
Title: State of Delaware 1996 Election Results
Article: State of Delaware Official Results of General Election for Statewide Offices November 5, 1996
Source Pages: p. 2

Also note the write-ins starting on p. 36.
So Lt. Governor should also have a total figure for write-ins of 22 votes, even though there are no county-level data.


Title: Re: RBH's Maps
Post by: Alcon on January 14, 2007, 04:39:01 pm
Done.  Note that with Delaware, later years separate out the City of Wilmington from New Castle County.  You'll need to add the two for the New Castle figure.

Yeah, that's a little annoying.  In earlier years, they also don't provide the losing candidate's full names - just the last names.  There doesn't appear to be any place online with this information.  Is it OK to just enter their last names for now, and update them when they're found?


Title: Re: RBH's Maps
Post by: Dave Leip on January 14, 2007, 05:04:23 pm
Done.  Note that with Delaware, later years separate out the City of Wilmington from New Castle County.  You'll need to add the two for the New Castle figure.

Yeah, that's a little annoying.  In earlier years, they also don't provide the losing candidate's full names - just the last names.  There doesn't appear to be any place online with this information.  Is it OK to just enter their last names for now, and update them when they're found?

Hi Alcon,
Sure, that is ok.  Post the names and offices in a thread and maybe you can enlist some help digging them up.  I'll also add a script to more easily edit candidate names/source info.
Also read the edits to my previous post as well.
Enjoy,
Dave


Title: Re: RBH's Maps
Post by: Dave Leip on January 14, 2007, 05:08:38 pm
Also, for the many Maryland members, there is always the Maryland Manual (http://www.msa.md.gov/megafile/msa/speccol/sc2900/sc2908/html/manual.html).  From the present back into the 19th century, they have compilation of scanned pdfs of the original manuals.  It takes a bit of getting used to finding the right pages with the election results - I tend to start in the index and find "E", look for election results and then go to that page.  Be sure to use the pdf versions and not the attempted OCR html data as there are often incorrect data in the html.  If you find the right pages, please also download them and send them to me, letting me know which edition of the manual they are from.  Finally, use the "Document" source choice with the appropriate information.
Thanks,
Dave


Title: Re: RBH's Maps
Post by: Dave Leip on January 14, 2007, 05:41:34 pm
For the Illinois Buff, there are the Illinois Blue Books (http://www.eliillinois.org/00001_00/html/BB/) back to 1900.  These also include election data as part of the document.  Also use "Document" for the source from any data here, including all the pertinant info: For example:
Goveror Illinois 1912

Source Author: Harry Woods
Source Author Title: Secretary of State
Source Author Compiled: comp.
Source Agency: Illinois Secretary of State
Source Title: Blue Book of the State of Illinois 1913-1914
Source Article: Vote for Governor - November 5, 1912
Source Publisher: Illinois Printing Company
Source City: Danville
Source Year: 1914
Source Pages: pp. 569-570


Title: Re: RBH's Maps
Post by: Bleeding heart conservative, HTMLdon on January 15, 2007, 07:02:52 pm
Dave,

All of the maps created before Texaslefty's CA Prop 81 map (2007-01-15   01:55:05) are coming up with db errors.  The maps are still showing, but the features of the pages are non-operational.


Title: Re: RBH's Maps
Post by: Dave Leip on January 15, 2007, 09:08:26 pm
Thanks - All should be well soon.  I made some modifications to the database table and a script is working to update the table.  Should be done soon.
Dave


Title: Re: RBH's Maps
Post by: Alcon on January 21, 2007, 05:20:15 am
It would be nice to have a quick way to change the title for idiots like me (https://uselectionatlas.org/RESULTS/state.php?fips=53&year=2001&f=0&off=61&elect=0) who can't spell or in instances where initiatives could be better-named.

This (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=53&elect=0&off=50&year=1992) needs to be transferred to 1991 (the SoS site lists the year incorrectly).


Title: Re: RBH's Maps
Post by: bgwah on January 21, 2007, 07:28:57 am
Hi Dave,

I was wondering it would be possible to add Presidential primary results?


Title: Re: RBH's Maps
Post by: Alcon on January 21, 2007, 10:29:40 am
Additional bugs:

- Initiative titles with apostrophes do not show up at all
- 1980s years without population generate MySQL errors


Title: Re: RBH's Maps
Post by: Dave Leip on January 23, 2007, 10:24:06 am
Great Job all!
This is turning out to be quite a feature!  I have created the ability to edit just the information (candidate names, initiative name, notes, and source info).  At the bottom of each page that you contributed, there is a new link titled "Change Info for this Contest".  This will take you to an edit form that has all the previously-entered data already in the boxes.  Just edit and hit submit.  Please let me know if you have any difficulties or find new introdced bugs.

Quote
There's a race where 5 candidates won counties (here).  Should we just treat that normally for now?  Maybe orange or purple could be added, or something, when that happens?
Yes.  I'll have to add support for all these contests that you dig up with 5 winning candidates (and RBH's < 20% win county!!!)

Quote
- Initiative titles with apostrophes do not show up at all
Could you give me an example contest?

Quote
I was wondering it would be possible to add Presidential primary results?
at some point, possibly - I have a bunch more work here though for delegates, etc.


Title: Re: RBH's Maps
Post by: bgwah on January 23, 2007, 05:55:04 pm
Possible bug; I added Alabama gubernatorial election results for 1946-1986 (I've assumed 1990 and 1994 will be added soon) and noticed that the party buttons don't work for for the elections before 1970.

And, somewhat off topic, Louisiana has their 1987 runoff election online but not the general. Strange...


Title: Re: RBH's Maps
Post by: Alcon on January 23, 2007, 06:52:19 pm
Here (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=53&elect=0&off=51&year=1977) is an example of the apostrophe bug.

By the way, Jesus, you might want to use the new feature to fix "Socialistt Workers" on the last Louisiana one you did (with all the colors).


Title: Re: RBH's Maps
Post by: True Democrat on January 23, 2007, 10:13:08 pm
Possible bug; I added Alabama gubernatorial election results for 1946-1986 (I've assumed 1990 and 1994 will be added soon) and noticed that the party buttons don't work for for the elections before 1970.

And, somewhat off topic, Louisiana has their 1987 runoff election online but not the general. Strange...

In 1966, Lurleen Wallace, his wife ran, since Wallace term limited and still wanted to be governor.


Title: Re: RBH's Maps
Post by: The love that set me free on January 27, 2007, 08:19:10 pm
I just added the 2000 Minnesota Senate Democratic primary: https://uselectionatlas.org/RESULTS/state.php?year=2000&off=3&elect=1&fips=27&f=0

It's there, but there are no links to it on the main contributions page, or on the Minnesota page. What's up?


Title: Re: RBH's Maps
Post by: RBH on January 27, 2007, 09:23:41 pm
And, somewhat off topic, Louisiana has their 1987 runoff election online but not the general. Strange...

Edwards refused to go a runoff with Roemer in 1987


Title: Re: RBH's Maps
Post by: Dave Leip on January 29, 2007, 10:49:37 am
This contest for AZ Prop 107 (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=4&elect=0&off=50&year=2006) is way off - it has unofficial CNN data that are short by over 300,000 votes.  Please avoid using CNN or other unofficial/secondary sources for data.  The AZ 2006 Official Canvass (http://www.azsos.gov/election/2006/General/Canvass2006GE.pdf) has all these official data. 
Thanks,
Dave


Title: Re: RBH's Maps
Post by: RBH on February 02, 2007, 08:31:11 pm
I don't think the script can upload results from O'Brien County Iowa due to the comma.


Title: Re: RBH's Maps
Post by: Dave Leip on February 03, 2007, 04:45:27 pm
Yep, the 'quote' was messed up because I had the variable in single quotes.  It should work now.


Title: Re: RBH's Maps
Post by: Joe Republic on February 11, 2007, 01:57:50 pm
I'm not sure what I did wrong here:

https://uselectionatlas.org/RESULTS/state.php?year=2006&off=11&elect=0&fips=39&f=0

Could somebody do a user's guide or something?  It's all a little baffling, and I have plenty of time and resources to make a bunch of maps.


Title: Re: RBH's Maps
Post by: The love that set me free on February 11, 2007, 05:12:53 pm
You probably either left commas in the digits or didn't delete the top line.


Title: Re: RBH's Maps
Post by: Dave Leip on February 11, 2007, 09:25:40 pm
I'm not sure what I did wrong here:

https://uselectionatlas.org/RESULTS/state.php?year=2006&off=11&elect=0&fips=39&f=0

Could somebody do a user's guide or something?  It's all a little baffling, and I have plenty of time and resources to make a bunch of maps.

Hi Joe,
Thanks - the effort would be great!
the file that you uploaded is for some reason blank.  Check that it is tab-delimited file from the template provided via the link on the script page.  It should only include lines from one state, including the statewide total.  The "?" next to each item in the form has a pop-up that gives info on that item of the form.  I'm not sure why the script actually entered the election - could you email me the file?
Thanks,
Dave


Title: Re: RBH's Maps
Post by: nclib on February 13, 2007, 08:18:39 pm
I'm trying to upload the Excel Template to create a map. I use IE but the Template opens up a Netscape window and I can't get the Template to open. Can someone please help me?

Thanks.


Title: Re: RBH's Maps
Post by: Dave Leip on February 14, 2007, 08:37:33 am
I'm trying to upload the Excel Template to create a map. I use IE but the Template opens up a Netscape window and I can't get the Template to open. Can someone please help me?

Thanks.

The template is zipped.  Right-click on the link and "save as".  then use uncompression software to unzip the excel file.  You can then load in Excel or OpenOffice.
Thanks,
Dave


Title: Re: RBH's Maps
Post by: nclib on February 14, 2007, 05:40:40 pm
I'm trying to upload the Excel Template to create a map. I use IE but the Template opens up a Netscape window and I can't get the Template to open. Can someone please help me?

Thanks.

The template is zipped.  Right-click on the link and "save as".  then use uncompression software to unzip the excel file.  You can then load in Excel or OpenOffice.
Thanks,
Dave

I'm not familiar with uncompression software. Can you (or someone else) please explain what needs to be done?

Thanks.


Title: Re: RBH's Maps
Post by: Gabu on February 14, 2007, 06:19:07 pm
I use WinZip (http://www.winzip.com/downwz.htm) for my archival needs.  Technically speaking, the version is an "evaluation" version, but it can be used indefinitely.


Title: Re: RBH's Maps
Post by: nclib on February 14, 2007, 06:23:31 pm
Thanks, Gabu, but I don't have the minimum requirements for WinZip.


Title: Re: RBH's Maps
Post by: Gabu on February 14, 2007, 06:33:02 pm
Thanks, Gabu, but I don't have the minimum requirements for WinZip.

Oh, I see.

What sort of computer are you using?


Title: Re: RBH's Maps
Post by: nclib on February 14, 2007, 06:37:51 pm
Thanks, Gabu, but I don't have the minimum requirements for WinZip.

Oh, I see.

What sort of computer are you using?

IBM PC with Windows '98. If there's a way for me to contribute a map, please PM me or post it here.


Title: Re: RBH's Maps
Post by: Gabu on February 15, 2007, 10:10:47 pm
Thanks, Gabu, but I don't have the minimum requirements for WinZip.

Oh, I see.

What sort of computer are you using?

IBM PC with Windows '98. If there's a way for me to contribute a map, please PM me or post it here.

Unfortunately, it's not maps that you contribute, but tab-delimited data about a race.  The map itself is generated automatically from the data.


Title: Re: RBH's Maps
Post by: RBH on February 16, 2007, 10:00:15 am
Hm, can someone delete this (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=13&elect=1&off=3&year=2006). I accidentally put this in with the wrong race title. And I did but Taylor/Cox in for the Gubernatorial race. It's just that there's no Senate primary for 2006 to put in to overwrite this info.


Title: Re: RBH's Maps
Post by: minionofmidas - supplemental forum account on February 16, 2007, 11:55:47 am
Are the 1998(?) referenda banning cockfighting in Missouri and Arizona online?


Title: Re: RBH's Maps
Post by: Joe Republic on February 16, 2007, 09:21:22 pm
Alright, now I'm confused.  What does "tab-delimited" mean?


Title: Re: RBH's Maps
Post by: Gabu on February 16, 2007, 09:39:15 pm
Alright, now I'm confused.  What does "tab-delimited" mean?

"Delimiting" is intarweb jargon for "separating with a specified character".  In tab-delimited data, each individual bit of data is separated by a tab.  It's important to specify the character because that's how the computer program knows what's data and what's a separator.

And if you're unfamiliar with the usage of "character" in the above explanation, that's another bit of intarweb jargon for "something you can write with a keyboard".


Title: Re: RBH's Maps
Post by: nclib on February 16, 2007, 10:43:46 pm
Alright, now I'm confused.  What does "tab-delimited" mean?

"Delimiting" is intarweb jargon for "separating with a specified character".  In tab-delimited data, each individual bit of data is separated by a tab.  It's important to specify the character because that's how the computer program knows what's data and what's a separator.

And if you're unfamiliar with the usage of "character" in the above explanation, that's another bit of intarweb jargon for "something you can write with a keyboard".

Gabu, based on my earlier message, are you saying that it would be impossible for me to do tab-delimited data from my computer?


Title: Re: RBH's Maps
Post by: Joe Republic on February 17, 2007, 11:00:53 am
Alright, now I'm confused.  What does "tab-delimited" mean?

"Delimiting" is intarweb jargon for "separating with a specified character".  In tab-delimited data, each individual bit of data is separated by a tab.  It's important to specify the character because that's how the computer program knows what's data and what's a separator.

And if you're unfamiliar with the usage of "character" in the above explanation, that's another bit of intarweb jargon for "something you can write with a keyboard".

Okay, so could you explain what I need to do with the template spreadsheet I downloaded?  I see that it has the states listed in the first column, and the counties for each state seem to be hidden.  Using Microsoft Works Spreadsheet, how do I make those hidden rows appear so I can input data?

My n00bitude is apparent for all to see.


Title: Re: RBH's Maps
Post by: RBH on February 17, 2007, 12:22:18 pm
Hit the plus sign on the left side.

Also, after you've put into the columns (in the form of numbers without commas).. copy all the info and paste it into a txt file.


Title: Re: RBH's Maps
Post by: Dave Leip on February 23, 2007, 11:34:42 am
Hm, can someone delete this (https://uselectionatlas.org/RESULTS/state.php?f=0&fips=13&elect=1&off=3&year=2006). I accidentally put this in with the wrong race title. And I did but Taylor/Cox in for the Gubernatorial race. It's just that there's no Senate primary for 2006 to put in to overwrite this info.

This race has been removed. 

Thanks for the tremendous effort!!!  Keep up the great work.
Dave


Title: Re: RBH's Maps
Post by: The love that set me free on February 23, 2007, 01:11:20 pm
Hit the plus sign on the left side.

Also, after you've put into the columns (in the form of numbers without commas).. copy all the info and paste it into a txt file.

Actually it's probably easier to hit "Save As" and then choose a Text File as the format.

Also the top line is just a guide for you when entering. It should be deleted before uploading.


Title: Re: RBH's Maps
Post by: RBH on February 24, 2007, 01:02:08 am
Hit the plus sign on the left side.

Also, after you've put into the columns (in the form of numbers without commas).. copy all the info and paste it into a txt file.

Actually it's probably easier to hit "Save As" and then choose a Text File as the format.

Also the top line is just a guide for you when entering. It should be deleted before uploading.

True.

But either way, you get to the same destination. ;)


Title: Re: RBH's Maps
Post by: RBH on February 24, 2007, 10:51:37 pm
My 1990 and 1992 Missouri maps are a demonstration of the power of taking digital camera photos of pages from a reference book.

It took me a time or two to figure out how to take photos where the text doesn't disappear from the flash.

So basically i'd move the photos onto my computer, and then I would keep that picture in a window and then I'd go though a spreadsheet to type in nymbers.

Digital photocopying!


Title: Re: RBH's Maps
Post by: Queen Mum Inks.LWC on March 06, 2007, 05:30:26 pm
Has anybody done the 2006 Primaries?  I have a lot of data that I downloaded and did in paint during the summer or last year.  This would be pretty easy for me just to put into the data file and enter.


Title: Re: RBH's Maps
Post by: Shilly on March 29, 2007, 11:23:38 pm
I've been trying to enter data for some elections but I keep getting errors similair to this for all of the candidates I put in the form.

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


As far as I can tell, I have done everything exactly as how I did the three succesful entries I made. Any possible explanations?


Title: Re: RBH's Maps
Post by: Dave Leip on March 30, 2007, 08:49:52 am
I've been trying to enter data for some elections but I keep getting errors similair to this for all of the candidates I put in the form.

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


As far as I can tell, I have done everything exactly as how I did the three succesful entries I made. Any possible explanations?

Thanks!  Be sure that your data file has no commas in the data (set all the cell numberical types to "General".  Also be sure that the file has UNIX return characters.  On a Mac, I use a program called convertNewlines.app  I don't know what you have to do on a PC -> RBH - do you perform any special operations on the tab-delimited file?


Title: Re: RBH's Maps
Post by: Shilly on March 30, 2007, 04:40:46 pm
I found the problem. The numbers in the cells weren't formatted as "general"
After I changed that, the data uploaded fine. Thanks for the help!


Title: Re: RBH's Maps
Post by: Dave Leip on June 11, 2008, 04:28:28 pm
Hi,
I've made a slight modification to the election upload script (https://uselectionatlas.org/SCRIPTS/election_upload.php) to account for official/unofficial data.  I've automatically made all data prior to 2006 as official.  Please take a moment to update the info (and data if appropriate) for elections that were entered prior to the results being certified.
many thanks,
Dave


Title: Re: RBH's Maps
Post by: A18 on June 11, 2008, 08:50:13 pm
Dave,

Do you know what's going on here?
https://uselectionatlas.org/RESULTS/state.php?year=1801&off=5&elect=0&fips=10&f=0

The map is broken, though the data--both statewide and county--appears to be in the database. (If elections that far back aren't supported, then please delete.)


Title: Re: RBH's Maps
Post by: A18 on June 12, 2008, 08:10:17 am
A few other things:

1. The page gives http://www.state.de.us/election/index.htm as the source URL, which is not correct. The proper URL appears in the Election Data Input Form, however.

2. The "Note 2" field is set to <textarea name="note_1". It is therefore impossible to modify Note 2; and moreover, whatever is entered into Note 2 becomes the new Note 1.

3. In order to make the Federalists' color purple, so as to be consistent with your presidential-election pages for 1789 through 1816, which candidate column must I use? Or is this not possible?


Title: Re: RBH's Maps
Post by: Dave Leip on June 12, 2008, 01:57:26 pm
Dave,

Do you know what's going on here?
https://uselectionatlas.org/RESULTS/state.php?year=1801&off=5&elect=0&fips=10&f=0

The map is broken, though the data--both statewide and county--appears to be in the database. (If elections that far back aren't supported, then please delete.)

Hi Philip,
Thanks - For each of the states, the county maps won't be generated prior to the year that I have verified the county boundaries.  For Delaware that was 1892 as of yesterday. I modified the map to cover the Kent/New Castle boundary change in 1841, so now Delaware is good to 1775.  Other states vary in regard to the correct boundaries.

Dave


Title: Re: RBH's Maps
Post by: Dave Leip on June 12, 2008, 01:58:56 pm
A few other things:

1. The page gives http://www.state.de.us/election/index.htm as the source URL, which is not correct. The proper URL appears in the Election Data Input Form, however.
I have corrected this code oversight.

2. The "Note 2" field is set to <textarea name="note_1". It is therefore impossible to modify Note 2; and moreover, whatever is entered into Note 2 becomes the new Note 1.
I've corrected this bug

3. In order to make the Federalists' color purple, so as to be consistent with your presidential-election pages for 1789 through 1816, which candidate column must I use? Or is this not possible?
I have more work to do to make the Federalists purple...


Title: Re: RBH's Maps
Post by: A18 on June 12, 2008, 02:03:31 pm
Excellent; thanks!


Title: Re: RBH's Maps
Post by: A18 on June 12, 2008, 10:21:40 pm
I managed to botch this Pennsylvania election (https://uselectionatlas.org/RESULTS/state.php?year=1860&off=5&elect=0&fips=42&f=0) as well, and I don't want to go on making mistakes. Would it be possible to get a list showing, for each state, how far back county boundaries have been verified?


Title: Re: RBH's Maps
Post by: A18 on June 21, 2008, 02:56:10 pm
Dave,

Can you change this entry (https://uselectionatlas.org/RESULTS/state.php?fips=25&year=2002&f=0&off=50&elect=0) from "referendum" to "initiative" for me? I hadn't realized the system distinguished between the two.

Additionally, for some reason the election note for this Illinois "referendum" (https://uselectionatlas.org/RESULTS/state.php?fips=17&year=1933&f=0&off=50&elect=7) appears on the county results pages, but not on the main, statewide results page.

EDIT: I also notice there's an extra "http://" for web sources on the various entries. Do you want us to omit the "http://" from the submitted URL?


Title: Re: RBH's Maps
Post by: Torie on July 07, 2008, 05:56:28 pm
Where does one find all of these maps that members create. Despite my best efforts, I can't find them. Thanks.


Title: Re: RBH's Maps
Post by: A18 on July 07, 2008, 06:50:05 pm
https://uselectionatlas.org/RESULTS/national.php?f=0&off=99

Click on the state you're interested in.


Title: Re: RBH's Maps
Post by: Torie on July 08, 2008, 12:05:16 am
https://uselectionatlas.org/RESULTS/national.php?f=0&off=99

Click on the state you're interested in.

Thanks so much. It appears to have a treasure trove of data. It should be easier to find, for those who drop by.


Title: Re: RBH's Maps
Post by: Хahar 🤔 on February 01, 2010, 10:52:28 pm
Excellent, this is stickied! I often have a hard time finding this thread.


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: bgwah on March 30, 2010, 06:04:35 pm
Dave, is there any chance we could get clarification on what to with blanket primaries? They don't quite fit any of the definitions presented in the upload script. I've just been doing them as open primaries, but I would like your opinion...


Title: Re: RBH's Maps
Post by: Vepres on May 22, 2010, 04:20:15 pm
https://uselectionatlas.org/RESULTS/national.php?f=0&off=99

Click on the state you're interested in.

Dave, you should put a link on the election results page. That would be more convenient, particularly for new people :)


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: Хahar 🤔 on July 20, 2010, 02:47:42 pm
When I open up the upload page, it tells me to log in, even though I already am logged in.


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: Dave Leip on July 21, 2010, 08:24:51 pm
When I open up the upload page, it tells me to log in, even though I already am logged in.

Thanks - try it now.

Dave


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: Хahar 🤔 on July 22, 2010, 01:09:08 am
It works now. Thanks.


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: bgwah on August 02, 2010, 04:11:03 pm
Dave, is there any chance we'll ever be able to submit primaries for third parties?


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: dadge on September 29, 2011, 09:00:59 am
I've put this question on the Vote UK board but I'll put it here too 'cause you guys might be able to help me:

I've got Boundary Line from the Ordnance Survey but I've never used GIS software so I'm a bit stuck. (In fact that's not quite true, but the last time I used it was 1985 and it was a bit different then!) This PC is a crappy Athlon 2600+ 1.92 GHz with 480MB of RAM, so ArcGIS is out of the question. In this very room there are two more PCs and I can set to work on improving the memory situation, but before I do that, is there any more slimline software, or online application, that I could use? Cheers, A


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: Miles on April 02, 2012, 09:55:18 pm
I'm trying to upload maps, but I'm getting all this:

Error: First-line fips code of the data file does not match the chosen state. Check selected state and whether first line of data file is the correct data for the first county of the selected state.

Error: Geographic type Type for Name is not in database. Please check spelling or email Dave

Check to be sure that the header row has been removed from the data file (data file should only include county, city, and state-level data rows and no column titles)
Error: Last-line fips code of the data file does not match the chosen state. Check whether last line of data file is the correct data for the statewide total (does the file have blank lines?).

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.

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


Can anyone help me? This is quite frustrating :(


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: nclib on April 08, 2012, 09:58:47 pm
BTW, what does WIP mean (on some user-generated county maps)?


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: Smid on April 09, 2012, 07:00:03 pm
BTW, what does WIP mean (on some user-generated county maps)?

I suspect that it's an ongoing work in progress?


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: bgwah on April 15, 2012, 06:55:08 pm
I'm trying to upload maps, but I'm getting all this:

Error: First-line fips code of the data file does not match the chosen state. Check selected state and whether first line of data file is the correct data for the first county of the selected state.

Error: Geographic type Type for Name is not in database. Please check spelling or email Dave

Check to be sure that the header row has been removed from the data file (data file should only include county, city, and state-level data rows and no column titles)
Error: Last-line fips code of the data file does not match the chosen state. Check whether last line of data file is the correct data for the statewide total (does the file have blank lines?).

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.

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


Can anyone help me? This is quite frustrating :(

Yeah it can be confusing. If you want to upload the file somewhere I can take a look at it for you.


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: bgwah on May 10, 2012, 12:32:51 am
DAVE,

The upload system doesn't seem to allow elections from 2012. It gives me "year is invalid." I notice nobody else has uploaded any 2012 maps, so I wouldn't be surprised if others have the same problem.


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: Dave Leip on May 10, 2012, 08:34:34 am
DAVE,

The upload system doesn't seem to allow elections from 2012. It gives me "year is invalid." I notice nobody else has uploaded any 2012 maps, so I wouldn't be surprised if others have the same problem.
Thanks -
this should now be corrected.
Dave


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: Oldiesfreak1854 on September 02, 2012, 04:12:22 pm
I just contributed the data for the 1962 Wisconsin governor's race, the first one after the founding of Menominee County.  But when I submitted the data, the Menominee County vote still shows up for Shawano County (the county Menominee County was formed out of.)  Anybody know how to fix this, please?

PS: Could you please help me also with the 2012 Wisconsin recall elections?  It showed up after 1960 instead of at the top after I uploaded the data.


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: Oldiesfreak1854 on September 21, 2012, 05:34:52 pm
I have two more questions: when I try to upload the data for the 1960 Michigan Governor's race, it keeps telling me that something is wrong with the FIPS code (which I've checked and it seems to be all right).  I've tried to correct the errors but I can't seem to think of what might be wrong with it.  Any help with this, please?


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: 2,868,691 on March 03, 2014, 10:10:52 pm
This may have been addressed long ago, but would it be possible to add Agriculture Commissioner to the list statewide offices we can upload?


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: Dave Leip on May 24, 2014, 03:35:39 pm
This may have been addressed long ago, but would it be possible to add Agriculture Commissioner to the list statewide offices we can upload?

Hi,
Thanks - I have updated the script and database to support Agriculture Commissioner.
Enjoy,
Dave


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: Oldiesfreak1854 on November 18, 2015, 10:34:00 am
Could we please remove the "Amendment" option from the upload script?  It's confusing, since all amendments that appear on a ballot are initiatives or referendums in the first place.  (And please delete the data that was uploaded with it, too.)


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: DPKdebator on December 28, 2016, 07:08:02 pm
I hate to sound ignorant, but where is the tool that allows me to edit these maps without having to manually edit the URL?

EDIT: just realized that this is something totally separate... sorry! :P


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: 136or142 on July 20, 2018, 02:32:14 am
I don't know if anything like this has been posted already because I'm not really into maps, but this was posted on twitter (I had nothing to do with it) and I thought people here might be interested.  I don't even know if this is the right thread to post this in.



(Image Link)



Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: 🐒Gods of Prosperity🔱🐲💸 on August 15, 2018, 11:56:30 pm
getting this message:  "
Error: First-line fips code of the data file does not match the chosen state. Check selected state and whether first line of data file is the correct data for the first county of the selected state.  "

does this look right:  ?

Quote
51840   Winchester   City   739   0   525   0   0   0   0   0   0   0               
51   Virginia   State   303531      239285                     42


EDIT:   Okay, I figured it out:   I had a blank line at the beginning of the file and the form did not like that.

here's the 2017 Virginia Gov. Primaries:
https://uselectionatlas.org/RESULTS/state.php?year=2017&off=5&elect=1&fips=51&f=0
https://uselectionatlas.org/RESULTS/state.php?year=2017&off=5&elect=2&fips=51&f=0

btw for Mac OS 10 or later, no conversion to UNIX is needed, as it is already the same format.


Title: Re: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
Post by: Speaker OneJ on December 13, 2018, 12:56:39 pm
Quick question: what would you choose for a special runoff election that wasnt open?