public inbox for [email protected]help / color / mirror / Atom feed
OpenStreetMap not showing in geometry viewer 4+ messages / 2 participants [nested] [flat]
* OpenStreetMap not showing in geometry viewer @ 2020-02-28 23:51 Charles Wang <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Charles Wang @ 2020-02-28 23:51 UTC (permalink / raw) To: [email protected] 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 Attachments: [image/png] Screen Shot 2020-02-28 at 3.41.47 PM.png (35.7K, 3-Screen%20Shot%202020-02-28%20at%203.41.47%20PM.png) download | view image ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: OpenStreetMap not showing in geometry viewer @ 2020-03-02 05:48 Aditya Toshniwal <[email protected]> parent: Charles Wang <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Aditya Toshniwal @ 2020-03-02 05:48 UTC (permalink / raw) To: Charles Wang <[email protected]>; +Cc: pgadmin-hackers <[email protected]> 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 <[email protected]> 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" Attachments: [image/png] Screen Shot 2020-02-28 at 3.41.47 PM.png (35.7K, 3-Screen%20Shot%202020-02-28%20at%203.41.47%20PM.png) download | view image ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: OpenStreetMap not showing in geometry viewer @ 2020-03-02 06:51 Charles Wang <[email protected]> parent: Aditya Toshniwal <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Charles Wang @ 2020-03-02 06:51 UTC (permalink / raw) To: Aditya Toshniwal <[email protected]>; +Cc: pgadmin-hackers <[email protected]> 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 < [email protected]> 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 <[email protected]> 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" > Attachments: [image/png] Screen Shot 2020-02-28 at 3.41.47 PM.png (35.7K, 3-Screen%20Shot%202020-02-28%20at%203.41.47%20PM.png) download | view image ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: OpenStreetMap not showing in geometry viewer @ 2020-03-02 07:08 Aditya Toshniwal <[email protected]> parent: Charles Wang <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Aditya Toshniwal @ 2020-03-02 07:08 UTC (permalink / raw) To: Charles Wang <[email protected]>; +Cc: pgadmin-hackers <[email protected]> On Mon, Mar 2, 2020 at 12:21 PM Charles Wang <[email protected]> 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 < > [email protected]> 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 <[email protected]> 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" >> > -- Thanks and Regards, Aditya Toshniwal pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune "Don't Complain about Heat, Plant a TREE" Attachments: [image/png] Screen Shot 2020-02-28 at 3.41.47 PM.png (35.7K, 3-Screen%20Shot%202020-02-28%20at%203.41.47%20PM.png) download | view image ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-03-02 07:08 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2020-02-28 23:51 OpenStreetMap not showing in geometry viewer Charles Wang <[email protected]> 2020-03-02 05:48 ` Aditya Toshniwal <[email protected]> 2020-03-02 06:51 ` Charles Wang <[email protected]> 2020-03-02 07:08 ` Aditya Toshniwal <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox