<div dir="ltr"><div><div><div><div>Hi Daniel and all list,<br><br>Again problem. I downloaded OSM data and save as shapefile using projection EPSG:3857.<br>I try to use many data but I still could not get result.<br><br></div>
<div>Actually, pgRouting can run on Windows7 but the problem is when I implement the road network data.<br></div><div><br></div>I just realise after I test with the same data in difference OS (Ubuntu, Windows8 and Windows7)<br>
</div>Ubuntu and Windows8 is work well but the problem is;<br>On Windows7, the system cannot get the correct topology after use command<br><br> '<span class="">SELECT</span> <span class="">pgr_createTopology</span><span class="">(</span><span class="">'ways'</span><span class="">,</span> <span class="">0</span><span class="">.</span><span class="">00001</span><span class="">,</span> <span class="">'the_geom'</span><span class="">,</span> <span class="">'gid'</span><span class="">);</span>' <br>
<br></div>You can see how its strange in the image files in this mail.<br><br></div><div>With the same data, 'topo_correct.jpg' showing the topology node which created on Window8 and we get the node for all junction which have only one ID values.<br>
</div><div>But, 'topo_error.jpg' showing the topology node which created on Windows7 and in one node its have ID values depend on how much edge connect on that node.<br><br></div><div>I think because of the problem that why when I use pgRouting function I got only empty table without any error of calculating.<br>
</div><div><br></div><div>Any ideas?<br><br>Best regards,<br>Bomp<br></div> <br><div><br><br><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Aug 7, 2014 at 3:37 PM, 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">Hi Daniel,<br><br>Now it work!! Thank you. The problem is from my data because the geometry is "multilinestring"<br>
I have to change to "linestring"<br><br>Best regards,<br>Bomp<br><br>P.S. If you need any help about pgRouting workshop on FOSS4G-ASIA in Thailand this years (<a href="http://www.foss4g-asia.org/2014/programmenu/workshops/" target="_blank">http://www.foss4g-asia.org/2014/programmenu/workshops/</a>), please feel free to tell me what can I help you?</div>
<div class="HOEnZb"><div class="h5">
<div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Aug 7, 2014 at 3:25 PM, Daniel Kastl <span dir="ltr"><<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</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">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" target="_blank">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" target="_blank">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"><div><div>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>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>
<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></div></div>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">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><span><font color="#888888"><br></font></span></blockquote></div>
<span><font color="#888888"><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>
</font></span></div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">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">
<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: +66 55 962753<br></span></span></span></div><div><span style="color:rgb(102,102,102)"><span style="background-color:rgb(243,243,243)">Mobile: +66 95-635-8102<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>
</div></div></blockquote></div><br><br clear="all"><br>-- <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: +66 55 962753<br></span></span></span></div><div><span style="color:rgb(102,102,102)"><span style="background-color:rgb(243,243,243)">Mobile: +66 95-635-8102<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>