Changes between Version 34 and Version 35 of GeospatialDataViewerInPgAdmin4ForPostGIS_FinalReport


Ignore:
Timestamp:
08/12/18 20:08:15 (6 years ago)
Author:
xurigong
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • GeospatialDataViewerInPgAdmin4ForPostGIS_FinalReport

    v34 v35  
    1 = Final Report: Implement Geospatial Data Viewer in pgAdmin4 for PostGIG =
     1= Final Report: Implement Geospatial Data Viewer in pgAdmin4 for PostGIS =
    22
    33* **Title:** Implement Geospatial Data Viewer in pgAdmin4 for PostGIS
    … …  
    99* **Code Patch:** [https://trac.osgeo.org/postgis/raw-attachment/wiki/GeospatialDataViewerInPgAdmin4ForPostGIS_FinalReport/geometry_viewer.patch geometry_viewer.patch]
    1010* **Pull Request:** [https://www.postgresql.org/message-id/CAA7HE_fnAKtAqfzz2jNZGfYnB5BAcuSt_ZCsJ%2Be-nwFPDHCdxg%40mail.gmail.com Code patch has been sent]
     11
     12== Abstract
     13
    1114== Status Before GSoC
    1215
    13 [https://www.pgadmin.org/ pgAdmin] is the GUI management tool for PostgreSQL. The latest version pgAdmin4 is web-based and written in Python and jQuery with Bootstrap, using the Flask framework. But currently there is no geospatial data viewer in pgAdmin4-3.1, and external applications, such as QGIS are required if we want to  browser the data in a map. It’s not convenient for users to view geometries directly in pgAdmin4 “Data Output” table panel.
     16[https://www.pgadmin.org/ pgAdmin] is the GUI management tool for PostgreSQL. The latest version pgAdmin4 is web-based and written in Python and jQuery with Bootstrap, using the Flask framework. But currently there is no geospatial data viewer in pgAdmin4-3.1, and external applications, such as QGIS are required if we want to view the data on a map. The pgAdmin4 Data Output panel only allows the user to view the table with the encoded geometries in text format.
    1417
    15 == My Proposal And Work
     18== My Proposal and Work
    1619
    1720I propose to implement a geospatial data viewer in pgAdmin4 that will allow users to view the tables in a spatial database and the results of queries executed. With the viewer I intend to develop, users can directly view geospatial data on a map within the pgAdmin4 GUI.
    1821
    19 With the geometry viewer I have created, now users can view individual geometry as well as all the geometries in the map. They can also view the properties directly by clicking the geometry. Here are some screenshots:
     22With the geometry viewer I have created, users can now view individual geometry as well as all the geometries in the map. They can also view the properties of the geometries directly in the geometry viewer by clicking the specific geometry. Here are some screenshots:
    2023
    2124[[Image(https://trac.osgeo.org/postgis/raw-attachment/wiki/GeospatialDataViewerInPgAdmin4ForPostGIS_FinalReport/screen_1.png, 600px)]]
    … …  
    2528
    2629== Test
    27 Please test my code following instructions here:
     30Please test my code following the instructions below:
    28311. Download the [https://github.com/Gooong/pgadmin4/tree/geoviewer geoviewer branch].
    29322. Build and run pgAdmin4 following README.md in the repository.