Hi Nicklas, <br><br>Please, let' s take this conversation "on-list". The attacments did not pass the list control, that's the reason why I wrote to you directly. <br>About generating 3D datasets it's simple if you have the data in .shp (using shp2pgsql). That's the way I get my data. <br>
<br>In the other hand, a polygon cannot be in more than one plane in 3D, if this is the case, this structure must be tessellated into triangles or at least polygons in the same plane. (the same as openGL do when rendering concave polygons). May be the tesselator included in the 3D extension eats this kind of structure, but I don't trust.<br>
<br>About PostGis I am a noob or less than a noob. I only know the basics to set a database and do a sql query. And I learned it yesterday :). I am a 3D developer, and postgis is a tangential theme for me. So for the questions about postGIS ask to the gurus in the list... ;) <br>
<br>Cheers.<br><br><br><div class="gmail_quote">2011/1/19 Nicklas Avén <span dir="ltr"><<a href="mailto:nicklas.aven@jordogskog.no">nicklas.aven@jordogskog.no</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Yes, that would be nice :-)<br>
<br>
It is a little bit difficult to create 3D datasets I think, at least if<br>
the polygons contains more than 3 points (counting the first and last as<br>
1) because they have to be in the same plan. That is the part in the 3D<br>
distance code that I am most worried about. Now there is no real test if<br>
people sends polygons not on one single plan to the function, because<br>
such a test is quite expensive to calculate if the polygon has many<br>
points. Also there have to be some tolerance.<br>
<br>
Have you tried the PostGIS trunk lately?<br>
<br>
It will be interesting to test and visualize st_3d_shortestline through<br>
gvSIG.<br>
<br>
Cheers<br>
<font color="#888888">Nicklas<br>
</font><div><div></div><div class="h5"><br>
On Wed, 2011-01-19 at 13:55 +0100, Jordi Torres wrote:<br>
> Hi Nick,<br>
><br>
> Is a lot of triangular separate polygons, if you want the archive to<br>
> do testing I can send it to you.<br>
><br>
> Cheers.<br>
><br>
> 2011/1/19 Nicklas Avén <<a href="mailto:nicklas.aven@jordogskog.no">nicklas.aven@jordogskog.no</a>><br>
> Thanks a lot<br>
><br>
> I will try it as soon as possible. When I have this woking<br>
> there will be<br>
> a blog post about this extension and comming 3d distance<br>
> functions in<br>
> postgis.<br>
><br>
> Is TIN supported? or is it a lot of triangular separate<br>
> polygons in the<br>
> example picture?<br>
><br>
> Great work!<br>
> Thanks<br>
><br>
> /Nicklas<br>
><br>
><br>
><br>
> On Wed, 2011-01-19 at 13:47 +0100, Jordi Torres wrote:<br>
> ><br>
> ><br>
> > ---------- Forwarded message ----------<br>
> > From: Jordi Torres <<a href="mailto:jtorresfabra@gmail.com">jtorresfabra@gmail.com</a>><br>
> > Date: 2011/1/19<br>
> > Subject: Re: [Gvsig_english] PostGis + 3D extension<br>
> > To: Users and Developers mailing list<br>
> > <<a href="mailto:gvsig_internacional@listserv.gva.es">gvsig_internacional@listserv.gva.es</a>><br>
> ><br>
> ><br>
> > Hi Nicklas,<br>
> ><br>
> > Here you have attached a zip file. Substitute the jars in<br>
> the way Fran<br>
> > told to you.<br>
> ><br>
> > And congrats to jaspa teams!! Good work!<br>
> ><br>
> > Cheers.<br>
> ><br>
> > 2011/1/19 Francisco José Peñarrubia <<a href="mailto:fpenarru@gmail.com">fpenarru@gmail.com</a>><br>
> ><br>
> ><br>
> > Hi.<br>
> ><br>
> > I just want to remark and say thanks to JASPA team,<br>
> who did<br>
> > the hard work of this patch in gvSIG Sprint. I hope<br>
> we can use<br>
> > it in 1.11 release.<br>
> ><br>
> > <a href="http://jaspa.forge.osor.eu/" target="_blank">http://jaspa.forge.osor.eu/</a><br>
> ><br>
> > Best regards.<br>
> ><br>
> > Jordi, please, can you send the latest jars to<br>
> Niklas?. I will<br>
> > create a patch and upload it to the repository.<br>
> ><br>
> > El 19/01/2011 13:30, Jordi Torres escribió:<br>
> > ><br>
> > > Hi Nick and Fran,<br>
> > ><br>
> > > I have started a new thread in the list, this way<br>
> we won't<br>
> > > merge topics.<br>
> > ><br>
> > > Fran has fixed the issues and now we are able to<br>
> see 3D<br>
> > > geometries using postigs (attached is a screenshot<br>
> of a 3D<br>
> > > polygons layer). By the way, polyhedral is not<br>
> supported by<br>
> > > gvSIG postGis driver (even I don't now if it is<br>
> OGC<br>
> > > compliant), so you have to decompose it in<br>
> polygons.<br>
> > ><br>
> > > Cheers!<br>
> > ><br>
> > > --<br>
> > > Jordi Torres Fabra<br>
> > ><br>
> > > gvSIG 3D blog<br>
> > > <a href="http://gvsig3d.blogspot.com" target="_blank">http://gvsig3d.blogspot.com</a><br>
> > > Instituto de Automática e Informática Industrial<br>
> > > <a href="http://www.ai2.upv.es" target="_blank">http://www.ai2.upv.es</a><br>
> > ><br>
> > ><br>
> > > _______________________________________________<br>
> > > Gvsig_internacional mailing list<br>
> > > <a href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a><br>
> > ><br>
> <a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
> ><br>
> > --<br>
> > Fran Peñarrubia<br>
> > Scolab<br>
> > <a href="http://www.scolab.es" target="_blank">www.scolab.es</a><br>
> ><br>
> > Asociación gvSIG<br>
> > <a href="http://www.gvsig.com" target="_blank">www.gvsig.com</a><br>
> ><br>
> > _______________________________________________<br>
> > Gvsig_internacional mailing list<br>
> > <a href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a><br>
> ><br>
> <a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
> ><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > Jordi Torres Fabra<br>
> ><br>
> > gvSIG 3D blog<br>
> > <a href="http://gvsig3d.blogspot.com" target="_blank">http://gvsig3d.blogspot.com</a><br>
> > Instituto de Automática e Informática Industrial<br>
> > <a href="http://www.ai2.upv.es" target="_blank">http://www.ai2.upv.es</a><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > Jordi Torres Fabra<br>
> ><br>
> > gvSIG 3D blog<br>
> > <a href="http://gvsig3d.blogspot.com" target="_blank">http://gvsig3d.blogspot.com</a><br>
> > Instituto de Automática e Informática Industrial<br>
> > <a href="http://www.ai2.upv.es" target="_blank">http://www.ai2.upv.es</a><br>
><br>
><br>
><br>
><br>
><br>
><br>
> --<br>
> Jordi Torres Fabra<br>
><br>
> gvSIG 3D blog<br>
> <a href="http://gvsig3d.blogspot.com" target="_blank">http://gvsig3d.blogspot.com</a><br>
> Instituto de Automática e Informática Industrial<br>
> <a href="http://www.ai2.upv.es" target="_blank">http://www.ai2.upv.es</a><br>
<br>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Jordi Torres Fabra<br><br>gvSIG 3D blog<br><a href="http://gvsig3d.blogspot.com">http://gvsig3d.blogspot.com</a><br>Instituto de Automática e Informática Industrial <br>
<a href="http://www.ai2.upv.es">http://www.ai2.upv.es</a><br>