[postgis-users] PostGIS data in mapserver

Tue Jul 2 08:49:40 PDT 2002

sure,

here is my map file definition :

#
# Start of map file
#
NAME DEMO
STATUS ON
SIZE 600 600
EXTENT -94 2 80 80
UNITS DD
SHAPEPATH "data"
IMAGECOLOR 255 255 255

# you may need to change this to match your MapServer build
IMAGETYPE PNG

#
# Projection definition, consult the PROJ.4 documentation for parameter
discussion
#
#PROJECTION
#  "proj=utm"
#  "ellps=GRS80"
#  "zone=15"
#  "north"
#  "no_defs"
#
#  OR:
#
#  "init=epsg:26915"
#END

#
# Start of web interface definition (including WMS enabling metadata)
#
WEB
  HEADER demo_header.html
  TEMPLATE demo.html
  FOOTER demo_footer.html
  MINSCALE 1000
  MAXSCALE 1550000
  IMAGEPATH "set in my_init.html"
  IMAGEURL "set in my_init.html"
  METADATA
    WMS_TITLE "UMN MapServer Itasca Demo"
    WMS_ABSTRACT "This is the UMN MapServer demonstration application for Itasca
County located in north central Minnesota."
    WMS_ACCESSCONSTRAINTS none

    # change this value to match your setup
    WMS_ONLINERESOURCE "http://mithrandir/cbe/mapserver/Postgis/my_init.html"

    WMS_SRS "EPSG:26915"
  END
END

QUERYMAP
  SIZE 200 200
  STATUS ON
  STYLE HILITE
  COLOR 255 0 0
END

#
# Start of reference map
#
REFERENCE
  IMAGE graphics/reference.png
  EXTENT -94 2 80 80
  SIZE 600 600
  STATUS ON
  COLOR -1 -1 -1
  OUTLINECOLOR 255 0 0
END

#
# Start of legend
#
LEGEND
  KEYSIZE 18 12
  LABEL
    TYPE BITMAP
    SIZE MEDIUM
    COLOR 0 0 89
  END
  STATUS ON
END

#
# Start of scalebar
#
SCALEBAR
  IMAGECOLOR 0 0 255
  LABEL
    COLOR 255 255 255
    SIZE tiny
  END
  STYLE 0
  SIZE 280 2
  COLOR 155 255 255
  UNITS METERS
  INTERVALS 5
  TRANSPARENT FALSE
  STATUS TRUE
END

#
# Start of layer definitions
#

LAYER
  CONNECTIONTYPE postgis
  NAME "Fir"
  CONNECTION "user=cbe dbname=sigdb host=localhost"
  DATA "the_geom from fir"
  STATUS ON
  TYPE POLYGON
  CLASS
    COLOR 0 255 0
    SIZE 2
  END
END

END # Map File

my table "fir has 2 column "key" and "the_geom"

and here is one of my record

 AYPM/F/PORT MORESBY
          | SRID=54004;POLYGON((148.828339 2.8e-05,154.228333 -0,
156.833328 2.8e-05,160 -0,160 -4.833333,159 -4.833333,158.259995
-5.285,157.668335 -5.645,
156.104996 -6.59,155.990005 -6.74,155 -7.316667,155 -7.41,155 -9.928333,155 -12,
144.96167 -12,144 -12,144.07222 -11.725,144.026672 -11.5,144.080276 -11.388333,
144.165283 -11.233055,144.178329 -11.093889,144.121109 -11.043333,143.96666
-10.550834,
144.031113 -10.214444,144.089172 -9.942778,144.233337 -9.4,143.875 -9.133333,
142.804993 -9.323334,142.731674 -9.338333,142.695007 -9.34,142.59166 -9.356667,
142.558334 -9.376667,142.524994 -9.363334,142.494995 -9.368333,142.345001
-9.268333,
142.273331 -9.231667,142.235001 -9.193334,142.214996 -9.19,142.171661 -9.2,
142.143326 -9.198334,142.106674 -9.213333,142.058334 -9.261666,141.018326
-9.616667,
141.018326 -9.191667,141 -8.6,141.018326 -6.891667,140.952774
-6.911111,140.916672 -6.875,
140.891663 -6.85,140.875 -6.783333,140.899994 -6.75,140.84584
-6.716667,140.850006 -6.683333,
140.837494 -6.616667,140.883331 -6.566667,140.920837 -6.505556,140.916672 -6.425,

140.941666 -6.375,140.958328 -6.325,141 -6.316667,141 -4.966667,141 -2.723333,141
-2.555,
141 -0,142.856674 -0,146.141663 -0,148.828339 2.8e-05))

Tyler Mitchell a écrit :

> Could you show us how you defined your layer in the map file?  Also, could
> you show us the details of your table structure (i.e. field definitions) for
> the layer?
>
> On Tuesday 02 July 2002 02:15 am, you wrote:
> > Hi all ,
> > thanks to Chip, Tommie and Tyler for your help,
> >
> > I have something wrong with my configuration of Mapserver.
> >
> > Here is the problem :when I add a layer in my map file (which is the demo
> > itasca) with a postgis connection type and when I try to visualize it with
> > ms ;  I obtain a query error from msPOSTGISLayerWhichShapes() executing the
> > POSTGIS SQL statement.
> >
> > To me, the problem is than my data used SRID 54004 and are world data.
> >
> > So if I try to add the data contained in BOX3D (387919.653225817
> > 5200489.10287243, 500708...)(this is part of my error message)  it doesn't
> > correspond to anything in my database.
> >
> > Am I right ?
> >
> > How can I specify the range to query in ?
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cedric.bernier.vcf
Type: text/x-vcard
Size: 377 bytes
Desc: Carte pour Cedric BERNIER
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020702/925d9800/attachment.vcf>