Any map drawing utilities out there?

Please post here for questions and discussion about scenario design, art and sound modding and the game editor for WITP Admiral's Edition.

Moderators: wdolson, MOD_War-in-the-Pacific-Admirals-Edition

Post Reply
User avatar
richlove
Posts: 196
Joined: Fri May 01, 2009 6:50 pm

Any map drawing utilities out there?

Post by richlove »

I've spent a few months writing down locations of TK sightings in my current grand campaign, and I have about 200 or so entries of stuff like this:

- [ ] TK Nisshin Maru
- [ ] 88, 61 on 7/2
- [ ] 79, 67 on 7/7
- [ ] 91, 63 on 7/22
- [ ] 94, 57 on 9/16

What I'd like to do is be able to visualize that data on a map, ideally in an automated fashion, as a means of sniffing out the IJN convoy routes. Does anyone know of any tools that can do any part of that process, or is 'by hand' the best I can do? I'm hopiing someone has built a program that can take a list of map hexes and crank out a map w/ dots on it.... long shot, I know.
Thanks!
User avatar
topeverest
Posts: 3376
Joined: Wed Oct 17, 2007 1:47 am
Location: Houston, TX - USA

RE: Any map drawing utilities out there?

Post by topeverest »

Unaware of anything like that, but back before my tracker stopped working I believe there was a signal intel function and map that did some of what you may want to do.

If you are coding type, C++ can easily set up a grid and data table you can use for a map. In excel, you also could create a tab to hold the data (227 x 202). You need to put a little thought into the excel grid, because each 'cell' probably would have 3 columns (date, type, and description) and then you need a row for each entry that occurs in the hex. I'd probably use a data table and macro to place the data.

In any event, eminently doable in a variety of formats if you are handy, but not if you are not.
Andy M
User avatar
richlove
Posts: 196
Joined: Fri May 01, 2009 6:50 pm

RE: Any map drawing utilities out there?

Post by richlove »

Hmm, thanks. It's been a while since I've done any C++. Are you saying I can decorate an image from excel, or are you saying I can represent the map in excel?
User avatar
richlove
Posts: 196
Joined: Fri May 01, 2009 6:50 pm

RE: Any map drawing utilities out there?

Post by richlove »

Hmm, this little project finally flipped from frustrating to fun. More to come.
User avatar
richlove
Posts: 196
Joined: Fri May 01, 2009 6:50 pm

RE: Any map drawing utilities out there?

Post by richlove »

OK, here's what I've got so far. I'm not sure I'm going to keep working on this, but I'll certainly explain how I generated it later today:

Image
Attachments
plottings.jpg
plottings.jpg (83.25 KiB) Viewed 122 times
User avatar
richlove
Posts: 196
Joined: Fri May 01, 2009 6:50 pm

RE: Any map drawing utilities out there?

Post by richlove »

The first thing you want to do is to capture the data you want to graphically represent. I use OmniOutliner for everything, which is a Mac program. See attached.

One thing to note is that if you actually want to do this, you should store the data in such a way as to immediately feed it into the next step. I spent a very boring 20 minutes transforming it into the x,y grid locations you see in the spreadsheet in the image. Were I to do this again, I would probably enter TK sightings directly into a spreadsheet. I occasionally re-observe TKs, so I sometimes try to plot out their routes, but in 9/42, that data is sparse.

Image
Attachments
graff.jpg
graff.jpg (128.6 KiB) Viewed 121 times
User avatar
richlove
Posts: 196
Joined: Fri May 01, 2009 6:50 pm

RE: Any map drawing utilities out there?

Post by richlove »

Next step is to find an image manipulation program and a good map image. I used ImageMagick (visible here) because it had a command line interface. I used the MapRev1024.bmp included in the game. Next time I'll use one of the 45MB planning map files.

Then you need to figure out how to turn your x,y coordinates into pixel coordinates to draw onto the map. Using essentially hunt and peck circle drawing, I figured out the following mapping:

Code: Select all

 Diamond Harbor
 Hex 52, 38 on the map corresponds to a circle drawn at this pixel on the image: 
 --> 278, 168 
 
 Rabaul 
 Hex 106, 125 on the map corresponds to a circle drawn at this pixel on the image: 
 --> 478,457
 
 Pearl Harbor 
 Hex 180, 107 on the map corresponds to a circle drawn at this pixel on the image: 
 --> 749, 398
 

For the record, the command to draw a dot using ImageMagick is:

Code: Select all

 convert MapRev1024.bmp -fill red -draw "circle 749,398 750,399"
 
That draws a circle on 749,398, which is PH on the image.
User avatar
richlove
Posts: 196
Joined: Fri May 01, 2009 6:50 pm

RE: Any map drawing utilities out there?

Post by richlove »

Next step: translate your x,y coordinates to pixel coordinates for your drawing program. If you look at the comment above, you see I plotted three pairs of "grid coordinates --> pixel coordinates". If you assume that mapping is linear, you can ask Wolfram Alpha to figure out the translation formula visible here, and in the attached image. Using this formula (one for the horizontal and one for the vertical (the one shown)), you can have excel translate all your map hexes into pixel points.



Image
Attachments
wolf.jpg
wolf.jpg (86.35 KiB) Viewed 121 times
User avatar
richlove
Posts: 196
Joined: Fri May 01, 2009 6:50 pm

RE: Any map drawing utilities out there?

Post by richlove »

Penultimate step. Using excel, generate a huge command line command to generate your map. Take the generated commands, slap them into your CLI, and out comes the image w/ the little red dots I posted above.

SO: would I do this again? Maybe?

- The data collection is a pain, every turn
- I think it would take a LOOOONG time to amass enough data to have a really good sense for the standard TK routes.... and one routing switch destroys a lot of your work.
- You run the danger of reinforcing your biases. I'm seeing ships there because my subs are there; who's to say what other TKs are running around, unseen?

Anyway. A fun exercise even if I'm not sure I'd do it again.

Image
Attachments
asdfadf.jpg
asdfadf.jpg (286.77 KiB) Viewed 121 times
chemkid
Posts: 1238
Joined: Sat Dec 15, 2012 2:02 pm

RE: Any map drawing utilities out there?

Post by chemkid »

.
Dili
Posts: 4713
Joined: Fri Sep 10, 2004 4:33 pm

RE: Any map drawing utilities out there?

Post by Dili »

Yeah thanks for explanation.
tc464
Posts: 126
Joined: Fri Feb 27, 2004 4:33 pm
Location: Sodom on Potomac

RE: Any map drawing utilities out there?

Post by tc464 »

oops
User avatar
richlove
Posts: 196
Joined: Fri May 01, 2009 6:50 pm

RE: Any map drawing utilities out there?

Post by richlove »

One last example; here's a track of the 5th Division's known locations through my game (Malaya to Singapore to Toungoo to the Akyab area).

You could do this for each unit, but staring at this image, I'm not sure it's very useful. For sussing out convoy routes, maybe... but do you really need to know the movement history of every enemy LCU? I am starting to think that it's better to just know their current position. Maybe there's value in decorating a map w/ known big LCU locations, but I'm not convinced.


Image
Attachments
asdfads.jpg
asdfads.jpg (284.82 KiB) Viewed 121 times
Post Reply

Return to “Scenario Design and Modding”