<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:DengXian;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:DengXian;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
text-align:justify;
text-justify:inter-ideograph;
font-size:10.5pt;
font-family:DengXian;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
.MsoChpDefault
{mso-style-type:export-only;}
/* Page Definitions */
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=ZH-CN link=blue vlink="#954F72"><div class=WordSection1><p class=MsoNormal> <span lang=EN-US>If you have started the work, I can help you. If you want to get a viewer right now, you can use QGIS, Grass GIS, Udig or use GeoServer and its layer previewer. The most urgent work I think is to rewrite functions to enable Postgres 9.6+’s parallel query feature (and for Postgres on Hadoop in the future).</span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Our company uses Postgres+PostGIS as the main spatial database, most of our products rely on them. It seems strange that a GISer complain about these things (pgAdmin4):</span></p><p class=MsoNormal><span lang=EN-US> No hint on invalid SQLs (version 2.1 is much better)</span></p><p class=MsoNormal><span lang=EN-US> Can not export query results(copy to)</span></p><p class=MsoNormal><span lang=EN-US> Can not import/export table data from/to text files(copy from/to)</span></p><p class=MsoNormal><span lang=EN-US> Can not backup/restore specified tables(pg_dump/pg_restore) </span></p><p class=MsoNormal><span lang=EN-US> No psql and shp2pgsql short cut </span></p><p class=MsoNormal><span lang=EN-US> A huge installer (150M+. PostgreSQL 9.5 with pgAdmin 3 is 60+M, PostgresSQL 10.3 with pgAdmin4 is 160+M)</span></p><p class=MsoNormal><span lang=EN-US> Starts slow (pgAdmin4.2 cost 30 seconds vs pgAdmin3 cost 5s)</span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>pgAdmin4 must change greately in the future or it will be a failure, I guess. May be an independent viewer is a good choice, but it must be small and smart.</span></p><p class=MsoNormal><span lang=EN-US style='font-size:12.0pt;font-family:SimSun'><o:p> </o:p></span></p><div style='mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='border:none;padding:0cm'><b>发件人<span lang=EN-US>: </span></b><span lang=EN-US><a href="mailto:xurigoong@gmail.com">Xuri Gong</a><br></span><b>发送时间<span lang=EN-US>: </span></b><span lang=EN-US>2018</span>年<span lang=EN-US>3</span>月<span lang=EN-US>21</span>日<span lang=EN-US> 22:19<br></span><b>收件人<span lang=EN-US>: </span></b><span lang=EN-US><a href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a><br></span><b>主题<span lang=EN-US>: </span></b><span lang=EN-US>[postgis-devel] [SoC] Proposal for geospatial data viewer inpgAdmin4 for PostGIS</span></p></div><p class=MsoNormal><span lang=EN-US style='font-size:12.0pt;font-family:SimSun'><o:p> </o:p></span></p><div><p class=MsoNormal align=left style='text-align:left'><span lang=EN-US>Hi,</span><span lang=EN-US style='font-size:12.0pt'><o:p></o:p></span></p><div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US>My name is Xuri Gong, undergraduate student in Peking University, Beijing, China. My project idea is to implement a geospatial data viewer for postGIS in pgAdmin4. Here is the draft of my proposal: <a href="https://docs.google.com/document/d/1MH54gIlQpbx56uVx5e_QNP4MWp9NoFdsCcWUFRGBESo/edit?usp=sharing">https://docs.google.com/document/d/1MH54gIlQpbx56uVx5e_QNP4MWp9NoFdsCcWUFRGBESo/edit?usp=sharing</a></span></p></div><div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US>It would be great if you could review it and provide your valuable feedback. You can comment directly on my proposal.</span></p></div><div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US>Regards,</span></p></div><div><p class=MsoNormal><span lang=EN-US>Xuri Gong</span></p></div></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:12.0pt;font-family:SimSun'><o:p> </o:p></span></p></div></body></html>