[Qgis-user] Converting CSV into a database

Gerhardus Geldenhuis gerhardus.geldenhuis at gmail.com
Mon Jan 30 11:04:16 PST 2012 

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
>
> _______________________________________________
> 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/96015869/attachment.html>

More information about the Qgis-user mailing list