[UMN_MAPSERVER-USERS] Problems displaying PostGIS Layer

[Ethan Alpert]

There's also the slight detail that you have the layer status set to OFF.

-e

-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of Skweda O'Bomsawin
Sent: Wednesday, January 12, 2005 10:15 AM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] RE : [UMN_MAPSERVER-USERS] Problems displaying PostGIS Layer


Hi William!

I'd first recommend you to create an index for your Postgis layer: CREATE INDEX us_cities_idx ON us_cities USING GIST (the_geom GIST_GEOMETRY_OPS);

Second, since your layer is using SRID 4326, make sure you have a PROJECTION bloc correctly set in your MAP section of you mapfile.  Otherwise, you must have a PROJECTION bloc in your LAYER section...

Skweda


-----Message d'origine-----
De : UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] De la part de William Hudspeth Envoyé : 12 janvier 2005 11:28 À : MAPSERVER-USERS at LISTS.UMN.EDU Objet : [UMN_MAPSERVER-USERS] Problems displaying PostGIS Layer

Hello,

I have imported a shapefile into PostGIS with the following:

./shp2pgsql -s 4326 /path/us_cities.shp us_cities -d reason | ./psql -d reason

The new table has a "gid" column as well as a populated geometry column named "the_geom". My map file entry looks like this:

****************************
LAYER
        CONNECTIONTYPE postgis
        NAME "us_cities"
        CONNECTION "user=postgis dbname=reason host=falstaff.unm.edu"
        DATA "the_geom from us_cities"
        STATUS OFF
        TYPE POINT

        CLASS
                COLOR 177 213 34
                SIZE 7
                SYMBOL "circle"
        END
END
********************************
The layer does not display. I get the following error in my Apache error
log:

[Wed Jan 12 08:47:48 2005] [error] [client 129.24.73.222]
_mapscript.MapServerError: msDrawMap(): Image handling error. Failed to draw layer named 'us_cities'., referer: http://falstaff.unm.edu/cgi- bin/reason/python_mapscript.py [Wed Jan 12 08:47:48 2005] [error] [client 129.24.73.222] prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual query)
statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT asbinary (force_collection(force_2d(the_geom)),'NDR'),gid::text from us_cities WHERE the_geom && setSRID('BOX3D(-125.000000000, referer: http://falstaff.unm.edu/cgi-bin/reason/python_mapscript.py


I would appreciate any insight into this problem.

Thanks, Bill

-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.10 - Release Date: 2005-01-10
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.10 - Release Date: 2005-01-10