I am loading shapefile data from a GPS into PostGIS via Leica ZenoOffice. This apparently imports fine with it's geometry in the attribute table. However, when I add a postGIS layer in QGIS the file uploads but without any geometry (all the other attributes have imported correctly). Is there something specific that this could be such as something simple like a box I have forgotten to tick or is this likely to be a problem with the GPS data itself?

  • Does the new table have a row in the geometry_columns table/view?
    – user30184
    Sep 18, 2014 at 15:36
  • Could you clarify how you were able to verify that the import from shapefile picked up the geometry?
    – janechii
    Sep 18, 2014 at 21:05
  • Does the table have a primary key?
    – Scro
    Sep 19, 2014 at 2:28
  • To clarify, the import from the shapefile picked up the geometry as I am able to view this column in postgrsql. However, when I import this into QGIS the geometry_columns disappears from the attributes within QGIS. I hope this is a little clearer :-)
    – kernow88
    Sep 26, 2014 at 15:06
  • 1
    The attribute table in QGIS does not display the geometry column.
    – Scro
    Oct 3, 2014 at 7:15