[postgis-users] Trouble getting PostGIS data to display in MapServer

[Nicolas Ribot]

> Thanks for the quick response.
> I've tried with just about every combination of lat/long (including -72)
> with no results.  I was just using the list here:
> http://www.realestate3d.com/gps/uslatlongdegmin.htm so I'm really not sure
> if they're all hosed or what.  My current viewer's extents extend from
> central america up to the north pole so I figured I would have hit
> something in the area by now ;)
> I modified my .map file as per your suggestions to look like this:
>         CONNECTION "user=postgres password=pgadmin dbname=test
> host=localhost port=5432"
>         DATA "point from cities using unique oid using SRID=4326"
> I assume that's what you meant for the DATA clause.  I know for sure that
> MapServer is connecting to the database & executing the queries, I can see
> as much in the PostgreSQL logs.
> If I set the layers status to default it's turned off when I load up my
> viewer & I'm still unable to display it when I turn it on and refresh the
> viewer.
> 

Maybe try to change the symbol for your points:
your CLASS definition, on my system, leads to a single-pixel point,
dispite the SIZE 50.

You can try something like:
# for CLASS part of the POINT layer definition:
class
        color 255 0 0
        symbol "circle"
        size 10
    end
# at the end of the mapfile, the following symbol def:
  symbol
   name "circle"
   type ellipse
   
   points
    1 1
   end
  end

Nicolas