<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<DEFANGED_META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<DEFANGED_META content="MSHTML 5.00.2614.3500" name=GENERATOR>
<!-- <DEFANGED_STYLE> --> </DEFANGED_STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV><FONT face=Arial size=2>
Juanse</FONT></DIV>
<DIV><FONT face=Arial size=2>Richard</FONT></DIV>
<DIV><FONT color=#800080 face=Arial size=2>Juanse</FONT></DIV>
<DIV><FONT face=Arial size=2><BR> </DIV></FONT>
<BLOCKQUOTE class=cite cite type="cite">
<DIV><FONT face=arial size=2>after reading and trying, trying and reading,
it seem that postgis file structure is not suited for grass5.1 postgrass
directly reading.</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE>
<DIV><BR>This gives a good overview:<BR><A
href="http://www.ing.unitn.it/~grass/proceedings/proceedings/pdfs/Blazek_Radim.pdf"
eudora="autourl">http://www.ing.unitn.it/~grass/proceedings/proceedings/pdfs/Blazek_Radim.pdf</A><BR></DIV>
<DIV><FONT color=#800080 face=Arial size=2>I been over it, also over the pdf
of <A
href="http://www.rcost.unisannio.it/antoniol/students/PostGrass/">http://www.rcost.unisannio.it/antoniol/students/PostGrass/</A></FONT></DIV>
<DIV><FONT color=#800080 face=Arial size=2>also others of
topology.</FONT></DIV>
<BLOCKQUOTE class=cite cite type="cite"><BR><FONT face=arial size=2>In fmrt
files i am ask to provide several fields for grass to be able to find the
geometry and category data.</FONT><BR> <BR><FONT face=arial
size=2>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?).</FONT></BLOCKQUOTE>
<DIV><BR>I don't think it is a string, I think it is a BLOB (a Binary Large
OBject) and PostgreSQL displays it as a string (with the help of PostGIS). And
where do you see this "<FONT face=arial size=2>constrain at the end that tell
pgsql how this string is constructed"?<BR></FONT></DIV>
<DIV><FONT face=arial size=2><FONT color=#800080>You are probably right, if i
do ssh \d rios in the type description of wkb_geometry column i get geometry
as type and at the end of the table's type table i get this
sentence.</FONT></FONT></DIV>
<DIV><FONT face=arial size=2><FONT color=#800080><BR><FONT
color=#000000>Unique keys: rios_ogc_fid_key<BR>Check constraints: "$1"
(srid(wkb_geometry) =
-1)<BR>
"$2" ((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS
NULL))</FONT></FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=arial size=2><FONT color=#800080>What is this BLOB type? How
do you decompose it?</FONT></FONT></DIV>
<DIV><FONT face=arial size=2><FONT color=#800080></FONT></FONT> </DIV>
<DIV><FONT face=arial size=2><FONT color=#800080>I must recall i am doing an
on purpose very long turn/detour/datajuggling, just to stress posibilities: An
original ArcInfo E00 (clean and build) import77 to arcview, save as
shape, Utranslated to tab and then loaded to pgsql/gis ejercicio database
via ogr2ogr. I didn't put the correct srid, but -1 non earth plane shouldn't
matter.</FONT></FONT></DIV>
<DIV><FONT face=arial size=2><FONT color=#800080></FONT></FONT> </DIV>
<DIV><FONT face=arial size=2><FONT color=#800080>In ejercicios db i
have related tables for rios linestring layer rios: rios_ogc_fid_seq and
one tuple in geometry_columns table. I also have loaded spatial_ref_sys in
ejercicio db.</FONT></FONT></DIV>
<DIV><FONT face=arial size=2></FONT> </DIV>
<DIV><FONT face=arial size=2><FONT color=#800080>I should have started with a
point table with one attibute, but ... i know this rios very well , ja! and
all other tables/layers in ejercicios db are already online with mapserver!!
Is the front end the part at this moment. i will love to be able to connect
mapinfo to this ... but that does not depend on us.</FONT></DIV>
<BLOCKQUOTE class=cite cite type="cite">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?</FONT></BLOCKQUOTE>
<DIV><BR>This might help:<BR><A
href="http://mapserver.gis.umn.edu/wilma/mapserver-users/0110/msg00283.html"
eudora="autourl">http://mapserver.gis.umn.edu/wilma/mapserver-users/0110/msg00283.html</A><BR></DIV>
<DIV><FONT face=Arial size=2>Thanks, I will take a look:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Juanse</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><BR>---<BR>Outgoing mail is certified Virus
Free.<BR>Checked by AVG anti-virus system (<A
href="http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version: 6.0.417
/ Virus Database: 233 - Release Date:
09/11/02</FONT></DIV></BLOCKQUOTE></BODY></HTML>