<div dir="ltr"><div><div>$B>>_7$5$^(B<br><br><br>$B$I$&$b$"$j$,$H$&$4$6$$$^$9!#(B<br><br>> SELECT pgr_createTopology('line_road', 0.0001, 'geom', 'gid');<br>$B>e5-$GL5;v$K(Bsource, target$B%+%i%`$KHV9f$,F~$j$^$7$?!#(B<br></div></div><br>pgrouting workshop$B$N%5%$%H$NFbMF$,>/$7$:$DJ,$+$k$h$&$K$J$C$F$-$^$7$?(B…$B!#(B<br>$B%5%$%H$r;29M$K?J$a$F$$$-$?$$$H;W$$$^$9!#$"$j$,$H$&$4$6$$$^$7$?!#(B<br><br><div>$B5WJ]$^$f$_(B<br><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2015$BG/(B4$B7n(B7$BF|(B 16:44 Taro Matsuzawa <span dir="ltr"><<a href="mailto:taro@georepublic.co.jp" target="_blank">taro@georepublic.co.jp</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">$B>>_7$G$9!#(B<br>
<span class=""><br>
>  > pgr_createTopology('line_road', 0.0001, 'geom', 'gid');<br>
<br>
</span>SELECT pgr_createTopology('line_road', 0.0001, 'geom', 'gid');<br>
$B$G$9!#(B<br>
SELECT$B$,L5$$$N$GEvA3(BSQL$B$H$7$F9=J8%(%i!<$G$9!#(B<br>
<div><div class="h5"><br>
<br>
On 2015/04/07 16:40, Mayumi Kubo wrote:<br>
> $B2E;3$5$s!">>_7$5$s!"(B<br>
><br>
> $B%"%I%P%$%9$I$&$b$"$j$,$H$&$4$6$$$^$9!#(B<br>
> pgRouting$B$O(B2.0.0$B$rMxMQ$7$F$$$^$9!#(B<br>
><br>
> $B65$($FD:$$$?%5%$%H$N%3%^%s%I(BSQL Query$B$G;n$7$F$_$?$N$G$9$,!"$I$A$i$b%((B<br>
> $B%i!<$,=P$F$7$^$$$^$9!#(B<br>
><br>
>  > psql -U postgres<br>
><br>
> ERROR:  "psql"$B$^$?$O$=$N6aJU$G9=J8%(%i!<(B<br>
> LINE 1: psql -U postgres<br>
>          ^<br>
> ********** $B%(%i!<(B **********<br>
> ERROR: "psql"$B$^$?$O$=$N6aJU$G9=J8%(%i!<(B<br>
> SQL$B%9%F!<%H(B:42601<br>
> $BJ8;z(B:1<br>
><br>
>  > pgr_createTopology('line_road', 0.0001, 'geom', 'gid');<br>
><br>
> ERROR:  "pgr_createTopology"$B$^$?$O$=$N6aJU$G9=J8%(%i!<(B<br>
> LINE 1: pgr_createTopology('line_road', 0.0001, 'geom', 'gid');<br>
>          ^<br>
> ********** $B%(%i!<(B **********<br>
> ERROR: "pgr_createTopology"$B$^$?$O$=$N6aJU$G9=J8%(%i!<(B<br>
> SQL$B%9%F!<%H(B:42601<br>
> $BJ8;z(B:1<br>
><br>
> $B%f!<%6!<%"%+%&%s%H$O(BPostgresSQL$B$r%$%s%9%H!<%k$7$F%G%U%)%k%H$G:n@.$5$l$k(B<br>
> postgres$B$rMxMQ$7$F$$$^$9!#(B<br>
> $B:#$^$G$O!"(BpgAdminIII$B$N(BExtensions$B$r1&%/%j%C%/"*(BNew Extension$B"*%W%m%Q(B<br>
> $B%F%#!'(Bpgrouting$B!!(BSQL: CREATE EXTENSION pgrouting $B"*(BOK $B$G%$%s%9%H!<%k$7$F(B<br>
> $B$$$^$7$?!#(B<br>
><br>
><br>
> $B5WJ]$^$f$_(B<br>
><br>
><br>
> 2015$BG/(B4$B7n(B7$BF|(B 16:08 Taro Matsuzawa <<a href="mailto:taro@georepublic.co.jp">taro@georepublic.co.jp</a><br>
</div></div>> <mailto:<a href="mailto:taro@georepublic.co.jp">taro@georepublic.co.jp</a>>>:<br>
<div><div class="h5">><br>
>     $B>>_7$G$9!#(B<br>
><br>
>     # Daniel$B$+$i$NEA8@$rK]Lu$7$D$D!"E,Ev$K=q$$$F$$$^$9!#(B<br>
>     pgRouting$B$O$I$N%P!<%8%g%s$r;H$C$F$$$^$9$+!)(B<br>
>     2.0$B0J9_$G$"$l$P!"$3$N4X?t$O(Bpgr_createTopology$B$KJQ99$K$J$C$F$$$^$9!#(B<br>
><br>
>     <a href="http://workshop.pgrouting.org/ja/chapters/topology.html#calculate-topology" target="_blank">http://workshop.pgrouting.org/ja/chapters/topology.html#calculate-topology</a><br>
>     <a href="http://docs.pgrouting.org/2.0/en/src/common/doc/functions/create_topology.html#pgr-create-topology" target="_blank">http://docs.pgrouting.org/2.0/en/src/common/doc/functions/create_topology.html#pgr-create-topology</a><br>
><br>
>     OSM$B%G!<%?$G$7$?$i!"(BpgRouting Workshop$B$NFbMF$r$=$N$^$^(B<br>
>     $B;H$C$F$b$h$$$+$b$7$l$^$;$s!#(B<br>
>     # $B$A$J$_$KK]Lu$OKM$HD9@%$5$s$,<g$K$d$C$F$^$7$?!#(B<br>
><br>
>     $B<h$j5^$.!#(B<br>
><br>
>     On 2015/04/07 15:52, Mayumi Kubo wrote:<br>
>      > $B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B<br>
>      > pgRouting$B$G7PO)8!:w$r$9$k$?$a$K!"2<5-$N%Z!<%8$r;29M$K(BPostGIS$B$GF;(B<br>
>     $BO)%M%C%H(B<br>
>      > $B%o!<%/%G!<%?$r:n@.$7$F$$$^$9$,%(%i!<$,=P$F$7$^$$>e<j$/$$$-$^$;(B<br>
>     $B$s!#F;O)(B<br>
>      > $B%G!<%?$O(BQGIS$B$GBP>]CO0h$N(Bosm$B%U%!%$%k$r%$%s%]!<%H8e!"(B<br>
>     Road_Atsubetsu.shp$B$H(B<br>
>      > $B$7$F=PNO$7$?$b$N$r(BPostGIS$B$GFI$_9~$s$G%M%C%H%o!<%/%G!<%?$KJQ49$7$?$$$H(B<br>
>      > $B;W$C$F$$$^$9!#4D6-$O(BWin7(32bit)$B$G(BPostgresSQL9.3.6, PostGIS2.1.5$B$r(B<br>
>     $B;HMQ$7(B<br>
>      > $B$F$$$^$9!J%f!<%6!<L>!'(Bpostgres, $B%G!<%?%Y!<%9L>!'(Bgisdb$B!K!#(B<br>
>      ><br>
>     <a href="http://themapguyde.blogspot.jp/2013/04/mapguide-and-pgrouting-shortest-path.html" target="_blank">http://themapguyde.blogspot.jp/2013/04/mapguide-and-pgrouting-shortest-path.html</a><br>
>      > <a href="http://www.geopacific.org/opensourcegis/postgis/pgrouting" target="_blank">http://www.geopacific.org/opensourcegis/postgis/pgrouting</a><br>
>      ><br>
>      ><br>
>      > $B:n6H$NN.$l$H%(%i!<$O2<5-$NDL$j$G$9!#(B<br>
>      ><br>
>      > 1) Road_Atsubetsu.shp$B$rFI9~$`$?$a$K2<5-$r<B9T$9$k$H!"!V(Bcould not<br>
>     find a<br>
>      > "psql" to execute$B!W$H%(%i!<$,=P$k$,!"(Bline_road$B%F!<%V%k$O:n@.$5$l(B<br>
>     $B$F$$$k!#(B<br>
>      >  > shp2pgsql -c -D -I -S -s 4612 -W cp932 Road_Atsubetsu.shp<br>
>     line_road |<br>
>      > psql -U postgres -d gisdb<br>
>      ><br>
>      ><br>
>      > 2) line_road$B%F!<%V%k$K(Bsource, target, leingth$B%+%i%`$rDI2C$9$k$3$H(B<br>
>     $B$O$G$-(B<br>
>      > $B$?!J%(%i!<$J$7!K(B<br>
>      >  > ALTER TABLE line_road ADD COLUMN source int4;<br>
>      >  > ALTER TABLE line_road ADD COLUMN target int4;<br>
>      >  > ALTER TABLE line_road ADD COLUMN length float4;<br>
>      ><br>
>      > 3) source$B$H(Btarget$B%+%i%`$KCM$rBeF~$9$k$?$a$K(Bassign_vartex_id()$B$r<B(B<br>
>     $B9T$9$k(B<br>
>      > $B$H%(%i!<$,$G$k!J(Bpgr_assign_vertex_id()$B$G$bF1$8%(%i!<!K!#(B<br>
>      >  > SELECT assign_vertex_id('line_road', 0.0001, 'geom', 'gid');<br>
>      ><br>
>      > #===$B%(%i!<(B=start=<br>
>      > ERROR:  $B4X?t(Bassign_vertex_id(unknown, numeric, unknown, unknown)<br>
>     $B$OB8:_$7(B<br>
>      > $B$^$;$s(B<br>
>      > LINE 1: SELECT assign_vertex_id('line_road', 0.0001, 'geom', 'gid');<br>
>      >                 ^<br>
>      > HINT:  $B;XDjL>>N!";XDj0z?t7?$K9g$&4X?t$,$"$j$^$;$s!#L@<(E*$J7?%-%c(B<br>
>     $B%9%H$,(B<br>
>      > $BI,MW$+$b$7$l$^$;$s(B<br>
>      ><br>
>      > ********** $B%(%i!<(B **********<br>
>      > ERROR: $B4X?t(Bassign_vertex_id(unknown, numeric, unknown, unknown)$B$O(B<br>
>     $BB8:_$7(B<br>
>      > $B$^$;$s(B<br>
>      > SQL$B%9%F!<%H(B:42883<br>
>      > $B%R%s%H(B:$B;XDjL>>N!";XDj0z?t7?$K9g$&4X?t$,$"$j$^$;$s!#L@<(E*$J7?%-%c(B<br>
>     $B%9%H$,(B<br>
>      > $BI,MW$+$b$7$l$^$;$s(B<br>
>      > $BJ8;z(B:8<br>
>      > #===$B%(%i!<(B=end==<br>
>      ><br>
>      ><br>
>      > $B!&%G!<%?%Y!<%9(Bgisdb$B$K(Bpostgis, pgrouting$B$O%$%s%9%H!<%k$5$l$F$$$k$H(B<br>
>     $B;W$$$^(B<br>
>      > $B$9!J$-$C$H(B…$B!K(BpgAdmin III$B$+$i%G!<%?%Y!<%9(Bgisdb$B$r3+$/$H(BExtensitons$B$K(B<br>
>      > pgrouting, plpgsql,postgis$B$,I=<($5$l$^$9!#4X?t$K$b(Bpgr_, postgis_<br>
>     $B$+$i;O$^(B<br>
>      > $B$k$b$N$,Bt;3I=<($5$l$^$9!J(Bpgr_assign_vertex_id()$B$O$"$j$^$;$s!K(B<br>
>      > $B!&(B1)$B$O%3%^%s%I%W%m%s%W%H!"(B2),3)$B$O(BpgAdmin III$B$N(BSQL Query(SQL$B%"%$%3(B<br>
>     $B%s$r%/(B<br>
>      > $B%j%C%/$7$F=P$F$/$k2hLL(B)$B$G:n6H$7$F$$$^$9!#%W%i%0%$%s"*(BPSQL Console<br>
>     $B$O;HMQ$7(B<br>
>      > $B$F$$$^$;$s!J;H$&$Y$-$J$N$+$h$/J,$+$i$J$$(B…$B!K(B<br>
>      ><br>
>      > PostGIS$B$G:n6H$9$k$N$O$[$H$s$I=i$a$F$G%(%i!<$N0UL#$b$h$/J,$+$i$J$$(B<br>
>     $B>u67$J(B<br>
>      > $B$N$G$9$,(B…$B!"BP=hK!$r$4B8CN$NJ}$465<xD:$1$k$HBgJQM-Fq$$$G$9!#$^$?!"(B<br>
>     $BL\E*$O(B<br>
>      > pgRouting$B$GMxMQ$G$-$kF;O)%M%C%H%o!<%/%G!<%?$N:n@.$J$N$G!"$b$C$HJL(B<br>
>     $B$N4JC1(B<br>
>      > $B$JJ}K!$,$"$l$P65$($FD:$1$k$H=u$+$j$^$9!J$3$A$i$b6lF.Cf$G$9(B…<br>
>      > <a href="http://anitagraser.com/2011/02/07/a-beginners-guide-to-pgrouting" target="_blank">http://anitagraser.com/2011/02/07/a-beginners-guide-to-pgrouting</a><br>
>     /$B!K!#$I(B<br>
>      > $B$&$>$h$m$7$/$*4j$$CW$7$^$9!#(B<br>
>      ><br>
>      ><br>
>      > $B5WJ]$^$f$_(B<br>
>      > $B4(COEZLZ8&5f=j(B<br>
>      ><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>
</div></div>>     <mailto:<a href="mailto:OSGeoJapan-discuss@lists.osgeo.org">OSGeoJapan-discuss@lists.osgeo.org</a>><br>
<span class="">>      > <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>
>     Taro Matsuzawa<br>
>     Georepublic Japan<br>
</span>>     mail: <a href="mailto:taro@georepublic.co.jp">taro@georepublic.co.jp</a> <mailto:<a href="mailto:taro@georepublic.co.jp">taro@georepublic.co.jp</a>><br>
>     web: <a href="http://georepublic.co.jp" target="_blank">http://georepublic.co.jp</a><br>
<div class="HOEnZb"><div class="h5">><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>
Taro Matsuzawa<br>
Georepublic Japan<br>
mail: <a href="mailto:taro@georepublic.co.jp">taro@georepublic.co.jp</a><br>
web: <a href="http://georepublic.co.jp" target="_blank">http://georepublic.co.jp</a><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>
</div></div></blockquote></div><br></div>