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

[李杨]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120826/6dbcdd08/attachment.htm>