In [1]:

    

%pylab notebook
import datetime as dt
import glob
import matplotlib.pyplot as plt
import matplotlib.dates as md
from charistools.hypsometry import Hypsometry
from charistools.meltModels import ImshowTriSurfMelt
from charistools.meltModels import PlotTriSurfInput
from charistools.meltModels import PlotTriSurfMelt
from charistools.modelEnv import ModelEnv
from charistools.timeSeries import TimeSeries
import pandas as pd
import re
import os


    

    




/Users/brodzik/.conda/envs/charis/lib/python2.7/site-packages/matplotlib/font_manager.py:273: UserWarning: Matplotlib is building the font cache using fc-list. This may take a moment.
  warnings.warn('Matplotlib is building the font cache using fc-list. This may take a moment.')






    




Populating the interactive namespace from numpy and matplotlib

In [2]:

    

%cd /Users/brodzik/projects/CHARIS/derived_hypsometries/MODSCAG_GF_v09/
#%ls


    

    




/Users/brodzik/projects/CHARIS/derived_hypsometries/MODSCAG_GF_v09
AM_OBJECTID100/            IN_v01_OBJECTID30/
AM_OBJECTID62/             IN_v01_OBJECTID31/
AM_OBJECTID64/             IN_v01_OBJECTID32/
AM_OBJECTID65/             IN_v01_OBJECTID33/
AM_OBJECTID66/             IN_v01_OBJECTID34/
AM_OBJECTID68/             IN_v01_OBJECTID36/
AM_OBJECTID69/             IN_v01_OBJECTID37/
AM_OBJECTID72/             IN_v01_OBJECTID39/
AM_OBJECTID77/             IN_v01_OBJECTID4/
AM_OBJECTID78/             IN_v01_OBJECTID44/
AM_OBJECTID79/             IN_v01_OBJECTID47/
AM_OBJECTID80/             IN_v01_OBJECTID48/
AM_OBJECTID81/             IN_v01_OBJECTID53/
AM_OBJECTID82/             IN_v01_OBJECTID56/
AM_OBJECTID83/             IN_v01_OBJECTID57/
AM_OBJECTID84/             IN_v01_OBJECTID58/
AM_OBJECTID85/             IN_v01_OBJECTID59/
AM_OBJECTID86/             IN_v01_OBJECTID6/
AM_OBJECTID88/             IN_v01_OBJECTID62/
AM_OBJECTID89/             IN_v01_OBJECTID63/
AM_OBJECTID90/             IN_v01_OBJECTID65/
AM_OBJECTID91/             IN_v01_OBJECTID7/
AM_OBJECTID93/             IN_v01_OBJECTID73/
AM_OBJECTID94/             IN_v01_OBJECTID8/
AM_OBJECTID97/             IN_v01_OBJECTID9/
AM_OBJECTID98/             SY_OBJECTID12/
AM_OBJECTID99/             SY_OBJECTID14/
AM_Vakhsh_at_Komsomolabad/ SY_OBJECTID16/
IN_Hunza_at_DainyorBridge/ SY_OBJECTID17/
IN_v01_OBJECTID0/          SY_OBJECTID29/
IN_v01_OBJECTID10/         SY_OBJECTID30/
IN_v01_OBJECTID11/         SY_OBJECTID40/
IN_v01_OBJECTID12/         SY_OBJECTID48/
IN_v01_OBJECTID13/         SY_OBJECTID49/
IN_v01_OBJECTID14/         SY_OBJECTID54/
IN_v01_OBJECTID17/         SY_OBJECTID55/
IN_v01_OBJECTID18/         SY_OBJECTID56/
IN_v01_OBJECTID19/         SY_OBJECTID57/
IN_v01_OBJECTID2/          SY_OBJECTID58/
IN_v01_OBJECTID20/         SY_OBJECTID59/
IN_v01_OBJECTID21/         SY_OBJECTID60/
IN_v01_OBJECTID23/         SY_OBJECTID61/
IN_v01_OBJECTID24/         SY_OBJECTID67/
IN_v01_OBJECTID25/         SY_OBJECTID70/
IN_v01_OBJECTID26/         SY_OBJECTID71/
IN_v01_OBJECTID27/         SY_OBJECTID73/
IN_v01_OBJECTID29/

In [3]:

    

# Generate a list of all OBJECTID basins
majorBasinID = 'IN_v01'
#majorBasinID = 'AM'
#majorBasinID = 'SY'
drainageIDs = glob.glob("%s_OBJECTID*" % majorBasinID)
drainageIDs.sort()
print("There are %d sub-basins for the %s major basin" % (len(drainageIDs), majorBasinID))


    

    




There are 43 sub-basins for the IN_v01 major basin

In [8]:

    

