[Fwd: Re: [postgis-users] dataset for postgis]

[Hao Ding]

Hi,

I got the error message when querying the map using itasca demo application

msPOSTGISLayerOpen(): Query error. Error parsing POSTGIS connection 
information.

The following is the Layer I set up in the mapfile

LAYER
   NAME "airports"
   CONNECTIONTYPE postgis
   CONNECTION "user=ryan dbname=gisdb host=localhost"
   TYPE POINT
   DATA "the_geom from airports"
   STATUS ON
   CLASS
     NAME 'Airports'
     COLOR 128 255 164
     SYMBOL 'circle'
     SIZE 7
     TEMPLATE "airports.html"
   END

   HEADER "airports_header.html"
   FOOTER "airports_footer.html"

   TOLERANCE 5

   METADATA
     WMS_TITLE "Airports"
     WMS_ABSTRACT "Airport runways for Itasca County."
     WMS_SRS "EPSG:26915"
   END
END

Is there somewhere wrong? Do I have to add a port number in the 
CONNECTION info? How do I know the port the postgis is running?

Thanks
Hao


Tyler Mitchell wrote:

> Hi Hao, we can talk about it off of the list if you'd like.  It's not really
> Postgis related.  You will need to setup a layer that reads your postgis
> data first.
> 
> 
>>-----Original Message-----
>>From: postgis-users-admin at postgis.refractions.net
>>[mailto:postgis-users-admin at postgis.refractions.net]On Behalf Of Hao
>>Ding
>>Sent: Thursday, July 04, 2002 3:44 PM
>>To: themitchells at telus.net
>>Cc: postgis-users at postgis.refractions.net
>>Subject: [Fwd: Re: [postgis-users] dataset for postgis]
>>
>>
>>Hi Tyler,
>>
>>I have converts the shapefile to sql file successfully. Now Could you
>>tell me how to set up WMS server mapfile in Mapserver for the data?
>>
>>Thanks a lot!
>>Hao
>>
>>-------- Original Message --------
>>Subject: Re: [postgis-users] dataset for postgis
>>Date: Fri, 05 Jul 2002 10:21:51 +1200
>>From: Hao Ding <hdi12 at it.canterbury.ac.nz>
>>Reply-To: postgis-users at postgis.refractions.net
>>Organization: University of Canterbury
>>To: Tyler Mitchell <themitchells at telus.net>
>>CC: postgis-users at postgis.refractions.net
>>References: <3D1F480A at webmail>
>><20020702050233.RUUD5909.priv-edtnes16-hme0.telusplanet.net at there>
>>
>>Hi,
>>
>>I tried creating a sql file from Itasca demo shapefile, but got
>>"Segmentation fault" error. Are there some faults in the command?
>>
>>cosc273:data$ shp2pgsql airports airports gisdb > airports.sql
>>Segmentation fault
>>
>>Thanks,
>>Hao
>>
>>
>>Tyler Mitchell wrote:
>>
>> > hi Hao,
>> > Do you have the Itasca demo data for Mapserver?  You can use the
>>postgis tool
>> > called 'shp2pgsql' (I can give you more info if needed) to
>>create a
>>SQL file
>> > and then you can load the sql commands into postgis.
>> > I don't have time right now but I'll gladly help walk you
>>through it.
>>  I even
>> > have a set of SQL files for the demo data available if you
>>want them.
>>  Just
>> > let me know.
>> >
>> > Tyler
>> > On Monday 01 July 2002 09:44 pm, you wrote:
>> >
>> >>Hi all,
>> >>
>> >>Now I am implementing a OGC WMS client application.  I
>>have installed
>> >>MapServer as WMS server and postgis as back-end
>>datasource.  Where can I
>> >>find some spatial dataset that can be stored in the
>>postgis and used by
>> >>MapServer? If I get some dataset, how to put them into
>>postgis and make
>> >>them work with MapServer?
>> >>
>> >>These questions could be simple for someone, but I am a new user of
>> >>MapServer and postgis, and the documents don't provide me all
>>information I
>> >>am hunting. Thanks very much for any help?
>> >>
>> >>Regards,
>> >>Hao
>> >>
>> >>
>> >>
>> >>_______________________________________________
>> >>postgis-users mailing list
>> >>postgis-users at postgis.refractions.net
>> >>http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >>
>>
>>
>>
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>