[Qgis-user] Converting CSV into a database

[Agustin Lobo]

Gerhardus,
1. In http://hub.qgis.org/projects/quantum-gis/wiki/Download
scroll down to Ubuntu then Ubuntu: With updated dependencies¶
and use the ubuntugis-unstable repositories. Unselect the ones you
have to avoid duplicity.
This is what I use and works fine

2. Not sure I understand your problem with the Plugin Installer, but
this page could help you:
http://sites.google.com/site/eospansite/qgis-installation/qgisinitcustom

Agus

2012/1/30 Gerhardus Geldenhuis <gerhardus.geldenhuis at gmail.com>:
> 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
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>