[postgis-users] Request for ideas to enhance the geometry viewer - GSoC

Simon Greener simon at spatialdbadvisor.com
Tue Jan 29 18:22:19 PST 2019

One needs context to answer this.

What is pgAdmin?

What is the purpose of the geometry visualisation extension within pgAdmin?

Is pgAdmin really the framework for developing a GIS?

I've been down this track with Tool (GeoRaptor within SQL Developer) vs GIS in the GeoRaptor project.

The GeoRaptor project which I was / am involved in , has reasonably powerful rendering capability based on out-of-the-box Java.
This was added to aid visualisation and interpretation of geometry results and structure.
I added almost all of the visualisation to it myself.
It was always clear that it was not a GIS (geoprocessing, editing, web mapping etc) but a visualisation tool mainly for developers.

On Wed, 30 Jan 2019 13:11:20 +1100, Paul Ramsey <pramsey at cleverelephant.ca> wrote:

> Yeah, every time I’ve thought about renderer-in-the-db I’ve come back to this. There’s nothing especially privileged about the db that makes a lot of >sense for bringing rendering in-process. And boy it’s a rat hole… once you go down, you’re never coming back out.
> P
>> On Jan 29, 2019, at 5:36 PM, Paolo Cavallini <cavallini at faunalia.it> wrote:
>> Are you sure you want to reimplement what a GIS does already? Doing proper, powerful styling it's a really big task.
>> Sorry to jump in like this, I'm a strong advocate of open source tools also because you can reuse what is available, avoiding duplication of efforts.
>> Cheers.
>> Il 30 gennaio 2019 02:13:50 CET, Martin Davis <mtnclimb at gmail.com> ha scritto:
>>> Here's an idea which might be a bit out there...  
>>> Allow styling/labelling to be driven by columns in the displayed query.  The styling columns would have well-known names which are unlikely to >>>conflict with data columns.  A nice pattern to follow is the SVG style names.  So e.g. styleStroke = line color, styleFill - fill color, >>>styleStrokeWidth = line width, etc etc etc.  styleLabel would be the string to label with.
>>> This allows styling to be data-driven and easily captured and shared.  
>>> On Mon, Jan 28, 2019 at 8:16 PM Victoria Rautenbach <victoria.rautenbach at gmail.com> wrote:
>>>> Dear PostGIS devs and users
>>>> Firstly, we (Frikan, Xuri and I) would like to thank the PostGIS
>>>> community again for the support you provided us in 2018 during Google
>>>> Summer of Code (GSoC). We truly appreciate your time and effort.
>>>> The call for OSGeo GSoC ideas is now out [1]. Frikan and I would like
>>>> to suggest a project to address some of the issues left in the
>>>> geometry viewer (available in pgAdmin4), but also include some new
>>>> functionality.
>>>> Are there any ideas or suggestions from you, the PostGIS community,
>>>> for extra functionalities that would improve the usefulness of the
>>>> geometry viewer?
>>>> Thank you in advance.
>>>> Regards
>>>> Victoria
>>>> [1] https://lists.osgeo.org/pipermail/soc/2019-January/004200.html
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users at lists.osgeo.org
>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>> --Sorry for being short_______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users

Spatial Advice & Solutions Architecture
Database Spatial Stored Procedure Designer
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE FME
Awarded "2011 Oracle Spatial Excellence Award for Education and Research"
A: 39 Cliff View Drive, Allens Rivulet, 7150, Tas, Aust
W: www.spdba.com.au
E: simon at spdba.com.au
V: +61 362 396 397
M: +61 418 396 391
GITC Supplier: T1005
Skype: sggreener
Long: 147.20515 (147° 12' 18" E)
Lat: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190130/90f7c7fb/attachment.html>

More information about the postgis-users mailing list