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

Simon Greener simon at spatialdbadvisor.com
Tue Jan 29 17:00:13 PST 2019

Here are a few suggestions.

1. Overlay queries.
Agree with Regina.
Currently I construct queries using UNION ALL to display other data (common SRID).
If view can be shared between pgADMIN Query Tools then one could have unlimited number of layers in a single view.

2. Colour/Style
Would be nice to have different colour for layers esp when sharing them.

3. Dynamic data
I would be nice to be able to create points, lines and polygons by clicking on a map.
Stored in clipboard using EWKT.
These can then be used to create test queries

4. Measurements
Ability to measure distances and areas.

On Wed, 30 Jan 2019 10:53:51 +1100, Regina Obe <lr at pcorp.us> wrote:

>> 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
> [Regina Obe]
> Victoria,
> Much thanks to all the work you've done with GSoc.  The viewer is pretty nice.
> I think the only thing at the moment I feel missing is being able to over lay queries.
> I'm not sure if pgAdmin has plumbing to easily allow that.
> The other thing I had on my dream list -- not really a viewer thing, is having a loader plugin for pgAdmin4. (I thought I had this ticketed, but can't find it)
> Right now the gui loader/dumper we have shp2pgsql-gui doesn't hook into pgAdmin4 and as such I'm reducing its mention in the PostGIS in Action 3rd edition.
> What would be really cool is if a replacement plugin could be put in place perhaps using shp2gpsql, pgsql2pgsql instead.
> I think the pgAdmin4 piggy-backs on pg_dump and pg_restore for its backup/restore console, so was thinking maybe something similar could be done with the
> Shp2pgsql / pgsql2shp command lines.
> That would kill 2 birds too - because shp2pgsql-gui is not shipped with many distributions (only the Windows and I think Boundless (now Planet) (Mac) ship it)
> So we could in theory scrap shp2gpsql-gui if we build the gui into pgAdmin4, and would allow more newbies (not running windows or mac) to be able to use a gui loader/dumper.
> In addition, if we are successful with that, I think we may able to reuse similar logic to build an ogr2ogr gui into pgAdmin4.  Since a lot of folks have GDAL installed in their local desktop they would be able to leverage this as well.  Thus solving some other annoying problem we have of not being able to import or export other formats (using a gui).
> Thanks,
> Regina
> _______________________________________________
> 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

More information about the postgis-users mailing list