Re: Implement geospatial data viewer in pgAdmin4 for PostGIS

Hi Dave,

I have sent the new patch in a new thread because I thought you have missed
this email... So please just ignore this patch and review the new patch. I
also added some test geo data in the new thread. You can add postGIS
extension and then import the data.

If you just want to have a quick look, I also build pgAdmin4 and import the
data on my server. You can login and have a look:
http://pgadmin4.gooong.cn:5050 . The username is my email address and
password is postgis_test .

I will add documentation for the viewer in the new thread.

Dave Page <dpage(at)pgadmin(dot)org> 于2018年8月2日周四 下午4:35写道：

> 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
>