[GRASSLIST:8173] Re: Plotting points from postgresql

[Stephan Holl]

Hello Morten, 

On Mon, 5 Sep 2005 11:42:53 +0200 "Morten Sickel"
<Morten.Sickel at 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 at gdf-hannover.de
Phone : ++49-(0)511.39088507       -        Fax: ++49-(0)511.39088508