postGIS problems

[Steven Monai]

On Tue, 14 Sep 2004 12:39:41 -0500, Tim <ttsai at POBOX.COM> wrote:

Assuming that road_segments.centerline contains linestrings and not
polygons, you might want to try "TYPE LINE" instead of "TYPE POLYGON" in
the LAYER block.

HTH,
-SM
--

>Also I have verified that the database queries are getting sent to
>PostgreSQL.  I am going to try gdb next but I am really hoping for
>a simpler answer here.  Very frustrating!
>
>Thanks,
>
>Tim
>
>On Tue, Sep 14, 2004 at 12:15:37PM -0500, Tim wrote:
>> Nope just tried it.
>>
>> Thanks,
>>
>> Tim
>>
>> On Tue, Sep 14, 2004 at 06:41:04AM -0700, Paul Ramsey wrote:
>> > Does adding a class object make any difference?
>> >
>> > >MAP
>> > >    NAME DEMO
>> > >    SIZE 600 400
>> > >    IMAGETYPE PNG
>> > >    IMAGECOLOR 240 240 240
>> > >    EXTENT 0 0 84 48
>> > >    WEB
>> > >        LOG /tmp/mapserver.log
>> > >    END
>> > >    DEBUG ON
>> > >    LAYER
>> > >        CONNECTIONTYPE postgis
>> > >        NAME "DEMO"
>> > >        # Connect to a remote spatial database
>> > >        CONNECTION "user=user dbname=db host=127.0.0.1"
>> > >        DATA "centerline from road_segments"
>> > >        TYPE POLYGON
>> > >        STATUS DEFAULT
>> >            CLASS
>> >               COLOR 0 0 0
>> >            END
>> > >    END
>> > >END