<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">I suggest you use QGIS as a WMS server, or use the "export Mapserver" plugin & use Mapserver to create an interactive web page with your comtent. A fully interactive website is perhaps the best way to demonstrate the functionality.<br><br>I have also created a Linux Live DVD with QGIS, the required data and a suitable project set up. This provides a bootable DVD from which users can boot directly into a QGIS application on any standard PC, without interfering with the current PC setup. A very elegant way of doing what you suggest. This is also now apparently possible with Windows: <a href="http://www.makeuseof.com/tag/how-to-create-your-own-custom-windows-live-cd/">http://www.makeuseof.com/tag/how-to-create-your-own-custom-windows-live-cd/</a><br><br>Cheers,<br><br> Brent Wood<br><br><br><br><br>--- On <b>Tue, 1/31/12, Gerhardus Geldenhuis
<i><gerhardus.geldenhuis@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Gerhardus Geldenhuis <gerhardus.geldenhuis@gmail.com><br>Subject: Re: [Qgis-user] Converting CSV into a database<br>To: tech@wildintellect.com<br>Cc: qgis-user@lists.osgeo.org<br>Date: Tuesday, January 31, 2012, 6:18 AM<br><br><div id="yiv1625533169"><div>Hi Alex,</div><div>The Plugin Installer if that is a plugin itself then it is not listed.</div><div><br></div><div>The keyservers have not been working for a while and that breaks any other updates. Which means I have to deselect any QGIS related updates every time ubuntu updates my laptop.</div>
<div><br></div><div>This is my listed repositories:</div><div><div>deb <a rel="nofollow" target="_blank" href="http://qgis.org/debian">http://qgis.org/debian</a> natty main</div><div>deb-src <a rel="nofollow" target="_blank" href="http://qgis.org/debian">http://qgis.org/debian</a> natty main</div>
</div><div><br></div><div>and I am definitely using natty and have not upgraded my OS.</div><div><br></div>Regards<br><br><div class="yiv1625533169gmail_quote">On 29 January 2012 19:10, Alex Mandel <span dir="ltr"><<a rel="nofollow" ymailto="mailto:tech_dev@wildintellect.com" target="_blank" href="/mc/compose?to=tech_dev@wildintellect.com">tech_dev@wildintellect.com</a>></span> wrote:<br>
<blockquote class="yiv1625533169gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Check in the Manage Plugins menu that you have the Plugin Installer enabled.<br>
<br>
The authentication thing is no big deal sometimes the keyservers just<br>
aren't working. As a question of clarification which repository are you<br>
installing QGIS from?<br>
<br>
Thanks,<br>
Alex<br>
<div class="yiv1625533169HOEnZb"><div class="yiv1625533169h5"><br>
On 01/29/2012 04:40 AM, Gerhardus Geldenhuis wrote:<br>
> Hi<br>
> That installation unfortunately had no effect. Still no python plugin menu<br>
> option. In addition I also get the message:<br>
><br>
> WARNING: The following packages cannot be authenticated!<br>
> libqgis1.7.3 python-qgis python-qgis-common<br>
> Install these packages without verification [y/N]? y<br>
><br>
> which I ignored<br>
><br>
> I ran sudo ldconfig thinking maybe a link somewhere is missing but that did<br>
> not do the trick either. The packages were installed previously:<br>
><br>
> Preparing to replace python-qgis 1.4.0+12730-5ubuntu1 (using<br>
> .../python-qgis_1.7.3-1~natty1_i386.deb) ...<br>
> Unpacking replacement python-qgis ...<br>
> Preparing to replace python-qgis-common 1.4.0+12730-5ubuntu1 (using<br>
> .../python-qgis-common_1.7.3-1~natty1_all.deb) ...<br>
><br>
> so maybe there is something else wrong?<br>
><br>
> Regards<br>
><br>
> On 28 January 2012 21:46, Alex Mandel <<a rel="nofollow" ymailto="mailto:tech_dev@wildintellect.com" target="_blank" href="/mc/compose?to=tech_dev@wildintellect.com">tech_dev@wildintellect.com</a>> wrote:<br>
><br>
>> A classic problem we really need to tackle better: you're missing the<br>
>> python-qgis package or maybe the base plugins<br>
>><br>
>> sudo apt-get install python-qgis python-qgis-common<br>
>><br>
>> Give that a try, restart qgis and see if you have python plugin access.<br>
>><br>
>> Thanks,<br>
>> Alex<br>
>><br>
>><br>
>> On 01/28/2012 01:39 PM, Gerhardus Geldenhuis wrote:<br>
>>> Thanks Alex,<br>
>>><br>
>>> I only have "Manage Plugins" and "Python Console" on my Plugins menu and<br>
>> my<br>
>>> list of plugins does not contain qspatialite plugin. I am using 1.7.0 on<br>
>>> Ubuntu. I am trying to get the spatialite gui working at the moment as<br>
>> the<br>
>>> alternative.<br>
>>><br>
>>> Regards<br>
>>><br>
>>> <a rel="nofollow" target="_blank" href="http://www.gaia-gis.it">http://www.gaia-gis.it</a><br>
>>> On 28 January 2012 21:16, Alex Mandel <<a rel="nofollow" ymailto="mailto:tech_dev@wildintellect.com" target="_blank" href="/mc/compose?to=tech_dev@wildintellect.com">tech_dev@wildintellect.com</a>><br>
>> wrote:<br>
>>><br>
>>>> On 01/28/2012 01:08 PM, Gerhardus Geldenhuis wrote:<br>
>>>>> Hi<br>
>>>>> I have spend some time polishing the data I have and it is in csv<br>
>>>> format. I<br>
>>>>> would like to run queries on it and display a number of custom<br>
>> queries's<br>
>>>>> data on my map. I thought spatialite would be the answer but I am<br>
>>>>> struggling to connect the dots. I first tried to import the csv file<br>
>>>>> directly which worked a treat. I then exported the csv file as a SQLite<br>
>>>>> database and tried to add it as Spatialite database, that failed for<br>
>>>>> obvious reasons.<br>
>>>>><br>
>>>>> I then thought that maybe I can directly do queries on the csv<br>
>> data.... I<br>
>>>>> managed to get a query working on the data and that query now displays<br>
>>>>> different coloured dots. However I could not find this query again nor<br>
>>>> seem<br>
>>>>> to be able to change the symbology based on the query type.<br>
>>>>><br>
>>>>> My csv file contain multiple types of points which I would like to map<br>
>>>> with<br>
>>>>> different symbology. Any help would be appreciated. The manual explains<br>
>>>> how<br>
>>>>> to create a spatialite db but makes no mention of how to get data into<br>
>> a<br>
>>>>> spatialite db,<br>
>>>>><br>
>>>>> Any help would be greatly appreciated.<br>
>>>>><br>
>>>>> Best Regards<br>
>>>>><br>
>>>><br>
>>>> Try the QSpatialite plugin (from Fetch python plugins).<br>
>>>> 1. Create an empty spatial database<br>
>>>> 2. Connect and use the Upload Tables tab under which you can pick CSV as<br>
>>>> the source.<br>
>>>><br>
>>>> Alternative method, download the spatialite gui from spatialite website<br>
>>>> and use that to import the csv. Once imported QGIS will be able to see<br>
>>>> it, though you may need to create a geometry column and run an update<br>
>>>> query to populate it.<br>
>>>><br>
>>>> Enjoy,<br>
>>>> Alex<br>
<br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a rel="nofollow" ymailto="mailto:Qgis-user@lists.osgeo.org" target="_blank" href="/mc/compose?to=Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a rel="nofollow" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Gerhardus Geldenhuis<br>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Qgis-user mailing list<br><a ymailto="mailto:Qgis-user@lists.osgeo.org" href="/mc/compose?to=Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></div></blockquote></td></tr></table>