Skip to main content

Hello

I am fairly new to 3D data handling and stumbled over the problem, that I can write 3D data to PostGIS but texture information seems to get lost.

Is it generally possible ? If yes, what do I need to do ?

Thanks for any hint

Michael

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


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

Thanks Paul for the clarification.

 

It confirms what I thought maybe the state of art for now.

 

Now I'm pretty sure

 

 


Reply