<div dir="ltr"><div><br></div><div>We don't know much about your organisation,</div><div>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.<br>
<br>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. </div><div>If for review purpose I suspect they don't really need to have it but more to use it. </div>
<div><br></div><div>The same idea more sophisticated (again depending your need) is to put your data into a web map service server (<a href="http://fr.wikipedia.org/wiki/Web_Map_Service">http://fr.wikipedia.org/wiki/Web_Map_Service</a>).</div>
<div>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).</div><div><br></div><div>Cheers.</div><div><br></div><div>Rémi-C</div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">2013/10/29 Wesley Roberts <span dir="ltr"><<a href="mailto:jwesroberts@gmail.com" target="_blank">jwesroberts@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div><div><div>Dear Rémi-C and Bo Victor,<br><br></div>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. <br>
<br>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.<br>
<br></div>Spatiallite may be the best alternative.<br><br></div>Many thanks and kind regards,<br></div>Wesley<br></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Oct 28, 2013 at 5:20 PM, Rémi Cura <span dir="ltr"><<a href="mailto:remi.cura@gmail.com" target="_blank">remi.cura@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hey, <div>as far as I know you cant load directly different geometry type into qgis (<a href="http://trac.osgeo.org/qgis/ticket/167" target="_blank">http://trac.osgeo.org/qgis/ticket/167</a>).</div>
<div><br></div><div>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.</div>
<div>If you have a table with a column with "geometry collection", qgis won't load it.</div><div><br></div><div>This being said, it is easilly worked around (still a hassle) :</div><div>simple : if you have a column with different geometry type, load it multiple time in qgis selecting each time a different geometry type</div>
<div>simple : if you have a column with geometry collection : use ST_CollectionExtract to be in the previous case</div><div><br></div><div>Note: if you are tired of selecting the type of geometry in qgis, you can create view with only one type of geometry.</div>
<div><br></div><div>dirty way : simply convert everything to polygon ! : use ST_Buffer with small area to convert point and line to polygon.</div><div><br></div><div>Don't hesitate if you need more details.</div><div>
Cheers,</div><div>Rémi-C</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/10/28 Wesley Roberts <span dir="ltr"><<a href="mailto:jwesroberts@gmail.com" target="_blank">jwesroberts@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><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.<span><font color="#888888"><br><div><div><div>Wesley<br clear="all"></div><div><div><br>-- <br><div dir="ltr">Dr Wesley Roberts<br>
<a href="mailto:jwesroberts@gmail.com" target="_blank">jwesroberts@gmail.com</a><br>
Cell: <a href="tel:%2B27%280%2983%205355%20646" value="+27835355646" target="_blank">+27(0)83 5355 646</a><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></font></span></div>
<br></div></div><div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></div></blockquote></div><br></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr">
Dr Wesley Roberts<br>
<a href="mailto:jwesroberts@gmail.com" target="_blank">jwesroberts@gmail.com</a><br>
Cell: <a href="tel:%2B27%280%2983%205355%20646" value="+27835355646" target="_blank">+27(0)83 5355 646</a><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></blockquote></div><br></div>