PostGIS 3D Texture writing

Hi @mhab,

Could you share us more details? Workspace template ( FMWT ), print Database PostGis, etc...

Thanks,

Danilo

I have a textured 3D building (read from CityGML). If I write it to a FileGDB as Multipatch and read it afterwards I see the 3D object and the texturing is there.

If I do the same with PostGIS writer and read it afterwards I get the 3D objects without the texture.

I dont have more info and the very general question if texture handling is supported in PostGIS or not.

Michael

This is expected behavior. The PostGIS reader/writer in FME does not preserve textures. This is because, to the best of my knowledge, PostGIS does not directly support textures.

That said, PostGIS (and FME) support rasters in PostGIS, and depending on your use case, there may be workarounds.

References:

- PostGIS 2.3 documentation on its supported geometry types: http://postgis.net/docs/manual-2.3/using_postgis_dbmanagement.html#RefObject http://postgis.net/docs/manual-2.3/ST_GeomFromWKB.html (and others, these are the main ones)

- A nice slide-deck talking about PostGID 3D from 2011 (so useful for context, not really useful for confirming the latest state of things) https://www.slideshare.net/SimeonNedkov/postgis-3d-implementation

Regards,

Paul