[postgis-users] Geometry Viewer in PgAdmin

ruvenml at beamerbrooks.com ruvenml at beamerbrooks.com
Wed Mar 9 09:45:24 PST 2022


Yet another reason to install QGIS is that it will read just about any 
GIS data format; the layer can then be saved as a shapefile which can be 
imported into PostGIS using the PostGIS Shapefile import tool.

Ruven Brooks

On 3/8/2022 9:59 PM, Brent Wood wrote:
> I'd also look as DBeaver, it has a free Community Edition and a nice 
> (but basic) geometry viewer for Postgis. Built in support for a good 
> set of backgrounds as well. Postgis columns are auto displayed as WKT 
> which I find useful.
>
> For a user (vs admin) of a Postgis DB I think DBeaver is nicer than 
> PgAdmin. It does primitive ERD's, which I don't think PgAdmin can do 
> yet, but that might have changed since I last looked...
>
> And you can access many other databases than just Postgres.
>
> But I agree with Ruven, if you want to do more that a casual perusal 
> of Postgis data, go QGIS.
>
>
> Brent Wood
>
>
> On Wednesday, March 9, 2022, 03:41:01 PM GMT+13, 
> ruvenml at beamerbrooks.com <ruvenml at beamerbrooks.com> wrote:
>
>
> Out of idle curiosity, I looked at Geometry Viewer.   It allows just 
> one data display layer so you can only look at one table/query at a 
> time. The style of the geometric objects is hard coded so you can't 
> change their color, background pattern, line style etc.   It does not 
> support color scales.  I can't think of any use case for which it 
> would be useful.
>
> I would strongly suggest using QGIS instead.  Not only does QGIS have 
> all of the capabilities missing from Geometry Viewer but it will read 
> directly from PostGIS tables.  Since it's so widely used there's lots 
> of documentation and other learning materials; I counted five 
> different Youtube beginner's tutorials.
>
> Ruven Brooks
>
>
>
> On 3/8/2022 5:02 AM, Shaozhong SHI wrote:
> Sometime, when clicking on the eye button in PgAdmin, Geometry Viewer 
> gets into a mode to display background map with options like Empty, 
> Street, Topography, Grey Scale, Light Colour and Dark Matter.
>
> I am interested in making use of visualisation within PgAmin.
>
> Are there any documentation or guides on how to make the best use of 
> these in PgAdmin?
>
> Regards,
>
> David
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org  <mailto:postgis-users at lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/postgis-users  <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/20220309/2d8511a7/attachment.html>


More information about the postgis-users mailing list