Thread: OpenStreetMap not showing in geometry viewer
Hi Guys, 
BRGDS,

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.
Charles
Attachment
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,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
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.htmlOn Sat, Feb 29, 2020 at 9:20 AM Charles Wang <c_w@berkeley.edu> wrote:Hi Guys,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 ToshniwalpgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune"Don't Complain about Heat, Plant a TREE"
Attachment
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,CharlesOn 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.htmlOn Sat, Feb 29, 2020 at 9:20 AM Charles Wang <c_w@berkeley.edu> wrote:Hi Guys,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 ToshniwalpgAdmin 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"