def latlon2env(lat,lon): #print "<br>env=",BIL.lookupBIL(r'c:\data\worldclim\tmin4',lat,lon),"<br>" #print "lat[1]=",lat[1]," lon[0]=",lon[0] MAT=BIL.lookupBIL(r'./worldclim/bio1',lat,lon) TSD=BIL.lookupBIL(r'./worldclim/bio4',lat,lon) AnnTMin=BIL.lookupBIL(r'./worldclim/bio6',lat,lon) ANNPREC=BIL.lookupBIL(r'./worldclim/bio12',lat,lon) return [MAT,TSD,AnnTMin,ANNPREC],['MAT (C*10)','Tsd (C*100)','AnnTMin (C*10)','AnnPrecip (mm)']
db = MySQLdb.connect("localhost", "smaranh","Tudoite007","bien_web") cursr = db.cursor() #cursr.execute("select distinct family, species, latitude, longitude from observation where (observationType='plot' OR (observationType='specimen' and isCultivated=0)) and isGeovalid=1 and isNewWorld=1 and species ='Pinus caribaea';") cursr.execute(sql) result = cursr.fetchall() w = shapefile.Writer(shapefile.POINT) #w.field('Family') #w.field('Species') w.field('MAT (C*10)') w.field('Tsd (C*100)') w.field('AnnTMin (C*10)') w.field('AnnPrecip (mm)') w.field('Latitude') w.field('Longitude') for rec in result: w.point(rec[3],rec[2])#Longitude, Latitude lat=[];lon=[] lat.append(rec[2]);lon.append(rec[3]) lat=[float(i) for i in lat];lon=[float(i) for i in lon] MAT=BIL.lookupBIL(r'./worldclim/bio1',lat,lon) TSD=BIL.lookupBIL(r'./worldclim/bio4',lat,lon) AnnTMin=BIL.lookupBIL(r'./worldclim/bio6',lat,lon) ANNPREC=BIL.lookupBIL(r'./worldclim/bio12',lat,lon) #w.record(rec[0], rec[1], MAT[0], TSD[0], AnnTMin[0], ANNPREC[0], rec[2], rec[3]) w.record(MAT[0], TSD[0], AnnTMin[0], ANNPREC[0], rec[2], rec[3]) w.save(File_loc)#example:'./shapefile/test.shp' print "Shapefile Successfully created"
def displayLoc(): lt=[];lon=[] lt.append(request.query.get('lat', 0.0, type=float));lon.append(request.query.get('lon', 0.0, type=float)) MAT=BIL.lookupBIL(r'/var/www/geo/worldclim/bio1',lt,lon) MDR=BIL.lookupBIL(r'/var/www/geo/worldclim/bio2',lt,lon) Iso=BIL.lookupBIL(r'/var/www/geo/worldclim/bio3',lt,lon) TSD=BIL.lookupBIL(r'/var/www/geo/worldclim/bio4',lt,lon) MaxTWM=BIL.lookupBIL(r'/var/www/geo/worldclim/bio5',lt,lon) AnnTMin=BIL.lookupBIL(r'/var/www/geo/worldclim/bio6',lt,lon) TAR=BIL.lookupBIL(r'/var/www/geo/worldclim/bio7',lt,lon) MeanTWQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio8',lt,lon) MeanTDQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio9',lt,lon) MeanTWaQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio10',lt,lon) MeanTCQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio11',lt,lon) ANNPREC=BIL.lookupBIL(r'/var/www/geo/worldclim/bio12',lt,lon) PrecWM=BIL.lookupBIL(r'/var/www/geo/worldclim/bio13',lt,lon) PrecDM=BIL.lookupBIL(r'/var/www/geo/worldclim/bio14',lt,lon) PrecS=BIL.lookupBIL(r'/var/www/geo/worldclim/bio15',lt,lon) PrecWQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio16',lt,lon) PrecDQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio17',lt,lon) PrecWarmQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio18',lt,lon) PrecCQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio19',lt,lon) result = { "mat": MAT[0], "mdr": MDR[0], "iso": Iso[0], "tsd": TSD[0], "maxtwm": MaxTWM[0], "anntmin": AnnTMin[0], "tar": TAR[0], "meantwq": MeanTWQ[0], "meantdq": MeanTDQ[0], "meantwaq": MeanTWaQ[0], "meantcq": MeanTCQ[0], "annprec": ANNPREC[0], "precwm": PrecWM[0], "precdm": PrecDM[0], "precs": PrecS[0], "precwq": PrecWQ[0], "precdq": PrecDQ[0], "precwarmq": PrecWarmQ[0], "preccq": PrecCQ[0] } return result
def downlCSV(): lt=[];lon=[] lt.append(request.query.get('lat', 0.0, type=float));lon.append(request.query.get('lon', 0.0, type=float)) MAT=BIL.lookupBIL(r'/var/www/geo/worldclim/bio1',lt,lon) MDR=BIL.lookupBIL(r'/var/www/geo/worldclim/bio2',lt,lon) Iso=BIL.lookupBIL(r'/var/www/geo/worldclim/bio3',lt,lon) TSD=BIL.lookupBIL(r'/var/www/geo/worldclim/bio4',lt,lon) MaxTWM=BIL.lookupBIL(r'/var/www/geo/worldclim/bio5',lt,lon) AnnTMin=BIL.lookupBIL(r'/var/www/geo/worldclim/bio6',lt,lon) TAR=BIL.lookupBIL(r'/var/www/geo/worldclim/bio7',lt,lon) MeanTWQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio8',lt,lon) MeanTDQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio9',lt,lon) MeanTWaQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio10',lt,lon) MeanTCQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio11',lt,lon) ANNPREC=BIL.lookupBIL(r'/var/www/geo/worldclim/bio12',lt,lon) PrecWM=BIL.lookupBIL(r'/var/www/geo/worldclim/bio13',lt,lon) PrecDM=BIL.lookupBIL(r'/var/www/geo/worldclim/bio14',lt,lon) PrecS=BIL.lookupBIL(r'/var/www/geo/worldclim/bio15',lt,lon) PrecWQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio16',lt,lon) PrecDQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio17',lt,lon) PrecWarmQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio18',lt,lon) PrecCQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio19',lt,lon) result = { "mat": MAT[0], "mdr": MDR[0], "iso": Iso[0], "tsd": TSD[0], "maxtwm": MaxTWM[0], "anntmin": AnnTMin[0], "tar": TAR[0], "meantwq": MeanTWQ[0], "meantdq": MeanTDQ[0], "meantwaq": MeanTWaQ[0], "meantcq": MeanTCQ[0], "annprec": ANNPREC[0], "precwm": PrecWM[0], "precdm": PrecDM[0], "precs": PrecS[0], "precwq": PrecWQ[0], "precdq": PrecDQ[0], "precwarmq": PrecWarmQ[0], "preccq": PrecCQ[0] } response.content_type = 'text/csv' return '%s\n%s' % (','.join(result.keys()), ','.join(str(r) for r in result.values()))
def fetchGJson(): lt=[];lon=[] lt.append(request.query.get('lat', 0.0, type=float));lon.append(request.query.get('lon', 0.0, type=float)) MAT=BIL.lookupBIL(r'/var/www/geo/worldclim/bio1',lt,lon) MDR=BIL.lookupBIL(r'/var/www/geo/worldclim/bio2',lt,lon) Iso=BIL.lookupBIL(r'/var/www/geo/worldclim/bio3',lt,lon) TSD=BIL.lookupBIL(r'/var/www/geo/worldclim/bio4',lt,lon) MaxTWM=BIL.lookupBIL(r'/var/www/geo/worldclim/bio5',lt,lon) AnnTMin=BIL.lookupBIL(r'/var/www/geo/worldclim/bio6',lt,lon) TAR=BIL.lookupBIL(r'/var/www/geo/worldclim/bio7',lt,lon) MeanTWQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio8',lt,lon) MeanTDQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio9',lt,lon) MeanTWaQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio10',lt,lon) MeanTCQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio11',lt,lon) ANNPREC=BIL.lookupBIL(r'/var/www/geo/worldclim/bio12',lt,lon) PrecWM=BIL.lookupBIL(r'/var/www/geo/worldclim/bio13',lt,lon) PrecDM=BIL.lookupBIL(r'/var/www/geo/worldclim/bio14',lt,lon) PrecS=BIL.lookupBIL(r'/var/www/geo/worldclim/bio15',lt,lon) PrecWQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio16',lt,lon) PrecDQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio17',lt,lon) PrecWarmQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio18',lt,lon) PrecCQ=BIL.lookupBIL(r'/var/www/geo/worldclim/bio19',lt,lon) result = { "type":"FeatureCollection", "features":[ { "geometry":{ "type":"Point", "coordinates":[ lon[0], lt[0] ] }, "type":"Feature", "properties":{ "mat": MAT[0], "mdr": MDR[0], "iso": Iso[0], "tsd": TSD[0], "maxtwm": MaxTWM[0], "anntmin": AnnTMin[0], "tar": TAR[0], "meantwq": MeanTWQ[0], "meantdq": MeanTDQ[0], "meantwaq": MeanTWaQ[0], "meantcq": MeanTCQ[0], "annprec": ANNPREC[0], "precwm": PrecWM[0], "precdm": PrecDM[0], "precs": PrecS[0], "precwq": PrecWQ[0], "precdq": PrecDQ[0], "precwarmq": PrecWarmQ[0], "preccq": PrecCQ[0] }, "id":1 }] } return result