Welcome, Guest. Please login or register.
Did you miss your activation email?
October 01, 2014, 11:30:15 pm
HomePredMockPollEVCalcAFEWIKIHelpLogin Register
News: Atlas Hardware Upgrade complete October 13, 2013.

+  Atlas Forum
|-+  Questions and Answers
| |-+  The Atlas
| | |-+  RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)
« previous next »
Pages: 1 [2] 3 4 5 6 7 8 Print
Author Topic: RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)  (Read 42904 times)
Dave Leip
leip
Administrator
YaBB God
*****
Posts: 2387
United States


View Profile WWW
« Reply #25 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
Logged
Dave Leip
leip
Administrator
YaBB God
*****
Posts: 2387
United States


View Profile WWW
« Reply #26 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).
Logged
bgwah
YaBB God
*****
Posts: 13745
United States


Political Matrix
E: -1.03, S: -6.96

View Profile
« Reply #27 on: January 02, 2007, 07:19:40 pm »
Ignore

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.

http://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 Tongue)
-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
Logged

Rob
Bob
YaBB God
*****
Posts: 6321
United States
Political Matrix
E: -6.32, S: -9.39

View Profile
« Reply #28 on: January 02, 2007, 07:31:32 pm »
Ignore

I made one: Oklahoma Lt. Governor [2006]

Great feature, Dave!
Logged

Here’s what Sarah Palin represents: being a fat fucking pig who pins “Country First” buttons on his man titties and chants “U-S-A! U-S-A!” at the top of his lungs while his kids live off credit cards and Saudis buy up all the mortgages in Kansas.
Shilly
YaBB God
*****
Posts: 528
United States


Political Matrix
E: -5.68, S: -4.00

View Profile
« Reply #29 on: January 02, 2007, 07:50:23 pm »
Ignore

Created one too.

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

Logged
bgwah
YaBB God
*****
Posts: 13745
United States


Political Matrix
E: -1.03, S: -6.96

View Profile
« Reply #30 on: January 02, 2007, 08:06:34 pm »
Ignore

