[Qgis-user] Converting CSV into a database

Mon Jan 30 10:19:30 PST 2012

Hi
I will give that a go and then report back.

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