[Qgis-user] Converting CSV into a database

[Gerhardus Geldenhuis]

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/20120129/45fa626f/attachment.html>