[postgis-users] Multiple Geometries in Single View

[Rémi Cura]

We don't know much about your organisation,
you may went to send all your data for each review, this is similar to
sending shapefile, and to sending a one file sqlite database.

On the other hand you can simply give access to your data trough internet
to your reviewers (and only them). This way they can browse it and use it
for computation.
If for review purpose I suspect they don't really need to have it but more
to use it.

The same idea more sophisticated (again depending your need) is to put your
data into a web map service server (
http://fr.wikipedia.org/wiki/Web_Map_Service).
To make it simple is the same kind of thing than google map. It allow to
visually use the data. (for a visual check for instance).

Cheers.

Rémi-C


2013/10/29 Wesley Roberts <jwesroberts at gmail.com>

> Dear Rémi-C and Bo Victor,
>
> Many thanks for your responses. It seems my idea will not work as I
> thought. Perhaps I should look for alternative methods to share my data. My
> main aim is to reduce the clutter of sharing shapefiles and making it
> easier for the auditor to access and use our data. Perhaps the spatiallite
> db approach is one to use.
>
> I looked around for methods for sharing a postGIS database and it is not
> as easy as one would think. As I understand it there is no single file or
> folder containing the database and tables that can be simply copied to a
> shared folder. Even setting up a database in a non-standard location is
> difficult enough. I will start a separate question regarding sharing
> postGIS databases.
>
> Spatiallite may be the best alternative.
>
> Many thanks and kind regards,
> Wesley
>
>
> On Mon, Oct 28, 2013 at 5:20 PM, Rémi Cura <remi.cura at gmail.com> wrote:
>
>> Hey,
>> as far as I know you cant load directly different geometry type into qgis
>> (http://trac.osgeo.org/qgis/ticket/167).
>>
>> If you have a table with different type in in (point, line, polygon),
>> qgis will ask you to chose which geometry you want to load.
>> If you have a table with a column with "geometry collection", qgis won't
>> load it.
>>
>> This being said, it is easilly worked around (still a hassle) :
>> simple : if you have a column with different geometry type, load it
>> multiple time in qgis selecting each time a different geometry type
>> simple : if you have a column with geometry collection : use
>> ST_CollectionExtract to be in the previous case
>>
>> Note:  if you are tired of selecting the type of geometry in qgis, you
>> can create view with only one type of geometry.
>>
>> dirty way : simply convert everything to polygon ! : use ST_Buffer with
>> small area to convert point and line to polygon.
>>
>> Don't hesitate if you need more details.
>> Cheers,
>> Rémi-C
>>
>>
>> 2013/10/28 Wesley Roberts <jwesroberts at gmail.com>
>>
>>> 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
>>> 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
>>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
>
> --
> Dr Wesley Roberts
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131029/49f7eaa0/attachment.html>