Re: [postgis-users] Highlighting features in PostGIS/PgAdmin

2022-03-01 Thread Alexandre Neto
Hi, Like someone said, pgadmin 4 has limited support to spatial visualisation. DBeaver is a bit better, but still not a tool to visualise and highlight spatial patterns or features. I would suggest you to use a GIS tool like QGIS to visualise the result of your queries. I used to use OpenJump fo

Re: [postgis-users] Highlighting features in PostGIS/PgAdmin

2022-03-01 Thread Shaozhong SHI
On Tue, 1 Mar 2022 at 18:02, Giuseppe Broccolo wrote: > Hi, > > On Tue, 1 Mar 2022, 12:55 Shaozhong SHI, wrote: > >> 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

Re: [postgis-users] Highlighting features in PostGIS/PgAdmin

2022-03-01 Thread Giuseppe Broccolo
Hi, On Tue, 1 Mar 2022, 12:55 Shaozhong SHI, wrote: > 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. > Can *ST_Buffer* (https://

Re: [postgis-users] Highlighting features in PostGIS/PgAdmin

2022-03-01 Thread 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 wrote: > What do you mea

Re: [postgis-users] Highlighting features in PostGIS/PgAdmin

2022-03-01 Thread Marcin Mionskowski
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

[postgis-users] Highlighting features in PostGIS/PgAdmin

2022-03-01 Thread Shaozhong SHI
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