Some regular expressions that may help working with the tz database data
If performed in this order, it will convert +- to NSEW
search ^- replace S search ^+ replace N search - replace W search + replace E
If +- is converted to NSEW:
search ([NS])([0-9]{2})([0-9]{2})[0-9]{0,2}([EW])([0-9]{3})([0-9]{2})[0-9]{0,2} replace $2|$3|$1|$5|$6|$4 result: all entries will have DD|MM|NS|DDD|MM|EW format - needed by template:coord
Converted data might be stored at template:Time zone/coord