Updating the "cadastral" model file. In addition to that:

Database¶

Create schema (as postgres):

avgis=# create schema other_lb AUTHORIZATION avgis;

Copy table (as avgis):

avgis=> CREATE TABLE other_lb.cadastral_lb AS TABLE other_avf.cadastral_avf;
SELECT 10562
avgis=> CREATE TABLE other_lb.cadastral_lb_dissolved AS TABLE other_avf.cadastral_avf_dissolved ;
SELECT 587

Style

insert into gisaf_map.qml (model_name, mapbox_paint ) VALUES ( 'CadastralLB', '{"fill-outline-color": ["rgba", 80, 100, 100, 0.4], "fill-color": ["match", ["get", "class"], "AVF", ["rgba", 150, 220, 150, 0.6], "B-Memo-Av", ["rgba", 150, 200, 100, 0.4], "Puramboke", ["rgba", 80, 20, 160, 0.4], "Temple", ["rgba", 20, 80, 150, 0.4], "Govt-land", ["rgba", 20, 80, 150, 0.4], "AV-Long-term-lease", ["rgba", 200, 230, 100, 0.6], "Access", ["rgba", 200, 130, 100, 0.6], "Exchanged", ["rgba", 150, 220, 150, 0.2], "Sea-erosion", ["rgba", 150, 150, 20, 0.5], "Private", ["rgba", 200, 200, 200, 0.1], ["rgba", 200, 200, 200, 0.4]]}');

insert into gisaf_map.qml (model_name, mapbox_paint ) VALUES ( 'CadastralLBDissolved', '{"fill-outline-color": ["rgba", 80, 100, 100, 0.4], "fill-color": ["match", ["get", "class"], "AVF", ["rgba", 150, 220, 150, 0.6], "B-Memo-Av", ["rgba", 150, 200, 100, 0.4], "Puramboke", ["rgba", 80, 20, 160, 0.4], "Temple", ["rgba", 20, 80, 150, 0.4], "Govt-land", ["rgba", 20, 80, 150, 0.4], "AV-Long-term-lease", ["rgba", 200, 230, 100, 0.6], "Access", ["rgba", 200, 130, 100, 0.6], "Exchanged", ["rgba", 150, 220, 150, 0.2], "Sea-erosion", ["rgba", 150, 150, 20, 0.5], "Private", ["rgba", 200, 200, 200, 0.1], ["rgba", 200, 200, 200, 0.4]]}');