[Geomoose-users] GeoMOOSE and PostGIS Help

[Len Kne]

Hi Rubin

What does Firebug say?  It usually gives good error messages for Postgres connection issues.

I believe that MapServer needs to have the geometry column entered in the geometry_columns table for the query to work.

Len

From: Rubin Seifert [mailto:rseifert at ci.faribault.mn.us]
Sent: Friday, June 25, 2010 2:22 PM
To: geomoose-users at lists.sourceforge.net
Subject: [Geomoose-users] GeoMOOSE and PostGIS Help

Hello Everyone,
I am having problems displaying postgis layers.  The postgis layer shows up pink.  If I use the shapefile, the layer displays correctly.

So, I have searched through the mail list archives, mapserver documentation, and postgis documentation with no luck.  I am thinking I missed something simple.  I am using MS4W version 2.3.1 and GeoMoose 2.2.  I have been able to connect to the database and view the data using QGIS.  So it has to be a mapserver problem right?

Here is the map file:
--
MAP ##
            NAME 'postgresql'
            STATUS ON
            UNITS METERS

            TRANSPARENT TRUE

            INCLUDE "../../geomoose_globals.map"

            LAYER
                        NAME "test"
                        CONNECTIONTYPE postgis
                        CONNECTION "host=localhost port=5432 dbname=geomoose user=gisadmin password=gis"
                        DATA "the_geom from test"
                        #DATA '../data/test.shp'

                        STATUS ON
                        TYPE line

                        CLASS
                           NAME 'PostGIS Test'
                          #STYLE
                                    # SYMBOL 'plainline'
                                    #SIZE 0.8
                                     COLOR 0 92 230
                         #END
                        END
            END # LAYER
END ## end Map
--
Any ideas are greatly appreciated, thanks.
Rubin


Rubin Seifert
GIS-CAD Tech.
City of Faribault
208 First Avenue N.W.
Faribault, MN 55021
Email: rseifert at ci.faribault.mn.us<mailto:rseifert at ci.faribault.mn.us>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20100625/848fea67/attachment.html