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

[Hao Ding]

Hi,

The previous error was disapeared by adding a port in the CONNECTION 
info. This time I got another error

msPOSTGISLayerWhichShapes(): Query error. prep_DB:Error executing 
POSTGIS DECLARE statement (0.6 failed - retried 0.5 and it failed too). 
DECLARE mycursor BINARY CURSOR FOR SELECT 
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from 
airports WHERE the_geom && setSRID('BOX3D(388013.643812817 
5200395.13465842,500802.348432817 5313156.99196842)'::BOX3D, 
find_srid('','airports','the_geom') )

How to deal with it? Thanks!

Hao


-------- Original Message --------

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
 >>
 >>
 >



_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users