PostGIS 1.0.0-rc2 points not rendering

Ken-ichi kenichi.ueda at GMAIL.COM
Mon Mar 21 19:16:28 PST 2005


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_Ameri
can_1927",SPHEROID["Clarke_1866",6378206.4,294.9786982]],PRIMEM["Greenwi
ch",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMET
ER["False_Easting",0.0],PARAMETER["False_Northing",
-4000000.0],PARAMETER["Central_Meridian",
-120.0],PARAMETER["Standard_Parallel_1",34.0],PARAMETER["Standard_Parall
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



More information about the MapServer-users mailing list