$B0B9>$5$^(B<div>$B$=$&$G$9$M!*(Bgroup by$B!!$GNI$+$C$?$G$9$M!#$"$j$,$H$&$4$6$$$^$9!#(B</div><div>$B$$$^$-(B<br><br><div class="gmail_quote">2012/11/5 $B0B9>LPN4(B <span dir="ltr"><<a href="mailto:yasue@chuogeomatics.jp" target="_blank">yasue@chuogeomatics.jp</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">$B0B9>$H?=$7$^$9!#(B<br>
$B$*@$OC$K$J$C$F$*$j$^$9!#(B<br>
<br>
PostGIS$B$N(BST_LineMerge()$B$O;HMQ$7$?$3$H$,$"$k$N$G;29M$K$J$l$P!#(B<br>
<br>
$BF1$8B0@-$GO"7k$9$k$3$H$O<!$N(BSQL$B$G=PMh$^$9!#(B<br>
create table roadmerge as<br>
select attr,((st_dump(st_linemerge(st_union(geom)))).geom)<br>
from road<br>
group by attr<br>
<br>
$B$?$@$7!"(B3$BK\0J>e$N@~$,8r$o$k2U=j$G$OA4$/O"7k$7$F$/$l$^$;$s$G$7$?!#(B<br>
$B$=$&$$$&2U=j$G$O(B2$BK\$:$D9T$&I,MW$,M-$k$h$&$G$9!#(B<br>
$B0lK\F;$J$iLdBjL5$/O"7k$G$-$k$H;W$$$^$9!#(B<br>
<br>
<br>
2012$BG/(B11$B7n(B6$BF|(B 12:36 Hiroo Imaki <<a href="mailto:hiroo@angeli.org">hiroo@angeli.org</a>>:<br>
<div><div class="h5">> $B4nB?$5$s!"3'MM(B<br>
><br>
> $B;d$bD+F|$5$s$HF1$89M$($G$9!#4pK\E*$K$O!"(BPostGIS$B$N(BST_LineMerge()$B$H(BST_UNION()$B$r;H$C$FF1$8B0@-CM$4$H$K@~$r$D$J$.9g$o$;$k$N$G$9$,!"!VF1$8B0@-CM$4$H$K!W!"$H$$$&$N$,>/$7%/%;%b%N$G$9!#$3$N>l9g!"$*$=$i$/(BPostgreSQL$B$N(BFunction$B$r:n@.$7$F!"0lC6(BDistinct$B$G%f%K!<%/$JB0@-CM$rCj=P$7$?$b$N$,=gHV$K(BST_UNION$B!J!K$N(BWHERE$B6g$K%U%#!<%I$5$l$k%k!<%W$r:n$k$3$H$K$J$k$H;W$$$^$9!#(B<br>
><br>
> $B;29M$^$G$K!#(B<br>
><br>
> $B:#LZ(B<br>
><br>
> 2012/11/5 ASAHI Kosuke <<a href="mailto:asahi@hcc.co.jp">asahi@hcc.co.jp</a>><br>
>><br>
>> $B4nB?$5$s!"$_$J$5$s(B<br>
>><br>
>> $BD+F|$G$9!#(B<br>
>><br>
>> QGIS$B$G$O$J$/$J$C$F$7$^$$$^$9$,!"(Bspatialite$B$d(BPostGIS$B$r;H$C$F(B<br>
>> ST_LineMerge()$BJU$j$+$J$H;W$C$F$$$?$N$G$9$,!"2?$b$^$H$a$F$*$j$^$;$s!#(B<br>
>>$B!!(B <a href="http://www.postgis.org/docs/ST_LineMerge.html" target="_blank">http://www.postgis.org/docs/ST_LineMerge.html</a><br>
>><br>
>> $B;n$7$F$+$i%V%m%0$K$G$b$d$jJ}$^$H$a$F%"%C%W$7$h$&$H;W$$$^$9$,!">/!9;~4V$+(B<br>
>> $B$+$k$+$b!&!&!&(B<br>
>><br>
>> (2012/11/06 10:18), Nobusuke Iwasaki wrote:<br>
>> > $B4nB?$5$s!$(B<br>
>> ><br>
>> > $B$$$o$5$-$G$9!#(B<br>
>> > $B7G<(HD$NJ}$KJVEz$,$"$,$C$F$$$^$9$,!$$A$g$C$H(BGRASS$B$G;n$7$F8+$^$7$?!#(B<br>
>> ><br>
>> > v.build.polylines $B$H$$$&%3%^%s%I$,$"$C$F!$$3$l$GJ#?t$N@~$r0l$D$N@~$K7k9g(B<br>
>> > $B$9$k$3$H$O2DG=$G$9!#$?$@$7!$Nc$K$"$C$?$h$&$KB0@-Kh$K$o$1$k$H$$$&$3$H$O$G(B<br>
>> > $B$-$^$;$s$G$7$?!#(B<br>
>> > $B!JB0@-$,0c$C$F$b!$J*M}E*$K$D$J$,$C$F$$$l$P!$0l$D$N@~$K7R$2$F$7$^$&!K(B<br>
>> ><br>
>> > $B$J$N$G!$;d$,$d$k$H$9$k$H!$(B<br>
>> > $B!&B0@-Kh$K(Bmap$B$r:n$k(B<br>
>> > $B!&$=$l$r(Bb.build.polylines$B$G@\B3$9$k(B<br>
>> > $B!&0l$D$N(Bmap$B$K$^$H$a$k(B<br>
>> ><br>
>> > $B$H$J$k$H$*$b$$$^$9!#(B<br>
>> > $B$b$7B>$K$b$$$$J}K!$,;W$$$D$/J}$,$$$i$C$7$c$$$^$7$?$i!$$h$m$7$/$*4j$$$7$^$9!#(B<br>
>> ><br>
>> ><br>
>> ><br>
>> ><br>
>> > 2012$BG/(B11$B7n(B4$BF|(B 22:18 $B4nB?9L0l(B <<a href="mailto:kou35tochas@gmail.com">kou35tochas@gmail.com</a><br>
>> > <mailto:<a href="mailto:kou35tochas@gmail.com">kou35tochas@gmail.com</a>>>:<br>
>> ><br>
>> > $B3'MM(B<br>
>> ><br>
>> > $BKL3$F;$N4nB?$G$9!#(B<br>
>> > FOSS4G TOKYO $B$*Hh$l$5$^$G$7$?!#(B<br>
>> ><br>
>> > QGIS $B=i?4<T7G<(HD$K$+$J$jA0$+$iMh$F$$$k<ALd$J$N$G$9$,!"(B<br>
>> > $B;d$K$O$o$+$i$J$$$N$G!"$o$+$kJ}$,$$$i$C$7$c$$$^$7$?$i!"(B<br>
>> > $B65$($F$$$?$@$1$J$$$G$7$g$&$+!#(B<br>
>> ><br>
>> > <a href="http://lijil.com/bbs/qgisbbs/index.php?textnum=162&PHPSESSID=bmsduqsfnk433df3er17mjbk65" target="_blank">http://lijil.com/bbs/qgisbbs/index.php?textnum=162&PHPSESSID=bmsduqsfnk433df3er17mjbk65</a><br>
>> ><br>
>> > $B%Y%/%?%a%K%e!<$NM;9g$@$H!"%]%j%4%s$O=PMh$^$9$,!"%i%$%s$O=PMh$J$$$h$&(B<br>
>> > $B$G$9!#(B<br>
>> > QGIS $B$GL5M}$G$b!"B>$N%"%W%j%1!<%7%g%s$G$G$-$k$H$+$G$b9=$$$^$;$s!#(B<br>
>> ><br>
>> > $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B<br>
>> ><br>
>> > $B4nB?9L0l(B<br>
>> ><br>
>> ><br>
>> > _______________________________________________<br>
>> > OSGeoJapan-discuss mailing list<br>
>> > <a href="mailto:OSGeoJapan-discuss@lists.osgeo.org">OSGeoJapan-discuss@lists.osgeo.org</a><br>
>> > <mailto:<a href="mailto:OSGeoJapan-discuss@lists.osgeo.org">OSGeoJapan-discuss@lists.osgeo.org</a>><br>
>> > <a href="http://lists.osgeo.org/mailman/listinfo/osgeojapan-discuss" target="_blank">http://lists.osgeo.org/mailman/listinfo/osgeojapan-discuss</a><br>
>> ><br>
>> ><br>
>> ><br>
>> ><br>
>> > --<br>
>> > $B4d:j(B $BOKE5(B<br>
>> ><br>
>> ><br>
>> ><br>
>> > _______________________________________________<br>
>> > OSGeoJapan-discuss mailing list<br>
>> > <a href="mailto:OSGeoJapan-discuss@lists.osgeo.org">OSGeoJapan-discuss@lists.osgeo.org</a><br>
>> > <a href="http://lists.osgeo.org/mailman/listinfo/osgeojapan-discuss" target="_blank">http://lists.osgeo.org/mailman/listinfo/osgeojapan-discuss</a><br>
>> ><br>
>><br>
>><br>
>> --<br>
>> $BKL3$F;CO?^3t<02q<R(B $B8&5f3+H/2](B<br>
>> $BD+F|!!9'Je(B<br>
>> mailto:<a href="mailto:asahi@hcc.co.jp">asahi@hcc.co.jp</a><br>
>> Tel : 0166-62-4711<br>
>><br>
>> _______________________________________________<br>
>> OSGeoJapan-discuss mailing list<br>
>> <a href="mailto:OSGeoJapan-discuss@lists.osgeo.org">OSGeoJapan-discuss@lists.osgeo.org</a><br>
>> <a href="http://lists.osgeo.org/mailman/listinfo/osgeojapan-discuss" target="_blank">http://lists.osgeo.org/mailman/listinfo/osgeojapan-discuss</a><br>
><br>
><br>
><br>
><br>
> --<br>
> Hiroo Imaki<br>
> <a href="mailto:hiroo@angeli.org">hiroo@angeli.org</a><br>
> <a href="http://www.geopacific.org" target="_blank">http://www.geopacific.org</a><br>
><br>
><br>
> _______________________________________________<br>
> OSGeoJapan-discuss mailing list<br>
> <a href="mailto:OSGeoJapan-discuss@lists.osgeo.org">OSGeoJapan-discuss@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/osgeojapan-discuss" target="_blank">http://lists.osgeo.org/mailman/listinfo/osgeojapan-discuss</a><br>
><br>
<br>
</div></div>---<br>
$B0B9>!!LPN4(B Shigetaka YASUE<br>
<a href="mailto:yasue@chuogeomatics.jp">yasue@chuogeomatics.jp</a><br>
$B3t<02q<RCf1{%8%*%^%A%C%/%9!!6u4V>pJsIt(B<br>
<a href="http://www.chuogeomatics.jp/" target="_blank">http://www.chuogeomatics.jp/</a><br>
TEL:<a href="tel:03%283967%291781" value="+49339671781">03(3967)1781</a><br>
FAX:<a href="tel:03%283967%291503" value="+49339671503">03(3967)1503</a><br>
--<br>
$BCO?^$+$i%8%*%^%A%C%/%9$X!%!%!%(B<br>
<div class="HOEnZb"><div class="h5">_______________________________________________<br>
OSGeoJapan-discuss mailing list<br>
<a href="mailto:OSGeoJapan-discuss@lists.osgeo.org">OSGeoJapan-discuss@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/osgeojapan-discuss" target="_blank">http://lists.osgeo.org/mailman/listinfo/osgeojapan-discuss</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Hiroo Imaki<br><a href="mailto:hiroo@angeli.org" target="_blank">hiroo@angeli.org</a><br><a href="http://www.geopacific.org" target="_blank">http://www.geopacific.org</a><br>
<br>
</div>