<!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>
Regarding my question yesterday. I am again trying to depict the attributes already mentioned:<BR>
<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 and into a new table in my database, tbl_attributes. This table also contains the attributes I need.<BR>
<BR>
tbl_attributes<BR>
"SECTION_ID","X_ANFANG","Y_ANFANG","X_ENDE","Y_ENDE","Baujahr","Laenge","Gebiet","MTiefe","KNutzung","Material","PArt","PBreite","PHoehe","ANALYSIS_CHAPTER"<BR>
1,3400630.04,5718486.603,3400639.238,5718515.776,1982,30.59,"Niederaden",2.88,1,"Beton",1,300,300,1<BR>
182,3400639.238,5718515.776,3400648.641,5718546.057,1982,31.71,"Niederaden",3.77,1,"Beton",1,300,300,1<BR>
<BR>
2. I created a new file with an awk-programm:<BR>
L 2 11<BR>
3400630.04 5718486.603<BR>
3400639.238 5718515.776<BR>
1 1<BR>
6 6<BR>
7 7<BR>
8 8<BR>
9 9<BR>
10 10<BR>
11 11<BR>
12 12<BR>
13 13<BR>
14 14<BR>
15 15<BR>
L 2 11<BR>
3400639.238 5718515.776<BR>
3400648.641 5718546.057<BR>
1 1<BR>
6 6<BR>
7 7<BR>
8 8<BR>
9 9<BR>
10 10<BR>
11 11<BR>
12 12<BR>
13 13<BR>
14 14<BR>
15 15<BR>
Each line having a series of layers each associated to a category number!? Is this right?<BR>
<BR>
3. I could load these data with v.in.ascii into GRASS<BR>
<BR>
4. And I also could connect this vector file with the tbl_attributes in my DB <BR>
<BR>
The problem is when I try to display the data. Using QGIS I realised that the entire vector file takes the attributes from the first record!!??? I tried the same with GRASS using d.vect.thematic and have the same problem:( What did I do wrong? I don't find out the answer. Any ideas????<BR>
<BR>
Thanks<BR>
<BR>
Jorge<BR>
<BR>
<BR>
<BR>
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>
</BODY>
</HTML>