<div dir="ltr"><div class="gmail_default" style="font-family:monospace"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b"><span>What do you mean by highlighting features in PostGIS?</span></span></span></div><div class="gmail_default" style="font-family:monospace"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b"><span>I don't know the pgAdmin. I use DBeaver.</span></span> <span class="gmail-JLqJ4b gmail-ChMk0b"><span>It displays objects on OpenStreetMap and other backgrounds. If you execute statement like:<br></span></span></span></div><div class="gmail_default" style="font-family:monospace"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b"><span></span></span></span></div><div class="gmail_default" style="font-family:monospace"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b"><span>select id,geom,case when id=value then geom else null end geom2 from table;</span></span></span></div><div class="gmail_default" style="font-family:monospace"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b"><span>then you will get all your geometries in blue, and those selected in second column (geom2) in red. At least it works for me.<br></span></span></span></div><div class="gmail_default" style="font-family:monospace"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b"><span><b>Glory to Ukraine!</b></span></span></span></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">wt., 1 mar 2022 o 12:34 Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com">shishaozhong@gmail.com</a>> napisał(a):<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Since PgAdmin has very limited visualisation capability, work arounds are needed for highlighting features in PostGIS/PgAdmin.<div><br></div><div>St_envelope can be used for putting a box around the features that need to highlighed.</div><div><br></div><div>Any other functions that can be used for highlighting features in PostGIS?</div><div><br></div><div>Regards,</div><div><br></div><div>David</div></div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote></div>