Thread: OpenStreetMap not showing in geometry viewer

OpenStreetMap not showing in geometry viewer

From
Charles Wang
Date:
Hi Guys, 
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
Attachment

Re: OpenStreetMap not showing in geometry viewer

From
Aditya Toshniwal
Date:
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@berkeley.edu> wrote:
Hi Guys, 
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"
Attachment

Re: OpenStreetMap not showing in geometry viewer

From
Charles Wang
Date:
Thank you Aditya, exactly! you made my day.
I appreciate your help. 


BRGDS,
Charles


On Sun, Mar 1, 2020 at 9:49 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
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@berkeley.edu> wrote:
Hi Guys, 
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"
Attachment

Re: OpenStreetMap not showing in geometry viewer

From
Aditya Toshniwal
Date:


On Mon, Mar 2, 2020 at 12:21 PM Charles Wang <c_w@berkeley.edu> wrote:
Thank you Aditya, exactly! you made my day.
I appreciate your help. 
Glad it worked !! :) 


BRGDS,
Charles


On Sun, Mar 1, 2020 at 9:49 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
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@berkeley.edu> wrote:
Hi Guys, 
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"


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