Re: Implement geospatial data viewer in pgAdmin4 for PostGIS

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Xuri Gong <xurigoong(at)gmail(dot)com>
Cc: Anthony DeBarros <adebarros(at)gmail(dot)com>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>, Joao Pedro De Almeida Pereira <jdealmeidapereira(at)pivotal(dot)io>
Subject: Re: Implement geospatial data viewer in pgAdmin4 for PostGIS
Date: 2018-08-02 08:35:37
Message-ID: CA+OCxoz84LYz_=-+uarRgZzsHv1SG3kHDvNpfrMNAa=GAPTmMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi

Can you suggest any freely available data sets that can be used to test
this with please? I don't have any geo databases.

As a quick review-point, I don't see any documentation updates with the
patch.

Thanks.

On Wed, Jul 25, 2018 at 9:13 AM, Xuri Gong <xurigoong(at)gmail(dot)com> wrote:

> Hi Anthony and Dave,
>
> Thank you for your suggestions and I have implemented this visualiser:). I
> add button in the cell and when it's clicked the geometry is shown in a
> map. Here is the screenshots of it: https://photos.app.goo.gl/
> fQVBRcmZJ3YcPLcL8
>
> Attached is the patch for this geometry viewer. Please review it. Thank
> you.
>
> Anthony DeBarros <adebarros(at)gmail(dot)com> 于2018年5月26日周六 上午12:47写道:
>
>> I agree the map is the ultimate tool. However, I do think that being able
>>> to quickly view a single geometry from within the grid makes a lot of sense
>>> - and for users who want to easily visualise a single geometry, will be a
>>> great deal more convenient than the map.
>>>
>>> Note that I'm not talking about anything complex here - just a
>>> convenience panel that renders the geometry, and maybe has zoom and
>>> scrolling. The viewing tab would be where the real magic happens - handling
>>> the map overlay and the ability to display many geometries at once.
>>>
>>>
>>> As a user, I would agree with Dave here. A good example is a table that
>> holds the polygons of each county in the U.S. or each country in Europe. It
>> would be very helpful to view each individually as well as collectively if
>> I were to select all in a query.
>>
>>
>>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Xuri Gong 2018-08-02 09:30:19 Re: Implement geospatial data viewer in pgAdmin4 for PostGIS
Previous Message Akshay Joshi 2018-08-02 08:34:33 Re: [pgAdmin4][Patch]: RM #3458 Error when using python 3.7