/
loadAmigosData.py
executable file
·72 lines (60 loc) · 1.98 KB
/
loadAmigosData.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
import json
from amigos_layers import *
from postsites import loadFromXlsConfigurationFile, DataSource
from postsites import makeXlsConfigurationFile
from postsites.configure import dbinfo
from site_ids import ids
def readFolder():
folder = 'C:\\Users\\demonchaux\\Dropbox\\Amigos De Los Rios\\Our Maps\\Parcel'
#folder = "C:\\Users\\demonchaux\\Dropbox\\Amigos De Los Rios\\Data June 7th"
#folder = "C:\\Users\\demonchaux\\Dropbox\\Amigos De Los Rios"
config_file = makeXlsConfigurationFile(folder, 'parcels.xls')
print config_file
def loadXls():
# load everything in
xlsFile = 'parcels.xls'
ds, results = loadFromXlsConfigurationFile( xlsFile, dbinfo, verbose=True, skipfailures=True)
print results
#print '\n'.join(results)
print '\n'.join([lay.name for lay in ds.config.layers])
def seeLayers():
ds = DataSource( dbinfo )
ds.viewLayers('layers.py')
def loadWithColumns(site_id):
#sites.update(micro)
#sites.update(stormdrains)
#sites.update(sewers)
#sites.update(publictransportation)
sites.update(basins)
#sites.update(billboards)
sites.update(hydro)
#sites.update(roads)
ds = DataSource(dbinfo)
ds.loadLayerDict(sites)
ds.config.setSiteLayer('proposed_sites')
#ds.config.setTerrainLayer('tin_pts')
#ds.config.terrainLayer.zColumn = 'elevation'
ds.config.siteRadius = 1000
return ds.getSiteJson( site_id )
def createJsonFiles(idList):
froot = 'C:\\amigos\\dump\\%s-site.json'
for id in idList:
print "loading site %s" % id
try:
json = ds.loadWithColumns
except:
print "error loading %s" % id
fpath = froot % id
f = open(fpath, 'w')
f.write(json)
f.close()
print "Successfully wrote %s" % fpath
print done
if __name__=='__main__':
import sys
siteId = sys.argv[1]
siteJson = loadWithColumns(siteId)
print siteJson
#idList = range(20)
#createJsonFiles(idList)
#seeLayers()