Group Abstract Group Abstract

Message Boards Message Boards

Searchable databases: Visualizing entry locations

Posted 10 years ago
Attachments:
POSTED BY: William Duhe
6 Replies
Posted 10 years ago

A couple of good links for Civil War flags:

http://www.historynet.com/civil-war-flags

http://www.americancivilwarstory.com/civil-war-flags.html

http://www.loeser.us/flags/civil.html

This last one seems to be the most interesting. You can get regimental and unit flags here. Ah, that would really blow up this thread. (Still...)

--Glen

POSTED BY: Glen Deering
Posted 10 years ago

Okay, William. I've got one for you.

http://www.civil-war-journeys.org/spreadsheetofcivilwarbattles.htm

There is a link to an Excel file at the bottom of the webpage. Among other things, it has the name of the battle, the state in which it was fought, the campaign it was a part of, names of Union/Confederate/Indian commanders, Union/Confederate victory, date ranges for each battle, number of casualties, and whether the battlefield has been preserved for visits today. These things could be indicated by Tooltip (for name of battle, campaign, and names of commanders), color code (for year), or symbol other than a disk (Stars and Bars for a Confederate victory and US flag for a Union victory--the bigger the flag, the more casualties inflicted--might have to be logarithmically scaled).

confederateFlag = 
 Interpreter["Image"][
  File[FindFile[
    "C:\\Users\\Glen\\Downloads\\Wolfram\\battle-flag-army-of-\
northern-virginia.jpg"]]]

GeoGraphics[{GeoMarker[
   Entity["City", {"Richmond", "Virginia", "UnitedStates"}], 
   confederateFlag]}]

enter image description here

But then, since a flag would be the symbol used in location, trying to color code it wouldn't make sense or look very good. Perhaps the Tooltip could be color coded for the year. As an example,

TooltipStyle -> {Background ->LightRed}

(However, since your Tooltip only shows up when you hover over the location, you'd lose the visual advantage of seeing a lot of information all over the map all at once.) What to do, what to do... Hmmm...

I'd plug it into your code myself for quick results, but the spreadsheet might need a little help first. Battlefields like Gettysburg, Richmond, and Atlanta will resort to their respective cities, but what about Gaines' Mill and Seven Pines? (I happen to know exactly where these latter two places are. Google Maps doesn't know.) Latitude and longitude coordinates might be necessary for viewing locations of battles. As a further example of the need for coordinates, the "Guide" tab in the spreadsheet explains that the Battle of Marietta, GA had four separate engagements at different places during a month-long period.

I'm sure with just a little more research, I can dig up all the coordinates I need. Well, coordinates for close to 400 listed battles might be more than a little research... I thought I'd give you heads up to see what ideas you had. I'll see what I can get to.

--Glen

POSTED BY: Glen Deering
Posted 10 years ago

I just saw this comment today! Wow thanks for the the information and the cool example you showed. I will be checking out the data file you posted this weekend and playing with it a bit to see if I can come up with a spin off like you suggested in your post. I will curate the data and re-post it a form that should be very easy to visualize - post a couple additional attempts/examples - and we can tackle it together.

POSTED BY: William Duhe
Posted 10 years ago

Excellent post, William!

Not only is it useful, but it was well-written (for long-time beginners like me who don't get their daily fill of Mathematica). I understood the purpose of every piece of syntax and function call due to your verbose explanations. Thanks!

If I get some time, I'd love to create some battlefield maps of the world and regions for the various wars throughout history. (Heck, one could even throw in the TimeLinePlot for completeness.) With a flexible "range" variable, one could program your SearchCItyFunction to allow viewing battle locations by war, theater, or region--and even be selective about which battles to show from which wars.

How about naval battles? Or sunken merchant ships? Or locations of discoveries in 20th century physics? Or the number of new fast food restaurants in a growing suburb in the last 15 years?

I'm not exactly sure where to get these data files, but I don't think it would be too hard to find. Your tool opens a world of possible diversions. Good job, and thanks for sharing!

POSTED BY: Glen Deering
Posted 10 years ago

Thank you for the compliments! If you know of anywhere that has databases that would include the information you would like to use please feel free to link it here and I can help you throw something together. I think it would be really cool to visualize maps of pertinent battles around the globe and be able to filter through them like you mentioned. I am also interested in creating some more real time visualizations for shifting through data sets more fluidly - and that would be a cool place to start.

POSTED BY: William Duhe

enter image description here - another post of yours has been selected for the Staff Picks group, congratulations !

We are happy to see you at the tops of the "Featured Contributor" board. Thank you for your wonderful contributions, and please keep them coming!

POSTED BY: EDITORIAL BOARD
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard