[postgis-users] Highlighting features in PostGIS/PgAdmin

[Shaozhong SHI]

Let's say that we have identified certain features and would like to draw
special attention of others to look at these features.

Highlighting or marking these features to stand out of the rest of features.

Regards,

David

On Tue, 1 Mar 2022 at 12:18, Marcin Mionskowski <mionskowskimarcin at gmail.com>
wrote:

> What do you mean by highlighting features in PostGIS?
> I don't know the pgAdmin. I use DBeaver. It displays objects on
> OpenStreetMap and other backgrounds. If you execute statement like:
> select id,geom,case when id=value then geom else null end geom2 from table;
> then you will get all your geometries in blue, and those selected in
> second column (geom2) in red. At least it works for me.
> *Glory to Ukraine!*
>
> wt., 1 mar 2022 o 12:34 Shaozhong SHI <shishaozhong at gmail.com> napisał(a):
>
>> Since PgAdmin has very limited visualisation capability, work arounds are
>> needed for highlighting features in PostGIS/PgAdmin.
>>
>> St_envelope can be used for putting a box around the features that need
>> to highlighed.
>>
>> Any other functions that can be used for highlighting features in PostGIS?
>>
>> Regards,
>>
>> David
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220301/2c0d7d73/attachment.html>