Suggested Additions to Cities.txt for a 1900's league

Spindel · 06-24-2006, 06:47 PM

I'd like to make some suggestions for addition to cities.txt.

I'm currently working on a 1901 league, and I've been dismayed to notice that some players don't have cities. I would have hoped that all cities in the lahman database would be represented. But they aren't, so as I go along, I'll suggest some 'key' additions for future editing of the cities.txt.

I'll try to include data for the Cities I find missing, and if I find cities that have had their names changed since then, I'll post into on that too.

Truxton, NY (John McGraw)
Burslem, England (Al "Shoddy" Shaw)
Eckley, PA (Barney McFadden)
Fond Du Lac, WI (Bert Husting)
North Brookfield, MA (Bill Bergen)
Odessa, Ukraine (Bill Cristall)
Nelliston, NY (Bill "Bad Bill" Dahlen)
Allenport, PA (Bill "Whoa Bill" Phillips)
Thorn Hill, OH (Bob Wood)
North Girard, PA (Bones Ely)
Brown County, MN (Burt Hart -New Ulm, MN?)
Taylortown, PA (Charlie "Piano Legs Hickman)
Clear Creek, MO (Clark Griffith)
Emlenton, PA (Claude Ritchie)
Calvert County, MD (Cupid Childs - Prince Frederick, MD?)
Gilmore, OH (Cy Young)
Lone Elm, KS (Dale Gear)
Williamsburg County, SC (Doc McJames - Kingstree, SC?)
Houcktown, OH (Dummy Hoy)
Queenstown, PA (Emmet "Snags" Hiedrick)
North Tarrytown, NY (Frank Murphy)
Luthersburg, PA (Frank Shugart)
Allegheny, PA (Frank Hartman)
Iberia, OH (Harry McNeal)
Galloway, PA (Jack Harper)
Gilbertville, MA (Jack McCarthy)
New Straitsville, OH (Jack Taylor)
Fitchburg, MA (Nixey Callahan, and James Callahan SP/3B, in cities.txt)
Upper Chanceford Township, PA (Jimmy Sheckard - I have no clue, Harrisburg?)
Rowlesburg, WV (Jock Menefee)
Sarpsborg, Norway (John "Honest John" Anderson)
Meadville, PA (John Dunn - Note, should be Jack Dunn, is in cities.txt)
Green Oak, MI (Jud Smith)
New Bethlehem, PA (Ossee Schreckengost *whew*)
LeSueur, MN (Roger "Peaceful Valley" Denzer)
Stoddard, WI (Roy "Pat" Patterson)
Calvert, TX (Rube Foster, Negro League Player)
Bouckville, NY (Snake Wiltse)
Bellaire, OH (Sol White, Negro League Player, comes up as Bellaire, TX)
French Creek, NY (Tommy Leach)
Cecil County, MD (Vic Willis - Elkton, MD?)
Lynch Station, VA (Watty Lee)
Blue Creek, OH (Wiley "Iron Man" Piatt)
Chartiers, PA (Honus Wagner - Is now Carnegie, PA)

That's everyone from 1901.

Other notes: Players born in St. Louis, etc of course come up as unknown. County Cork, Irish players like Patsy Donovan can be listed as Cork for ease of use, too, I think. Perhaps an edit of the lahman and other databases to replace some of these uses can quickly take care of the problems.

Raidergoo · 06-24-2006, 10:02 PM

St. Louis is Saint Louis for the purposes of OOTP 2006.

If you can come up with population and latitude/longitude, I can make a request for addition to the official file. Heck, if I get bored at work next week I may just pitch in and start doing this myself, using Google, Wikipedia, and this neat airport website I found.

Spindel · 06-25-2006, 05:17 PM

Quote:

Originally Posted by Raidergoo

St. Louis is Saint Louis for the purposes of OOTP 2006.

If you can come up with population and latitude/longitude, I can make a request for addition to the official file. Heck, if I get bored at work next week I may just pitch in and start doing this myself, using Google, Wikipedia, and this neat airport website I found.

Yeah, I noticed. I've already replaced all the Saint Louis origins in my league, and I also went and did a quick fix for it in my copy of the Arod-Garlon DB.

Spindel · 06-26-2006, 07:48 AM

Truxton,1225,206,New York,42.71,-76.02
Burslem,21400,61,,53.05,-2.18
Eckley,313431,206,Pennsylvania,40.993,-75.862
Fond Du Lac,2463,206,Wisconsin,43.773,-88.447

Raidergoo · 06-26-2006, 10:41 AM

Code:

North Brookfield, MA	42.27,-72.08	4683
Nelliston, NY		42.93,-74.61	617
Allenport, PA		40.10,-79.85	535
Clear Creek, MO		37.89,-94.11	610
Emlenton, PA		41.18,-79.71	759

Spindel · 06-26-2006, 01:02 PM

Truxton,1225,206,New York,42.71,-76.02
Burslem,21400,61,,53.05,-2.18
Eckley,313431,206,Pennsylvania,40.993,-75.862
Fond Du Lac,2463,206,Wisconsin,43.773,-88.447
Odessa,1012500,204,Odessa,46.466,30.733
North Brookfield,4683,206,Massachusetts MA,42.27,-72.08
Nelliston,617,206,New York,42.93,-74.61
Allenport,535,206,Pennsylvania,40.10,-79.85
Clear Creek,610,206,Missouri,37.89,-94.11
Emlenton,759,206,Pennsylvania,41.18,-79.71
Gilmore,4008,206,Ohio,40.274,-81.602
Lone Elm,27,206,Kansas,38.079,-95.242
Houcktown,73602,206,Ohio,40.935N,-83.594
Queenstown,2860,206,Pennsylvania,41.006,-79.632

Raidergoo · 06-28-2006, 11:26 AM

Lone Elm,27,206,Kansas,38.08,-95.24
Gilbertville,1288,206,Massachusetts,42.31,-72.21
North Brookfield,4683,206,Massachusetts,42.27,-72.08
Green Oak,15618,206,Michigan,42.47,-83.73
LeSueur,4220,206,Minnesota,44.46,-93.91
Clear Creek,610,206,Missouri,37.89,-94.11
North Tarrytown,0,206,New York,41.08,-73.86
French Creek,935,206,New York,42.07,-79.7
Nelliston,617,206,New York,42.93,-74.61
Bouckville,404,206,New York,42.93,-75.56
Bellaire,4892,206,Ohio,40.02,-80.75
Gilmore,0,206,Ohio,40.29,81.44
Iberia,200,206,Ohio,40.67,-82.84
Houcktown,112,206,Ohio,40.94,-83.59
Blue Creek,1303,206,Ohio,38.75,-83.34
New Straitsville,865,206,Ohio,39.58,-82.24
Allenport,535,206,Pennsylvania,40.1,-79.85
Taylortown,0,206,Pennsylvania,40.2,-80.4
Chartiers,0,206,Pennsylvania,40.41,-80.08
Allegheny,0,206,Pennsylvania,40.46,-80
New Bethlehem,1057,206,Pennsylvania,41,-79.33
Luthersburg,963,206,Pennsylvania,41.05,-78.72
Emlenton,759,206,Pennsylvania,41.18,-79.71
Galloway,0,206,Pennsylvania,41.42,-79.81
Queenstown,617,206,Pennsylvania,38.99,-76.16
Upper Chanceford Township,291,206,Pennsylvania,39.91,-76.47
Calvert,1426,206,Texas,30.97,-96.67
Lynch Station,1861,206,Virginia,37.15,-79.3
Rowlesburg,632,206,West Virginia,39.35,-79.67
Stoddard,815,206,Wisconsin,43.66,-91.22

I am having fun tracking some of this stuff down. I am using old census data from the 1870's, a student activist site, a weather site, and the Yellow Pages.

Spindel · 07-01-2006, 08:57 AM

Yeah, it's hard finding some of this stuff. I was using wikipedia for some of it, as they sometimes list L&L and pop. figures. Anyway, haven't had much time to work on it, as It's been busy as hell at work between the local flooding here in NJ and PA and the 4th of july Coming up.

06-24-2006, 06:47 PM	#1
Spindel All Star Reserve Join Date: Oct 2003 Location: Lambertville, NJ Posts: 751	Suggested Additions to Cities.txt for a 1900's league I'd like to make some suggestions for addition to cities.txt. I'm currently working on a 1901 league, and I've been dismayed to notice that some players don't have cities. I would have hoped that all cities in the lahman database would be represented. But they aren't, so as I go along, I'll suggest some 'key' additions for future editing of the cities.txt. I'll try to include data for the Cities I find missing, and if I find cities that have had their names changed since then, I'll post into on that too. Truxton, NY (John McGraw) Burslem, England (Al "Shoddy" Shaw) Eckley, PA (Barney McFadden) Fond Du Lac, WI (Bert Husting) North Brookfield, MA (Bill Bergen) Odessa, Ukraine (Bill Cristall) Nelliston, NY (Bill "Bad Bill" Dahlen) Allenport, PA (Bill "Whoa Bill" Phillips) Thorn Hill, OH (Bob Wood) North Girard, PA (Bones Ely) Brown County, MN (Burt Hart -New Ulm, MN?) Taylortown, PA (Charlie "Piano Legs Hickman) Clear Creek, MO (Clark Griffith) Emlenton, PA (Claude Ritchie) Calvert County, MD (Cupid Childs - Prince Frederick, MD?) Gilmore, OH (Cy Young) Lone Elm, KS (Dale Gear) Williamsburg County, SC (Doc McJames - Kingstree, SC?) Houcktown, OH (Dummy Hoy) Queenstown, PA (Emmet "Snags" Hiedrick) North Tarrytown, NY (Frank Murphy) Luthersburg, PA (Frank Shugart) Allegheny, PA (Frank Hartman) Iberia, OH (Harry McNeal) Galloway, PA (Jack Harper) Gilbertville, MA (Jack McCarthy) New Straitsville, OH (Jack Taylor) Fitchburg, MA (Nixey Callahan, and James Callahan SP/3B, in cities.txt) Upper Chanceford Township, PA (Jimmy Sheckard - I have no clue, Harrisburg?) Rowlesburg, WV (Jock Menefee) Sarpsborg, Norway (John "Honest John" Anderson) Meadville, PA (John Dunn - Note, should be Jack Dunn, is in cities.txt) Green Oak, MI (Jud Smith) New Bethlehem, PA (Ossee Schreckengost whew) LeSueur, MN (Roger "Peaceful Valley" Denzer) Stoddard, WI (Roy "Pat" Patterson) Calvert, TX (Rube Foster, Negro League Player) Bouckville, NY (Snake Wiltse) Bellaire, OH (Sol White, Negro League Player, comes up as Bellaire, TX) French Creek, NY (Tommy Leach) Cecil County, MD (Vic Willis - Elkton, MD?) Lynch Station, VA (Watty Lee) Blue Creek, OH (Wiley "Iron Man" Piatt) Chartiers, PA (Honus Wagner - Is now Carnegie, PA) That's everyone from 1901. Other notes: Players born in St. Louis, etc of course come up as unknown. County Cork, Irish players like Patsy Donovan can be listed as Cork for ease of use, too, I think. Perhaps an edit of the lahman and other databases to replace some of these uses can quickly take care of the problems. __________________ Union League Baseball Commissioner since 2011.

06-26-2006, 07:48 AM	#4
Spindel All Star Reserve Join Date: Oct 2003 Location: Lambertville, NJ Posts: 751	Truxton,1225,206,New York,42.71,-76.02 Burslem,21400,61,,53.05,-2.18 Eckley,313431,206,Pennsylvania,40.993,-75.862 Fond Du Lac,2463,206,Wisconsin,43.773,-88.447 __________________ Union League Baseball Commissioner since 2011.

06-26-2006, 10:41 AM	#5
Raidergoo Hall Of Famer Join Date: Mar 2003 Posts: 9,004	Code: North Brookfield, MA 42.27,-72.08 4683 Nelliston, NY 42.93,-74.61 617 Allenport, PA 40.10,-79.85 535 Clear Creek, MO 37.89,-94.11 610 Emlenton, PA 41.18,-79.71 759

06-26-2006, 01:02 PM	#6
Spindel All Star Reserve Join Date: Oct 2003 Location: Lambertville, NJ Posts: 751	Truxton,1225,206,New York,42.71,-76.02 Burslem,21400,61,,53.05,-2.18 Eckley,313431,206,Pennsylvania,40.993,-75.862 Fond Du Lac,2463,206,Wisconsin,43.773,-88.447 Odessa,1012500,204,Odessa,46.466,30.733 North Brookfield,4683,206,Massachusetts MA,42.27,-72.08 Nelliston,617,206,New York,42.93,-74.61 Allenport,535,206,Pennsylvania,40.10,-79.85 Clear Creek,610,206,Missouri,37.89,-94.11 Emlenton,759,206,Pennsylvania,41.18,-79.71 Gilmore,4008,206,Ohio,40.274,-81.602 Lone Elm,27,206,Kansas,38.079,-95.242 Houcktown,73602,206,Ohio,40.935N,-83.594 Queenstown,2860,206,Pennsylvania,41.006,-79.632 __________________ Union League Baseball Commissioner since 2011.

06-28-2006, 11:26 AM	#7
Raidergoo Hall Of Famer Join Date: Mar 2003 Posts: 9,004	Lone Elm,27,206,Kansas,38.08,-95.24 Gilbertville,1288,206,Massachusetts,42.31,-72.21 North Brookfield,4683,206,Massachusetts,42.27,-72.08 Green Oak,15618,206,Michigan,42.47,-83.73 LeSueur,4220,206,Minnesota,44.46,-93.91 Clear Creek,610,206,Missouri,37.89,-94.11 North Tarrytown,0,206,New York,41.08,-73.86 French Creek,935,206,New York,42.07,-79.7 Nelliston,617,206,New York,42.93,-74.61 Bouckville,404,206,New York,42.93,-75.56 Bellaire,4892,206,Ohio,40.02,-80.75 Gilmore,0,206,Ohio,40.29,81.44 Iberia,200,206,Ohio,40.67,-82.84 Houcktown,112,206,Ohio,40.94,-83.59 Blue Creek,1303,206,Ohio,38.75,-83.34 New Straitsville,865,206,Ohio,39.58,-82.24 Allenport,535,206,Pennsylvania,40.1,-79.85 Taylortown,0,206,Pennsylvania,40.2,-80.4 Chartiers,0,206,Pennsylvania,40.41,-80.08 Allegheny,0,206,Pennsylvania,40.46,-80 New Bethlehem,1057,206,Pennsylvania,41,-79.33 Luthersburg,963,206,Pennsylvania,41.05,-78.72 Emlenton,759,206,Pennsylvania,41.18,-79.71 Galloway,0,206,Pennsylvania,41.42,-79.81 Queenstown,617,206,Pennsylvania,38.99,-76.16 Upper Chanceford Township,291,206,Pennsylvania,39.91,-76.47 Calvert,1426,206,Texas,30.97,-96.67 Lynch Station,1861,206,Virginia,37.15,-79.3 Rowlesburg,632,206,West Virginia,39.35,-79.67 Stoddard,815,206,Wisconsin,43.66,-91.22 I am having fun tracking some of this stuff down. I am using old census data from the 1870's, a student activist site, a weather site, and the Yellow Pages. Last edited by Raidergoo; 06-28-2006 at 11:29 AM.

06-24-2006, 10:02 PM	#2
Raidergoo Hall Of Famer Join Date: Mar 2003 Posts: 9,004	St. Louis is Saint Louis for the purposes of OOTP 2006. If you can come up with population and latitude/longitude, I can make a request for addition to the official file. Heck, if I get bored at work next week I may just pitch in and start doing this myself, using Google, Wikipedia, and this neat airport website I found.

07-01-2006, 08:57 AM	#8
Spindel All Star Reserve Join Date: Oct 2003 Location: Lambertville, NJ Posts: 751	Yeah, it's hard finding some of this stuff. I was using wikipedia for some of it, as they sometimes list L&L and pop. figures. Anyway, haven't had much time to work on it, as It's been busy as hell at work between the local flooding here in NJ and PA and the 4th of july Coming up. __________________ Union League Baseball Commissioner since 2011.