[postgis-devel] 3d in postgis

[Mathieu Le Serre]

Hi all,

A few months ago, I wrote some patchs related to 3D geometries storage
in postgis. (See for instance http://tinyurl.com/3y9xhv)

Since september, I've been working on several import/export functions,
based on TIN and POLYHEDRALSURFACE, which are geometries that describe
3D volumes or surfaces.

I first developed a script named collada2pgsql which imports TIN or
POLYHEDRALSURFACE from collada format. It allows importing and storing
geometries with texture informations.

I also wrote two export functions:
  -pgsql2kmz:  which exports pgsql geometries into kml or collada
format, and allows to see the model in GoogleEarth. It is possible to
export a textured model if the informations are stored in PostGIS.

  -pgsql2x3d:  which exports pgsql geometries into x3d format. It is
also possible to export with textures

All the information you need to use these functionalities are available
from this url: http://postgis3d.blogspot.com

HTH,

Mathieu