@@ -0,0 +1,485 @@
+from pandas.io.sql import read_sql%0Aimport psycopg2%0Apgconn = psycopg2.connect(database='postgis', host='localhost', port=5555)%0A%0Apd = read_sql(%22%22%22WITH data as (%0A  SELECT distinct wfo, extract(year from issue) as yr,%0A  phenomena, significance from warnings where issue %3E '2005-01-01' and%0A  significance is not null and phenomena is not null)%0A%0A  SELECT wfo, yr, count(*) from data GROUP by wfo, yr%22%22%22, pgconn)%0A%0Apd2 = pd.pivot_table(index=%5B'wfo'%5D, columns=%5B'yr'%5D)%0A%0Apd2.to_excel('dump.xls')%0A

add offline script to dump vtec counts