Google map mashup for teams/players

kleric · 06-06-2008, 10:50 AM

Totally a work in progress, but just seeing how interested people might be in the code for this.

TTBL Players on GoogleMaps

It's run off a mysql DB (I don't know Perl enough, so can't truly integrate it with Getch's tools...), the maps starts off showing all teams in the league, at all levels, and where they're located. Click on a team marker, and for now just get the logo and a link. Click the link and you get a map of the players on that team.

Incredibly useful? No. Kinda neat? Yeah.

No Pepper · 06-06-2008, 11:14 AM

That's pretty slick, kleric!

ifspuds · 06-06-2008, 11:48 AM

That is really cool stuff. Like you said, maybe not so useful, but definitely fun to look at.

Corsairs · 06-06-2008, 01:52 PM

Count me in as someone who'd be plenty interested in this. It's little touches like this that bring a league to life, especially fictional leagues. The owners in my league would love something like this. Very well done, kleric! I'll look forward to the release of your code.

Raidergoo · 06-06-2008, 02:34 PM

Um, that is fantastic!

For some reason, it shows Antietam off the coast of Nigeria.

kleric · 06-06-2008, 02:42 PM

Quote:

Originally Posted by Raidergoo

Um, that is fantastic!

For some reason, it shows Antietam off the coast of Nigeria.

That happens when there's no lat/long stored in the OOTP database. I still need to write a script to go fix all the 0,0 lat/longs in the ootp sql output.

Raidergoo · 06-06-2008, 03:31 PM

Quote:

Originally Posted by kleric

That happens when there's no lat/long stored in the OOTP database. I still need to write a script to go fix all the 0,0 lat/longs in the ootp sql output.

I made a request to add Sharpsburg, MD to the cities.txt file for you and your league.

Sharpsburg,691,206,Maryland,39.42,-77.74

Bug 1228 has been added to the database.

f.montoya · 06-07-2008, 09:27 AM

I love this! I play about 80% with historical leagues but my 20% belongs to an old 3 1/2 versions back, converted fictional league that I can't ever throw away. A screen shot of a little map like this would be a very nice touch to my old faithful.

CHCfan · 06-08-2008, 03:19 PM

wow. I'd be very interested.

Great idea!!

Oxydizer · 06-08-2008, 04:03 PM

I like seeing these kind of maps, I wonder.......if someone could make a google map with all the members at OOTP on it.

kleric · 06-08-2008, 05:02 PM

Quote:

Originally Posted by Oxydizer

I like seeing these kind of maps, I wonder.......if someone could make a google map with all the members at OOTP on it.

Someone start a frappr.com map, sure.

Roundin Third · 06-09-2008, 07:05 PM

Quote:

Originally Posted by Oxydizer

I like seeing these kind of maps, I wonder.......if someone could make a google map with all the members at OOTP on it.

http://www.frappr.com/ootp/map

06-06-2008, 10:50 AM	#1
kleric Minors (Double A) Join Date: Dec 2003 Location: Denver, CO Posts: 160	Google map mashup for teams/players Totally a work in progress, but just seeing how interested people might be in the code for this. TTBL Players on GoogleMaps It's run off a mysql DB (I don't know Perl enough, so can't truly integrate it with Getch's tools...), the maps starts off showing all teams in the league, at all levels, and where they're located. Click on a team marker, and for now just get the logo and a link. Click the link and you get a map of the players on that team. Incredibly useful? No. Kinda neat? Yeah.

06-06-2008, 11:14 AM	#2
No Pepper All Star Starter Join Date: Jan 2003 Location: Milwaukee, WI Posts: 1,570	That's pretty slick, kleric! __________________ Uniforms compatible with OOTP23/24 Historical Major League Baseball 1901-current Historical Major League Baseball 1871-1900 Historical Federal League Historical Negro Leagues

06-06-2008, 11:48 AM	#3
ifspuds Hall Of Famer Join Date: Jun 2003 Location: Spokane WA Posts: 2,117	That is really cool stuff. Like you said, maybe not so useful, but definitely fun to look at. __________________ Jeff Watson Former dynasty writer and online league player, now mostly retired

06-06-2008, 01:52 PM	#4
Corsairs Hall Of Famer Join Date: Aug 2007 Posts: 2,360	Count me in as someone who'd be plenty interested in this. It's little touches like this that bring a league to life, especially fictional leagues. The owners in my league would love something like this. Very well done, kleric! I'll look forward to the release of your code. __________________ Founder of the Planetary Extreme Baseball Alliance (PEBA) Premiere OOTP fictional league where creativity counts and imagination is your only limitation Check for openings - contact us today! Join the PEBA

06-07-2008, 09:27 AM	#8
f.montoya Hall Of Famer Join Date: Nov 2004 Posts: 6,077	I love this! I play about 80% with historical leagues but my 20% belongs to an old 3 1/2 versions back, converted fictional league that I can't ever throw away. A screen shot of a little map like this would be a very nice touch to my old faithful. __________________ Fidel Montoya Asahi2 Baseball League ex-Commissioner(Historical League Since 2004) Ex-Web Host Current Mod Maker??

06-06-2008, 02:34 PM	#5
Raidergoo Hall Of Famer Join Date: Mar 2003 Posts: 9,005	Um, that is fantastic! For some reason, it shows Antietam off the coast of Nigeria.

06-08-2008, 03:19 PM	#9
CHCfan All Star Starter Join Date: Jun 2002 Location: Grand Island, NE Posts: 1,117	wow. I'd be very interested. Great idea!!

06-08-2008, 04:03 PM	#10
Oxydizer All Star Reserve Join Date: Jan 2007 Location: San Francisco, Ca Posts: 586	I like seeing these kind of maps, I wonder.......if someone could make a google map with all the members at OOTP on it.