[Qgis-user] UMN Mapserver & PostgreSQL-PostGIS - Fails to draw layers

[Langen Mallya]

Hi everybody,

I have a question about MapServer and PostGIS.

Im working on a project which involves OpenSource. I have managed to plot
nearly all layers except three. after 1 month of trying there is no hope for
these 3 layers to display, but the layers are loaded well in QGIS.

I have tried to delete the layers and load it again in the server, still the
same problem.

see the mapserver layer code below and for regions(fails to display) & Intl.
boundaries (Display well)



#=============================================================

  LAYER
    NAME 'Region'
    TYPE POLYGON
    DUMP true
    TEMPLATE fooOnlyForWMSGetFeatureInfo
  EXTENT 24.162085 -12.027731 45.340160 -0.726251
    CONNECTIONTYPE postgis
    CONNECTION "dbname='ttaf' host=127.0.0.1 port=5432 user='XXXXXXX'
password='XXXXXXX' sslmode=disable"
    DATA "the_geom FROM Regions"
    METADATA
      'ows_title' 'Region'
    END
    STATUS OFF
    TRANSPARENCY 100
    PROJECTION
    'proj=longlat'
    'ellps=WGS84'
    'datum=WGS84'
    'no_defs'
    END
    CLASS
       NAME 'Region'
       STYLE
         WIDTH 1
         OUTLINECOLOR 100 0 0
       END
    END
  END

#=============================================================

  LAYER
    NAME 'Intl._Boundary'
    TYPE POLYGON
    DUMP true
    TEMPLATE fooOnlyForWMSGetFeatureInfo
  EXTENT 24.162085 -12.027731 45.340160 -0.726251
    CONNECTIONTYPE postgis
    CONNECTION "dbname='ttaf' host=127.0.0.1 port=5432 user='XXXXXXX'
password='XXXXXXXXX' sslmode=disable"
    DATA 'the_geom FROM tzbord'
    METADATA
      'ows_title' 'Intl._Boundary'
    END
    STATUS OFF
    TRANSPARENCY 100
    PROJECTION
    'proj=longlat'
    'ellps=WGS84'
    'datum=WGS84'
    'no_defs'
    END
    CLASS
       NAME 'Intl. Boundary'
       STYLE
         WIDTH 2
         OUTLINECOLOR 0 0 0
       END
    END
  END
#=============================================================





Hope to have answers from you.

-- 
Langen R. M. Mallya,
Chief Consultant,
Cutlan Consultant,
Makuyuni, Monduli,
P.O.Box 16967,
Arusha,
Tanzania.

Phone #: +255-78-444-5465
Phone #: +255-76-866-0802
Phone#: +255-71-940-6096
Fax #: +255-78-744-5465

e-mail: info at cutlan.co.tz
e-mail: cutlan at gmail.com
http://www.cutlan.co.tz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110518/973e3c9a/attachment.html>