I have an esri Enterprise Geodatabase (9.3) stored in MSSql 2008 with storage type as sde binary.

I upgraded it to EGDB 10.4.1 (using multiple up-gradation steps) in MSSql 2012.

Then I copy/paste my data to PostgreSQL(9.4). I have the storage type in PostgreSQL as high precision ST_Geometry spatial type (SRID 300001).

I tried to connect to PostgreSQL geodatabase using QGIS but all my data are showing as no geometry and hence I cannot view it in QGIS.

However I can connect to it using ArcMap.

How do I solve this?

enter image description here enter image description here enter image description here

  • How did you defined geometry for the table? – Ahsan Mukhtar Jul 29 '19 at 11:22
  • 1
    Do you have PostGIS installed? Can you see the data in the spatial viewer in either PGAdmin4 or DBeaver? – DPSSpatial Jul 29 '19 at 17:29
  • @AhsanMukhtar i didnot deifne the geometry manually. I just migrated the data from MSSQL 2012(which has data type as sde binary) to postgreSQL using copy/paste in arcgis. – tsering Jul 30 '19 at 3:46
  • @DPSSpatial yes i have postgis(2.3)insatlled. i can see tables but cannot view in spatial viewer both in pgadmin 4 and Dbeaver. – tsering Jul 30 '19 at 4:33
  • @tsering can you post the result of a query that selects the geometry and what is shown in the results window? – DPSSpatial Jul 30 '19 at 15:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.