[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Visualizing PostGIS 3D geometries
From:       Rémi_Cura <remi.cura () gmail ! com>
Date:       2015-07-08 12:02:01
Message-ID: CAJvUf_txO5UsBmpngQeD8aO5ovyr_QSZ6qHe2gp=PJvuwNfDRg () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hey,
I went trough a similar quest recently.
The only solution I found that worked easily was to export the 3D
shapefile,
and visualize it in an external software
(in my case , CloudCompare )

Sadly it's difficult to find a mature x3d viewer.

Cheers,
R=C3=A9mi-C

2015-07-08 13:22 GMT+02:00 Tom van Tilburg <tom.van.tilburg@gmail.com>:

> I think 3D is still in it's infancy in the world of GIS, so for many
> things you have to things manually.
>
> If it's just visualizing, you may try to export them as X3D and open them
> in an X3D capable viewer.
>
> Regina made a first (impressive) effort on a viewer with this:
>     https://github.com/robe2/postgis_x3d_viewer
>
> but you can also directly output a valid x3d file from an SQL query:
>     http://postgis.net/docs/ST_AsX3D.html
>
> T.
>
>
> On 7-7-2015 21:44, Hillier, Michael wrote:
>
>> Greetings,
>>
>> I am searching for advice on how to visualize PostGIS 3D geometries:
>> PointZ, PolygonZ, TinZ. So far I have tested out:
>>
>>    *   ArcScene - supports pointz and polygonz. but many issues with
>> polygonz and confirmed by ESRI
>>    *   pg3Dviewer - only supports Pointz. Although, was never able to
>> visualize it even with their test dataset and tutorial.
>>    *   QGIS - only supports 2D geometry - 3rd dimension ignored
>>    *   Grass GIS - extremely difficult to use (I am not a GIS expert):
>> connecting to database, creating new mapset, vector map etc. I was able =
to
>> connect to the database and see my tables, figured out the mapset and
>> vector map system. But the only thing it seems to pull in from the table=
 is
>> the id column and not the geometry.
>>
>> Honestly, the issues I have gone through to visualize simple 3D PostGIS
>> geometries doesn't make sense to me. Shouldn't there be a simple
>> environment to connect to the PostgreSQL/PostGIS database and visualize =
the
>> 3D geometries? Or have I really missed something here? If there isn't wh=
at
>> is the point in having standardized geometries on a S-DBMS if you can't
>> visualize them?
>>
>>
>>
>> Is it expected that some advanced end user develop their own software
>> using some visualization toolkit like VTK to visualize these geometries?
>>
>>
>>
>> Many thanks for any advice/guidance.
>>
>>
>>
>> Michael
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users@lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>

[Attachment #5 (text/html)]

<div dir="ltr"><div class="gmail_default" \
style="font-family:monospace,monospace">Hey,<br></div><div class="gmail_default" \
style="font-family:monospace,monospace">I went trough a similar quest \
recently.<br></div><div class="gmail_default" \
style="font-family:monospace,monospace">The only solution I found that worked easily \
was to export the 3D shapefile, <br></div><div class="gmail_default" \
style="font-family:monospace,monospace">and visualize it in an external software \
<br></div><div class="gmail_default" style="font-family:monospace,monospace">(in my \
case , CloudCompare )<br><br></div><div class="gmail_default" \
style="font-family:monospace,monospace">Sadly it&#39;s difficult to find a mature x3d \
viewer.<br><br></div><div class="gmail_default" \
style="font-family:monospace,monospace">Cheers,<br></div><div class="gmail_default" \
style="font-family:monospace,monospace">Rémi-C<br></div></div><div \
class="gmail_extra"><br><div class="gmail_quote">2015-07-08 13:22 GMT+02:00 Tom van \
Tilburg <span dir="ltr">&lt;<a href="mailto:tom.van.tilburg@gmail.com" \
target="_blank">tom.van.tilburg@gmail.com</a>&gt;</span>:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">I think 3D is still in it&#39;s infancy in the world of GIS, \
so for many things you have to things manually.<br> <br>
If it&#39;s just visualizing, you may try to export them as X3D and open them in an \
X3D capable viewer.<br> <br>
Regina made a first (impressive) effort on a viewer with this:<br>
      <a href="https://github.com/robe2/postgis_x3d_viewer" rel="noreferrer" \
target="_blank">https://github.com/robe2/postgis_x3d_viewer</a><br> <br>
but you can also directly output a valid x3d file from an SQL query:<br>
      <a href="http://postgis.net/docs/ST_AsX3D.html" rel="noreferrer" \
target="_blank">http://postgis.net/docs/ST_AsX3D.html</a><span class="HOEnZb"><font \
color="#888888"><br> <br>
T.</font></span><div class="HOEnZb"><div class="h5"><br>
<br>
On 7-7-2015 21:44, Hillier, Michael wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> Greetings,<br>
<br>
I am searching for advice on how to visualize PostGIS 3D geometries: PointZ, \
PolygonZ, TinZ. So far I have tested out:<br> <br>
     *     ArcScene - supports pointz and polygonz. but many issues with polygonz and \
                confirmed by ESRI<br>
     *     pg3Dviewer - only supports Pointz. Although, was never able to visualize \
                it even with their test dataset and tutorial.<br>
     *     QGIS - only supports 2D geometry - 3rd dimension ignored<br>
     *     Grass GIS - extremely difficult to use (I am not a GIS expert): connecting \
to database, creating new mapset, vector map etc. I was able to connect to the \
database and see my tables, figured out the mapset and vector map system. But the \
only thing it seems to pull in from the table is the id column and not the \
geometry.<br> <br>
Honestly, the issues I have gone through to visualize simple 3D PostGIS geometries \
doesn&#39;t make sense to me. Shouldn&#39;t there be a simple environment to connect \
to the PostgreSQL/PostGIS database and visualize the 3D geometries? Or have I really \
missed something here? If there isn&#39;t what is the point in having standardized \
geometries on a S-DBMS if you can&#39;t visualize them?<br> <br>
<br>
<br>
Is it expected that some advanced end user develop their own software using some \
visualization toolkit like VTK to visualize these geometries?<br> <br>
<br>
<br>
Many thanks for any advice/guidance.<br>
<br>
<br>
<br>
Michael<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
</blockquote> <br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
</div></div></blockquote></div><br></div>



_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic