[Qgis-user] Converting CSV into a database

Mon Jan 30 09:52:35 PST 2012

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.

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: http://www.makeuseof.com/tag/how-to-create-your-own-custom-windows-live-cd/

Cheers,

   Brent Wood

--- On Tue, 1/31/12, Gerhardus Geldenhuis <gerhardus.geldenhuis at gmail.com> wrote:

From: Gerhardus Geldenhuis <gerhardus.geldenhuis at gmail.com>
Subject: Re: [Qgis-user] Converting CSV into a database
To: tech at wildintellect.com
Cc: qgis-user at lists.osgeo.org
Date: Tuesday, January 31, 2012, 6:18 AM

Hi Alex,The Plugin Installer if that is a plugin itself then it is not listed.
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.

This is my listed repositories:deb     http://qgis.org/debian natty maindeb-src http://qgis.org/debian natty main

and I am definitely using natty and have not upgraded my OS.
Regards

On 29 January 2012 19:10, Alex Mandel <tech_dev at wildintellect.com> wrote:

Check in the Manage Plugins menu that you have the Plugin Installer enabled.

The authentication thing is no big deal sometimes the keyservers just

aren't working. As a question of clarification which repository are you

installing QGIS from?

Thanks,

Alex

On 01/29/2012 04:40 AM, Gerhardus Geldenhuis wrote:

> Hi

> That installation unfortunately had no effect. Still no python plugin menu

> option. In addition I also get the message:

>

> WARNING: The following packages cannot be authenticated!

>   libqgis1.7.3 python-qgis python-qgis-common

> Install these packages without verification [y/N]? y

>

> which I ignored

>

> I ran sudo ldconfig thinking maybe a link somewhere is missing but that did

> not do the trick either. The packages were installed previously:

>

> Preparing to replace python-qgis 1.4.0+12730-5ubuntu1 (using

> .../python-qgis_1.7.3-1~natty1_i386.deb) ...

> Unpacking replacement python-qgis ...

> Preparing to replace python-qgis-common 1.4.0+12730-5ubuntu1 (using

> .../python-qgis-common_1.7.3-1~natty1_all.deb) ...

>

> so maybe there is something else wrong?

>

> Regards

>

> On 28 January 2012 21:46, Alex Mandel <tech_dev at wildintellect.com> wrote:

>

>> A classic problem we really need to tackle better: you're missing the

>> python-qgis package or maybe the base plugins

>>

>> sudo apt-get install python-qgis python-qgis-common

>>

>> Give that a try, restart qgis and see if you have python plugin access.

>>

>> Thanks,

>> Alex

>>

>>

>> On 01/28/2012 01:39 PM, Gerhardus Geldenhuis wrote:

>>> Thanks Alex,

>>>

>>> I only have "Manage Plugins" and "Python Console" on my Plugins menu and

>> my

>>> list of plugins does not contain qspatialite plugin. I am using 1.7.0 on

>>> Ubuntu. I am trying to get the spatialite gui working at the moment as

>> the

>>> alternative.

>>>

>>> Regards

>>>

>>>  http://www.gaia-gis.it

>>> On 28 January 2012 21:16, Alex Mandel <tech_dev at wildintellect.com>

>> wrote:

>>>

>>>> On 01/28/2012 01:08 PM, Gerhardus Geldenhuis wrote:

>>>>> Hi

>>>>> I have spend some time polishing the data I have and it is in csv

>>>> format. I

>>>>> would like to run queries on it and display a number of custom

>> queries's

>>>>> data on my map. I thought spatialite would be the answer but I am

>>>>> struggling to connect the dots. I first tried to import the csv file

>>>>> directly which worked a treat. I then exported the csv file as a SQLite

>>>>> database and tried to add it as Spatialite database, that failed for

>>>>> obvious reasons.

>>>>>

>>>>> I then thought that maybe I can directly do queries on the csv

>> data.... I

>>>>> managed to get a query working on the data and that query now displays

>>>>> different coloured dots. However I could not find this query again nor

>>>> seem

>>>>> to be able to change the symbology based on the query type.

>>>>>

>>>>> My csv file contain multiple types of points which I would like to map

>>>> with

>>>>> different symbology. Any help would be appreciated. The manual explains

>>>> how

>>>>> to create a spatialite db but makes no mention of how to get data into

>> a

>>>>> spatialite db,

>>>>>

>>>>> Any help would be greatly appreciated.

>>>>>

>>>>> Best Regards

>>>>>

>>>>

>>>> Try the QSpatialite plugin (from Fetch python plugins).

>>>> 1. Create an empty spatial database

>>>> 2. Connect and use the Upload Tables tab under which you can pick CSV as

>>>> the source.

>>>>

>>>> Alternative method, download the spatialite gui from spatialite website

>>>> and use that to import the csv. Once imported QGIS will be able to see

>>>> it, though you may need to create a geometry column and run an update

>>>> query to populate it.

>>>>

>>>> Enjoy,

>>>> Alex

_______________________________________________

Qgis-user mailing list

Qgis-user at lists.osgeo.org

http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Gerhardus Geldenhuis

-----Inline Attachment Follows-----

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120130/679c5b67/attachment.html>