[GIS] pgsql2shp ERROR: incompatible mixed geometry types in table

exportpgsql2shppostgisshapefile

I have multi-linestring in .shp files and I split the lines with postgis, but that result is only geom column.

It does not works with shape file exporter

error: incompatible mixed geometry types in table

I guess it needs at least gid, shape_leng, polyline_n …etc columns?

How can I get data able to export .shp file with only geom column?

Best Answer

Probably in your table there are more than one type of geometry but, in a shape file, you must have only a type (Line, Polygon or Point). When you split lines the result could be not only a line but a point ( or multi). Use st_geometrytype(geom) for analyze what you have in your table. If you only need lines, you have just to delete what is not a linestring:

DELETE FROM tablename WHERE st_geometrytype(geom) NOT IN ('ST_LineString', 'ST_MultiLineString');

After this, export will work. If you want only the geometry column of the shape just delete the .dbf file.

Related Solutions

PostGIS – How to Populate the Geometry Column in a PostGIS Table?

Per comments, in occasions the geom column might not be visible to the client as a human readable string (a geom column is encoded as an EWTB - Extended Well Known Binary ).

There are two ways to visually check if the geom column is populated:

Load the table to your favourite gis client (eg. Qgis)
Count the NULL and NOT NULL values of the geom column :

      SELECT COUNT(geom), 'null_tally' AS narrative 
      FROM 'myTable' 
      WHERE a IS NULL 
      UNION
      SELECT COUNT(geom), 'not_null_tally' AS narrative 
      FROM 'myTable'  
      WHERE a IS NOT NULL;

count sql snippet from : https://stackoverflow.com/questions/1271810/counting-null-and-non-null-values-in-a-single-query )

[GIS] Can’t import shapefile to PostGIS

I think that you have to configure postGIS library as extension in your database. Here an example.

Best Answer

Related Solutions

PostGIS – How to Populate the Geometry Column in a PostGIS Table?

[GIS] Can’t import shapefile to PostGIS

Related Question