0

I have a PostGis table I have generated by importing an existing geojson file using ogr2ogr. When I add this table as a layer in QGIS, the layer shows up as having no geometry. In the layer properties I get:

Geometry type of the features in this layer

No geometry (WKB type: "NoGeometry")

The table has geometry data in the wkb_geometry column with binary data, and if I export the table using ogr2ogr I get the correct geojson object reconstructed.

What am I missing here?

Improve this question
2
  • 2
    "with binary data" can you output the table definition \d?
    – Evan Carroll
    Commented Mar 27, 2018 at 0:20
  • Not sure what you mean by this or what you are expecting. But the wkb_geometry is of bytea type.
    – Tristan Rhodes
    Commented Mar 27, 2018 at 8:00

1 Answer 1

Reset to default
3

PostGis installed, but database not configured for PostGis...

So for future reference, run this:

CREATE EXTENSION postgis

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.