[Feature] Create Map repository in personnel system

[swomma]

As per request from 1Lt. Patterson we need a repository for maps from all games to be created in personnel system.

New table Table maps with fields:

• id
• map_name - name of the map
• game - which game it is on (Arma3, DH, RS) - if one map is on different games
• descriptions - text field with description of the map
• type - A/A, A/D
• style - (Training, Infantry, Combined Arms, Tank)
• teams - Germany/USSR, Germany/USA, Germany/Commonwealth, Japan/USA [any more?]
• size - Small, Medium or Large
• linearity - Linear / Non-linear
• notes

Pictures Also we'd need to include way to include and link with map record pictures:

• overhead map
• screenshot from the game

Coding

• api for data
• api/admin + permissions for Bn HQ, Co HQ, Engineers
• front-end: personnel/map with ability to filter upon most fields

[wilson29thid]

What will it be used for? Could a google spreadsheet suffice?

[Patty29th]

It will be a resource and tool for all drill leaders to review and compare maps.

With over 200 maps on DH and a growing number of maps in RO2/RS it is increasingly hard for drill leaders to remember maps and to put a name of a map to the mental image in their head.

This tool will have images displayed alongside map names / info and also have filters for all the variables T/4 Swom listed. Because of this it basically needs to be a database, and to have the filters / images it needs to be done through personnel afaik.

[Patty29th]

Actually Im learning a bit more of Google Spreadsheet and it looks like I can have filters and Images after all. Though I think it would be nice to have it under personnnel as it will look better and be more accesable, Google Spreadsheet is definatly an option.

[Patty29th]

Although Google spread sheet would technichally work it would be fairly unwieldly and not really achieve the desired effect.

It would basically be an edexcel page where I would have to download all the pics Pike put on his google drive, reupload them to an image hosting site. Embedd the links in the cells and have the other info next to it.

But if I did that it would look ugly, it would be unwieldly to edit, it would be outside of our website on my Google page and if the links changed on my image host (which happens alot) I would havve to redo it.

Id rather do it in house where we can tweak it to suit our needs and where we can build it into a usefull tool for 29th'ers. I think this project has alot of scope and 2 years down the line it could of grown to something even bigger: An Interactive data bank with all sorts of usefull information to augment what we already have on the wiki.

[Vlad29th]

We could have tags for maps, which would be major things on the map, for example Omaha beach could have the tags: Beach, Hill, Bunkers, Landings, Assault Crafts, etc.

[swomma]

DB structure for maps added