<div dir="ltr"><div><div>$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B<br></div>pgRouting$B$G7PO)8!:w$r$9$k$?$a$K!"2<5-$N%Z!<%8$r;29M$K(BPostGIS$B$GF;O)%M%C%H%o!<%/%G!<%?$r:n@.$7$F$$$^$9$,%(%i!<$,=P$F$7$^$$>e<j$/$$$-$^$;$s!#F;O)%G!<%?$O(BQGIS$B$GBP>]CO0h$N(Bosm$B%U%!%$%k$r%$%s%]!<%H8e!"(BRoad_Atsubetsu.shp$B$H$7$F=PNO$7$?$b$N$r(BPostGIS$B$GFI$_9~$s$G%M%C%H%o!<%/%G!<%?$KJQ49$7$?$$$H;W$C$F$$$^$9!#4D6-$O(BWin7(32bit)$B$G(BPostgresSQL9.3.6, PostGIS2.1.5$B$r;HMQ$7$F$$$^$9!J%f!<%6!<L>!'(Bpostgres, $B%G!<%?%Y!<%9L>!'(Bgisdb$B!K!#(B<br><a href="http://themapguyde.blogspot.jp/2013/04/mapguide-and-pgrouting-shortest-path.html">http://themapguyde.blogspot.jp/2013/04/mapguide-and-pgrouting-shortest-path.html</a><br><a href="http://www.geopacific.org/opensourcegis/postgis/pgrouting">http://www.geopacific.org/opensourcegis/postgis/pgrouting</a><br><br></div><div><br>$B:n6H$NN.$l$H%(%i!<$O2<5-$NDL$j$G$9!#(B<br></div><div><br>1) Road_Atsubetsu.shp$B$rFI9~$`$?$a$K2<5-$r<B9T$9$k$H!"!V(Bcould not find a "psql" to execute$B!W$H%(%i!<$,=P$k$,!"(Bline_road$B%F!<%V%k$O:n@.$5$l$F$$$k!#(B<br>> shp2pgsql -c -D -I -S -s 4612 -W cp932 Road_Atsubetsu.shp line_road | 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$O$G$-$?!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></div><br>3) source$B$H(Btarget$B%+%i%`$KCM$rBeF~$9$k$?$a$K(Bassign_vartex_id()$B$r<B9T$9$k$H%(%i!<$,$G$k!J(Bpgr_assign_vertex_id()$B$G$bF1$8%(%i!<!K!#(B<br><div>> SELECT assign_vertex_id('line_road', 0.0001, 'geom', 'gid');<br></div><div><br>#===$B%(%i!<(B=start=<br>ERROR:  $B4X?t(Bassign_vertex_id(unknown, numeric, unknown, unknown)$B$OB8:_$7$^$;$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%9%H$,I,MW$+$b$7$l$^$;$s(B<br><br>********** $B%(%i!<(B **********<br>ERROR: $B4X?t(Bassign_vertex_id(unknown, numeric, unknown, unknown)$B$OB8:_$7$^$;$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%9%H$,I,MW$+$b$7$l$^$;$s(B<br>$BJ8;z(B:8<br>#===$B%(%i!<(B=end==<br></div><div><br><div><br>$B!&%G!<%?%Y!<%9(Bgisdb$B$K(Bpostgis, pgrouting$B$O%$%s%9%H!<%k$5$l$F$$$k$H;W$$$^$9!J$-$C$H(B…$B!K(BpgAdmin III$B$+$i%G!<%?%Y!<%9(Bgisdb$B$r3+$/$H(BExtensitons$B$K(Bpgrouting, plpgsql,postgis$B$,I=<($5$l$^$9!#4X?t$K$b(Bpgr_, postgis_$B$+$i;O$^$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%s$r%/%j%C%/$7$F=P$F$/$k2hLL(B)$B$G:n6H$7$F$$$^$9!#%W%i%0%$%s"*(BPSQL Console$B$O;HMQ$7$F$$$^$;$s!J;H$&$Y$-$J$N$+$h$/J,$+$i$J$$(B…$B!K(B<br><br></div><div>PostGIS$B$G:n6H$9$k$N$O$[$H$s$I=i$a$F$G%(%i!<$N0UL#$b$h$/J,$+$i$J$$>u67$J$N$G$9$,(B…$B!"BP=hK!$r$4B8CN$NJ}$465<xD:$1$k$HBgJQM-Fq$$$G$9!#$^$?!"L\E*$O(BpgRouting$B$GMxMQ$G$-$kF;O)%M%C%H%o!<%/%G!<%?$N:n@.$J$N$G!"$b$C$HJL$N4JC1$JJ}K!$,$"$l$P65$($FD:$1$k$H=u$+$j$^$9!J$3$A$i$b6lF.Cf$G$9(B…$B!!(B<a href="http://anitagraser.com/2011/02/07/a-beginners-guide-to-pgrouting/">http://anitagraser.com/2011/02/07/a-beginners-guide-to-pgrouting/</a>$B!K!#$I$&$>$h$m$7$/$*4j$$CW$7$^$9!#(B<br><br><br>$B5WJ]$^$f$_(B<br>$B4(COEZLZ8&5f=j(B<br></div><div><br><br></div></div></div>