Re: [OSGeoJapan-discuss] Re: 【質問】QGISでの新しいラベル機能について

[Yoichi Kayama]

$B4nB?$5$s(B
$B$_$J$5$s(B

$B$H$j$"$($:%V%m%0!!(Bhttp://d.hatena.ne.jp/yoichi_46/$B!!$K$^$H$a$k$D$b$j$G$9$,(B
$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
$B$*$-$^$9!#(B

spatialite-gui$B$H$$$&%W%m%0%i%`$r%@%&%s%m!<%I$7$F;H$&$H(BShapefile$B$r(BSpatialite
$B$K%m!<%I$G$-$^$9!#(B

http://www.gaia-gis.it/gaia-sins/


$B$3$3$N%Z!<%8$K%=!<%9$"$j$^$9$,(BWindows$B$N>l9g$G$9$H%P%$%J%j$,$"$j$^$9!#(B
$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
$B%@%V%k%/%j%C%/$9$k$H%W%m%0%i%`5/F0$7$^$9!#!J#W#i#n$N>l9g!K(B

$B?75,$K(Bspatialite $B$N%U%!%$%k$r:n ＠ .$9$k>l9g$O!!(BFile$B#s%a%K%e!<$N!!(BCreating a New(empty) SQLite
DB, $B4{B8$N%U%!%$%k$rMxMQ$9$k>l9g$O!!(BConnecting an existing SQLite DB $B$r(B
$BA*Br$7$F2<$5$$!#!!(BNew $B$N>l9g$O%U%!%$%k$N%Q%9L>$r;XDj$7$F2<$5$$!#(B

$B%U%!%$%k$K@\B3$9$k$H%a%K%e!<$K!!(BAdbanced$B$H$$$&9`L\$,$G$-$^$9$N$G!"$=$3$G(BLoad Shapefile
$B$rA*Br$9$k$H%U%!%$%kA*Br%@%$%"%m%0$,I=<($5$l$k$N$G!"$=$3$G!!(BShapefile$B$r;XDj$7$F%U%!%$%k(B
$B$r%m!<%I$7$F$_$F$/$@$5$$!#(B
$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
$B$3$3$G;XDj$9$Y$-$3$H$O85%U%!%$%kFb$NJ8;z%3!<%I!J(BCP932$B$+!K!!(BSRID($B6u4V;2>H7O$NHV9f!"(B
$BB?J,85%U%!%$%k$N:BI87O$N(BEPSG$B%3!<%I!!(BJGD2000$B$NJ?LLD>3Q#X-77O$N>l9g$O(B2455)$B$N;XDj!#(B
$B$"$H2<It$N%A%'%C%/%\%C%/%9$G$O(B With Spatial Index(R*Tree)$B!!$N;XDj!#$"$H(B Table name
$B$N$H$3$O%U%!%$%kFb$N4{B8%F!<%V%kL>$H$@$V$i$J$$$h$&$K$7$F$/$@$5$$!#(B

$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
$B$&$^$/$$$/$+$I$&$+$OL$3NG'$G$9!#(B

$B$3$l$G#O#K%\%?%s%/%j%C%/$G%G!<%?$N%m!<%I$G$-$^$9!#(B

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
$B%m!<%I$7$?%F!<%V%k$rMxMQ$G$-$^$9!#(B
$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
$B?75,!!%\%?%s$r%/%j%C%/$7$?8e$KI=<($5$l$k%U%!%$%kA*Br%@%$%"%m%0$G:n ＠ .$7$?%U%!%$%k$rA*Br(B
$B$7$F2<$5$$!#(B

$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
$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
$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
$B$,I=<($5$l$k$N$GA*Br$9$k$HDL>o$N%l%$%d$H$7$FMxMQ$G$-$^$9!#(B

$B$"$HJ8;zI=<(MQ$KDI2C$7$?%+%i%`$N%"%C%W%G!<%H$G$9$,(B

$B%F!<%V%kL>!!(Bsyouhan  $B%8%*%a%H%j%+%i%`L>$,(B Geometry $B$@$H$7$F(B

select X(centroid(Geometry)),Y(centroid(Geometry)) from syouhan

$B$3$N$h$&$J(BSQL$B$rH/9T$9$k$H%F!<%V%k(Bsyouhan$BFb$N3F%]%j%4%s$NCf?4E@(B
$B:BI8$N#X$H#Y$NCM$r<hF@$G$-$^$9!#(B

$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

update syouhan set x=X(centroid(Geometry)), y=Y(centroid(Geometry))
$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
$B$N:BI8$G99?7$9$k$3$H$,$G$-$^$9!#(B

SQL$B$O(B spatialite_gui $B$N1&>e$NNN0h$KF~NO$r9T$C$?8e!"%a%K%e!<(B->Advanced->Execute SQL Script
$B$rA*Br$9$k$H<B9T$G$-$^$9!#(B
$B$^$?$O(BSQL$BF~NONN0h$N1&B&$K$"$k%"%$%3%s$r%/%j%C%/$7$F$b<B9T$G$-$^$9!#(B









2012$BG/(B1$B7n(B18$BF|(B21:39 $B4nB?9L0l(B <kou35tochas ＠ gmail.com>:
> spatialite $B$X$N%G!<%?%m!<%IJ}K!$OBgJQ6=L#$,$"$j$^$9!#(B
> $B$<$R$h$m$7$/$*4j$$$7$^$9!#!J=PMh$k$@$14JC1$K$*4j$$$7$^$9!#!K(B
>
>
> 2012$BG/(B1$B7n(B17$BF|(B9:06 Yoichi Kayama <yoichi.kayama ＠ gmail.com>:
>
>> $B4nB?$5$s(B
>> $B$_$J$5$s(B
>>
>> spatialite$B$K$D$$$F%G!<%?%m!<%I$H(BSQL$B;H$C$?:BI8CM$N ＠ _Dj$,$G$-$^$7$?!#(B
>> $B<j=g$r$"$H$G$^$H$a$F$_$^$9$N$G!"$A$g$$$H$*BT$A$/$@$5$$!#(B
>>
>