[postgis-users] shp2pgsql: Where are x,y-coordinates stored?

H.Lekin h.lekin at gmx.net
Mon Aug 7 06:44:59 PDT 2006


Hi!

I am doing my very first steps in this area...

I imported a sample .shp into PostgreSQL/PostGIS using shp2pgsql. Now I
wish to access this map from GRASS. For the GRASS command v.in.db, the x
and y column name must be specified:

GRASS 6.0.2> v.in.db help
Description:
 Create new vector (points) from database table containing coordinates.
Usage:
 v.in.db driver=name database=name table=name x=name y=name [z=name]
   key=name output=name
Parameters:
    driver   Input driver name
             options: odbc,dbf,mysql,pg,ogr
             default: pg
  database   Input database name
             default: gistest
     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

Where are these columns hidden?

Thanks a lot in advance for any help,
H.Lekin



More information about the postgis-users mailing list