[Qgis-user] Converting CSV into a database

Gerhardus Geldenhuis gerhardus.geldenhuis at gmail.com
Mon Jan 30 11:38:24 PST 2012 

Excellent
Thank you very much. That finally did the trick. I had to do an extra
apt-get for easy_install but there after all was fine.

It also means I can do all my work without having to reboot into Windows
which is a great time saver.

Regards

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

> 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
> >>
> >
> >
> >
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>



-- 
Gerhardus Geldenhuis
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120130/505e447c/attachment.html>

More information about the Qgis-user mailing list