<div dir="ltr">Hi Bomp,<div><br></div><div>Because you mention "Windows 7" in the subject, do you want to say that it worked before, for example on Linux?</div><div><br></div><div>If you use the sample data of the documentation [1], does it return an empty table as well? You can run the sample queries [2] to verify it works or not.</div>
<div><br></div><div>If the sample queries with the sample data work, then you may have a problem with your data.</div><div><br></div><div>Just one remark (which shouldn't prevent you from running pgr_dijkstra though): your geometry is "multilinestring". If you really have multilinestrings, then you would have a problem to define source and target. Otherwise just make it ordinary linestrings.</div>
<div><br></div><div>Best regards,</div><div>Daniel</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div>[1] <a href="http://docs.pgrouting.org/2.0/en/doc/src/developer/sampledata.html#sampledata">http://docs.pgrouting.org/2.0/en/doc/src/developer/sampledata.html#sampledata</a></div>
<div>[2] <a href="http://docs.pgrouting.org/2.0/en/src/dijkstra/doc/index.html#examples">http://docs.pgrouting.org/2.0/en/src/dijkstra/doc/index.html#examples</a></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Thu, Aug 7, 2014 at 10:07 AM, sittichai choosumrong <span dir="ltr"><<a href="mailto:sittichai.ocu@gmail.com" target="_blank">sittichai.ocu@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Dear all,<br><br>I has implemented and install PostgreSQL/PostGIS and pgRouting on windows 7 as showing the detail of version belows;<br clear="all"><div><br></div><div>PostgreSQL = "PostgreSQL 9.3.5, compiled by Visual C++ build 1600, 32-bit"<br>
</div><div>PostGIS = "POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3924" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8" LIBJSON="UNKNOWN" TOPOLOGY RASTER"<br>
</div><div>pgRouting ="(2.0.0,pgrouting-2.0.0,0,d6ed2cb,master,1.46.1)"<br></div><div><br></div><div>After I create all needed column into my road table then use pgr_dijkstra() function. But I could not get the routing result. The table showing empty data.<br>
<br>### My road data structure is showing below;<br><br><div>-- Table: public.ways</div><div><br></div><div>-- DROP TABLE public.ways;</div><div><br></div><div>CREATE TABLE public.ways</div><div>(</div><div> gid integer NOT NULL DEFAULT nextval('ways_gid_seq'::regclass),</div>
<div> the_geom geometry(MultiLineString,3857),</div><div> source integer,</div><div> target integer,</div><div> reverse_cost double precision,</div><div> length double precision,</div><div> x1 double precision,</div>
<div> y1 double precision,</div><div> x2 double precision,</div><div> y2 double precision,</div><div> CONSTRAINT ways_pkey PRIMARY KEY (gid)</div><div>)</div><div>WITH (</div><div> OIDS=FALSE</div><div>);</div><div>
ALTER TABLE public.ways</div>
<div> OWNER TO postgres;</div><div><br></div><div>-- Index: public.source_idx</div><div><br></div><div>-- DROP INDEX public.source_idx;</div><div><br></div><div>CREATE INDEX source_idx</div><div> ON public.ways</div><div>
USING btree</div><div> (source);</div><div><br></div><div>-- Index: public.target_idx</div><div><br></div><div>-- DROP INDEX public.target_idx;</div><div><br></div><div>CREATE INDEX target_idx</div><div> ON public.ways</div>
<div> USING btree</div><div> (target);</div><div><br></div><div>-- Index: public.ways_geom_gist</div><div><br></div><div>-- DROP INDEX public.ways_geom_gist;</div><div><br></div><div>CREATE INDEX ways_geom_gist</div><div>
ON public.ways</div><div> USING gist</div><div> (the_geom);</div><div><br></div><div>-- Index: public.ways_source_idx</div><div><br></div><div>-- DROP INDEX public.ways_source_idx;</div><div><br></div><div>CREATE INDEX ways_source_idx</div>
<div> ON public.ways</div><div> USING btree</div><div> (source);</div><div><br></div><div>-- Index: public.ways_target_idx</div><div><br></div><div>-- DROP INDEX public.ways_target_idx;</div><div><br></div><div>CREATE INDEX ways_target_idx</div>
<div> ON public.ways</div><div> USING btree</div><div> (target);</div><div><br></div><br><br><br>What I am missing, any ideas?<br><br>Bomp</div>-- <br><div dir="ltr"><div dir="ltr"><div><span style="color:rgb(102,102,102)"><span style="background-color:rgb(243,243,243)">■□■□■□■□■□■□■□■□■</span></span></div>
<div><span style="color:rgb(102,102,102)"><span style="background-color:rgb(243,243,243)">Sittichai Choosumrong (Ph.D)<br>Lecturer at <span>Faculty of Agriculture, Natural Resources and Environment</span>,<br></span><span style="background-color:rgb(243,243,243)"><span>Department of Natural Resources and Environment, </span></span><br>
</span></div><div><span style="color:rgb(102,102,102)"><span style="background-color:rgb(243,243,243)">Geography<br></span></span><span style="color:rgb(102,102,102)"><span style="background-color:rgb(243,243,243)">99 Moo 9 Tambon Tha Pho, <br>
Amphoe Muang<br>Phitsanulok Thailand 65000<br></span><span style="background-color:rgb(243,243,243)"><span>Office: <a href="tel:%2B66%2055%20962753" value="+6655962753" target="_blank">+66 55 962753</a><br></span></span></span></div>
<div><span style="color:rgb(102,102,102)"><span style="background-color:rgb(243,243,243)">Mobile: <a href="tel:%2B66%2095-635-8102" value="+66956358102" target="_blank">+66 95-635-8102</a><br>
</span></span></div><div><span style="color:rgb(102,102,102)"><span style="background-color:rgb(243,243,243)">email: <a href="mailto:sittichaic@nu.ac.th" target="_blank">sittichaic@nu.ac.th</a><br></span></span></div><div>
<span style="color:rgb(102,102,102)"><span style="background-color:rgb(243,243,243)">■□■□■□■□■□■□■□■□■</span></span></div></div></div>
</div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">
<span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.info" style="color:rgb(66,99,171)" target="_blank">http://georepublic.info</a></span></div>
</div>