Dear PostGIS users, I am a new postgis user and have a question regarding views and multiple geometry types. I understand that I can create a *view* where I select a portion of my data using an sql statement and view that *view *in QGIS. I would like to know if it is possible to create a *view *that contains multiple geometry types, so for example: a view displaying points lines and polygons from different tables within the my db?
The context to this question is as follows. Our organization needs to share a number of GIS layers with an auditor as part of our validation process. Instead of sending the auditor a "bucket load" of shapefiles with instructions on what to look at, I would prefer to share one postGIS DB with all the layers in tables and all of our geo-spatial requirements in views. Is this possible? Many thanks and looking forward to your responses. Wesley -- Dr Wesley Roberts [email protected] Cell: +27(0)83 5355 646 skype: roberts-w I hear...I forget I see...and I remember I do...and I understand Ancient Chinese Proverb
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
