<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">To Wesley -<br>
<br>
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.<br>
<br>
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.<br>
<br>
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 ;-)<br>
<br>
Regards<br>
Bo Victor Thomsen<br>
Aestas-GIS<br>
Denmark <br>
<br>
Den 28-10-2013 13:51, Wesley Roberts skrev:<br>
</div>
<blockquote
cite="mid:CAFik=FcXyAhf2jcoXBHx2KDQPC63piSq=Rfr1itiuyJ6nB=RTQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>Dear PostGIS users,<br>
<br>
</div>
I am a new postgis user and have a question regarding views
and multiple geometry types. I understand that I can create
a <i>view</i> where I select a portion of my data using an
sql statement and view that <i>view </i>in QGIS. I would
like to know if it is possible to create a <i>view </i>that
contains multiple geometry types, so for example: a view
displaying points lines and polygons from different tables
within the my db?<br>
<br>
</div>
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?<br>
<br>
</div>
Many thanks and looking forward to your responses.<br>
<div>
<div>
<div>Wesley<br clear="all">
</div>
<div>
<div><br>
-- <br>
<div dir="ltr">Dr Wesley Roberts<br>
<a moz-do-not-send="true"
href="mailto:jwesroberts@gmail.com" target="_blank">jwesroberts@gmail.com</a><br>
Cell: +27(0)83 5355 646<br>
skype: roberts-w<br>
<br>
I hear...I forget <br>
I see...and I remember <br>
I do...and I understand <br>
Ancient Chinese Proverb<br>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>