years = np.arange(14) + 2001
fig, ax = plt.subplots(len(years),1, figsize=(12,3*len(years)))
for j, year in enumerate(years):
    # For each basin, get the 3 tri-surf melt files
    for i, drainageID in enumerate(drainageIDs):
        solfile = glob.glob("%s/%s.%d.*snow_on_land_melt_by_elev*" % (drainageID, drainageID, year))
        soifile = glob.glob("%s/%s.%d.*snow_on_ice_melt_by_elev*" % (drainageID, drainageID, year))
        egifile = glob.glob("%s/%s.%d.*exposed_glacier_ice_melt_by_elev*" % (drainageID, drainageID, year))
        print(year, drainageID)
        SOLmelt = Hypsometry(filename=solfile[0])
        SOImelt = Hypsometry(filename=soifile[0])
        EGImelt = Hypsometry(filename=egifile[0])
        # If SOLmelt is non-empty, but SOImelt and SGImelt are empty,
        # then make a copy of the dimensions of SOLmelt that is filled with zeroes
        if not SOLmelt.data.empty and SOImelt.data.empty and EGImelt.data.empty:
            SOImelt.data = SOLmelt.data.copy()
            SOImelt.data[:] = 0.
            EGImelt.data = SOLmelt.data.copy()
            EGImelt.data[:] = 0.
        if i == 0:
            title = "Modelled melt for CHARIS basin %s %d sub-basins (%d)" % (
                majorBasinID, len(drainageIDs), year)
        else:
            title = None
        ax[j] = PlotTriSurfMelt(ax[j], SOLmelt, SOImelt, EGImelt, title=title, linewidth=0.5)
        handles, labels = ax[j].get_legend_handles_labels()
        ax[j].legend(handles[:4], labels[:4], loc='best')
        
fig.tight_layout()


    

    















    












    




