import ogr
import os
import glob

pj = '/Users/danielmsheehan/Desktop/data/'
#pj = '/Users/danielmsheehan/Dropbox/data_temp/'

csvList = glob.glob(pj+'tables/'+"*.csv")

x = []

for i in csvList:
    i = i.replace(pj+'tables/','').replace('.csv','')
    #print i
    x.append(i)

#print x
# z = x[:30]
# z = x[30:120]
# z = x[112:120]
# z = x[120:200]
# z = x[200:280]
# z = x[280:365]

# print z

for i in x:
    
    command1 = 'ogr2ogr -f CSV '+pj+'processing/d/d_'+i+'_int_cb2010.csv '+pj+'processing/d/d_'+i+'_wgs84_prj_int_cb2010.shp -lco GEOMETRY=AS_WKT'
    command2 = 'ogr2ogr -f CSV '+pj+'processing/p/p_'+i+'_int_cb2010.csv '+pj+'processing/p/p_'+i+'_wgs84_prj_int_cb2010.shp -lco GEOMETRY=AS_WKT'

    os.system(command1)
    os.system(command2)
    
    print i + ' is complete for pickup and dropoffs'