Re: Implement geospatial data viewer in pgAdmin4 for PostGIS

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