[postgis-devel] [SoC]Week 10 Report - Implement Geospatial Data Viewer in pgAdmin4 for PostGIS

Mon Jul 30 22:33:49 PDT 2018

Thank you for your suggestions.

I have added the functionality to show the whole result as well as
feature's properties in a new version and will send the patch soon. Here
are the new screenshots: https://photos.app.goo.gl/HwKHMHfzuRMhGC5C6

As for the OSM tile layer, currently it would be added to the map only if
the geometry's SRID is 4326. There would be no tile layer for geometries
with other SRIDs because the viewer can't do coordinate transformations. I
think it' a good idea to disable the tile layer by default and add more
tile layer options for users :). Since this is the last week for GSOC, I
will submit the current version(with map view) and update the tile layer
after GSOC.

Regina Obe <lr at pcorp.us> 于2018年7月31日周二 上午2:17写道：

> Would be nicer if it were a configurable setting or maybe it is already so
> as part of the setting panel you can specify the tile url.
> For example I'd rather use my own tiles than any of these since I have
> custom stuff showing on mine.
>
> Might even be better for the default to be no tile at all.  When I look at
> my data, especially data that is not earthly bound, I don't want it
> overlaid against anything.
>
> robe waiting for strk to scream at pramsey's blasphemy :)
>
>
> > -----Original Message-----
> > From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On
> > Behalf Of Paul Ramsey
> > Sent: Monday, July 30, 2018 2:09 PM
> > To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
> > Subject: Re: [postgis-devel] [SoC]Week 10 Report - Implement Geospatial
> > Data Viewer in pgAdmin4 for PostGIS
> >
> > Also, do you find the OSM tileserver slow? I find it's incredibly slow.
> Maybe
> > using bing or some other public-but-available tile set would be good?
> > P
> >
> > On Mon, Jul 30, 2018 at 11:01 AM, Paul Ramsey
> > <pramsey at cleverelephant.ca> wrote:
> > > OK, that branch builds... there's just functionality for looking at
> > > geometries one-at-a-time, is there a plan for a map view that shows
> > > the whole result set?
> > >
> > > P.
> > >
> > > On Fri, Jul 27, 2018 at 6:23 PM, Xuri Gong <xurigoong at gmail.com>
> wrote:
> > >> Hi Paul,
> > >>
> > >> Since there are some bugs using openlayers in pgadmin4, I have
> > >> replaced it with leafletjs in 'geometry_visualiser' branch. Please
> > >> use 'geometry_visualiser' branch to build:
> > >> https://github.com/Gooong/pgadmin4/tree/geometry_visualiser
> > >>
> > >> Thank you:)
> > >>
> > >> Paul Ramsey <pramsey at cleverelephant.ca> ?2018?7?28??? ??5:26??:
> > >>>
> > >>> Trying out the geoviewer branch,
> > >>>
> > >>> I can run 'make bundle' fine in the master branch. In your branch it
> > >>> errors out like this:
> > >>>
> > >>> ERROR in ./pgadmin/static/jsx/map_view/map_view.jsx
> > >>> Module not found: Error: Can't resolve 'ol/dist/ol.js' in
> > >>> '/Users/pramsey/Code/pgadmin4/web/pgadmin/static/jsx/map_view'
> > >>>  @ ./pgadmin/static/jsx/map_view/map_view.jsx 60:9-33  @
> > >>> ./pgadmin/tools/sqleditor/static/js/sqleditor.js
> > >>>
> > >>> ERROR in ./pgadmin/static/jsx/map_view/map_view_map.jsx
> > >>> Module not found: Error: Can't resolve 'ol/dist/ol.js' in
> > >>> '/Users/pramsey/Code/pgadmin4/web/pgadmin/static/jsx/map_view'
> > >>>  @ ./pgadmin/static/jsx/map_view/map_view_map.jsx 37:9-33  @
> > >>> ./pgadmin/static/jsx/map_view/map_view.jsx
> > >>>  @ ./pgadmin/tools/sqleditor/static/js/sqleditor.js
> > >>> error Command failed with exit code 2.
> > >>> info Visit https://yarnpkg.com/en/docs/cli/run for documentation
> > >>> about this command.
> > >>>
> > >>> I assume there's a small piece of configuration not checked in
> > somewhere?
> > >>>
> > >>> On Sun, Jul 22, 2018 at 7:00 PM, Xuri Gong <xurigoong at gmail.com>
> > wrote:
> > >>> > Hi,
> > >>> > I am Xuri Gong. This is my report for week 10(July 16 - 22).
> > >>> >
> > >>> > What did you get done this period?
> > >>> >
> > >>> > Create visualiser for individual geometry in datagrid. [1] Fix
> > >>> > image url errors in leaflet. [2]
> > >>> >
> > >>> > This visualiser is independent from the geoviewer and is in the
> > >>> > geometry_visualiser branch[3]. Here is the screen shot:
> > >>> >
> > >>> > Screenshot 1 [4]
> > >>> > Screenshot 2 [5]
> > >>> >
> > >>> > What do you plan on doing next week?
> > >>> >
> > >>> > Create test for both geometry_visualiser and geoviewer.
> > >>> > Check the code style to meet the pgAdmin coding standards[6].
> > >>> >
> > >>> > Are you blocked on anything?
> > >>> > No, I am not blocked.
> > >>> >
> > >>> > Wiki page: [7]
> > >>> > Public repository: [8]
> > >>> >
> > >>> > [1]
> > >>> >
> > >>> >
> > https://github.com/Gooong/pgadmin4/commit/d6407baa3a0a96adac169d18
> > >>> > 3bed8bc044dbb8f5
> > >>> > [2]
> > >>> >
> > >>> >
> > https://github.com/Gooong/pgadmin4/commit/3b160b668c4f9b5867b4b218
> > >>> > 9714c934a5de85c6 [3]
> > >>> > https://github.com/Gooong/pgadmin4/tree/geometry_visualiser
> > >>> > [4] https://photos.app.goo.gl/kH58WDbZeKAtRvNi8
> > >>> > [5] https://photos.app.goo.gl/AnQMZndMQ62HGLmbA
> > >>> > [6] https://pgadmin.org/docs/pgadmin4/dev/coding_standards.html
> > >>> > [7]
> > >>> >
> > >>> > https://trac.osgeo.org/postgis/wiki/GeospatialDataViewerInPgAdmin4
> > >>> > ForPostGIS [8] https://github.com/Gooong/pgadmin4/tree/geoviewer
> > >>> >
> > >>> > _______________________________________________
> > >>> > postgis-devel mailing list
> > >>> > postgis-devel at lists.osgeo.org
> > >>> > https://lists.osgeo.org/mailman/listinfo/postgis-devel
> > >>> _______________________________________________
> > >>> postgis-devel mailing list
> > >>> postgis-devel at lists.osgeo.org
> > >>> https://lists.osgeo.org/mailman/listinfo/postgis-devel
> > >>
> > >>
> > >> _______________________________________________
> > >> postgis-devel mailing list
> > >> postgis-devel at lists.osgeo.org
> > >> https://lists.osgeo.org/mailman/listinfo/postgis-devel
> > _______________________________________________
> > postgis-devel mailing list
> > postgis-devel at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-devel
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20180731/10aa3f8e/attachment.html>