[Qgis-user] Converting CSV into a database

[Gerhardus Geldenhuis]

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
>



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