$B;3<jMM(B<div><br></div><div>$B$J$K$r%7%s%0%k%/%)!<%F!<%7%g%s$G0O$a$P$$$$$N$G$7$g$&$+!#(B</div><div>$B%m!<%I$7$h$&$H$7$F$$$k%7%'!<%W%U%!%$%k$NB0@-%G!<%?$O!"(B</div><div>$B!V(Brinhan$B!W0l$D$@$1$G!"%G!<%?7?$O?tCM$G$9!#(B</div><div><br></div><div>$B%7%'!<%W%U%!%$%k<+BN$,!"%@%a$J$N$G$7$g$&$+!#(B</div><div><br></div><div>$B4nB?9L0l(B</div><div><br><div class="gmail_quote">
2012$BG/(B1$B7n(B25$BF|(B23:26 <span dir="ltr"><<a href="mailto:arctic_tern@mf-atelier.sakura.ne.jp">arctic_tern@mf-atelier.sakura.ne.jp</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
$B4nB?MM(B<br>
<br>
$B;3<j$H?=$7$^$9!#(B<br>
$B@h$[$I$N%"%s%@!<%9%3%"$O4X78$J$5$=$&$G$9!#?=$7Lu$"$j$^$;$s!#(B<br>
<br>
$B$*$=$i$/J8;zNs7?$r%m!<%I$7$h$&$H$5$l$F$$$k$+$H;W$o$l$^$9$,!"(B<br>
$BJ8;zNs$O%7%s%0%k%/%)!<%F!<%7%g%s$G0O$`$Y$-$H$"$j$^$7$?!#(B<br>
<br>
<a href="http://www.dbonline.jp/sqlite/type/index4.html" target="_blank">http://www.dbonline.jp/sqlite/type/index4.html</a><br>
<br>
$B0l1~%=!<%9%3!<%I$b3NG'$7$F$_$^$7$?$,!":G8e$NJ8;z$,%7%s%0%k%/%)!<%F!<%7%g%s$G$"$l$PJ8;zNs$H$5$l$k$h$&$K8+$($^$9!#(B<br>
$B$=$N$[$+!"IT@5%H!<%/%s$H$J$k%1!<%9$G4X78$,$"$j$=$&$J$N$,!"?t;z!\J8;zNs$N>l9g$N$h$&$G$9!#(B<br>
$B>e5-$N$h$&$K%7%s%0%k%/%)!<%F!<%7%g%s$G0O$a$PLdBj$"$j$^$;$s$,!"0O$s$G$$$J$$>l9g$O@hF,J8;z$r8+$F?tCM7?$HG'<1$9$k$h$&$G$9!#(B<br>
<br>
$B0J>e!"$4;29M$K$J$l$P9,$$$G$9!#(B<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
> $B;3<jMM(B $B$_$J$5$^(B<br>
> $B%"%s%@!<%9%3%"$r30$7$F$bF1$8$G$7$?!#(B<br>
> $B$=$N$[$+$K2?$+860x$,$"$k$N$G$7$g$&$+!#(B<br>
><br>
> $B4nB?9L0l(B<br>
><br>
> $BA0$N%a!<%k$OL>A0$r=q$-K:$l$F$$$^$7$?!#$9$_$^$;$s!#(B<br>
><br>
><br>
> 2012$BG/(B1$B7n(B25$BF|(B22:17 <<a href="mailto:arctic_tern@mf-atelier.sakura.ne.jp">arctic_tern@mf-atelier.sakura.ne.jp</a>>:<br>
><br>
> > $B4nB?MM(B<br>
> ><br>
> > $B$O$8$a$^$7$F!";3<j$H?=$7$^$9!#(B<br>
> > $B%(%i!<$rGR8+$7$^$7$?$,!"$*$=$i$/%"%s%@!<%9%3%"$,4^$^$l$F$$$k$N$,860x$G$O$J$$$+$H;W$o$l$^$9!#(B<br>
> > Shape$B%U%!%$%k$N%m!<%I$OFbIt$G$O(BSQL$B$G<B9T$5$l$F$$$^$9!#(B<br>
> > $B%"%s%@!<%9%3%"$O(BSQLite$B$G$O(B'%'$BEy$HF1MM$KFC<lJ8;z$J$N$G!"9=J82r@O$G%(%i!<!VG'<1$5$l$J$$%H!<%/%s!W$,=P$?$b$N$H;W$o$l$^$9!#(B<br>
> ><br>
> > $B0J>e!"$4;29M$K$J$l$P9,$$$G$9!#(B<br>
> ><br>
> > > $B$+$d$^$5$^(B $B$_$J$5$^(B<br>
> > ><br>
> > > spatialite-gui$B$G!"(BShapefile$B$r(BSpatialite$B$K%m!<%I$7$h$&$H$9$k$H!"(B<br>
> > > $BE:IU%U%!%$%k$N$h$&$J%(%i!<$,=P$^$9!#(B<br>
> > > $B$3$l$O2?$,$$$1$J$$$N$G$7$g$&$+!)(B<br>
> > ><br>
> > > $B%Q%9L>!"B0@-%G!<%?$N%U%#!<%k%IL>$J$I$O$9$Y$FH>3Q1Q?tJ8;z$G$9!#(B<br>
> > > $BB,CO7O$O(BJGD2000$BJ?LLD>3Q:BI87O(B13$B7O(B ID:2455$B$G$9!#(B<br>
> > ><br>
> > > $B$_$s$J$NCO5eCO?^$N%G!<%?Ey$O%m!<%I$9$k$3$H$O=PMh$^$9!#(B<br>
> > > $B?&>l$G;H$C$F$$$k;3$N%G!<%?$,$J$<$+%m!<%I$G$-$^$;$s!#(B<br>
> > ><br>
> > > $B$h$m$7$/$*4j$$$7$^$9!#(B<br>
> > ><br>
> > > 2012$BG/(B1$B7n(B19$BF|(B5:49 Yoichi Kayama <<a href="mailto:yoichi.kayama@gmail.com">yoichi.kayama@gmail.com</a>>:<br>
> > ><br>
> > > > $B4nB?$5$s(B<br>
> > > > $B$_$J$5$s(B<br>
> > > ><br>
> > > > $B$H$j$"$($:%V%m%0(B <a href="http://d.hatena.ne.jp/yoichi_46/" target="_blank">http://d.hatena.ne.jp/yoichi_46/</a> $B$K$^$H$a$k$D$b$j$G$9$,(B<br>
> > > > $B%m!<%I$@$1$G$9$H$=$s$J$K$b$C$?$$$V$C$?$b$s$G$b$J$$$N$G4JC1$K=q$$$F(B<br>
> > > > $B$*$-$^$9!#(B<br>
> > > ><br>
> > > > spatialite-gui$B$H$$$&%W%m%0%i%`$r%@%&%s%m!<%I$7$F;H$&$H(BShapefile$B$r(BSpatialite<br>
> > > > $B$K%m!<%I$G$-$^$9!#(B<br>
> > > ><br>
> > > > <a href="http://www.gaia-gis.it/gaia-sins/" target="_blank">http://www.gaia-gis.it/gaia-sins/</a><br>
> > > ><br>
> > > ><br>
> > > > $B$3$3$N%Z!<%8$K%=!<%9$"$j$^$9$,(BWindows$B$N>l9g$G$9$H%P%$%J%j$,$"$j$^$9!#(B<br>
> > > > $B%P%$%J%j$r%@%&%s%m!<%I$9$k$H!"%$%s%9%H!<%k$7$J$/$F$b(B spatialite_gui.exe $B$r(B<br>
> > > > $B%@%V%k%/%j%C%/$9$k$H%W%m%0%i%`5/F0$7$^$9!#!J#W#i#n$N>l9g!K(B<br>
> > > ><br>
> > > > $B?75,$K(Bspatialite $B$N%U%!%$%k$r:n@.$9$k>l9g$O(B File$B#s%a%K%e!<$N(B Creating a New(empty) SQLite<br>
> > > > DB, $B4{B8$N%U%!%$%k$rMxMQ$9$k>l9g$O(B Connecting an existing SQLite DB $B$r(B<br>
> > > > $BA*Br$7$F2<$5$$!#(B New $B$N>l9g$O%U%!%$%k$N%Q%9L>$r;XDj$7$F2<$5$$!#(B<br>
> > > ><br>
> > > > $B%U%!%$%k$K@\B3$9$k$H%a%K%e!<$K(B Adbanced$B$H$$$&9`L\$,$G$-$^$9$N$G!"$=$3$G(BLoad Shapefile<br>
> > > > $B$rA*Br$9$k$H%U%!%$%kA*Br%@%$%"%m%0$,I=<($5$l$k$N$G!"$=$3$G(B Shapefile$B$r;XDj$7$F%U%!%$%k(B<br>
> > > > $B$r%m!<%I$7$F$_$F$/$@$5$$!#(B<br>
> > > > $B%@%$%"%m%0$G%U%!%$%k$r;XDj$9$k$H%m!<%I;~$N%Q%i%a!<%?$r;XDj$9$k%@%$%"%m%0$,I=<($5$l$^$9!#(B<br>
> > > > $B$3$3$G;XDj$9$Y$-$3$H$O85%U%!%$%kFb$NJ8;z%3!<%I!J(BCP932$B$+!K(B SRID($B6u4V;2>H7O$NHV9f!"(B<br>
> > > > $BB?J,85%U%!%$%k$N:BI87O$N(BEPSG$B%3!<%I(B JGD2000$B$NJ?LLD>3Q#X(B?$B7O$N>l9g$O(B2455)$B$N;XDj!#(B<br>
> > > > $B$"$H2<It$N%A%'%C%/%\%C%/%9$G$O(B With Spatial Index(R*Tree) $B$N;XDj!#$"$H(B Table name<br>
> > > > $B$N$H$3$O%U%!%$%kFb$N4{B8%F!<%V%kL>$H$@$V$i$J$$$h$&$K$7$F$/$@$5$$!#(B<br>
> > > ><br>
> > > > $B0l1~F~NO(BShape$B%U%!%$%kL>$KF|K\8l$O$$$l$J$$$G$d$C$F$_$^$7$?!#F|K\8l$O$$$C$?>l9g(B<br>
> > > > $B$&$^$/$$$/$+$I$&$+$OL$3NG'$G$9!#(B<br>
> > > ><br>
> > > > $B$3$l$G#O#K%\%?%s%/%j%C%/$G%G!<%?$N%m!<%I$G$-$^$9!#(B<br>
> > > ><br>
> > > > QGIS$B$N$[$&$G$O%l%$%d%a%K%e!<$N(B Spatialite$B%F!<%V%k$NDI2C$G;XDj$r$9$k$3$H$G!"$3$3$G(B<br>
> > > > $B%m!<%I$7$?%F!<%V%k$rMxMQ$G$-$^$9!#(B<br>
> > > > $B=i$a$F$=$N(BSpatialite$B%U%!%$%k$rMxMQ$9$k>l9g$O(B Spatialite$B%F!<%V%k$NDI2C%@%$%"%m%0$G(B<br>
> > > > $B?75,(B $B%\%?%s$r%/%j%C%/$7$?8e$KI=<($5$l$k%U%!%$%kA*Br%@%$%"%m%0$G:n@.$7$?%U%!%$%k$rA*Br(B<br>
> > > > $B$7$F2<$5$$!#(B<br>
> > > ><br>
> > > > $B$=$&$9$k$H$=$N%U%!%$%k$X$N@\B3%(%s%H%j$,%@%$%"%m%0$N%I%m%C%W%@%&%s%j%9%H$KI=<($5$l$k(B<br>
> > > > $B$N$G!"0J8e$=$N(BSpatialite$B%G!<%?%Y!<%9%U%!%$%k$rMxMQ$9$k>l9g$O%I%m%C%W%@%&%s%j%9%H$G(B<br>
> > > > $BA*Br$r9T$C$?8e$K@\B3%\%?%s$r%/%j%C%/$9$k$H!"$=$N%U%!%$%kFb$N%8%*%a%H%j$,$"$k%F!<%V%k(B<br>
> > > > $B$,I=<($5$l$k$N$GA*Br$9$k$HDL>o$N%l%$%d$H$7$FMxMQ$G$-$^$9!#(B<br>
> > > ><br>
> > > > $B$"$HJ8;zI=<(MQ$KDI2C$7$?%+%i%`$N%"%C%W%G!<%H$G$9$,(B<br>
> > > ><br>
> > > > $B%F!<%V%kL>(B syouhan $B%8%*%a%H%j%+%i%`L>$,(B Geometry $B$@$H$7$F(B<br>
> > > ><br>
> > > > select X(centroid(Geometry)),Y(centroid(Geometry)) from syouhan<br>
> > > ><br>
> > > > $B$3$N$h$&$J(BSQL$B$rH/9T$9$k$H%F!<%V%k(Bsyouhan$BFb$N3F%]%j%4%s$NCf?4E@(B<br>
> > > > $B:BI8$N#X$H#Y$NCM$r<hF@$G$-$^$9!#(B<br>
> > > ><br>
> > > > $B$?$H$($P%i%Y%kI=<(0LCV$N:BI8$r3JG<$9$k%+%i%`L>$,(B x $B$H(B y $B$H$7$?>l9g(B<br>
> > > ><br>
> > > > update syouhan set x=X(centroid(Geometry)), y=Y(centroid(Geometry))<br>
> > > > $B$H$$$&$h$&$J(BSQL$B$r<B9T$9$k$H%+%i%`(Bx,y$B$NCM$r$=$l$>$l$N%]%j%4%s$NCf?4E@(B<br>
> > > > $B$N:BI8$G99?7$9$k$3$H$,$G$-$^$9!#(B<br>
> > > ><br>
> > > > SQL$B$O(B spatialite_gui $B$N1&>e$NNN0h$KF~NO$r9T$C$?8e!"%a%K%e!<(B->Advanced->Execute SQL Script<br>
> > > > $B$rA*Br$9$k$H<B9T$G$-$^$9!#(B<br>
> > > > $B$^$?$O(BSQL$BF~NONN0h$N1&B&$K$"$k%"%$%3%s$r%/%j%C%/$7$F$b<B9T$G$-$^$9!#(B<br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > > 2012$BG/(B1$B7n(B18$BF|(B21:39 $B4nB?9L0l(B <<a href="mailto:kou35tochas@gmail.com">kou35tochas@gmail.com</a>>:<br>
> > > > > spatialite $B$X$N%G!<%?%m!<%IJ}K!$OBgJQ6=L#$,$"$j$^$9!#(B<br>
> > > > > $B$<$R$h$m$7$/$*4j$$$7$^$9!#!J=PMh$k$@$14JC1$K$*4j$$$7$^$9!#!K(B<br>
> > > > ><br>
> > > > ><br>
> > > > > 2012$BG/(B1$B7n(B17$BF|(B9:06 Yoichi Kayama <<a href="mailto:yoichi.kayama@gmail.com">yoichi.kayama@gmail.com</a>>:<br>
> > > > ><br>
> > > > >> $B4nB?$5$s(B<br>
> > > > >> $B$_$J$5$s(B<br>
> > > > >><br>
> > > > >> spatialite$B$K$D$$$F%G!<%?%m!<%I$H(BSQL$B;H$C$?:BI8CM$N@_Dj$,$G$-$^$7$?!#(B<br>
> > > > >> $B<j=g$r$"$H$G$^$H$a$F$_$^$9$N$G!"$A$g$$$H$*BT$A$/$@$5$$!#(B<br>
> > > > >><br>
> > > > ><br>
> > > ><br>
> > ><br>
> > ><br>
> ><br>
><br>
><br>
</div></div></blockquote></div><br></div>