[mapguide-users] Tool tips and Labeling

Fri Aug 25 09:16:03 EDT 2006

thanks a lot i've done it using command promp also but not as administrator
as the user
mentioning
*psql -U postgres swift -f "D:\roads.sql"*
and i can also logged in using pgadmin wizard

thanks Jhon.. Thanks a lot ..

thanks jhon you have solved my most of the problems.

now again i'm asking about using postgresql data in mapguide.
i'm using MG studio 2007

i've loded the OSGeo.OGR.0.1 provider. but i don't know how can i use this.

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.

Is there any brief solution with u?

i've already extracted libdijkstra.dll inside C:\Program
Files\PostgreSQL\8.1\lib
and
loaded the dijkstra.sql and dijkstra_postgis.sql successfully.

now what should be my next steps..

thanks a lot again

On 8/25/06, Johann Muller <johannfm at gmail.com> wrote:
>
>  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.
>
>
> *psql **-U postgres -W **-d my_db -f country.sql
> -U specifies user account
> -W prompt for password
>
> *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.
>
>
>
>
> sukalyan chakraborty wrote:
>
> *Yehhhh....   *
> thanks a lot... Johann
>
> I got the sql file with the write sql string.
>
> But now when i going to import the data into postgresql database
>
> using
>
> *psql -d my_db -f country.sql*
> it wants the password:
> i gave the password for the user postgres ;
> password is sukalyan.
> but it returns
> psql: FATAL: password authentication failed for user "Administrator"
> I've not yet any password for Administrator.
> is there any default password for Administrator??
>
>
> One more problem is i can not connect the server using pgadminIII
>
>
>
>
> On 8/25/06, Johann Muller <johannfm at gmail.com> wrote:
> >
> >  That is strange, here is one that i just tried. The " symbols are just
> > there because there is spaces in the filename.
> >
> > *C:\street_data>shp2pgsql "Street 5m Buffer.shp " buffer > buffer.sql
> > Shapefile type: Polygon
> > Postgis type: MULTIPOLYGON[2]
> > *
> > Then the beginning of my buffer.sql:
> > *
> > BEGIN;
> > CREATE TABLE "buffer" (gid serial PRIMARY KEY,
> > "prefix" varchar(2),
> > "name" varchar(50),
> > "type" varchar(15),
> > "suffix" varchar(2),
> > "full_name" varchar(50),
> > "alt_name" varchar(50),
> > "label" varchar(50),
> > "route" varchar(30),
> > "roadclass" varchar(10),
> > "category" varchar(20),
> > "province" varchar(30),
> > "municipal" varchar(50),
> > "cityname" varchar(30),
> > "oldcity" varchar(35),
> > "sub_left" varchar(35),
> > "sub_right" varchar(35),
> > "f_zlev" int2,
> > "t_zlev" int2,
> > "oneway" varchar(2),
> > "ramp_flag" varchar(1),
> > "br_flag" varchar(1),
> > "tn_flag" varchar(1),
> > "meters" numeric,
> > "speed_lim" int2);
> > SELECT AddGeometryColumn('','buffer','the_geom','-1','MULTIPOLYGON',2);*
> >
> > Once you have the buffer.sql you need to run this script on your
> > database to import the data.
> > The usage of the sh2sqlpgsql is as follows
> > shp2pgsql shape_file table_name > output_sql_file
> >
> > Maybe try the following:
> > *shp2pgsql D:\roads.shp roads > d:\roads.sql
> > ***Then go to the D: drive and the contents of the file roads.sql
> >
> > Hope this helps.
> >
> >
> > sukalyan chakraborty wrote:
> >
> > roads.sql is blank after running this .
> > and it is running if i provide the commnd
> > *shp2pgsql D:\roads.shp roads.sql *
> > then postgre running the command and showing the extraction data from
> > shp file but
> > i'm sorry to say u that after that also the roads.sql file is blank.
> > i'm also unable to see the database from postgre database window.
> >
> >
> >
> > On 8/25/06, Johann Muller <johannfm at gmail.com > wrote:
> > >
> > >  Is there any errors that occur when you run the command?
> > > And what is the contents of *roads.sql *after you have run the
> > > command?
> > >
> > >
> > > sukalyan chakraborty wrote:
> > >
> > > thanks a lot i've started my jouney on Shortest path calculation.. at
> > > the path of my journey
> > > i'm facing problem on *shp2pgsql D:\roads.shp roads > roads.sql *to
> > > convert the sql file into postgreSQL 8 format. it is not converting. Is
> > > there any help with anybody??
> > >
> > >
> > >
> > > On 8/19/06, Jason Birch <Jason.Birch at nanaimo.ca > wrote:
> > > >
> > > > 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:
> > > >
> > > > http://chris.narx.net/2005/12/14/build-your-own-routing-solution/
> > > >
> > > > I'm not sure if this will work with the OGR provider for PostGIS.
> > > >
> > > > 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.
> > > >
> > > > 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.
> > > >
> > > > You'd probably want to use a few different weighting mechanisms
> > > > too:  distance, speed, fewest left turns, etc.
> > > >
> > > > This feature isn't of huge use to me, but I think it should be high
> > > > on the wishlist.
> > > >
> > > > Jason
> > > >
> > > >
> > > > ________________________________
> > > >
> > > > From: sukalyan chakraborty [mailto: chakraborty.sarkar at gmail.com]
> > > > Sent: Fri 2006-08-18 11:28 PM
> > > > To: users at mapguide.osgeo.org
> > > > Subject: Re: [mapguide-users] Tool tips and Labeling
> > > >
> > > >
> > > > Thanks a lot i've solved my problem
> > > >
> > > > Now can any body help me how can i implement a routing algorithm
> > > > on  mapguide to find
> > > > the shortest path and as well as all posible path.
> > > >
> > > > Is there any help or link available.
> > > >
> > > >
> > > > --
> > > > Thanks A Lot
> > > > Have A Nice Time
> > > > Have Fun
> > > > Be Jolly
> > > > Sukalyan Chakraborty
> > > > [Software Developer]
> > > >
> > > >
> > > > ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> > > > For additional commands, e-mail: users-help at mapguide.osgeo.org
> > > >
> > > >
> > >
> > >
> > > --
> > > Thanks A Lot
> > > Have A Nice Time
> > > Have Fun
> > > Be Jolly
> > > Sukalyan Chakraborty
> > > [Software Developer]
> > >
> > >
> >
> >
> > --
> > Thanks A Lot
> > Have A Nice Time
> > Have Fun
> > Be Jolly
> > Sukalyan Chakraborty
> > [Software Developer]
> >
> >
>
>
> --
> Thanks A Lot
> Have A Nice Time
> Have Fun
> Be Jolly
> Sukalyan Chakraborty
> [Software Developer]
>
>

-- 
Thanks A Lot
Have A Nice Time
Have Fun
Be Jolly
Sukalyan Chakraborty
[Software Developer]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20060825/e2922c2e/attachment.html