[mapserver-users] still have problem when add postgis layer on mapserver mapfile

[Havard Tveite]

In later versions of Mapserver, you seem to need to use a symbol.
For example:

   SYMBOL
     NAME "circle"
     TYPE ellipse
     POINTS
       1 1
     END
   END


   LAYER
   ...
     CLASS
     NAME "places1_color"
       STYLE
         SYMBOL 'circle'
         COLOR 255 215 0
         SIZE 1
       END # style
     END # class
   END # layer

I guess the documentation needs to be updated.

Håvard

On 08/26/2012 07:57 AM, 李杨 wrote:
> I try to load a postgis data layer on my mapfile, have problem when
> configure the mapfile done, then visit it using
> "http://127.0.0.1/cgi-bin/mapserv?&map=/var/www/osm-google.map&mode=map&mode=map"
> on the browser address. , only a blank blue image return, with no
> expected dot info.
>
> I can not figure out which step is have problem.
>
> Provide background info:
>
> ogrinfo for the database  table:
>
> jack at jack-Vostro-1450:/usr/lib/cgi-bin$ ogrinfo PG:"host=127.0.0.1
> user=osm  password=osm dbname=osm port=5432" osm_new_mainroads -summary
> INFO: Open of `PG:host=127.0.0.1 user=osm  password=osm dbname=osm
> port=5432'
>        using driver `PostgreSQL' successful.
>
> Layer name: osm_new_mainroads
> Geometry: Line String
> Feature Count: 9704
> Extent: (-9871463.421196, 3533052.471384) - (-9460289.228784,
> 4190971.740014)
> Layer SRS WKT:
> PROJCS["Popular Visualisation CRS / Mercator (deprecated)",
>      GEOGCS["Popular Visualisation CRS",
>          DATUM["Popular_Visualisation_Datum",
>              SPHEROID["Popular Visualisation Sphere",6378137,0,
>                  AUTHORITY["EPSG","7059"]],
>              TOWGS84[0,0,0,0,0,0,0],
>              AUTHORITY["EPSG","6055"]],
>          PRIMEM["Greenwich",0,
>              AUTHORITY["EPSG","8901"]],
>          UNIT["degree",0.01745329251994328,
>              AUTHORITY["EPSG","9122"]],
>          AUTHORITY["EPSG","4055"]],
>      UNIT["metre",1,
>          AUTHORITY["EPSG","9001"]],
>      PROJECTION["Mercator_1SP"],
>      PARAMETER["central_meridian",0],
>      PARAMETER["scale_factor",1],
>      PARAMETER["false_easting",0],
>      PARAMETER["false_northing",0],
>      AUTHORITY["EPSG","3785"],
>      AXIS["X",EAST],
>      AXIS["Y",NORTH]]
> FID Column = id
> Geometry Column = geometry
> osm_id: Integer (0.0)
> name: String (255.0)
> type: String (255.0)
> tunnel: Integer (5.0)
> bridge: Integer (5.0)
> oneway: Integer (5.0)
> ref: String (255.0)
> z_order: Integer (5.0)
> jack at jack-Vostro-1450:/usr/lib/cgi-bin$
>
> --------------------------------------------------------------------------------------------
> .map(uing in the link above : osg-google.map) info for configure:
>
> MAP
> NAME places1
> STATUS ON
> SIZE 800 800
> EXTENT -9871463.421196 3533052.471384 -9460289.228784 4190971.740014
> UNITS meters
> IMAGECOLOR 153 179 204
>
>
> WEB
>      IMAGEPATH "/var/www/output"
>      IMAGEURL "/output/"
> END
>
> LAYER
>   STATUS DEFAULT
>   NAME "places1"
>   DATA "geometry from osm_new_mainroads using unique osm_id using srid 3785"
>   TYPE POINT
>   CONNECTIONTYPE postgis
>   CONNECTION "host=localhost dbname=osm user=osm password=osm port=5432"
>   CLASS
> NAME "places1_color"
> COLOR 255 215 0
>    END
> END
>
> END
>
> -------------------------
> for a explanation , whenever set  "DATA "geometry from osm_new_mainroads
> using unique osm_id using srid 3785"",
> DATA "geometry from osm_new_mainroads", or
> DATA "geometry from osm_new_mainroads using unique osm_id using srid 3875
>
> is the same , a blank image return
> -------------------------------------------------------
> massperv version info:
>
> ./mapserv -v
> MapServer version 6.0.3 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG SUPPORTS=PROJ
> SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER
> SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT
> SUPPORTS=GEOS INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
>
>
>
> I try to experiment it in two different laptop and can not get expected
> result.
>
> Please those with experience help me., this problem qurrall  me a lot
> this weeked.
>
> Thanks a lot.
>
>
> --
> Yang Li
> GIS Developer
> P.R.China
>
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>