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 <[email protected]> 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@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 > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
