data munging to update guns.periscopic.com