[postgis-users] X3D Export Command

[Leonardo Rafael Fernandez Ruiz]

Hi all.

I am trying to export my geo-data in x3d format, I know that function is not integrated in postgis versions (asX3D). I get a old postgis version patched already for David Techer blog at http://www.davidgis.fr/blog/index.php?2007/04/05

I test an example it goes fine, my asx3d() function works !!. But is necessary now the structure of the geometry, that is the complex part to me, for example

select asx3d(geomfromewkt('SRID=-1;MULTIPOINT(1.0 -1.0 -1.0, 1.0 -1.0 1.0,
-1.0 -1.0 1.0, -1.0 -1.0 -1.0, 1.0 1.0 -1.0, 1.0 1.0 1.0, -1.0 1.0 1.0, -1.0 1.0 -1.0)'),
array[[0,1,2,3],[4,7,6,5],[0,4,5,1],[1,5,6,2],[2,6,7,3],[4,0,3,7]]);

In my case i need to import a city in shape format to postgis DB then export to x3d. So when i install my patch version with asX3D() this miss the command that not need many parameters, i think that will be perfect to me.

pgsql2x3d -u postgres -f testfile -g the_geom MABASE mytable

from http://postgis3d.blogspot.com/2007/12/x3d-export.html

How to use that, how i can get the postgis patch to run this?

If any one have solve this conflict please help me, i will appreciate any suggestion.

Thanks

Leo

PD. I am spanish speaker sorry for any mistakes.