<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;">Hi,<br><br>How do I create a multipart line feature class known in the ESRI world in Postgresql/postgis ?<br>What feature type is it equivalent to...umm... multilinestring or linestring or...xxxx in Postgresql PostGIS?<br><br>I have a points geom table of coordinates with attributes. Using these attributes I want to generate a linestring or multilinestring where ever the attribute is active with a 1. So I need some SQL statement here to do this somehow.<br><br>below is an example of how the raw data looks the attributes are class1 and class2 <br><br>table name: raw_data (type: point srid 4326)<br><br>id;track_id;Lat;Long;Alt;DTime;SoG;DOP;class1;class2<br>1,35,46.596805,14.27998,392.4,2008-10-10 06:48:24,9.11184,8.4,0,1<br>2,35,46.5969333333333,14.2799983333333,390.2,2008-10-10 06:48:29,9.76004,8.4,0,1<br>3,35,46.597085,14.2800533333333,388.2,2008-10-10 06:48:38,8.01916,8.4,1,0<br>4,35,46.5972883333333,14.280115,387.8,2008-10-10 06:48:46,8.48216,7.8,1,1<br>5,35,46.5973966666667,14.280215,386.9,2008-10-10 06:48:53,9.8156,7.8,1,1<br>6,35,46.5975683333333,14.2803133333333,386.3,2008-10-10 06:49:01,8.48216,7.8,0,0<br>7,35,46.597785,14.2803816666667,387.3,2008-10-10 06:49:08,8.77848,7.8,1,1<br>8,35,46.597955,14.2804516666667,386.3,2008-10-10 06:49:14,11.03792,7.8,1,1<br>9,35,46.5981683333333,14.2805466666667,386.9,2008-10-10 06:49:21,10.2786,7.8,0,1<br><br>class1 0,0,1,1,1,0,1,1,0<br>class2 1,1,0,1,1,0,1,1,1<br><br>For class1 I should have 2 new line segments<br>For class2 I should have 3 new line segments<br><br>thanks for any help rusty on the SQL<br><br>michael<br><br>m.diener@gomogi.com<br><br><a href="http://www.gomogi.com" mce_href="http://www.gomogi.com"><br></a></span></body></html>