[postgis-users] Multiple Geometries in Single View

[Bo Victor Thomsen]

To Wesley -

You can have a table or a view in PostGIS/PostgreSQL that contains 
different geometry types (type: geometry). The problem is that QGIS 
can't show them as a single table. QGIS is the limiting factor, not PostGIS.

You can load all your shapefiles into a PostGIS database and make 
different views that select/modify the data in the base tables in 
different ways. But you can still only have one type of geometry in 
every table/view if you want to show them in QGIS.

On another note: Have you thought about putting your data in a 
Spatialite database instead of Postgis ? It can be done as a single file 
for all the tables/views, that simply can be copied from one computer to 
another (Still: only one geometry type in each table/view ;-)

Regards
Bo Victor Thomsen
Aestas-GIS
Denmark

Den 28-10-2013 13:51, Wesley Roberts skrev:
> 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
> jwesroberts at gmail.com <mailto:jwesroberts at gmail.com>
> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131028/21e5da79/attachment.html>