[Qgis-user] Converting CSV into a database

[Alex Mandel]

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