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.
HTH
Simon
On Wed, 30 Jan 2019 10:53:51 +1100, Regina Obe <l...@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@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
--
Regards
Simon
--------------------------------------------------------------------------------------------------------
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: si...@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
NAC:W80CK 7SWP3
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
