[Qgis-user] Converting CSV into a database

Alex Mandel tech_dev at wildintellect.com
Mon Jan 30 11:13:43 PST 2012


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
>>>>




More information about the Qgis-user mailing list