PostGIS 1.0.0-rc2 points not rendering

[Paul Ramsey]

Ken,
You'll want to move to RC4, there was a problem w/ mapserver in early
releases of postgis 1.0.
Paul

On 21-Mar-05, at 7:16 PM, Ken-ichi wrote:

> Hi all. Forgive me if this has been dealt with before but I wasn't able
> to find anything.  I'm having trouble rendering a point layer from
> PostGIS in MapServer.  The points in the table were entered via SQL
> using the GeometryFromText() function, using a custom projection that I
> entered into the spatial_ref_sys table.  Adding the points does not
> generate any errors, and when I select the rows in psql using the
> AsText() function, they look fine.  However, they do not render in
> MapServer (nor do they render in QGIS, for that matter).  There are no
> errors, just no points.  I can dump the points out into a shapefile
> using pgsql2shp and they show up fine.  I'm fairly sure this setup
> worked in PostgreSQL 7.x and PostGIS < 1.0.  Here are the details of my
> setup:
>
> Mac OS X
> MapServer 4.4.1
> Postgresql 8.0.1
> PostGIS 1.0.0-rc2
>
> CUSTOM PROJECTION
> srid: 1000
> auth_name: CA_Albers
> srtext:
> PROJCS["CA_Albers",GEOGCS["GCS_North_American_1927",DATUM["D_North_Amer
> i
> can_1927",SPHEROID["Clarke_1866",6378206.4,294.9786982]],PRIMEM["Greenw
> i
> ch",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAME
> T
> ER["False_Easting",0.0],PARAMETER["False_Northing",
> -4000000.0],PARAMETER["Central_Meridian",
> -120.0],PARAMETER["Standard_Parallel_1",34.0],PARAMETER["Standard_Paral
> l
> el_2",40.5],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]
> proj4text: +proj=aea +ellps=clrk66 +datum=NAD27 +lon_0=-120 +lat_1=34
> +lat_2=40.5 +x_0=0 +y_0=-4000000 +units=m
>
> SQL
>
> insert into test_points (name, comment, the_geom, error) values
> ('name', 'comment', GeometryFromText('POINT(-211189.484375
> -23160.20625)', 1000), 30);
>
> MAPFILE
>
> MAP
>   NAME "blah"
>   EXTENT -293050 -120300 -103350 71250
>   SIZE 500 500
>   SHAPEPATH "data"
>   SYMBOLSET "../../tutorial/etc/symbols.sym"
>   FONTSET "../../tutorial/etc/fonts.txt"
>   IMAGETYPE PNG
>   UNITS METERS
>   WEB
>     IMAGEPATH "/web/tmp/"
>     IMAGEURL "/tmp/"
>   END
>   LAYER
>        NAME "Counties"
>        STATUS DEFAULT
>        TYPE POLYGON
>        DATA "counties"
>        CLASS
>       NAME "Counties"
>       STYLE
>         COLOR 255 255 153
>         OUTLINECOLOR 204 153 51
>       END
>     END
>    END
>    LAYER
>        NAME "Test Points"
>        STATUS DEFAULT
>        TYPE POINT
>        CONNECTIONTYPE POSTGIS
>        CONNECTION "user=username dbname=nat_db host=localhost
> password=password"
>        DATA "the_geom from test_points"
>        CLASS
>       NAME "Points"
>       STYLE
>         SYMBOL 7
>         COLOR 255 0 0
>         SIZE 5
>       END
>     END
>   END
> END
>
> Any help / suggestions appreciated.
>
> -Ken-ichi