https://redmine.auroville.org.in/
https://redmine.auroville.org.in/favicon.ico
2022-04-26T11:51:18Z
Redmine
Geomatic studio models for Gisaf - Feature #13968: Create layers and all for the LB records
https://redmine.auroville.org.in/issues/13968?journal_id=108098
2022-04-26T11:51:18Z
Philippe May
<ul></ul><p>Updating the "cadastral" model file. In addition to that:</p>
<a name="Database"></a>
<h1 >Database<a href="#Database" class="wiki-anchor">¶</a></h1>
<p>Create schema (as postgres):</p>
<pre>
avgis=# create schema other_lb AUTHORIZATION avgis;
</pre>
<p>Copy table (as avgis):</p>
<pre>
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
</pre>
<p>Style</p>
<pre>
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]]}');
</pre>
<pre>
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]]}');
</pre>
Geomatic studio models for Gisaf - Feature #13968: Create layers and all for the LB records
https://redmine.auroville.org.in/issues/13968?journal_id=108178
2022-04-28T11:48:05Z
Philippe May
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Resolved</i></li></ul>