Hi,
For those of you who knows ArcView 3x: I want to make an event theme
from a table fetched from postgresql.
For you others: Is there any simple way to plot points stored (with
geographical coordinates) in postgresql on a map? As far as I can see,
the old command d.site.pg could do what I wantet, but that is removed
now, and I cannot see if any of the other d.* commands can plot
something directly from postgres (withouh the postgis layer installed)
Morten
Hello Morten,
On Mon, 5 Sep 2005 11:42:53 +0200 "Morten Sickel"
<Morten.Sickel@nrpa.no> wrote:
Hi,
For those of you who knows ArcView 3x: I want to make an event theme
from a table fetched from postgresql.For you others: Is there any simple way to plot points stored (with
geographical coordinates) in postgresql on a map? As far as I can see,
the old command d.site.pg could do what I wantet, but that is removed
now, and I cannot see if any of the other d.* commands can plot
something directly from postgres (withouh the postgis layer installed)
Try using v.in.db:
GRASS 6.1.cvs (spearfish57):~ > v.in.db -help
Beschreibung:
Create new vector (points) from database table containing coordinates.
Benutzung:
v.in.db driver=name database=name table=name x=name y=name [z=name]
key=name output=name
Parameter:
driver Input driver name
Optionen: odbc,dbf,pg,ogr
Standard: dbf
database Input database name
Standard: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
table Input table name
x x column name
y y column name
z z column name
key category column name
output Name of vector output file
GRASS 6.1.cvs (spearfish57):~ >
More information about the module can be cound here:
http://grass.itc.it/grass61/manuals/html61_user/v.in.db.html
Best regards
Stephan
--
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office - Mengendamm 16d - D-30177 Hannover
Internet: www.gdf-hannover.de - Email: holl@gdf-hannover.de
Phone : ++49-(0)511.39088507 - Fax: ++49-(0)511.39088508