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
[email protected] <mailto:[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
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