(2001, 'IN_v01_OBJECTID0')
(2001, 'IN_v01_OBJECTID10')
(2001, 'IN_v01_OBJECTID11')
(2001, 'IN_v01_OBJECTID12')
(2001, 'IN_v01_OBJECTID13')
(2001, 'IN_v01_OBJECTID14')
(2001, 'IN_v01_OBJECTID17')
(2001, 'IN_v01_OBJECTID18')
(2001, 'IN_v01_OBJECTID19')
(2001, 'IN_v01_OBJECTID2')
(2001, 'IN_v01_OBJECTID20')
(2001, 'IN_v01_OBJECTID21')
(2001, 'IN_v01_OBJECTID23')
(2001, 'IN_v01_OBJECTID24')
(2001, 'IN_v01_OBJECTID25')
(2001, 'IN_v01_OBJECTID26')
(2001, 'IN_v01_OBJECTID27')
(2001, 'IN_v01_OBJECTID29')
(2001, 'IN_v01_OBJECTID30')
(2001, 'IN_v01_OBJECTID31')
(2001, 'IN_v01_OBJECTID32')
(2001, 'IN_v01_OBJECTID33')
(2001, 'IN_v01_OBJECTID34')
(2001, 'IN_v01_OBJECTID36')
(2001, 'IN_v01_OBJECTID37')
(2001, 'IN_v01_OBJECTID39')
(2001, 'IN_v01_OBJECTID4')
(2001, 'IN_v01_OBJECTID44')
(2001, 'IN_v01_OBJECTID47')
(2001, 'IN_v01_OBJECTID48')
(2001, 'IN_v01_OBJECTID53')
(2001, 'IN_v01_OBJECTID56')
(2001, 'IN_v01_OBJECTID57')
(2001, 'IN_v01_OBJECTID58')
(2001, 'IN_v01_OBJECTID59')
(2001, 'IN_v01_OBJECTID6')
(2001, 'IN_v01_OBJECTID62')
(2001, 'IN_v01_OBJECTID63')
(2001, 'IN_v01_OBJECTID65')
(2001, 'IN_v01_OBJECTID7')
(2001, 'IN_v01_OBJECTID73')
(2001, 'IN_v01_OBJECTID8')
(2001, 'IN_v01_OBJECTID9')
(2002, 'IN_v01_OBJECTID0')
(2002, 'IN_v01_OBJECTID10')
(2002, 'IN_v01_OBJECTID11')
(2002, 'IN_v01_OBJECTID12')
(2002, 'IN_v01_OBJECTID13')
(2002, 'IN_v01_OBJECTID14')
(2002, 'IN_v01_OBJECTID17')
(2002, 'IN_v01_OBJECTID18')
(2002, 'IN_v01_OBJECTID19')
(2002, 'IN_v01_OBJECTID2')
(2002, 'IN_v01_OBJECTID20')
(2002, 'IN_v01_OBJECTID21')
(2002, 'IN_v01_OBJECTID23')
(2002, 'IN_v01_OBJECTID24')
(2002, 'IN_v01_OBJECTID25')
(2002, 'IN_v01_OBJECTID26')
(2002, 'IN_v01_OBJECTID27')
(2002, 'IN_v01_OBJECTID29')
(2002, 'IN_v01_OBJECTID30')
(2002, 'IN_v01_OBJECTID31')
(2002, 'IN_v01_OBJECTID32')
(2002, 'IN_v01_OBJECTID33')
(2002, 'IN_v01_OBJECTID34')
(2002, 'IN_v01_OBJECTID36')
(2002, 'IN_v01_OBJECTID37')
(2002, 'IN_v01_OBJECTID39')
(2002, 'IN_v01_OBJECTID4')
(2002, 'IN_v01_OBJECTID44')
(2002, 'IN_v01_OBJECTID47')
(2002, 'IN_v01_OBJECTID48')
(2002, 'IN_v01_OBJECTID53')
(2002, 'IN_v01_OBJECTID56')
(2002, 'IN_v01_OBJECTID57')
(2002, 'IN_v01_OBJECTID58')
(2002, 'IN_v01_OBJECTID59')
(2002, 'IN_v01_OBJECTID6')
(2002, 'IN_v01_OBJECTID62')
(2002, 'IN_v01_OBJECTID63')
(2002, 'IN_v01_OBJECTID65')
(2002, 'IN_v01_OBJECTID7')
(2002, 'IN_v01_OBJECTID73')
(2002, 'IN_v01_OBJECTID8')
(2002, 'IN_v01_OBJECTID9')
(2003, 'IN_v01_OBJECTID0')
(2003, 'IN_v01_OBJECTID10')
(2003, 'IN_v01_OBJECTID11')
(2003, 'IN_v01_OBJECTID12')
(2003, 'IN_v01_OBJECTID13')
(2003, 'IN_v01_OBJECTID14')
(2003, 'IN_v01_OBJECTID17')
(2003, 'IN_v01_OBJECTID18')
(2003, 'IN_v01_OBJECTID19')
(2003, 'IN_v01_OBJECTID2')
(2003, 'IN_v01_OBJECTID20')
(2003, 'IN_v01_OBJECTID21')
(2003, 'IN_v01_OBJECTID23')
(2003, 'IN_v01_OBJECTID24')
(2003, 'IN_v01_OBJECTID25')
(2003, 'IN_v01_OBJECTID26')
(2003, 'IN_v01_OBJECTID27')
(2003, 'IN_v01_OBJECTID29')
(2003, 'IN_v01_OBJECTID30')
(2003, 'IN_v01_OBJECTID31')
(2003, 'IN_v01_OBJECTID32')
(2003, 'IN_v01_OBJECTID33')
(2003, 'IN_v01_OBJECTID34')
(2003, 'IN_v01_OBJECTID36')
(2003, 'IN_v01_OBJECTID37')
(2003, 'IN_v01_OBJECTID39')
(2003, 'IN_v01_OBJECTID4')
(2003, 'IN_v01_OBJECTID44')
(2003, 'IN_v01_OBJECTID47')
(2003, 'IN_v01_OBJECTID48')
(2003, 'IN_v01_OBJECTID53')
(2003, 'IN_v01_OBJECTID56')
(2003, 'IN_v01_OBJECTID57')
(2003, 'IN_v01_OBJECTID58')
(2003, 'IN_v01_OBJECTID59')
(2003, 'IN_v01_OBJECTID6')
(2003, 'IN_v01_OBJECTID62')
(2003, 'IN_v01_OBJECTID63')
(2003, 'IN_v01_OBJECTID65')
(2003, 'IN_v01_OBJECTID7')
(2003, 'IN_v01_OBJECTID73')
(2003, 'IN_v01_OBJECTID8')
(2003, 'IN_v01_OBJECTID9')
(2004, 'IN_v01_OBJECTID0')
(2004, 'IN_v01_OBJECTID10')
(2004, 'IN_v01_OBJECTID11')
(2004, 'IN_v01_OBJECTID12')
(2004, 'IN_v01_OBJECTID13')
(2004, 'IN_v01_OBJECTID14')
(2004, 'IN_v01_OBJECTID17')
(2004, 'IN_v01_OBJECTID18')
(2004, 'IN_v01_OBJECTID19')
(2004, 'IN_v01_OBJECTID2')
(2004, 'IN_v01_OBJECTID20')
(2004, 'IN_v01_OBJECTID21')
(2004, 'IN_v01_OBJECTID23')
(2004, 'IN_v01_OBJECTID24')
(2004, 'IN_v01_OBJECTID25')
(2004, 'IN_v01_OBJECTID26')
(2004, 'IN_v01_OBJECTID27')
(2004, 'IN_v01_OBJECTID29')
(2004, 'IN_v01_OBJECTID30')
(2004, 'IN_v01_OBJECTID31')
(2004, 'IN_v01_OBJECTID32')
(2004, 'IN_v01_OBJECTID33')
(2004, 'IN_v01_OBJECTID34')
(2004, 'IN_v01_OBJECTID36')
(2004, 'IN_v01_OBJECTID37')
(2004, 'IN_v01_OBJECTID39')
(2004, 'IN_v01_OBJECTID4')
(2004, 'IN_v01_OBJECTID44')
(2004, 'IN_v01_OBJECTID47')
(2004, 'IN_v01_OBJECTID48')
(2004, 'IN_v01_OBJECTID53')
(2004, 'IN_v01_OBJECTID56')
(2004, 'IN_v01_OBJECTID57')
(2004, 'IN_v01_OBJECTID58')
(2004, 'IN_v01_OBJECTID59')
(2004, 'IN_v01_OBJECTID6')
(2004, 'IN_v01_OBJECTID62')
(2004, 'IN_v01_OBJECTID63')
(2004, 'IN_v01_OBJECTID65')
(2004, 'IN_v01_OBJECTID7')
(2004, 'IN_v01_OBJECTID73')
(2004, 'IN_v01_OBJECTID8')
(2004, 'IN_v01_OBJECTID9')
(2005, 'IN_v01_OBJECTID0')
(2005, 'IN_v01_OBJECTID10')
(2005, 'IN_v01_OBJECTID11')
(2005, 'IN_v01_OBJECTID12')
(2005, 'IN_v01_OBJECTID13')
(2005, 'IN_v01_OBJECTID14')
(2005, 'IN_v01_OBJECTID17')
(2005, 'IN_v01_OBJECTID18')
(2005, 'IN_v01_OBJECTID19')
(2005, 'IN_v01_OBJECTID2')
(2005, 'IN_v01_OBJECTID20')
(2005, 'IN_v01_OBJECTID21')
(2005, 'IN_v01_OBJECTID23')
(2005, 'IN_v01_OBJECTID24')
(2005, 'IN_v01_OBJECTID25')
(2005, 'IN_v01_OBJECTID26')
(2005, 'IN_v01_OBJECTID27')
(2005, 'IN_v01_OBJECTID29')
(2005, 'IN_v01_OBJECTID30')
(2005, 'IN_v01_OBJECTID31')
(2005, 'IN_v01_OBJECTID32')
(2005, 'IN_v01_OBJECTID33')
(2005, 'IN_v01_OBJECTID34')
(2005, 'IN_v01_OBJECTID36')
(2005, 'IN_v01_OBJECTID37')
(2005, 'IN_v01_OBJECTID39')
(2005, 'IN_v01_OBJECTID4')
(2005, 'IN_v01_OBJECTID44')
(2005, 'IN_v01_OBJECTID47')
(2005, 'IN_v01_OBJECTID48')
(2005, 'IN_v01_OBJECTID53')
(2005, 'IN_v01_OBJECTID56')
(2005, 'IN_v01_OBJECTID57')
(2005, 'IN_v01_OBJECTID58')
(2005, 'IN_v01_OBJECTID59')
(2005, 'IN_v01_OBJECTID6')
(2005, 'IN_v01_OBJECTID62')
(2005, 'IN_v01_OBJECTID63')
(2005, 'IN_v01_OBJECTID65')
(2005, 'IN_v01_OBJECTID7')
(2005, 'IN_v01_OBJECTID73')
(2005, 'IN_v01_OBJECTID8')
(2005, 'IN_v01_OBJECTID9')
(2006, 'IN_v01_OBJECTID0')
(2006, 'IN_v01_OBJECTID10')
(2006, 'IN_v01_OBJECTID11')
(2006, 'IN_v01_OBJECTID12')
(2006, 'IN_v01_OBJECTID13')
(2006, 'IN_v01_OBJECTID14')
(2006, 'IN_v01_OBJECTID17')
(2006, 'IN_v01_OBJECTID18')
(2006, 'IN_v01_OBJECTID19')
(2006, 'IN_v01_OBJECTID2')
(2006, 'IN_v01_OBJECTID20')
(2006, 'IN_v01_OBJECTID21')
(2006, 'IN_v01_OBJECTID23')
(2006, 'IN_v01_OBJECTID24')
(2006, 'IN_v01_OBJECTID25')
(2006, 'IN_v01_OBJECTID26')
(2006, 'IN_v01_OBJECTID27')
(2006, 'IN_v01_OBJECTID29')
(2006, 'IN_v01_OBJECTID30')
(2006, 'IN_v01_OBJECTID31')
(2006, 'IN_v01_OBJECTID32')
(2006, 'IN_v01_OBJECTID33')
(2006, 'IN_v01_OBJECTID34')
(2006, 'IN_v01_OBJECTID36')
(2006, 'IN_v01_OBJECTID37')
(2006, 'IN_v01_OBJECTID39')
(2006, 'IN_v01_OBJECTID4')
(2006, 'IN_v01_OBJECTID44')
(2006, 'IN_v01_OBJECTID47')
(2006, 'IN_v01_OBJECTID48')
(2006, 'IN_v01_OBJECTID53')
(2006, 'IN_v01_OBJECTID56')
(2006, 'IN_v01_OBJECTID57')
(2006, 'IN_v01_OBJECTID58')
(2006, 'IN_v01_OBJECTID59')
(2006, 'IN_v01_OBJECTID6')
(2006, 'IN_v01_OBJECTID62')
(2006, 'IN_v01_OBJECTID63')
(2006, 'IN_v01_OBJECTID65')
(2006, 'IN_v01_OBJECTID7')
(2006, 'IN_v01_OBJECTID73')
(2006, 'IN_v01_OBJECTID8')
(2006, 'IN_v01_OBJECTID9')
(2007, 'IN_v01_OBJECTID0')
(2007, 'IN_v01_OBJECTID10')
(2007, 'IN_v01_OBJECTID11')
(2007, 'IN_v01_OBJECTID12')
(2007, 'IN_v01_OBJECTID13')
(2007, 'IN_v01_OBJECTID14')
(2007, 'IN_v01_OBJECTID17')
(2007, 'IN_v01_OBJECTID18')
(2007, 'IN_v01_OBJECTID19')
(2007, 'IN_v01_OBJECTID2')
(2007, 'IN_v01_OBJECTID20')
(2007, 'IN_v01_OBJECTID21')
(2007, 'IN_v01_OBJECTID23')
(2007, 'IN_v01_OBJECTID24')
(2007, 'IN_v01_OBJECTID25')
(2007, 'IN_v01_OBJECTID26')
(2007, 'IN_v01_OBJECTID27')
(2007, 'IN_v01_OBJECTID29')
(2007, 'IN_v01_OBJECTID30')
(2007, 'IN_v01_OBJECTID31')
(2007, 'IN_v01_OBJECTID32')
(2007, 'IN_v01_OBJECTID33')
(2007, 'IN_v01_OBJECTID34')
(2007, 'IN_v01_OBJECTID36')
(2007, 'IN_v01_OBJECTID37')
(2007, 'IN_v01_OBJECTID39')
(2007, 'IN_v01_OBJECTID4')
(2007, 'IN_v01_OBJECTID44')
(2007, 'IN_v01_OBJECTID47')
(2007, 'IN_v01_OBJECTID48')
(2007, 'IN_v01_OBJECTID53')
(2007, 'IN_v01_OBJECTID56')
(2007, 'IN_v01_OBJECTID57')
(2007, 'IN_v01_OBJECTID58')
(2007, 'IN_v01_OBJECTID59')
(2007, 'IN_v01_OBJECTID6')
(2007, 'IN_v01_OBJECTID62')
(2007, 'IN_v01_OBJECTID63')
(2007, 'IN_v01_OBJECTID65')
(2007, 'IN_v01_OBJECTID7')
(2007, 'IN_v01_OBJECTID73')
(2007, 'IN_v01_OBJECTID8')
(2007, 'IN_v01_OBJECTID9')
(2008, 'IN_v01_OBJECTID0')
(2008, 'IN_v01_OBJECTID10')
(2008, 'IN_v01_OBJECTID11')
(2008, 'IN_v01_OBJECTID12')
(2008, 'IN_v01_OBJECTID13')
(2008, 'IN_v01_OBJECTID14')
(2008, 'IN_v01_OBJECTID17')
(2008, 'IN_v01_OBJECTID18')
(2008, 'IN_v01_OBJECTID19')
(2008, 'IN_v01_OBJECTID2')
(2008, 'IN_v01_OBJECTID20')
(2008, 'IN_v01_OBJECTID21')
(2008, 'IN_v01_OBJECTID23')
(2008, 'IN_v01_OBJECTID24')
(2008, 'IN_v01_OBJECTID25')
(2008, 'IN_v01_OBJECTID26')
(2008, 'IN_v01_OBJECTID27')
(2008, 'IN_v01_OBJECTID29')
(2008, 'IN_v01_OBJECTID30')
(2008, 'IN_v01_OBJECTID31')
(2008, 'IN_v01_OBJECTID32')
(2008, 'IN_v01_OBJECTID33')
(2008, 'IN_v01_OBJECTID34')
(2008, 'IN_v01_OBJECTID36')
(2008, 'IN_v01_OBJECTID37')
(2008, 'IN_v01_OBJECTID39')
(2008, 'IN_v01_OBJECTID4')
(2008, 'IN_v01_OBJECTID44')
(2008, 'IN_v01_OBJECTID47')
(2008, 'IN_v01_OBJECTID48')
(2008, 'IN_v01_OBJECTID53')
(2008, 'IN_v01_OBJECTID56')
(2008, 'IN_v01_OBJECTID57')
(2008, 'IN_v01_OBJECTID58')
(2008, 'IN_v01_OBJECTID59')
(2008, 'IN_v01_OBJECTID6')
(2008, 'IN_v01_OBJECTID62')
(2008, 'IN_v01_OBJECTID63')
(2008, 'IN_v01_OBJECTID65')
(2008, 'IN_v01_OBJECTID7')
(2008, 'IN_v01_OBJECTID73')
(2008, 'IN_v01_OBJECTID8')
(2008, 'IN_v01_OBJECTID9')
(2009, 'IN_v01_OBJECTID0')
(2009, 'IN_v01_OBJECTID10')
(2009, 'IN_v01_OBJECTID11')
(2009, 'IN_v01_OBJECTID12')
(2009, 'IN_v01_OBJECTID13')
(2009, 'IN_v01_OBJECTID14')
(2009, 'IN_v01_OBJECTID17')
(2009, 'IN_v01_OBJECTID18')
(2009, 'IN_v01_OBJECTID19')
(2009, 'IN_v01_OBJECTID2')
(2009, 'IN_v01_OBJECTID20')
(2009, 'IN_v01_OBJECTID21')
(2009, 'IN_v01_OBJECTID23')
(2009, 'IN_v01_OBJECTID24')
(2009, 'IN_v01_OBJECTID25')
(2009, 'IN_v01_OBJECTID26')
(2009, 'IN_v01_OBJECTID27')
(2009, 'IN_v01_OBJECTID29')
(2009, 'IN_v01_OBJECTID30')
(2009, 'IN_v01_OBJECTID31')
(2009, 'IN_v01_OBJECTID32')
(2009, 'IN_v01_OBJECTID33')
(2009, 'IN_v01_OBJECTID34')
(2009, 'IN_v01_OBJECTID36')
(2009, 'IN_v01_OBJECTID37')
(2009, 'IN_v01_OBJECTID39')
(2009, 'IN_v01_OBJECTID4')
(2009, 'IN_v01_OBJECTID44')
(2009, 'IN_v01_OBJECTID47')
(2009, 'IN_v01_OBJECTID48')
(2009, 'IN_v01_OBJECTID53')
(2009, 'IN_v01_OBJECTID56')
(2009, 'IN_v01_OBJECTID57')
(2009, 'IN_v01_OBJECTID58')
(2009, 'IN_v01_OBJECTID59')
(2009, 'IN_v01_OBJECTID6')
(2009, 'IN_v01_OBJECTID62')
(2009, 'IN_v01_OBJECTID63')
(2009, 'IN_v01_OBJECTID65')
(2009, 'IN_v01_OBJECTID7')
(2009, 'IN_v01_OBJECTID73')
(2009, 'IN_v01_OBJECTID8')
(2009, 'IN_v01_OBJECTID9')
(2010, 'IN_v01_OBJECTID0')
(2010, 'IN_v01_OBJECTID10')
(2010, 'IN_v01_OBJECTID11')
(2010, 'IN_v01_OBJECTID12')
(2010, 'IN_v01_OBJECTID13')
(2010, 'IN_v01_OBJECTID14')
(2010, 'IN_v01_OBJECTID17')
(2010, 'IN_v01_OBJECTID18')
(2010, 'IN_v01_OBJECTID19')
(2010, 'IN_v01_OBJECTID2')
(2010, 'IN_v01_OBJECTID20')
(2010, 'IN_v01_OBJECTID21')
(2010, 'IN_v01_OBJECTID23')
(2010, 'IN_v01_OBJECTID24')
(2010, 'IN_v01_OBJECTID25')
(2010, 'IN_v01_OBJECTID26')
(2010, 'IN_v01_OBJECTID27')
(2010, 'IN_v01_OBJECTID29')
(2010, 'IN_v01_OBJECTID30')
(2010, 'IN_v01_OBJECTID31')
(2010, 'IN_v01_OBJECTID32')
(2010, 'IN_v01_OBJECTID33')
(2010, 'IN_v01_OBJECTID34')
(2010, 'IN_v01_OBJECTID36')
(2010, 'IN_v01_OBJECTID37')
(2010, 'IN_v01_OBJECTID39')
(2010, 'IN_v01_OBJECTID4')
(2010, 'IN_v01_OBJECTID44')
(2010, 'IN_v01_OBJECTID47')
(2010, 'IN_v01_OBJECTID48')
(2010, 'IN_v01_OBJECTID53')
(2010, 'IN_v01_OBJECTID56')
(2010, 'IN_v01_OBJECTID57')
(2010, 'IN_v01_OBJECTID58')
(2010, 'IN_v01_OBJECTID59')
(2010, 'IN_v01_OBJECTID6')
(2010, 'IN_v01_OBJECTID62')
(2010, 'IN_v01_OBJECTID63')
(2010, 'IN_v01_OBJECTID65')
(2010, 'IN_v01_OBJECTID7')
(2010, 'IN_v01_OBJECTID73')
(2010, 'IN_v01_OBJECTID8')
(2010, 'IN_v01_OBJECTID9')
(2011, 'IN_v01_OBJECTID0')
(2011, 'IN_v01_OBJECTID10')
(2011, 'IN_v01_OBJECTID11')
(2011, 'IN_v01_OBJECTID12')
(2011, 'IN_v01_OBJECTID13')
(2011, 'IN_v01_OBJECTID14')
(2011, 'IN_v01_OBJECTID17')
(2011, 'IN_v01_OBJECTID18')
(2011, 'IN_v01_OBJECTID19')
(2011, 'IN_v01_OBJECTID2')
(2011, 'IN_v01_OBJECTID20')
(2011, 'IN_v01_OBJECTID21')
(2011, 'IN_v01_OBJECTID23')
(2011, 'IN_v01_OBJECTID24')
(2011, 'IN_v01_OBJECTID25')
(2011, 'IN_v01_OBJECTID26')
(2011, 'IN_v01_OBJECTID27')
(2011, 'IN_v01_OBJECTID29')
(2011, 'IN_v01_OBJECTID30')
(2011, 'IN_v01_OBJECTID31')
(2011, 'IN_v01_OBJECTID32')
(2011, 'IN_v01_OBJECTID33')
(2011, 'IN_v01_OBJECTID34')
(2011, 'IN_v01_OBJECTID36')
(2011, 'IN_v01_OBJECTID37')
(2011, 'IN_v01_OBJECTID39')
(2011, 'IN_v01_OBJECTID4')
(2011, 'IN_v01_OBJECTID44')
(2011, 'IN_v01_OBJECTID47')
(2011, 'IN_v01_OBJECTID48')
(2011, 'IN_v01_OBJECTID53')
(2011, 'IN_v01_OBJECTID56')
(2011, 'IN_v01_OBJECTID57')
(2011, 'IN_v01_OBJECTID58')
(2011, 'IN_v01_OBJECTID59')
(2011, 'IN_v01_OBJECTID6')
(2011, 'IN_v01_OBJECTID62')
(2011, 'IN_v01_OBJECTID63')
(2011, 'IN_v01_OBJECTID65')
(2011, 'IN_v01_OBJECTID7')
(2011, 'IN_v01_OBJECTID73')
(2011, 'IN_v01_OBJECTID8')
(2011, 'IN_v01_OBJECTID9')
(2012, 'IN_v01_OBJECTID0')
(2012, 'IN_v01_OBJECTID10')
(2012, 'IN_v01_OBJECTID11')
(2012, 'IN_v01_OBJECTID12')
(2012, 'IN_v01_OBJECTID13')
(2012, 'IN_v01_OBJECTID14')
(2012, 'IN_v01_OBJECTID17')
(2012, 'IN_v01_OBJECTID18')
(2012, 'IN_v01_OBJECTID19')
(2012, 'IN_v01_OBJECTID2')
(2012, 'IN_v01_OBJECTID20')
(2012, 'IN_v01_OBJECTID21')
(2012, 'IN_v01_OBJECTID23')
(2012, 'IN_v01_OBJECTID24')
(2012, 'IN_v01_OBJECTID25')
(2012, 'IN_v01_OBJECTID26')
(2012, 'IN_v01_OBJECTID27')
(2012, 'IN_v01_OBJECTID29')
(2012, 'IN_v01_OBJECTID30')
(2012, 'IN_v01_OBJECTID31')
(2012, 'IN_v01_OBJECTID32')
(2012, 'IN_v01_OBJECTID33')
(2012, 'IN_v01_OBJECTID34')
(2012, 'IN_v01_OBJECTID36')
(2012, 'IN_v01_OBJECTID37')
(2012, 'IN_v01_OBJECTID39')
(2012, 'IN_v01_OBJECTID4')
(2012, 'IN_v01_OBJECTID44')
(2012, 'IN_v01_OBJECTID47')
(2012, 'IN_v01_OBJECTID48')
(2012, 'IN_v01_OBJECTID53')
(2012, 'IN_v01_OBJECTID56')
(2012, 'IN_v01_OBJECTID57')
(2012, 'IN_v01_OBJECTID58')
(2012, 'IN_v01_OBJECTID59')
(2012, 'IN_v01_OBJECTID6')
(2012, 'IN_v01_OBJECTID62')
(2012, 'IN_v01_OBJECTID63')
(2012, 'IN_v01_OBJECTID65')
(2012, 'IN_v01_OBJECTID7')
(2012, 'IN_v01_OBJECTID73')
(2012, 'IN_v01_OBJECTID8')
(2012, 'IN_v01_OBJECTID9')
(2013, 'IN_v01_OBJECTID0')
(2013, 'IN_v01_OBJECTID10')
(2013, 'IN_v01_OBJECTID11')
(2013, 'IN_v01_OBJECTID12')
(2013, 'IN_v01_OBJECTID13')
(2013, 'IN_v01_OBJECTID14')
(2013, 'IN_v01_OBJECTID17')
(2013, 'IN_v01_OBJECTID18')
(2013, 'IN_v01_OBJECTID19')
(2013, 'IN_v01_OBJECTID2')
(2013, 'IN_v01_OBJECTID20')
(2013, 'IN_v01_OBJECTID21')
(2013, 'IN_v01_OBJECTID23')
(2013, 'IN_v01_OBJECTID24')
(2013, 'IN_v01_OBJECTID25')
(2013, 'IN_v01_OBJECTID26')
(2013, 'IN_v01_OBJECTID27')
(2013, 'IN_v01_OBJECTID29')
(2013, 'IN_v01_OBJECTID30')
(2013, 'IN_v01_OBJECTID31')
(2013, 'IN_v01_OBJECTID32')
(2013, 'IN_v01_OBJECTID33')
(2013, 'IN_v01_OBJECTID34')
(2013, 'IN_v01_OBJECTID36')
(2013, 'IN_v01_OBJECTID37')
(2013, 'IN_v01_OBJECTID39')
(2013, 'IN_v01_OBJECTID4')
(2013, 'IN_v01_OBJECTID44')
(2013, 'IN_v01_OBJECTID47')
(2013, 'IN_v01_OBJECTID48')
(2013, 'IN_v01_OBJECTID53')
(2013, 'IN_v01_OBJECTID56')
(2013, 'IN_v01_OBJECTID57')
(2013, 'IN_v01_OBJECTID58')
(2013, 'IN_v01_OBJECTID59')
(2013, 'IN_v01_OBJECTID6')
(2013, 'IN_v01_OBJECTID62')
(2013, 'IN_v01_OBJECTID63')
(2013, 'IN_v01_OBJECTID65')
(2013, 'IN_v01_OBJECTID7')
(2013, 'IN_v01_OBJECTID73')
(2013, 'IN_v01_OBJECTID8')
(2013, 'IN_v01_OBJECTID9')
(2014, 'IN_v01_OBJECTID0')
(2014, 'IN_v01_OBJECTID10')
(2014, 'IN_v01_OBJECTID11')
(2014, 'IN_v01_OBJECTID12')
(2014, 'IN_v01_OBJECTID13')
(2014, 'IN_v01_OBJECTID14')
(2014, 'IN_v01_OBJECTID17')
(2014, 'IN_v01_OBJECTID18')
(2014, 'IN_v01_OBJECTID19')
(2014, 'IN_v01_OBJECTID2')
(2014, 'IN_v01_OBJECTID20')
(2014, 'IN_v01_OBJECTID21')
(2014, 'IN_v01_OBJECTID23')
(2014, 'IN_v01_OBJECTID24')
(2014, 'IN_v01_OBJECTID25')
(2014, 'IN_v01_OBJECTID26')
(2014, 'IN_v01_OBJECTID27')
(2014, 'IN_v01_OBJECTID29')
(2014, 'IN_v01_OBJECTID30')
(2014, 'IN_v01_OBJECTID31')
(2014, 'IN_v01_OBJECTID32')
(2014, 'IN_v01_OBJECTID33')
(2014, 'IN_v01_OBJECTID34')
(2014, 'IN_v01_OBJECTID36')
(2014, 'IN_v01_OBJECTID37')
(2014, 'IN_v01_OBJECTID39')
(2014, 'IN_v01_OBJECTID4')
(2014, 'IN_v01_OBJECTID44')
(2014, 'IN_v01_OBJECTID47')
(2014, 'IN_v01_OBJECTID48')
(2014, 'IN_v01_OBJECTID53')
(2014, 'IN_v01_OBJECTID56')
(2014, 'IN_v01_OBJECTID57')
(2014, 'IN_v01_OBJECTID58')
(2014, 'IN_v01_OBJECTID59')
(2014, 'IN_v01_OBJECTID6')
(2014, 'IN_v01_OBJECTID62')
(2014, 'IN_v01_OBJECTID63')
(2014, 'IN_v01_OBJECTID65')
(2014, 'IN_v01_OBJECTID7')
(2014, 'IN_v01_OBJECTID73')
(2014, 'IN_v01_OBJECTID8')
(2014, 'IN_v01_OBJECTID9')

In [ ]: