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