<html><head></head><body><div dir="auto">Here are a few suggestions.<br><br></div>
<div dir="auto">1. Overlay queries.<br></div>
<div dir="auto">Agree with Regina.<br></div>
<div dir="auto">Currently I construct queries using UNION ALL to display other data (common SRID).<br></div>
<div dir="auto">If view can be shared between pgADMIN Query Tools then one could have unlimited number of layers in a single view.<br><br></div>
<div dir="auto">2. Colour/Style<br></div>
<div dir="auto">Would be nice to have different colour/style for layers esp when sharing them.<br><br></div>
<div dir="auto">3. Dynamic data<br></div>
<div dir="auto">I would be nice to be able to create points, lines and polygons by clicking on a map.<br></div>
<div dir="auto">Stored in clipboard using EWKT.<br></div>
<div dir="auto">These can then be used to create test queries<br><br></div>
<div dir="auto">4. Measurements<br></div>
<div dir="auto">Ability to measure distances and areas.<br><br></div>
<div dir="auto">HTH<br></div>
<div dir="auto">Simon<br></div>
<div dir="auto">On Wed, 30 Jan 2019 10:53:51 +1100, Regina Obe <lr@pcorp.us> wrote:<br><br></div>
<div dir="auto"> The call for OSGeo GSoC ideas is now out [1]. Frikan and I would like to<br></div>
<div dir="auto"> suggest a project to address some of the issues left in the geometry viewer<br></div>
<div dir="auto"> (available in pgAdmin4), but also include some new functionality.<br><br></div>
<div dir="auto"> Are there any ideas or suggestions from you, the PostGIS community, for<br></div>
<div dir="auto"> extra functionalities that would improve the usefulness of the geometry<br></div>
<div dir="auto"> viewer?<br><br></div>
<div dir="auto"> Thank you in advance.<br><br></div>
<div dir="auto"> Regards<br></div>
<div dir="auto"> Victoria<br><br><br></div>
<div dir="auto"> [1] <a href="https://lists.osgeo.org/pipermail/soc/2019-January/004200.html">https://lists.osgeo.org/pipermail/soc/2019-January/004200.html</a><br></div>
<div dir="auto"> [Regina Obe]<br><br></div>
<div dir="auto"> Victoria,<br></div>
<div dir="auto"> Much thanks to all the work you've done with GSoc. The viewer is pretty nice.<br></div>
<div dir="auto"> I think the only thing at the moment I feel missing is being able to over lay queries.<br></div>
<div dir="auto"> I'm not sure if pgAdmin has plumbing to easily allow that.<br><br></div>
<div dir="auto"> 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)<br><br></div>
<div dir="auto"> 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.<br><br></div>
<div dir="auto"> What would be really cool is if a replacement plugin could be put in place perhaps using shp2gpsql, pgsql2pgsql instead.<br></div>
<div dir="auto"> 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<br></div>
<div dir="auto"> Shp2pgsql / pgsql2shp command lines.<br><br></div>
<div dir="auto"> 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)<br></div>
<div dir="auto"> 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.<br><br></div>
<div dir="auto"> 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).<br><br><br></div>
<div dir="auto"> Thanks,<br></div>
<div dir="auto"> Regina<br></div>
<div class="gmail_quote" ><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="blue"><br></pre></blockquote></div></body></html>