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:[email protected] http://www.agi.so.ch ----- Originalnachricht ----- Von: Marco <[email protected]> Gesendet: Don, 16.9.2010 17:43 An: [email protected] 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 [email protected] <mailto:[email protected]> _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
