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