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

[Paul Ramsey]

Why as a modal popup, and not as another tab in the set of views?
When someone says to me "postgis support in pgadmin" my thoughts leap to
doing exploratory queries and seeing the results, for sure.
What happens when I query some geometry that is in a non-global projection,
like UTM?
P.

On Mon, Jul 30, 2018 at 10:33 PM, Xuri Gong <xurigoong at gmail.com> wrote:

>
> 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
>
>
> _______________________________________________
> 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/35057a8f/attachment-0001.html>