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

[minionofmidas]

Are the 1998(?) referenda banning cockfighting in Missouri and Arizona online?

[Joe Republic]

Alright, now I'm confused.  What does "tab-delimited" mean?

[Gabu]

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".

[nclib]

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?

[Joe Republic]

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.

[RBH]

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.

[ElectionAtlas]

Hm, can someone delete this. 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

[they don't love you like i love you]

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.

[RBH]

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.

[RBH]

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!

[Queen Mum Inks.LWC]

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.

[Shilly]

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?

[ElectionAtlas]

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?

[Shilly]

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!

[ElectionAtlas]

Hi,
I've made a slight modification to the election upload script 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

[A18]

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.)

[A18]

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?

[ElectionAtlas]

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

[ElectionAtlas]

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...

[A18]

Excellent; thanks!

[A18]

I managed to botch this Pennsylvania election 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?

[A18]

Dave,

Can you change this entry 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" 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?

[Torie]

Where does one find all of these maps that members create. Despite my best efforts, I can't find them. Thanks.

[A18]

https://uselectionatlas.org/RESULTS/national.php?f=0&off=99

Click on the state you're interested in.

[Torie]

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.