359
359
db[table].insert(
360
363
name = 'Incident',
362
365
db[table].insert(
364
marker_id = db(db.gis_marker.name=='shelter').select()[0].id,
370
marker_id = db(db.gis_marker.name=='office').select()[0].id,
379
marker_id = db(db.gis_marker.name=='airport').select()[0].id,
383
marker_id = db(db.gis_marker.name=='bridge').select()[0].id,
387
marker_id = db(db.gis_marker.name=='port').select()[0].id,
390
366
name = 'Hospital',
391
367
marker_id = db(db.gis_marker.name=='hospital').select()[0].id,
395
marker_id = db(db.gis_marker.name=='church').select()[0].id,
399
marker_id = db(db.gis_marker.name=='school').select()[0].id,
403
marker_id = db(db.gis_marker.name=='food').select()[0].id,
407
marker_id = db(db.gis_marker.name=='water').select()[0].id,
411
marker_id = db(db.gis_marker.name=='phone').select()[0].id,
371
# marker_id = db(db.gis_marker.name=='shelter').select()[0].id,
373
# resource = 'shelter'
377
# marker_id = db(db.gis_marker.name=='office').select()[0].id,
379
# resource = 'office'
382
# name = 'Warehouse',
386
# marker_id = db(db.gis_marker.name=='airport').select()[0].id,
390
# marker_id = db(db.gis_marker.name=='bridge').select()[0].id,
394
# marker_id = db(db.gis_marker.name=='port').select()[0].id,
399
# marker_id = db(db.gis_marker.name=='church').select()[0].id,
403
# marker_id = db(db.gis_marker.name=='school').select()[0].id,
407
# marker_id = db(db.gis_marker.name=='food').select()[0].id,
411
# marker_id = db(db.gis_marker.name=='water').select()[0].id,
415
# marker_id = db(db.gis_marker.name=='phone').select()[0].id,
414
418
table = 'gis_feature_group'
415
419
if not db(db[table].id).count():
447
451
# feature_class_id = db(db.gis_feature_class.name == 'Town').select()[0].id,
449
453
db[table].insert(
450
feature_group_id = db(db.gis_feature_group.name == 'Transport').select()[0].id,
451
feature_class_id = db(db.gis_feature_class.name == 'Airport').select()[0].id,
454
feature_group_id = db(db.gis_feature_group.name == 'Transport').select()[0].id,
455
feature_class_id = db(db.gis_feature_class.name == 'Bridge').select()[0].id,
458
feature_group_id = db(db.gis_feature_group.name == 'Transport').select()[0].id,
459
feature_class_id = db(db.gis_feature_class.name == 'Port').select()[0].id,
462
454
feature_group_id = db(db.gis_feature_group.name == 'Hospitals').select()[0].id,
463
455
feature_class_id = db(db.gis_feature_class.name == 'Hospital').select()[0].id,
466
feature_group_id = db(db.gis_feature_group.name == 'Infrastructure').select()[0].id,
467
feature_class_id = db(db.gis_feature_class.name == 'Church').select()[0].id,
470
feature_group_id = db(db.gis_feature_group.name == 'Infrastructure').select()[0].id,
471
feature_class_id = db(db.gis_feature_class.name == 'School').select()[0].id,
474
feature_group_id = db(db.gis_feature_group.name == 'Programme').select()[0].id,
475
feature_class_id = db(db.gis_feature_class.name == 'Food').select()[0].id,
478
feature_group_id = db(db.gis_feature_group.name == 'Programme').select()[0].id,
479
feature_class_id = db(db.gis_feature_class.name == 'Water').select()[0].id,
482
feature_group_id = db(db.gis_feature_group.name == 'Offices').select()[0].id,
483
feature_class_id = db(db.gis_feature_class.name == 'Office').select()[0].id,
486
feature_group_id = db(db.gis_feature_group.name == 'SMS Alerts').select()[0].id,
487
feature_class_id = db(db.gis_feature_class.name == 'SMS').select()[0].id,
459
# feature_group_id = db(db.gis_feature_group.name == 'Transport').select()[0].id,
460
# feature_class_id = db(db.gis_feature_class.name == 'Airport').select()[0].id,
463
# feature_group_id = db(db.gis_feature_group.name == 'Transport').select()[0].id,
464
# feature_class_id = db(db.gis_feature_class.name == 'Bridge').select()[0].id,
467
# feature_group_id = db(db.gis_feature_group.name == 'Transport').select()[0].id,
468
# feature_class_id = db(db.gis_feature_class.name == 'Port').select()[0].id,
471
# feature_group_id = db(db.gis_feature_group.name == 'Infrastructure').select()[0].id,
472
# feature_class_id = db(db.gis_feature_class.name == 'Church').select()[0].id,
475
# feature_group_id = db(db.gis_feature_group.name == 'Infrastructure').select()[0].id,
476
# feature_class_id = db(db.gis_feature_class.name == 'School').select()[0].id,
479
# feature_group_id = db(db.gis_feature_group.name == 'Programme').select()[0].id,
480
# feature_class_id = db(db.gis_feature_class.name == 'Food').select()[0].id,
483
# feature_group_id = db(db.gis_feature_group.name == 'Programme').select()[0].id,
484
# feature_class_id = db(db.gis_feature_class.name == 'Water').select()[0].id,
487
# feature_group_id = db(db.gis_feature_group.name == 'Offices').select()[0].id,
488
# feature_class_id = db(db.gis_feature_class.name == 'Office').select()[0].id,
491
# feature_group_id = db(db.gis_feature_group.name == 'SMS Alerts').select()[0].id,
492
# feature_class_id = db(db.gis_feature_class.name == 'SMS').select()[0].id,
489
494
table = 'gis_apikey'
490
495
if not db(db[table].id).count():
491
496
db[table].insert(