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)']
示例#2
0
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"    
示例#3
0
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
示例#4
0
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()))
示例#5
0
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