[mapguide-users] Tool tips and Labeling
Johann Muller
johannfm at gmail.com
Fri Aug 25 08:22:22 EDT 2006
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 *spec*ifies 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
> <mailto: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
>> <mailto: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
>>> <mailto: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
>>> <mailto:chakraborty.sarkar at gmail.com>]
>>> Sent: Fri 2006-08-18 11:28 PM
>>> To: users at mapguide.osgeo.org
>>> <mailto: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
>>> <mailto:users-unsubscribe at mapguide.osgeo.org>
>>> For additional commands, e-mail:
>>> users-help at mapguide.osgeo.org
>>> <mailto: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]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20060825/94ed7ece/attachment.html
More information about the Mapguide_users
mailing list