v.in.db driver=pg database="host=myserver.itc.it,dbname=mydb,user=name" \ table=pat_stazioni x=east y=north z=quota key=id output=pat_stazioni
If an ID column is not not present in the PostgreSQL table,
the 'object ID' of PostgreSQL can be used. In this case set:
cat=OID
2) Creating a map from PostGIS: To extract coordinate values from PostGIS, functions have to be used:
v.in.db driver=pg database="host=myserver.itc.it,dbname=mydb,user=name" \ table=station x="x(geom)" y="y(geom)" z="z(geom)" key=id out=meteostations
If an ID column is not not present in the PostgreSQL table,
the 'object ID' of PostgreSQL can be used. In this case set:
cat=OID
3) Import of a points table (x, y, z) from DBF file to vector points map:
The DBF file has to be copied into $MAPSET/dbf/ (to be created if not existing yet). Then the DBMI needs to be connected to this directory:
#check current DB settings: db.connect -p #only needed, if not already defined: db.connect driver=dbf database='$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/' #create vector map from DBF table ('idcol' is containing unique row IDs): v.in.db table=pointsfile x=x y=y z=z key=idcol out=dtmpoints #check result: v.info dtmpoints v.info -c dtmpoints
If an ID column is missing in the DBF file, such a column with unique IDs has to be added beforehand.
Last changed: $Date$