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

Tue Jan 29 17:25:16 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/style 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 <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

On 30 Jan. 2019, 12:01, at 12:01, Simon Greener <simon at spatialdbadvisor.com> wrote:
>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 <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
>
>
>-- 
>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: 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
>NAC:W80CK 7SWP3
>_______________________________________________
>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-devel/attachments/20190130/2c541c65/attachment.html>