[Qgis-user] Converting CSV into a database

[Alex Mandel]

Ah it's a python dependency. So at the terminal:
sudo easy_install pyspatialite

That should pull down the python package from pypi, which is a python
way of managing python add ons. It's outside the usual ubuntu packaging
but generally is more up to date.

Enjoy,
Alex

On 01/30/2012 11:18 AM, Gerhardus Geldenhuis wrote:
> Cool,
> I did all that and it works kind of but I now get:
> 
> PySpatiaLite python module is required for QSpatiaLite
> 
> 
> I have installed every available Spatialite package:
> 
> 
> libspatialite-dev install
> 
> libspatialite2 install
> 
> libspatialite3 install
> 
> spatialite-bin install
> 
> Thoughts? Maybe 2 and 3 is clashing? I can try and remove spatialite and
> qgis completely again and try a reinstall. I did not remove spatialite when
> I did the qgis reinstall.
> 
> Regars
> 
> On 30 January 2012 19:13, Alex Mandel <tech_dev at wildintellect.com> wrote:
> 
>> Add 3rd Party Repos.
>> http://www.qgisworkshop.org/html/workshop/python_in_qgis_tutorial1.html
>>
>> Then look for the QSpatialite plugin.
>>
>> Enjoy,
>> Alex
>>
>> On 01/30/2012 11:04 AM, Gerhardus Geldenhuis wrote:
>>> Ok,
>>> Complete removal and re-installation seem to have done the trick.
>>> Thank you very much for all the help so far.
>>>
>>> I can see the correct menus now and the Plugin Installer Plugin is
>>> installed and working. However the plugin listings is very limited. Any
>> way
>>> to get more python plugins listed?
>>> This is the repositories I have listed:
>>> http://pyqgis.org/repo/official
>>>
>>> after browsing to that I have now added user contributed. Could this be
>>> installed by default perhaps?
>>>
>>> Regards
>>>
>>> On 30 January 2012 18:18, Alex Mandel <tech_dev at wildintellect.com>
>> wrote:
>>>
>>>> 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
>>
> 
> 
>