old_contents: import sys
  import os
  import urllib2
  import datetime
  import time
  import psycopg2
  import pandas
  from subprocess import call, Popen
  
  # pull the 6 hr forecast track forecast from NHC  
  #os.system("wget http://www.srh.noaa.gov/ridge2/Precip/qpehourlyshape/latest/last_1_hours.tar.gz -O last_1_hours.tar.gz")
  #os.system("mv last_1_hours.tar.gz last_1_hours.tar")
  
  #os.system("tar xvf last_1_hours.tar")
  
  conn_string = "dbname='hamlethurricane' user=postgres port='5432' host='127.0.0.1' password='password'"
  
  print "Connecting to database..."
  
  try:
  	conn = psycopg2.connect(conn_string)
  except Exception as e:
  	print str(e)
  	sys.exit()
  
  print "Connected!\n"
  
  
  dataframe_cur = conn.cursor()
  
  dataframe_cur.execute("""Select * from hurricane_irene""")
  
  data = dataframe_cur.fetchall()
  
  colnames = [desc[0] for desc in dataframe_cur.description]
  
  dataframe = pandas.DataFrame(data)
  
  dataframe.columns = colnames
  
  print data
  print dataframe
  
  conn.commit()
  
  num_feat = len(data)
  
  range_feat =  range(num_feat)
  
  range_feat_strp = str(range_feat).strip('[]')
  
  range_feat_strp_v2 = range_feat_strp.split(',')
  
  test = ' ' 
  
  for data in range_feat:
  	test += ' ' + str(data)
  
  print test
  
  print range_feat_strp_v2
  
  bash_deconstruct = 'for i in 1 ' + test + ' ' + str(num_feat) + ' ; do pgsql2shp -f irene_$i.shp hamlethurricane "select * from hurricane_irene where id = $i"; done'
  
  print bash
  
  call(bash_deconstruct, shell = True) 
  
  print bash_deconstruct
  
  bash_reconstruct = 'for i in 1 ' + test + ' ' + str(num_feat) + ' ; do ogr2ogr -f "PostgreSQL" PG:"user=postgres dbname=hamlethurricane password=password" irene_$i.shp -t_srs EPSG:4326; done'
  
  print bash_reconstruct
  
  call(bash_reconstruct, shell = True)
  
  bash_rm='for i in 1 ' + test + ' ' + str(num_feat) + ' ; do sudo rm irene_$i.* ; done'
  
  call(bash_rm, shell = True)
  
  #os.system('pgsql2shp -f {}.shp -g geom -h 127.0.0.1 -u postgres -p 5432 -P password hamlethurricane "Select * from hurricane_irene where id =  "; done'
  
  
  #rint bash 
  
  #os.system(bash)
  
  #drop_cur.close()
  
  # hurricane_cur = conn.cursor() 
  
  # hurricane_cur.execute("""
  # create table roads_flooded_bunco as 
  # select
  # a.gid,
  # street_nam,
  # sum(b.globvalue),
  # a.geom
  # from conterlines_poly as a
  # inner join last_1hr_qpe as b 
  # on st_dwithin(a.geom::geometry(MULTIpolygon, 4326), b.wkb_geometry::geometry(point, 4326), 0.025)
  # group by a.gid, a.street_nam, a.geom;""")
  
  
  # conn.commit()
  
new_contents: import sys
  import os
  import urllib2
  import datetime
  import time
  import psycopg2
  import pandas
  from subprocess import call, Popen
  
  # pull the 6 hr forecast track forecast from NHC  
  #os.system("wget http://www.srh.noaa.gov/ridge2/Precip/qpehourlyshape/latest/last_1_hours.tar.gz -O last_1_hours.tar.gz")
  #os.system("mv last_1_hours.tar.gz last_1_hours.tar")
  
  #os.system("tar xvf last_1_hours.tar")
  
  conn_string = "dbname='hamlethurricane' user=postgres port='5432' host='127.0.0.1' password='password'"
  
  print "Connecting to database..."
  
  try:
  	conn = psycopg2.connect(conn_string)
  except Exception as e:
  	print str(e)
  	sys.exit()
  
  print "Connected!\n"
  
  
  dataframe_cur = conn.cursor()
  
  dataframe_cur.execute("""Select * from hurricane_katrina""")
  
  data = dataframe_cur.fetchall()
  
  colnames = [desc[0] for desc in dataframe_cur.description]
  
  dataframe = pandas.DataFrame(data)
  
  dataframe.columns = colnames
  
  print data
  print dataframe
  
  conn.commit()
  
  num_feat = len(data)
  
  range_feat =  range(num_feat)
  
  range_feat_strp = str(range_feat).strip('[]')
  
  range_feat_strp_v2 = range_feat_strp.split(',')
  
  test = ' ' 
  
  for data in range_feat:
  	test += ' ' + str(data)
  
  print test
  
  print range_feat_strp_v2
  
  bash_deconstruct = 'for i in 1 ' + test + ' ' + str(num_feat) + ' ; do pgsql2shp -f irene_$i.shp hamlethurricane "select * from hurricane_katrina where id = $i"; done'
  
  print bash
  
  call(bash_deconstruct, shell = True) 
  
  print bash_deconstruct
  
  bash_reconstruct = 'for i in 1 ' + test + ' ' + str(num_feat) + ' ; do ogr2ogr -f "PostgreSQL" PG:"user=postgres dbname=hamlethurricane password=password" katrina_$i.shp -t_srs EPSG:4326; done'
  
  print bash_reconstruct
  
  call(bash_reconstruct, shell = True)
  
  bash_rm='for i in 1 ' + test + ' ' + str(num_feat) + ' ; do sudo rm katrina_$i.* ; done'
  
  call(bash_rm, shell = True)
  
  
  #os.system(bash)
  
  #drop_cur.close()
  
  # hurricane_cur = conn.cursor() 
  
  # hurricane_cur.execute("""
  # create table roads_flooded_bunco as 
  # select
  # a.gid,
  # street_nam,
  # sum(b.globvalue),
  # a.geom
  # from conterlines_poly as a
  # inner join last_1hr_qpe as b 
  # on st_dwithin(a.geom::geometry(MULTIpolygon, 4326), b.wkb_geometry::geometry(point, 4326), 0.025)
  # group by a.gid, a.street_nam, a.geom;""")
  
  
  # conn.commit()
  
subject: Update model.py