Re: OpenStreetMap not showing in geometry viewer

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: Charles Wang <c_w(at)berkeley(dot)edu>
Cc: pgadmin-hackers <pgadmin-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: OpenStreetMap not showing in geometry viewer
Date: 2020-03-02 05:48:59
Message-ID: CAM9w-_k0ZkQGiEB_TRJxxUWQtZN1ChAW=0w02q=q_8SY7vUGNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi Charles,

It looks like the SRID for your geometry column is different from 4326 (You
need to explore on your own what is SRID)
Use https://postgis.net/docs/Find_SRID.html to get your SRID and try
converting it to 4326(if not 4326) using
https://postgis.net/docs/UpdateGeometrySRID.html

On Sat, Feb 29, 2020 at 9:20 AM Charles Wang <c_w(at)berkeley(dot)edu> wrote:

> Hi Guys,
> [image: Screen Shot 2020-02-28 at 3.41.47 PM.png]
> I've spent two days on this and still have no clue....
> The openstreetmap basemap only worked once at the first try of pgadmin.
> And it only worked for one database.
> I tried it on the second database it didn't work: no openstreetmap shown
> up.
>
> I reinstalled it (macos), and it still didn't work for any database that I
> connected to.
>
> I tried different browsers, cleared all browsers histories and cache.
> I even tried to fire up pgadmin in a container, but the openstreetmap base
> map is still missing in the geometry viewer.
>
> where is osm, any idea? Thanks.
>
>
> BRGDS,
> Charles
>

--
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Charles Wang 2020-03-02 06:51:47 Re: OpenStreetMap not showing in geometry viewer
Previous Message Akshay Joshi 2020-03-02 04:31:28 pgAdmin 4 commit: Update libraries.txt