<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.12.2">
</HEAD>
<BODY>
Hi,<BR>
<BR>
I need to do the following:<BR>
<BR>
Display a sewer network and generate charts with classification in a colour scale based on attributes like Age, Material, Diameter, etc.<BR>
<BR>
Data are in a MySQL database:<BR>
<BR>
The network is geometrically defined by the relationship between these two tables:<BR>
<BR>
tbl_line:<BR>
"LINE_ID","FROM_NODE_ID","TO_NODE_ID"<BR>
1,1,2<BR>
tbl_node<BR>
"NODE_ID","X_COORDINATE","Y_COORDINATE","Z_COORDINATE","NET_TYPE_ID"<BR>
1,3400630.04,5718486.603,,1,<BR>
<BR>
Assuming that attributes where also stored in the same table: tbl_line, which is not the case, how would be the better way to perform this task? Attributes are actually stored in another table, tbl_basedata, which is in the same database and has a 1:c relationship to tbl_line.<BR>
<BR>
So far I have managed to connect to the MySQL-database but cannot figure out how to further proceed.<BR>
<BR>
Previously I had tried following workaround:<BR>
1.I performed a MySQL-query on tbl_node and tbl_line to obtain the couples of points defining a line and stored this in a .csv-file. <BR>
2. From this I created a new file with an awk-programm like this:<BR>
#'X_COORDINATE, Y_COORDINATE'<BR>
L 2 0<BR>
3400630.04 5718486.603<BR>
3400639.238 5718515.776<BR>
L 2 0<BR>
3400639.238 5718515.776<BR>
3400648.641 5718546.057<BR>
L 2 0<BR>
3400648.641 5718546.057<BR>
3400665.041 5718562.99<BR>
L 2 0<BR>
3400665.041 5718562.99<BR>
3400625.996 5718597.349<BR>
L 2 0 <BR>
3.I successfully imported this with v.in.ascii and can depict the geometry.<BR>
<BR>
But I don't think that is the most logical way to do it as GRASS can connect directly to the DB. Any suggestions???<BR>
<BR>
Thanks in advance<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
Jorge Echeverri<BR>
SP
</TD>
</TR>
</TABLE>
</BODY>
</HTML>