AW: [Qgis-user] Qgis, Postgres Data exchange, Graticule
Möri Cedric
Cedric.Moeri at bd.so.ch
Thu Sep 16 09:22:26 PDT 2010
Hi Marco
do you have PostgreSql/PostGIS or is it only a "naked" Postgresql? Things would be a lot easier with Postgis:
Create a view with a column of type geometry from your lat/lon columns (and the rest of your columns of course) and it should then work with the postresql/postgis connector.
About the graticule: you may add a grid in the print composer. Just add a map item to your composer and choose 'show grid' in the Grid section of the map item.
regards
Cédric
mit freundlichen Grüssen
Cédric Möri
GIS-Informatiker
--
Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
Rötistrasse 4
4501 Solothurn
Telefon: +41 (0)32 627 24 75
Telefax: +41 (0)32 627 22 14
mailto:cedric.moeri at bd.so.ch
http://www.agi.so.ch
----- Originalnachricht -----
Von: Marco <mklicker at gmx.net>
Gesendet: Don, 16.9.2010 17:43
An: qgis-user at lists.osgeo.org
Betreff: [Qgis-user] Qgis, Postgres Data exchange, Graticule
Dear Qgis community and experts,
it is only some days since I try to use qgis (Tethys) and have to confess
that it is a great GIS compliation.
Maybe I can trigger an improvement, maybe there already is a solution for
the tiny problem I have.
I would like to directly get postgres - data into qgis with a few mouse
clicks
Having Data in a postgres database like:
Header: Place, Zipcode, number of oaktrees, latitude, longitude, alitude
Data: Horn, 32805, 123090, 8.91, 51,87, 270
.
.
.
Data: ...,...,
The workaround I'm using now is to copy paste the data queried by pgadmin
into MS-Editor, add a header, save it as a textfile
and from qgis using the Delimited Text Plugin !
This works, but I'd like to get it more easy and maybe in addition to
connect to a Postgres-view for easy update.
Using the PostGIS/Postgres connection fails because the data available is
not compliant.
By the way, in the Kore version of QGis a graticule tool was available. Is
there such a tool for Tethys too? So, how to add a graticule to a
qgis(Tethys)-map?
I would be very grateful receiving your helpful suggestions.
All the best
Marco Klicker
Clara-Schumann Str. 22
41352 Korschenbroich
Germany
mklicker at gmx.net <mailto:Mmklicker at gmx.net>
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
More information about the Qgis-user
mailing list