[postgis-users] Unknown geometry type: 12 - MultiSurface

Jim Klassen klassen.js at gmail.com
Mon Apr 24 09:50:47 PDT 2017

Thanks, that works.  I wouldn't have guessed to try the 3D functions for
support of 2D curves.  Also, good to know that information is available
in Ch 14.  I didn't realize I needed to think of Intersects as "Special"
depending on geometry type.

On 04/23/2017 09:31 PM, Mike Toews wrote:
> The list of functions that are supported for polyhedral surface
> geometries are documented for PostGIS 2.2 here:
> https://postgis.net/docs/manual-2.2/PostGIS_Special_Functions_Index.html#PostGIS_PS_GeometryFunctions
> So, for instance, try replacing ST_Intersects with ST_3DIntersects,
> and your example should work.
> Many of the functions were written before curve support, which is why
> you may see a generic-looking "unknown geometry type" error.
> On 22 April 2017 at 06:59, James Klassen <klassen.js at gmail.com> wrote:
>> I have been getting "ERROR: Unknown geometry type: 12 - MultiSurface" on
>> some operations since importing a File GeoDatabase containing curved
>> geometries into PostGIS using a recent OGR (2.2.0dev trunk at 37918).  Using
>> ST_CurveToLine(geom) instead or the original curved geometry is a work
>> around, but it would be desirable to directly use the original geometry if
>> possible.  Is this the expected behavior?
>> I am running PostgreSQL 9.5.5/PostGIS 2.2.2 from
>> http://apt.postgresql.org/pub/repos/apt/ on Ubuntu 12.04.
>> It is unclear to me from the documentation if Curved geometries are
>> generally supported or only with a few specific functions.  I have found
>> some references to "Unknown geometry type" errors from long ago that
>> reference closed tickets against PostGIS 1.x and a Stack Exchange question
>> "Smallworld > FME > PostGIS > QGIS" that seems similar but different.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

More information about the postgis-users mailing list