[Qgis-user] Converting CSV into a database

[Alex Mandel]

Gerhardus,

I wonder if something is strange with the main qgis packages. I suggest
trying the packages from Ubuntugis repositories instead, as detailed here:

http://hub.qgis.org/projects/quantum-gis/wiki/Download#Ubuntu-With-updated-dependencies

So try to remove your current install, change your repos, and the update
and install again, making sure to grab the python-qgis too.

Thanks,
Alex

On 01/30/2012 09:18 AM, Gerhardus Geldenhuis wrote:
> 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 main
> deb-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
>>
> 
> 
> 
> 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user