Tried doing the 2004 Washington Democratic Primary for Governor. The page I got after I hit upload showed the map ( http://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.
Logged

Grad Students are the Worst
Alcon
Moderators
YaBB God
*****
Posts: 29661
United States
View Profile
« Reply #31 on: January 02, 2007, 08:38:27 pm »
Ignore

Excellent.  I got it to work, with the tables working too...but the "county data by graphs" function seems to error out.
Logged

n/c
Dave Leip
leip
Administrator
YaBB God
*****
Posts: 2387
United States


View Profile WWW
« Reply #32 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  These contests will also show up in the state election page, such as: here
Thanks,
Dave  
« Last Edit: January 02, 2007, 08:50:33 pm by Dave Leip »Logged
black and white band photos
BRTD
YaBB God
*****
Posts: 72327
United Kingdom


View Profile
« Reply #33 on: January 02, 2007, 08:57:51 pm »
Ignore

Wow, I'll probably be addicted all night making Minnesota maps.
Logged




01/05/2004-01/10/2014
Rob
Bob
YaBB God
*****
Posts: 6321
United States
Political Matrix
E: -6.32, S: -9.39

View Profile
« Reply #34 on: January 02, 2007, 10:22:37 pm »
Ignore

Dave, the green on this initiative map doesn't appear. I don't know if it was my error or a site glitch.
Logged

Here’s what Sarah Palin represents: being a fat fucking pig who pins “Country First” buttons on his man titties and chants “U-S-A! U-S-A!” at the top of his lungs while his kids live off credit cards and Saudis buy up all the mortgages in Kansas.
black and white band photos
BRTD
YaBB God
*****
Posts: 72327
United Kingdom


View Profile
« Reply #35 on: January 02, 2007, 10:29:29 pm »
Ignore

Here's my first shot at it: http://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.
Logged




01/05/2004-01/10/2014
Dave Leip
leip
Administrator
YaBB God
*****
Posts: 2387
United States


View Profile WWW
« Reply #36 on: January 02, 2007, 10:44:35 pm »

Another minor bug:

Third-party maps are broken (Libertarian broke 10% in Skamania County)

This has been fixed.  If a minor party receives > 5%, they get their own map.
Logged
Dave Leip
leip
Administrator
YaBB God
*****
Posts: 2387
United States


View Profile WWW
« Reply #37 on: January 02, 2007, 10:45:05 pm »

Dave, the green on this initiative map 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.
Logged
Rob
Bob
YaBB God
*****
Posts: 6321
United States
Political Matrix
E: -6.32, S: -9.39

View Profile
« Reply #38 on: January 02, 2007, 10:46:32 pm »
Ignore

Thanks. Smiley
Logged

Here’s what Sarah Palin represents: being a fat fucking pig who pins “Country First” buttons on his man titties and chants “U-S-A! U-S-A!” at the top of his lungs while his kids live off credit cards and Saudis buy up all the mortgages in Kansas.
black and white band photos
BRTD
YaBB God
*****
Posts: 72327
United Kingdom


View Profile
« Reply #39 on: January 02, 2007, 10:50:18 pm »
Ignore

As practice, I decided to do an easy race in a state with not many counties. So here's AZ Attorney General this year:

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




01/05/2004-01/10/2014
Grad Students are the Worst
Alcon
Moderators
YaBB God
*****
Posts: 29661
United States
View Profile
« Reply #40 on: January 02, 2007, 10:59:45 pm »
Ignore

God bless SoS Sam Reed for putting county results for Washington up back to 1970.

I'll be up all night too.  Tongue

Thanks again, Dave!
« Last Edit: January 02, 2007, 11:03:14 pm by Alcon »Logged

n/c
Dave Leip
leip
Administrator
YaBB God
*****
Posts: 2387
United States


View Profile WWW
« Reply #41 on: January 02, 2007, 11:03:26 pm »

Here's my first shot at it: http://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?
Logged
Dave Leip
leip
Administrator
YaBB God
*****
Posts: 2387
United States


View Profile WWW
« Reply #42 on: January 02, 2007, 11:04:27 pm »

Don't forget to take your time with the data.  Quality counts!
Logged
black and white band photos
BRTD
YaBB God
*****
Posts: 72327
United Kingdom


View Profile
« Reply #43 on: January 02, 2007, 11:23:53 pm »
Ignore

Here's my first shot at it: http://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.
Logged




01/05/2004-01/10/2014
Dave Leip
leip
Administrator
YaBB God
*****
Posts: 2387
United States


View Profile WWW
« Reply #44 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:

http://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
Logged
black and white band photos
BRTD
YaBB God
*****
Posts: 72327
United Kingdom


View Profile
« Reply #45 on: January 02, 2007, 11:28:59 pm »
Ignore

OK, I found the error, the totals in Becker county are transposed.
Logged




01/05/2004-01/10/2014
Dave Leip
leip
Administrator
YaBB God
*****
Posts: 2387
United States


View Profile WWW
« Reply #46 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 Smiley
Logged
RBH
YaBB God
*****
Posts: 2069


View Profile
« Reply #47 on: January 02, 2007, 11:54:40 pm »
Ignore

God bless SoS Sam Reed for putting county results for Washington up back to 1970.

I'll be up all night too.  Tongue

Thanks again, Dave!

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

RBH
black and white band photos
BRTD
YaBB God
*****
Posts: 72327
United Kingdom


View Profile
« Reply #48 on: January 02, 2007, 11:59:55 pm »
Ignore

OK, new data is up, looks good but a minor error: The default format for the table is not in alphabetical order
Logged




01/05/2004-01/10/2014
black and white band photos
BRTD
YaBB God
*****
Posts: 72327
United Kingdom


View Profile
« Reply #49 on: January 03, 2007, 01:00:55 am »
Ignore

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




01/05/2004-01/10/2014
Pages: 1 [2] 3 4 5 6 7 8 Print 
« previous next »
Jump to:  


Login with username, password and session length

Logout

Powered by SMF 1.1.19 | SMF © 2013, Simple Machines