Re: [postgis-users] Visualizing PostGIS 3D geometries
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 what 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
Re: [postgis-users] Visualizing PostGIS 3D geometries
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émi-C 2015-07-08 13:22 GMT+02:00 Tom van Tilburg tom.van.tilb...@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 what 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 ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Visualizing PostGIS 3D geometries
There's the Horao plugin[1] for QGIS that might let you view postgis 3d geometries. It can run stand-alone as well, without QGIS. It was developed for the SFCGAL 3D geometry types, but haven't tested on ...Z geometry types. Donovan [1] http://oslandia.github.io/horao/ On 07/07/15 01:27 PM, Paolo Cavallini wrote: Il 07/07/2015 21:44, Hillier, Michael ha scritto: 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 what 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? QGIS 2.10 has some basic support for 3D, will have more in 2.12. All the best. -- Kind regards, Donovan ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Visualizing PostGIS 3D geometries
Il 07/07/2015 21:44, Hillier, Michael ha scritto: 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 what 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? QGIS 2.10 has some basic support for 3D, will have more in 2.12. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
