Re: Implement geospatial data viewer in pgAdmin4 for PostGIS

Thanks!

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

> Hi
>
> On Thu, Aug 2, 2018 at 10:30 AM, Xuri Gong <xurigoong(at)gmail(dot)com> wrote:
>
>> 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.
>>
>
> No - I just got back from vacation so am working my way through a large
> backlog. I'll look at the newer patch, but it might not be for a couple of
> days.
>
> Thanks!
>
>
>>
>> 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
>>>
>>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>