$BFj:j$5$s!"3'MM!"(B<div>$B%7%"%H%k$N:#LZ$G$9!#Ej9F$,@9$j>e$,$C$F$$$k$N$G;d$b;22C$G$9!#(BPostGIS$B$N%P%C%U%!!<$NOC$,=P$F$$$?$N$G%3%a%s%H$G$9!#%P%C%U%!!<$O!"(B</div><div>ST_Buffer(geometry, distance) $B$GH/@8$5$;$k$3$H$,$G$-$^$9!#H/@8$5$;$?%P%C%U%!!<$G?7$7$$%F!<%V%k$r:n$k$J$i!"(B</div><div><br></div><div>Create Table new_table As</div><div>Select your_id, ST_Buffer(the_geom, your_distance) As the_geom From Your_table;</div>
<div><br></div><div>$B$G%P%C%U%!!<$,H/@8$5$;$i$l$^$9!#(Bt$B$A$J$_$K!"(Bnew_table, your_id, the_geom, your_distance, Your_table$B$O<+J,$G;XDj$7$F$/$@$5$$!#COM};2>H7O$O(BGeographic$B$G$O$J$/(BUTM$B$J$I$NEj1F7O$G$3$N:n6H$O$7$?$[$&$,$$$$$H;W$$$^$9!#(B</div><div><br></div><div>$B:#LZ(B</div><div><br></div><div><br><div class="gmail_quote">
2010/6/5 Bravo-Astro <span dir="ltr"><<a href="mailto:mnara-260116@kamakuranet.ne.jp">mnara-260116@kamakuranet.ne.jp</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
$BNSMM(B<br>
1km$B%a%C%7%e$N(Bmaptools$B$N%^!<%8$d$C$F$_$^$7$?$,!"<!$NDL$jIT2D2r$J8=>]$,H/@8$7$^$7$?!#(B<br>
(1)e-stat$B$N%7%'!<%W%U%!%$%k$N%a%C%7%e%3!<%I%U%!%$%k$N(B6$B8D$r(BGeoMarge$B$G7k9g!#(B<br>
$B$3$l$O!"1_%P%C%U%!$rH/@8$5$;$F?M8}Ey$r<hF@$9$k;~!"$J$k$Y$/>/$J$$2s?t$G:Q$^$;$k$?$a$G$9!#(B<br>
$B!J$A$J$_$K!"(BPostGIS$B$G$N%P%C%U%!H/@8J}K!$,$^$@$o$+$i$J$$$N$G!"%U%j!<%=%U%H$N(BMANDARA$B$G(B<br>
$B1_%P%C%U%!$rH/@8$5$;!"?M8}Ey$r<hF@$7$^$7$?!#(B)<br>
(2)maptools$B$N%^!<%8$G(Bcsv$B%U%!%$%k$r<hF@8e!"%(%/%;%k(B2003$B$N(Bdbf$B$GJ]B88e!"(BQGIS$B$GI=<((B<br>
$B$9$k$H!":G8e$N%a%C%7%e$O!"$[$H$s$I?M8}Ey$,<h$l$F$$$J$$!#(B<br>
($B:G8e$N%7%'!<%W%U%!%$%k$N%a%C%7%e%3!<%I%U%!%$%k$N:82<3QIU6a$G$O<h$l$F$$$k%a%C%7%e$,6K$o$:$+$"$j!#(B)<br>
$B$3$N%(%j%"$N1_%P%C%U%!$rH/@8$5$;$k$3$H$OD|$a<!$NNN0h$N;~$KH/@8$5$;$l$P$h$$$H9M$($F$$$^$9$,!"(B<br>
$B$3$N$h$&$J7P83$r$5$l$?$3$H$O$"$j$^$9$+!)(B<br>
$B!!!!!!!!!!!!!!!!!!!!!!(BBravo-Astro<br>
<br>
<br>
----- Original Message ----- From: <<a href="mailto:hayashi@apptec.co.jp" target="_blank">hayashi@apptec.co.jp</a>><br>
To: "OSHIMA Hideki" <<a href="mailto:oshimapanda@gmail.com" target="_blank">oshimapanda@gmail.com</a>><br>
Cc: <<a href="mailto:OSGeoJapan-discuss@lists.osgeo.org" target="_blank">OSGeoJapan-discuss@lists.osgeo.org</a>><br>
Sent: Saturday, June 05, 2010 5:11 PM<div><div></div><div class="h5"><br>
Subject: Re: [OSGeoJapan-discuss] $B9q@*D4::$N(B1km$B$N(Btxt$B%U%!%$%k$N;HMQJ}K!(B<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
$BF`NI:j$5$s(B<br>
<br>
| > $B!J(B1km$B%a%C%7%e$N;~$O!":G8e$K!!(Ball=T$B!K(B<br>
<br>
$BBg>fIW$H;W$$$^$9$,!"$"$H$G$43NG'$/$@$5$$$M!#(B<br>
<br>
<br>
| $BF`NI:j$5$^(B<br>
|<br>
| $B$=$&$G$9$M!#(B<br>
| $B9q@*D4::$N?M8}$O$$$o$f$kLk4V?M8}$J$N$KBP$7$F!";v6H=j!&4k6HE}7WD4::$N=>6H0w?t$O!"$$$o$f$kCk4V?M8}$H4X78$,$"$k$N$G!J87L)$K$O!"Ck4V?M8}!aLk4V?M8}!>="6H?M8}!\<+BpFb="6H?M8}!\=>6H0w?t!K!"N>J};H$o$l$k$H$$$$$G$9$M!#(B<br>
|<br>
| $B%a%C%7%e$K!"9q@*D4::$N?M8}$H;v6H=j!&4k6HE}7WD4::$N=>6H0w?t$NN>J}$r%^!<%8$9$l$P$$$$$G$9$M!#(B<br>
|<br>
|<br>
|<br>
| 2010$BG/(B6$B7n(B4$BF|(B20:08 $BF`NI:j!!M%(B <<a href="mailto:mnara-260116@kamakuranet.ne.jp" target="_blank">mnara-260116@kamakuranet.ne.jp</a>>:<br>
| > $B4d:jMM!"NSMM!"BgEgMM(B<br>
| > $B%a!<%k2sEz$"$j$,$H$&$4$6$$$^$9!#(B<br>
| > $BD+<ALd$7$FM<J}$K$OB??t$N?M$K2sEz$7$F$$$?$@$$$F$$$k$3$H$K467c$7$F$$$^$9!#(B <br>
| > $BBgEgMM(B<br>
| > $B;d$,!"(B1km$B%a%C%7%e%G!<%?$bM_$7$$$H;W$C$?$N$O!">.CO0h$H$OLS?'$,0c$C$?!";v6H=j!&4k6HE}7WD4::$b(B<br>
| > $B=E2s5"$N@bL@JQ?t$KF~$l$?$[$&$,NI$$$N$G$O$J$$$+$H;W$C$?$+$i$G$9!#K\Ev$+$I$&$+$o$+$j$^$;$s$,!#(B<br>
| > $B4d:jMM(B<br>
| > QGIS$B$G$b%^!<%8$,=PMh$k$H$OCN$j$^$;$s$G$7$?!#$*<j?t$G$9$,!"J}K!$,5-:\$7$F$"$k%5%$%H$^$?$O(B<br>
| > $B%^%K%e%"%k!J=PMh$l$PF|K\8l(B)$B$r65$($F$$$?$@$1$J$$$G$7$g$&$+!)(B<br>
| > $BNSMM(B<br>
| > $B;d$N(Bmaptools$B$N%3%^%s%I$ONSMM$NNc$rE,MQ$9$k$H$D$.$NDL$j$G$9!#(B<br>
| > Mapobject<-readShapePoly("C:/GISdata/gunma61.shp")<br>
| ><br>
| > Mapdata<-Mapobject@data<br>
| > #$B72GO8)I=<(%G!<%?$NFI$_9~$_(B<br>
| > aged<- read.csv("C:/GISdata/agedprop.txt")<br>
| > Mapdata<- merge(Mapdata,aged,sort=F,by="JCODE")<br>
| ><br>
| > $B!J(B1km$B%a%C%7%e$N;~$O!":G8e$K!!(Ball=T$B!K(B<br>
| > $B4V0c$$$,$"$l$P!"$4;XE&$/$@$5$$!#(B<br>
| ><br>
| > Bravo-Astro<br>
| ><br>
| ><br>
| ><br>
| > ----- Original Message ----- From: "Nobusuke IWASAKI" <<a href="mailto:niwasaki@affrc.go.jp" target="_blank">niwasaki@affrc.go.jp</a>><br>
| > To: <<a href="mailto:hayashi@apptec.co.jp" target="_blank">hayashi@apptec.co.jp</a>><br>
| > Cc: "$BF`NI:j!!M%(B" <<a href="mailto:mnara-260116@kamakuranet.ne.jp" target="_blank">mnara-260116@kamakuranet.ne.jp</a>>;<br>
| > <<a href="mailto:OSGeoJapan-discuss@lists.osgeo.org" target="_blank">OSGeoJapan-discuss@lists.osgeo.org</a>><br>
| > Sent: Friday, June 04, 2010 7:07 PM<br>
| > Subject: Re: [OSGeoJapan-discuss] $B9q@*D4::$N(B1km$B$N(Btxt$B%U%!%$%k$N;HMQJ}K!(B<br>
| ><br>
| ><br>
| >> $BNS$5$s!$(BBravo-Astro$B$5$s(B<br>
| >><br>
| >> $B4d:j$G$9!#(B<br>
| >><br>
| >> $B$9$_$^$;$s!$A4BN$KJV?.$7B;$M$F$^$7$?!J$h$M!&!&!$$?$V$s!)!K!#(B<br>
| >> $B0J2<$NDL$jJV?.$7$?$N$G$9$,!$NS$5$s$+$i$N%"%I%P%$%9$NJ}$,>\$7$$$G$9$M(B($B4@(B <br>
| >><br>
| >> $BE}7WE*$J%G!<%?$N07$$J}$K$D$$$F$O!$BgEg$5$s$N%"%I%P%$%9$,E,@Z$+$H;W$$$^$9!#(B<br>
| >> $B!&!&!&$"$s$^$j$*Lr$KN)$F$:!$?=$7Lu$"$j$^$;$s!#(B<br>
| >><br>
| >>> Bravo-Astro$B$5$^(B<br>
| >>><br>
| >>> $B4d:j$H?=$7$^$9!#(B<br>
| >>><br>
| >>> $B$4<ALd$NJ}$O!$(B<br>
| >>> dbf$B%U%!%$%k$H(Btxt$B%U%!%$%k$r(Bmaptools$B$r;H$C$F7k9g$5$;$?$H$-!$?M8}$,(B0$B?M0J>e(B<br>
| >>> $B$N>.CO0h$7$+;D$i$J$$(B<br>
| >>><br>
| >>> $B$H$$$&$3$H$G$7$g$&$+!)(B<br>
| >>> $B$=$&$G$"$l$P!$$*$=$i$/(Bmaptools$B$N%3%^%s%I$N%*%W%7%g%s$G!$@_Dj$G$-$k$N$G$O(B<br>
| >>> $B$J$$$+$H;W$$$^$9!#(B<br>
| >>> $B$?$H$($P!$(BQGIS$B$GF1$8$3$H$r$d$m$&$H$7$?>l9g!$!X$9$Y$F$N%l%3!<%I$r;D$9!Y$H(B <br>
| >>> $B$$$&%*%W%7%g%s$,$"$j$^$9!#(B<br>
| >>><br>
| >>> $B$?$@!$$=$NJU$O(Bmaptools$B$N;H$$J}$K$D$F$O!$$3$A$i$h$j$b(BR$B$N%a!<%j%s%0%j%9%H(B<br>
| >>> $B$KJ9$$$?J}$,J,$+$k?M$,B?$$$H$O;W$$$^$9!#(B<br>
| >>><br>
| >>> $B$"$^$j;29M$K$O$J$i$J$$$+$b$7$l$^$;$s$,!$<h$j5^$.!#(B<br>
| >><br>
| >><br>
| >> (2010/06/04 10:47), <a href="mailto:hayashi@apptec.co.jp" target="_blank">hayashi@apptec.co.jp</a> wrote:<br>
| >>><br>
| >>> $BF`NI:j$5$s(B<br>
| >>><br>
| >>> $B$h$m$7$/$*4j$$$7$^$9!#(B<br>
| >>> $BJ8LL$+$i;!$9$k$K!"(B<br>
| >>> ---------------------------------<br>
| >>> #$B72GO8)(BShapeFile$BFI$_9~$_(B<br>
| >>> Mapobject<-read.shape("C:/GISdata/gunma61.shp")<br>
| >>> Mapdata<-Mapobject$att.data<br>
| >>> #$B72GO8)I=<(%G!<%?$NFI$_9~$_(B<br>
| >>> aged<- read.delim("C:/GISdata/agedprop.txt")<br>
| >>> Mapdata<- merge(Mapdata,aged,sort=F,by="JCODE")<br>
| >>> ----------------------------------<br>
| >>> $B$r;29M$K%^!<%8$r$5$l$F$$$k$H;W$$$^$9!#(B<br>
| >>> $B7k9g$K$D$$$F$O(BR$B%G!<%?%Y!<%9$bF1$8$G$9$+$i(B<br>
| >>> $B#1BP#1!"#1BPB?!"B?BP#1(B<br>
| >>> $B$N7k9g<oN`$r;XDj$9$l$P$h$$$H;W$$$^$9!#(B<br>
| >>> <a href="http://cse.naro.affrc.go.jp/takezawa/r-tips/r/43.html" target="_blank">http://cse.naro.affrc.go.jp/takezawa/r-tips/r/43.html</a><br>
| >>> $B$r;29M$K$7$F$O$$$+$,$G$7$g$&$+!#(B<br>
| >>> all=T$B$r;XDj$9$k$H$9$Y$F$N%l%3!<%I$,;D$k$h$&$G$9$M!#(B<br>
| >>><br>
| >>> $B$$$o$5$-$5$s!"%"%I%P%$%9$"$j$^$;$s$+!)(B<br>
| >>><br>
| >>><br>
| >>> | $B=i$a$FEj9F$7$^$9(BBravo-Astro$B$G$9!#(B<br>
| >>> | $B;d$O!"(BNOAA$B:#LZ8&5f0w$N(B3$B7n$N!V%*!<%W%s%=!<%9(BGIS$BF~Lg%3!<%9!W$K;22C$7$?$b$N$G!"(B<br>
| >>> | GIS$B$rMQ$$$FGd$j>e$2M=B,$r$7$?$$$H9M$($F$$$k$b$N$G$9!#(B<br>
| >>> | $B$9$J$o$A!"=E2s5"$N@bL@JQ?t$N0lIt$r(BGIS$B$N%=%U%H$G<hF@$7$h$&$H$7$F$$$^$9!#(B<br>
| >>> | $B<ALd(B<br>
| >>> | $BAmL3>J$N(BHP$B$N(Be-stat$B$+$i%@%&%s%m!<%I$G$-$k(B1km$B%a%C%7%e$N9q@*D4::!J>.CO0h(B)$B$N(Btxt$B%U%!%$%k$+$i!"(B<br>
| >>> | $B%7%'!<%W%U%!%$%k$r:n$kJ}K!$O%$%s%?!<%M%C%H$r;29M$K$7$F$o$+$j$^$7$?!#(B <br>
| >>> | $BNc$($P!"(B<a href="http://mjin.doshisha.ac.jp/R/200712_53.pdf" target="_blank">http://mjin.doshisha.ac.jp/R/200712_53.pdf</a><br>
| >>> | R$B$N(Bmaptools$B$N%^!<%85!G=$r;H$$(Bdbf$B%U%!%$%k$H(Btxt$B%U%!%$%k$r%^!<%8$7!"(Bdbf$B$K>e=q$-$9$l$P$h$$$H;W$$$^$9!#(B<br>
| >>> | $B$=$N8e!"<!$N8e=hM}$,I,MW$G$9!#(B<br>
| >>> | $BNc$($PG/NpJL(Btxt$B%U%!%$%k$r(Bdbf$B%U%!%$%k$K7k9g$5$;$?>l9g!"?M8}(B0$B?M$N>.CO0h$K$b!"$"$k?M?t$,3d$jEv$F$i$l$k$N$G!"(B<br>
| >>> | $B$3$l$i$NMs$N?tCM$r#0$K$9$kI,MW$,$"$j$^$9!#(B<br>
| >>> |<br>
| >>> | $B$7$+$7!"#1(Bkm$B%a%C%7%e$GF1MM$K(Bdbf$B%U%!%$%k$H(Btxt$B%U%!%$%k$r%^!<%8$7$h$&$H$9$k$H$&$^$/9T$-$^$;$s!#(B<br>
| >>> | dbf$B%U%!%$%k$N%a%C%7%e$,$J$/$J$j(Btxt$B%U%!%$%k$KB8:_$9$k%a%C%7%e$@$1$K$J$j$^$9!#(B<br>
| >>> | $B#1(Bkm$B%a%C%7%e$N>l9g$I$NMM$K$7$F%^!<%8$5$;$l$P$h$$$N$+65$($F$/$@$5$$!#(B <br>
| >>> |<br>
| >>> | $B$h$m$7$/$*4j$$$7$^$9!#(B<br>
| >>> |<br>
| >>> | _______________________________________________<br>
| >>> | OSGeoJapan-discuss mailing list<br>
| >>> | <a href="mailto:OSGeoJapan-discuss@lists.osgeo.org" target="_blank">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>
| >>><br>
| >>> _______________________________________________<br>
| >>> OSGeoJapan-discuss mailing list<br>
| >>> <a href="mailto:OSGeoJapan-discuss@lists.osgeo.org" target="_blank">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>
| >> Nobusuke IWASAKI Ph.D., Researcher<br>
| >> Ecosystem Informatics Division<br>
| >> National Institute for Agro-Environmental Sciences<br>
| >> 3-1-1, Kannondai, Tsukuba-shi,<br>
| >> Ibaraki-ken 305-8604, JAPAN<br>
| >> Tel / Fax 81-29-838-8226 Email: <a href="mailto:niwasaki@affrc.go.jp" target="_blank">niwasaki@affrc.go.jp</a><br>
| >> Website <a href="http://cse.niaes.affrc.go.jp/niwasaki/" target="_blank">http://cse.niaes.affrc.go.jp/niwasaki/</a><br>
| >><br>
| >> $B4d:j!!OKE5(B<br>
| >> ($BFH(B)$BG@6H4D6-5;=Q8&5f=j(B<br>
| >> $B@8BV7O7WB,8&5fNN0h!!<gG$8&5f0w(B<br>
| >> $B")(B305-8604 $B0q>k8)$D$/$P;T4Q2;Bf(B3-1-3<br>
| >><br>
| >> $B!ZNr;KE*G@6H4D6-1\Mw%7%9%F%`$r8x3+Cf$G$9![(B<br>
| >> <a href="http://habs.dc.affrc.go.jp/" target="_blank">http://habs.dc.affrc.go.jp/</a><br>
| ><br>
| ><br>
|<br>
|<br>
|<br>
| -- | $BBgEg1Q44(B<br>
| $B7DXf5A=NBg3XBg3X1!@/:v!&%a%G%#%"8&5f2J(B<br>
| OSHIMA, Hideki<br>
| KEIO Univ. graduate school of media and governance<br>
|<br>
| _______________________________________________<br>
| OSGeoJapan-discuss mailing list<br>
| <a href="mailto:OSGeoJapan-discuss@lists.osgeo.org" target="_blank">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>
</blockquote>
<br>
<br></div></div>
--------------------------------------------------------------------------------<div><div></div><div class="h5"><br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
_______________________________________________<br>
OSGeoJapan-discuss mailing list<br>
<a href="mailto:OSGeoJapan-discuss@lists.osgeo.org" target="_blank">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>
</blockquote>
<br>
</div></div><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></blockquote></div><br><br clear="all"><br>-- <br>Hiroo Imaki<br><a href="mailto:hiroo@angeli.org">hiroo@angeli.org</a><br><a href="http://www.geopacific.org">http://www.geopacific.org</a><br>
</div>