<div>thanks a lot i've done it using command promp also but not as administrator as the user </div>
<div>mentioning</div>
<div><strong>psql -U postgres swift -f "D:\roads.sql"</strong></div>
<div>and i can also logged in using pgadmin wizard</div>
<div> </div>
<div>thanks Jhon.. Thanks a lot ..</div>
<div> </div>
<div>thanks jhon you have solved my most of the problems.</div>
<div> </div>
<div>now again i'm asking about using postgresql data in mapguide. </div>
<div>i'm using MG studio 2007</div>
<div> </div>
<div>i've loded the OSGeo.OGR.0.1 provider. but i don't know how can i use this.</div>
<div> </div>
<div>one more thing: i also want to prepare the postgresql database for using Dijkstras algo for shortest path & will be implemented in mapguide using OSGeo.OGR.0.1 provider.</div>
<div> </div>
<div>Is there any brief solution with u?</div>
<div> </div>
<div>i've already extracted libdijkstra.dll inside C:\Program Files\PostgreSQL\8.1\lib </div>
<div>and</div>
<div>loaded the dijkstra.sql and dijkstra_postgis.sql successfully.</div>
<div> </div>
<div>now what should be my next steps..</div>
<div> </div>
<div>thanks a lot again</div>
<div><br><br> </div>
<div><span class="gmail_quote">On 8/25/06, <b class="gmail_sendername">Johann Muller</b> <<a href="mailto:johannfm@gmail.com">johannfm@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div text="#000000" bgcolor="#ffffff">I dont know postgres/postgis well enough, but im guessing its using the windows account that you have logged in with, in this case Administrator.<br><br><br><strong>psql </strong><strong>
-U postgres -W </strong><strong>-d my_db -f country.sql <br>-U <b>spec</b>ifies user account<br>-W prompt for password<br><br></strong>Otherwise you can use PgAdmin, open the database that you want yo use and open the sql window, load the sql script file and run it.
</div>
<div><span class="e" id="q_10d4548076d1d201_1"><br><br><br><br>sukalyan chakraborty wrote:
<blockquote cite="http://midfe9cd10b0608250513h6bd08d78y87838a3c3b62c885@mail.gmail.com" type="cite">
<div><strong><font style="BACKGROUND-COLOR: rgb(255,153,0)">Yehhhh.... </font></strong></div>
<div><font style="BACKGROUND-COLOR: rgb(255,153,0)">thanks a lot... Johann</font></div>
<div> </div>
<div>I got the sql file with the write sql string.</div>
<div> </div>
<div>But now when i going to import the data into postgresql database </div>
<div> </div>
<div>using</div>
<div> </div>
<div><strong>psql -d my_db -f country.sql</strong></div>
<div>it wants the password:</div>
<div>i gave the password for the user postgres ;</div>
<div>password is sukalyan.</div>
<div>but it returns </div>
<div>psql: FATAL: password authentication failed for user "Administrator"</div>
<div>I've not yet any password for Administrator.</div>
<div>is there any default password for Administrator??</div>
<div> </div>
<div> </div>
<div>One more problem is i can not connect the server using pgadminIII</div>
<div><br><br><br> </div>
<div><span class="gmail_quote">On 8/25/06, <b class="gmail_sendername">Johann Muller</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:johannfm@gmail.com" target="_blank">johannfm@gmail.com</a>
> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div>
<div text="#000000" bgcolor="#ffffff">That is strange, here is one that i just tried. The " symbols are just there because there is spaces in the filename.<br><br><i>C:\street_data>shp2pgsql "Street 5m Buffer.shp
" buffer > buffer.sql<br>Shapefile type: Polygon<br>Postgis type: MULTIPOLYGON[2]<br></i><br>Then the beginning of my buffer.sql:<br><i><br>BEGIN;<br>CREATE TABLE "buffer" (gid serial PRIMARY KEY,<br>"prefix" varchar(2),
<br>"name" varchar(50),<br>"type" varchar(15),<br>"suffix" varchar(2),<br>"full_name" varchar(50),<br>"alt_name" varchar(50),<br>"label" varchar(50),<br>"route" varchar(30),
<br>"roadclass" varchar(10),<br>"category" varchar(20),<br>"province" varchar(30),<br>"municipal" varchar(50),<br>"cityname" varchar(30),<br>"oldcity" varchar(35),
<br>"sub_left" varchar(35),<br>"sub_right" varchar(35),<br>"f_zlev" int2,<br>"t_zlev" int2,<br>"oneway" varchar(2),<br>"ramp_flag" varchar(1),<br>"br_flag" varchar(1),
<br>"tn_flag" varchar(1),<br>"meters" numeric,<br>"speed_lim" int2);<br>SELECT AddGeometryColumn('','buffer','the_geom','-1','MULTIPOLYGON',2);</i><br><br>Once you have the buffer.sql you need to run this script on your database to import the data.
<br>The usage of the sh2sqlpgsql is as follows<br>shp2pgsql shape_file table_name > output_sql_file<br><br>Maybe try the following:<br><strong>shp2pgsql D:\roads.shp roads > d:\roads.sql<br></strong><strong></strong>
Then go to the D: drive and the contents of the file roads.sql<br><br>Hope this helps.</div>
<div><span><br><br>sukalyan chakraborty wrote:
<blockquote cite="http://midfe9cd10b0608242257g1ab6d2cfm5a3caf08dd4ebbc0@mail.gmail.com" type="cite">
<div>roads.sql is blank after running this .</div>
<div>and it is running if i provide the commnd</div>
<div><strong>shp2pgsql D:\roads.shp roads.sql </strong></div>
<div>then postgre running the command and showing the extraction data from shp file but</div>
<div>i'm sorry to say u that after that also the roads.sql file is blank.</div>
<div>i'm also unable to see the database from postgre database window.</div>
<div><br><br> </div>
<div><span class="gmail_quote">On 8/25/06, <b class="gmail_sendername">Johann Muller</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:johannfm@gmail.com" target="_blank">johannfm@gmail.com</a>
> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div>
<div text="#000000" bgcolor="#ffffff">Is there any errors that occur when you run the command? <br>And what is the contents of <b>roads.sql </b>after you have run the command?</div>
<div><span><br><br>sukalyan chakraborty wrote:
<blockquote cite="http://midfe9cd10b0608242224n2883cc88wf8edc3c45e28ed93@mail.gmail.com" type="cite">
<div>thanks a lot i've started my jouney on Shortest path calculation.. at the path of my journey</div>
<div>i'm facing problem on <strong>shp2pgsql D:\roads.shp roads > roads.sql </strong>to convert the sql file into postgreSQL 8 format. it is not converting. Is there any help with anybody??</div>
<div><br><br> </div>
<div><span class="gmail_quote">On 8/19/06, <b class="gmail_sendername">Jason Birch</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Jason.Birch@nanaimo.ca" target="_blank">Jason.Birch@nanaimo.ca
</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">There is no direct routing (or geocoding) capability in MapGuide. However you could implement this at the database level. Here's a link that might help:
<br><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://chris.narx.net/2005/12/14/build-your-own-routing-solution/" target="_blank">http://chris.narx.net/2005/12/14/build-your-own-routing-solution/</a>
<br><br>I'm not sure if this will work with the OGR provider for PostGIS. <br><br>I guess you could set up a table that contains a cross product of all the nodes, along with the routes between them and the relative costs. This could get very, very large though.
<br><br>Also, you'd have to build some logic to extract the portions of the lines between the start/destination points on the line and the nodes at the start/end of the shortest route. <br><br>You'd probably want to use a few different weighting mechanisms too: distance, speed, fewest left turns, etc.
<br><br>This feature isn't of huge use to me, but I think it should be high on the wishlist.<br><br>Jason <br><br><br>________________________________<br><br>From: sukalyan chakraborty [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:chakraborty.sarkar@gmail.com" target="_blank">
chakraborty.sarkar@gmail.com</a>]<br>Sent: Fri 2006-08-18 11:28 PM<br>To: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:users@mapguide.osgeo.org" target="_blank">users@mapguide.osgeo.org</a><br>Subject: Re: [mapguide-users] Tool tips and Labeling
<br><br><br>Thanks a lot i've solved my problem<br><br>Now can any body help me how can i implement a routing algorithm on mapguide to find <br>the shortest path and as well as all posible path.<br><br>Is there any help or link available.
<br><br><br>--<br>Thanks A Lot<br>Have A Nice Time<br>Have Fun<br>Be Jolly<br>Sukalyan Chakraborty<br>[Software Developer]<br><br>---------------------------------------------------------------------<br>To unsubscribe, e-mail:
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:users-unsubscribe@mapguide.osgeo.org" target="_blank">users-unsubscribe@mapguide.osgeo.org</a><br>For additional commands, e-mail: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:users-help@mapguide.osgeo.org" target="_blank">
users-help@mapguide.osgeo.org</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>Thanks A Lot<br>Have A Nice Time<br>Have Fun<br>Be Jolly<br>Sukalyan Chakraborty<br>[Software Developer] </blockquote></span></div>
</div></blockquote></div><br><br clear="all"><br>-- <br>Thanks A Lot<br>Have A Nice Time<br>Have Fun<br>Be Jolly<br>Sukalyan Chakraborty<br>[Software Developer] </blockquote></span></div></div></blockquote></div><br><br clear="all">
<br>-- <br>Thanks A Lot<br>Have A Nice Time<br>Have Fun<br>Be Jolly<br>Sukalyan Chakraborty<br>[Software Developer] </blockquote></span></div>
<div></div></div></blockquote></div><br><br clear="all"><br>-- <br>Thanks A Lot<br>Have A Nice Time<br>Have Fun<br>Be Jolly<br>Sukalyan Chakraborty<br>[Software Developer]