def get_datas(sids, siteCols, siteLayer, nearLayers):
ds = DataSource(dbinfo)
ds._connect()
datas = {}
for sid in sids:
sitesql = getInfo(siteLayer, siteCols, sid)
datas[sid] = {}
datas[sid][siteLayer] = dict(zip(siteCols, *ds._run(sitesql)))
for layer in nearLayers:
cols = nearLayers[layer]['cols']
sql = nearest( siteLayer, layer, 1000, sid, cols )
data = ds._run(sql)
if len(data) > 0:
vals = data[0]
else:
vals = []
datas[sid][layer] = dict(zip(cols, vals))
ds._close()
return datas
def get_datas(sids, siteCols, siteLayer, nearLayers):
ds = DataSource(dbinfo)
ds._connect()
datas = {}
for sid in sids:
sitesql = getInfo(siteLayer, siteCols, sid)
datas[sid] = {}
datas[sid][siteLayer] = dict(zip(siteCols, *ds._run(sitesql)))
for layer in nearLayers:
cols = nearLayers[layer]["cols"]
sql = nearest(siteLayer, layer, 1000, sid, cols)
data = ds._run(sql)
if len(data) > 0:
vals = data[0]
else:
vals = []
datas[sid][layer] = dict(zip(cols, vals))
ds._close()
return datas
