Changes between Version 3 and Version 4 of GoogleSummerCode2022

Timestamp:

02/16/22 18:12:19 (3 years ago)

Author:

robe

Comment:

--

GoogleSummerCode2022

@@ -29 +29 @@
 **Idea 1: Augment pgAdmin to support importing and exporting shapefiles**
 
-''Expected outcome'': There should be a menu option in the pgAdmin browser tree whenever you right-click a database, table, or schema that allows you to import or export shapefiles.  The tool would use the shp2pgsql and pgsql2shp commandlines that are part of the PostGIS source code in much the same way the backup and restore data browse menu options
-built into pgAdmin utilizes pg_dump / pg_restore. 
+''Expected outcome'': 
+ 
+Import Feature:
 
-This is to replace in newer pgAdmin the shp2pgsql-gui plugin (which still exists but is standalone) that could be hosted as a plugin in pgAdmin3.  Here is a screen shot of what that looks like and what we are trying to achieve:
+1) There should be a menu option in the pgAdmin browser tree whenever you right-click a database, table, or schema that allows you to import or export Dbase/shapefiles. 
+2) The tool would use the shp2pgsql and pgsql2shp commandlines that are part of the PostGIS source code in much the same way the backup and restore data browse menu options
+built into pgAdmin utilizes pg_dump / pg_restore. It will look for the files in default runtime folder or user specified binary path.
 
--- IMPORT --
+3)  If a particular table is selected, it will give option to export as a Dbase/Shapefile or import (append to) (no need to ask for table aside from export/import path) or append to
+4) If no table is selected - it will pop up a list of tables (as show in export screenshot) and allow user to import a file as a table in currently selected schema.
+If no schema is selected it would load in the default schema.
+
+This is to replace in newer pgAdmin 4 6.5+ the shp2pgsql-gui plugin (which still exists but is standalone) that was hosted as a plugin in pgAdmin3.  Here is a screen shot of what the old guis looks like.  We want to achieve the same or similar functionality
+
+
+''Import''
+
 [[Image(postgis-qui-import-1.png)]]
 [[Image(postgis-qui-import-2.png)]]
 [[Image(postgis-qui-import-3.png)]]
 
--- EXPORT -- 
+
+
+''Export''
+
 [[Image(postgis-qui-export-1.png)]]
 [[Image(postgis-qui-export-2.png)]]
@@ -45 +59 @@
 
 
-''Skills required'': python, html, css, and javascript, ability to compile PostgreSQL code, ability to compile PostGIS code, ability to compile [https://git.postgresql.org/git/pgadmin4.git pgAdmin]
+''Skills required'': 
+
+python, html, css, and javascript, ability to compile PostgreSQL code, ability to compile PostGIS code, ability to compile [https://git.postgresql.org/git/pgadmin4.git pgAdmin]
  some familiarity with PostGIS, PostgreSQL, and pgAdmin is preferable