[Qgis-user] Qgis, Postgres Data exchange, Graticule

[Bernhard Ströbl]

Hi Marco,

just to give you the direction:

if you have PostGIS installed (very much recommended) add a point 
geometry column to the table
SELECT addGeoemtryColumn 
http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2574409
and populate it with point geometries:
UPDATE table set geom_column = ST_PointFromText('POINT(' || 
cast(longitude as varchar) || ' ' || cast(latitude as varchar) || ')')

after that you can access your data directly from within QGIS.


Marco schrieb:
> 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 

An easier way to create a delimited text file is to use PostgreSQL's 
COPY command.


Bernhard
> 
> 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> 
> 
>  
> 
> 
> 
> ________ Information from NOD32 ________
> This message was checked by NOD32 Antivirus System for Linux Mail Server.
> http://www.nod32.com
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> 
> ________ Information from NOD32 ________
> This message was checked by NOD32 Antivirus System for Linux Mail Server.
> http://www.nod32.com



________ Information from NOD32 ________
This message was checked by NOD32 Antivirus System for Linux Mail Server.
http://www.nod32.com