[GRASS-user] postgresql driver

GRASS GRASS user
1

Hi!

I have postgresql table with point data type column "mypointloc". When i have tried to create vectors (points) object in GRASS 6.2.2

v.in.db driver=pg database="localhost,dbname=aeronet" table=mytable x=mypointloc[0] y=mypointloc[1] key=myid output=mynewtable

I have got message " WARNING: pg driver: column 'mypointloc', type 600 is not supported"!
Result table "mynewtable" have not x and y columns.

How I have create vectors(points) objects from postgresql table?

Is it possible to create new vectors(points) without creation new attribute table?

Thanks & Regards

Basil

2

hi,

Vassily Poddubny píše v Út 26. 02. 2008 v 20:18 +0500:

Hi!

I have postgresql table with point data type column "mypointloc". When i
have tried to create vectors (points) object in GRASS 6.2.2

v.in.db driver=pg database="localhost,dbname=aeronet" table=mytable
x=mypointloc[0] y=mypointloc[1] key=myid output=mynewtable

I have got message " WARNING: pg driver: column 'mypointloc', type 600
is not supported"!
Result table "mynewtable" have not x and y columns.

afaik you have to specify two new collumns of types (float or double),
for x and y coordinates.

grass does not support "point" column type used in potgresql

How I have create vectors(points) objects from postgresql table?

Is it possible to create new vectors(points) without creation new
attribute table?

yes, v.in.ascii should do the job

jachym

Thanks & Regards

Basil

_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

--
Jachym Cepicky
e-mail: jachym.cepicky gmail com
URL: http://les-ejk.cz
GPG: http://www.les-ejk.cz/pgp/jachym_cepicky-gpg.pub

3

Hi, Jachym!

Thanks!

Jachym Cepicky пишет:

hi,

Vassily Poddubny píše v Út 26. 02. 2008 v 20:18 +0500:

Hi!

I have postgresql table with point data type column "mypointloc". When i have tried to create vectors (points) object in GRASS 6.2.2

v.in.db driver=pg database="localhost,dbname=aeronet" table=mytable x=mypointloc[0] y=mypointloc[1] key=myid output=mynewtable

I have got message " WARNING: pg driver: column 'mypointloc', type 600 is not supported"!
Result table "mynewtable" have not x and y columns.

afaik you have to specify two new collumns of types (float or double),
for x and y coordinates.

grass does not support "point" column type used in potgresql

Does you mean - it is better do not use postgresql tables with point type? It is strange for me!

How I have create vectors(points) objects from postgresql table?

Is it possible to create new vectors(points) without creation new attribute table?

yes, v.in.ascii should do the job

OK! I think it is lucky thought. I will try to create ascii file from postgresql table and then I will use v.in.ascii.
Thank you!

Basil

4

Hi,
Jachym Cepicky píše v Út 26. 02. 2008 v 16:17 +0100:

hi,

afaik you have to specify two new collumns of types (float or double),
for x and y coordinates.

grass does not support "point" column type used in potgresql

no, it does not (afaik) support any "point" type in any database. even
postgis implements point type on it's own. you can also store the data
in postgis and import them to grass via v.in.ogr

adding support for the "point" type for postgresql should not be that
hard...

you can also use `"SELECT point FROM your_table"|v.in.ascii out=points`
approach

jachym

--
Jachym Cepicky
e-mail: jachym.cepicky gmail com
URL: http://les-ejk.cz
GPG: http://www.les-ejk.cz/pgp/jachym_cepicky-gpg.pub