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