Re: Implement geospatial data viewer in pgAdmin4 for PostGIS

Hi

On Thu, Aug 2, 2018 at 10:30 AM, Xuri Gong <xurigoong@gmail.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@pgadmin.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@gmail.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@gmail.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