Dear Sittichai,<br><br>Thank you for your reply, very useful and helpful.<br><br>Would you mind just confirming though that you have installed PostgreSQL 9.0 in Windows, and then used the PGRouting 8.4.2 Windows Binary to install PGRouting? And that it works fine?<br>
<br>Thank you<br><br>James<br><br><br><br><br><div class="gmail_quote">On 17 December 2011 17:27, sittichai choosumrong <span dir="ltr"><<a href="mailto:sittichai.ocu@gmail.com">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">Hi James,<br><br>About your question;<div><div class="im"><br><br>>> 1) I note that PGRouting with Windows Binaries is on version 8.4.2 <br>
</div>>> (<a href="http://www.pgrouting.org/download.html#windows-binaries" target="_blank">http://www.pgrouting.org/download.html#windows-binaries</a> ). Could someone<div class="im"><br>
>> please confirm which version of PostgreSQL I should install to ensure that<br>
>> PGRouting works with it? List here:<br>
<br></div></div>I also installed pgRouting on Windows 7 Binaries and I installed postgresql 8.4 it is work well :) <br>for another computer I use postgresql 9.0 this version also have no problem with pgRouting on my PC.<br>
So you can choose.<div class="im"><div><br><br>
>> 2) I have a road network that I use in ArcGIS at the moment, stored in an<br>
>> access database, but I would like to use it in PG Routing instead. Could<br>
>> someone talk me through how to do this or provide a link to a guide? I<br>
>> thought that I could perhaps save it as a Shapefile and then use the QGIS<br>
>> 'Spit' tool to move it into the PostgreSQL database. Would this be a<br>
>> suitable method? Will it work?<br>
<br></div></div>You can see this link <a href="http://www.pgrouting.org/docs/foss4g2008/ch05.html" target="_blank">http://www.pgrouting.org/docs/foss4g2008/ch05.html</a><br><br>Hope this is could help you to start working with pgRouting :)<br>
Bomp<br><br>P.S. Am sorry about the previous mail that I forgot to change the subject.<br><br><div class="gmail_quote">On Sat, Dec 17, 2011 at 2:00 AM, <span dir="ltr"><<a href="mailto:pgrouting-users-request@lists.osgeo.org" target="_blank">pgrouting-users-request@lists.osgeo.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Pgrouting-users mailing list submissions to<br>
<a href="mailto:pgrouting-users@lists.osgeo.org" target="_blank">pgrouting-users@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:pgrouting-users-request@lists.osgeo.org" target="_blank">pgrouting-users-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:pgrouting-users-owner@lists.osgeo.org" target="_blank">pgrouting-users-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Pgrouting-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Install Pg Routing in Windows environment? (James David Smith)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Fri, 16 Dec 2011 11:13:31 +0000<br>
From: James David Smith <<a href="mailto:james.david.smith@gmail.com" target="_blank">james.david.smith@gmail.com</a>><br>
Subject: [pgrouting-users] Install Pg Routing in Windows environment?<br>
To: pgRouting users mailing list <<a href="mailto:pgrouting-users@lists.osgeo.org" target="_blank">pgrouting-users@lists.osgeo.org</a>><br>
Message-ID:<br>
<<a href="mailto:CAMu32AAYHZ10X7CK7mV%2Bq5r2BvJTq8_nXGFhZUNLXyr7Ss6_Jg@mail.gmail.com" target="_blank">CAMu32AAYHZ10X7CK7mV+q5r2BvJTq8_nXGFhZUNLXyr7Ss6_Jg@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<div><div class="h5"><br>
<br>
Hi everyone,<br>
<br>
A couple of basic questions that I hope someone could help me with.<br>
<br>
1) I note that PGRouting with Windows Binaries is on version 8.4.2 (<br>
<a href="http://www.pgrouting.org/download.html#windows-binaries" target="_blank">http://www.pgrouting.org/download.html#windows-binaries</a> ). Could someone<br>
please confirm which version of PostgreSQL I should install to ensure that<br>
PGRouting works with it? List here:<br>
<a href="http://www.enterprisedb.com/products-services-training/pgdownload" target="_blank">http://www.enterprisedb.com/products-services-training/pgdownload</a> . As an<br>
aside I will be wanting to use PostGIS too, but I hope/prsume that this is<br>
largely unrelated to my question.<br>
<br>
2) I have a road network that I use in ArcGIS at the moment, stored in an<br>
access database, but I would like to use it in PG Routing instead. Could<br>
someone talk me through how to do this or provide a link to a guide? I<br>
thought that I could perhaps save it as a Shapefile and then use the QGIS<br>
'Spit' tool to move it into the PostgreSQL database. Would this be a<br>
suitable method? Will it work?<br>
<br>
Thank you and best wishes<br>
<br>
James<br></div></div>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20111216/76083eeb/attachment-0001.html" target="_blank">http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20111216/76083eeb/attachment-0001.html</a><br>
<br>
------------------------------<br>
<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>
<br>
<br>
End of Pgrouting-users Digest, Vol 39, Issue 17<br>
***********************************************<span class="HOEnZb"><font color="#888888"><br>
</font></span></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><br>-- <br><div>$B"#"""#"""#"""#"""#"""#"""#"""#"""#(B<br>Free and Open Source Software for Geospatial<br>GIS Laboratory <br>Osaka City University $BBg:e;TN)Bg3X(B <br>
Sittichai Choosumrong<br>TEL<font color="#17365d"> <span><a href="tel:%2B81-90-6558-8559" value="+819065588559" target="_blank">+81-90-6558-8559</a></span><span dir="ltr"><span></span><span dir="ltr" title="Call this phone number in Japan with Skype: +819065588559"><span> </span><span title="Skype actions"><span> </span> </span><span><span> </span></span></span></span></font><br>
$B"#"""#"""#"""#"""#"""#"""#"""#"""#(B</div><br>
</font></span><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>
<br></blockquote></div><br>