[postgis-users] RE: [GRASSLIST:5069] RE: Grass to Postgres

[Juanse]

This is a multi-part message in MIME format.

---------------------- multipart/alternative attachment
Right, it is actually not that simple to read a postgresql/postgis layer =
from grass5.1

after reading and trying, trying and reading, it seem that postgis file =
structure is not suited for grass5.1 postgrass directly reading.

In fmrt files i am ask to provide several fields for grass to be able to =
find the geometry and category data.

Postgis stores in one column in my case wkb_geometry, a string =
identifying at the same type the SRID, the geometry type and the actual =
geometry in wkb, with a constrain at the end that tell pgsql how this =
string is constructed (Am i right?).

Has anyone build a protocol or sql sentence to prepare a postgis table =
for the grass requiered format: ie separate geometry from category with =
the same ID on both tables, and in the geometry table separate the =
geometry from the geometry type?

which geometry type are allowed in Grass, i have an int4 from >0 to < 5, =
which are those? which int is equivalente to point, which to line, which =
to polyline, which to area and so on?

Juanse
temuko-Chile



  ----- Original Message -----=20
  From: Juanse=20
  To: Richard Greenwood=20
  Cc: postgis-users@postgis.refractions.net ; GRASSList@baylor.edu=20
  Sent: Monday, November 25, 2002 9:04 PM
  Subject: [GRASSLIST:5069] RE: Grass to Postgres


  I have pass the first wall. I need some Grass help.

  what is the meaning of Location, mapset and database.

  I sort get that they are related to the actual path where the data is? =
Am i correct?

  I have made the following dir structure

  Inside Home i have created Mapa dir, and inside it a vector dir and =
inside it a rio dir

  /home
  /home/mapa
  /home/mapa/vector
  /home/mapa/vector/rio

  inside rio i have make two files:
   head (with nothing in it)
  =20
  and frmt with
  FORMAT:postgis
  HOST:192.168.0.1
  PORT:5432  =20
  DATABASE:ejercicio
  USER:postgres
  PASSWORD:xxxx
  GEOM_TABLE:rios
  CAT_TABLE:rios
  #GEOM_ID:
  #GEOM_TYPE:
  #GEOM_GEOM:
  #CAT_ID:
  #CAT_FIELD:
  #CAT_CAT:

  rios is a NTAM table in ejercicio. I am using it again for categories. =
Is that all right or i have to separate geometry from categories in =
pgsql/gis?

  after running grass51 i have set

  location:    vector
  Mapset:     rio
  database: /home/mapa/
  <esc><enter>

  welcome to grass 5.1
  bla bla bla
  GRASS:/home/map/vector/rio> d.mon start=3Dx0
  d.mon: error while lodaing shared libraries: libpd.so: cannot open =
shared object file: No such file or directory.

  GRASS:/home/map/vector/rio>

  where do i have the mistake?

  Do I need that pqsql library installed in the client machine? why?
  Is is already installed on the pgsql server.

  Do i need to make this path structure by hand for each layer i want to =
use in grass eventhough they are all stored in the same pgsql/GIS =
database?

  Juanse
  temuko-Chile

    ----- Original Message -----=20
    From: Richard Greenwood=20
    To: Juanse=20
    Sent: Monday, November 25, 2002 8:16 PM
    Subject: Re: Grass to Postgres


    It is no bother at all, but I'm afraid that I have not tried =
connecting to PostGIS from GRASS. I have only used PostGIS with =
MapServer. Keep trying on the GRASS list and maybe try asking the =
Refractions guys for help. And please post your finding because I would =
like to give it a try if I ever find some time.

    Best regards,
    Rich

    At 08:09 PM 11/25/2002 -0300, you wrote:

      Hi Richard
      =20
      Sorry to bother directly but seem that this Grass to Postgres is =
to much for a new comer.
      =20
      have you tried it yet?
      =20
      can i bother with some questions?
      =20
      Having the data already in postgreSQL/PostGIS, how to read it with =
Grass?
      =20
      I am making the head and frmt, but have question as to the =
definition of various entries, the same applies for location, mapset and =
database.
      =20
      Juanse
      temuko-Chile
      =20
      =20

      ---
      Outgoing mail is certified Virus Free.
      Checked by AVG anti-virus system (http://www.grisoft.com).
      Version: 6.0.417 / Virus Database: 233 - Release Date: 08/11/02

    Richard W. Greenwood, PLS
    Greenwood Mapping, Inc.
    Rich@GreenwoodMap.com
    (307) 733-0203
    http://www.GreenwoodMap.com=20


---------------------- multipart/alternative attachment
An HTML attachment was scrubbed...
URL: http://lists.refractions.net/pipermail/postgis-users/attachments/20021125/97241a1d/attachment.htm

---------------------- multipart/alternative attachment--