<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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.<br>
<br>
<br>
<br>
sukalyan chakraborty wrote:
<blockquote
cite="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
href="mailto:johannfm@gmail.com">johannfm@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">
<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 class="e" id="q_10d440a072617b1a_1"><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="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">
<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="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">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>
</body>
</html>