[MapServer-users] MapServer-users Digest, Vol 183, Issue 13

Sun Apr 30 16:28:16 PDT 2023

Try "class" lower case. Be sure that the case of your column names match
the case in postges.

On Sun, Apr 30, 2023, 3:04 PM Jeremy JK <jason2017jay at gmail.com> wrote:

> Hi Jeff,
> My understanding, as the tutorial says, is that the class column comes
> from the dbf file
> That's the tutorial's dataset - shp file and dbf file
> So I guess my query will be how to import the dbf file into the database
> such that is "corresponds" to the shp file table
>
> How to import  states_ugl.dbf together with states_ugl.shp?
>
> I guess this is more of a problem with handling a specific data set for a
> specific purpose (tutorial data for the tutorial)
>
> I will practice using files
> But would be good to know how to insert the 2 different types of files
> "simultaneously" for future reference
>
>
>
>
>
>
>
> On Sun, Apr 30, 2023 at 3:00 PM <mapserver-users-request at lists.osgeo.org>
> wrote:
>
>> Send MapServer-users mailing list submissions to
>>         mapserver-users at lists.osgeo.org
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>         https://lists.osgeo.org/mailman/listinfo/mapserver-users
>> or, via email, send a message with subject or body 'help' to
>>         mapserver-users-request at lists.osgeo.org
>>
>> You can reach the person managing the list at
>>         mapserver-users-owner at lists.osgeo.org
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of MapServer-users digest..."
>>
>>
>> Today's Topics:
>>
>>    1. Database problem when using CLASSITEM (Jeremy JK)
>>    2. Re: Database problem when using CLASSITEM (Jeff McKenna)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Sat, 29 Apr 2023 15:12:26 -0400
>> From: Jeremy JK <jason2017jay at gmail.com>
>> To: Jason Snyder <mapserver-users at lists.osgeo.org>
>> Subject: [MapServer-users] Database problem when using CLASSITEM
>> Message-ID:
>>         <CAKjBGf+iN=mw+F9=
>> fODiXGr6rYnaSKbPV9wxrNAF_-M2-pB+ew at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> Hola
>>
>> OK so I am going through the MapServer tutorial
>> Example 1-3 to be exact
>> the one with the classes
>> using classes to split layer polygon into land and water
>>
>> when shp and dbf file is in filesystem it works fine
>> But
>> When I import shp file into postgres I get the following error
>>
>> After checking the error logs, my question is how do I get a class column?
>> Do I have to insert the dbf file into schema? If so, how?
>> Thanks
>>
>> *Error*:
>> msDrawMap(): Image handling error. Failed to draw layer named
>> 'states_poly'. msPostGISLayerWhichShapes(): Query error. Error executing
>> query. Check server logs
>>
>>
>>
>> *Query: *
>>
>> http://localhost:8081/cgi-bin/mapserv?map=/opt/map/mdm60/example1-3.map&layer=states_poly&layer=states_line&mode=map
>>
>>
>> *Mapfile*:
>> MAP
>>   IMAGETYPE      PNG
>>   EXTENT         -97.238976 41.619778 -82.122902 49.385620
>>   SIZE           400 300
>>   SHAPEPATH      "/opt/map/mdm60/ms4w/apps/tutorial/data/"
>>   IMAGECOLOR     255 255 255
>>
>>   LAYER
>>     NAME         "states_poly"
>>     CONNECTIONTYPE POSTGIS
>>     CONNECTION "user=postgres password=postgres dbname=mdm6data
>> host=mxsig-db port=5432"
>>     DATA         "wkb_geometry from tutoiral.states_ugl_imported using
>> srid=3857"
>>     STATUS       OFF
>>     TYPE         POLYGON
>>
>> CLASSITEM "CLASS"
>>
>> CLASS
>>       NAME 'States'
>>       EXPRESSION 'land'
>>   STYLE
>>         COLOR      232 232 232
>>       END
>>     END
>>     CLASS
>>       NAME 'Water'
>>       EXPRESSION 'water'
>>       STYLE
>>         COLOR      198 198 255
>>       END
>>     END
>>   END
>>
>>  LAYER
>>     NAME         "states_line"
>>     CONNECTIONTYPE POSTGIS
>>     CONNECTION "user=postgres password=postgres dbname=mdm6data
>> host=mxsig-db port=5432"
>>     DATA         "wkb_geometry from tutorial.sttes_ugl_imported using
>> srid=3875"
>>     STATUS       OFF
>>     TYPE         LINE
>>
>>     CLASSITEM    "CLASS"
>>
>>     CLASS
>>       NAME       'State Boundary'
>>       EXPRESSION 'land'
>>       STYLE
>>         COLOR    32 32 32
>>       END
>>     END
>>   END
>>
>>
>> END
>>
>>
>> *Error Log:*[Sat Apr 29 19:08:42 2023].232185 CGI Request 1 on process
>> 1677
>> [Sat Apr 29 19:08:42 2023].233452 msDrawMap(): rendering using
>> outputformat
>> named png (AGG/PNG).
>> [Sat Apr 29 19:08:42 2023].233473 msDrawMap(): WMS/WFS set-up and query,
>> 0.000s
>> [Sat Apr 29 19:08:42 2023].282742 msPostGISLayerWhichShapes(): Error
>> (ERROR:  no existe la columna ?CLASS?
>> LINE 1: select "CLASS"::text,ST_AsBinary(("wkb_geometry"),'NDR') as ...
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://lists.osgeo.org/pipermail/mapserver-users/attachments/20230429/f3df399b/attachment-0001.htm
>> >
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Sun, 30 Apr 2023 14:56:45 -0300
>> From: Jeff McKenna <jmckenna at gatewaygeomatics.com>
>> To: mapserver-users at lists.osgeo.org
>> Subject: Re: [MapServer-users] Database problem when using CLASSITEM
>> Message-ID:
>>         <8e6a0d0c-34aa-fe09-698a-6c815d9b3ef2 at gatewaygeomatics.com>
>> Content-Type: text/plain; charset=UTF-8; format=flowed
>>
>> Hi Jeremy,
>>
>> I would run ogrinfo on that table to see what field to use for your
>> CLASSITEM, such as:
>>
>> ogrinfo PG:"user=postgres password=postgres dbname=mdm6data
>> host=mxsig-db port=5432" tutoiral.states_ugl_imported -summary
>>
>> (your timing is good as the tutorial was recently updated for MapServer 8
>> )
>>
>> -jeff
>>
>>
>>
>> --
>> Jeff McKenna
>> GatewayGeo: Developers of MS4W, MapServer Consulting and Training
>> co-founder of FOSS4G
>> http://gatewaygeo.com/
>>
>>
>>
>>
>> On 2023-04-29 4:12 p.m., Jeremy JK wrote:
>> > Hola
>> >
>> > OK so I am going through the MapServer tutorial
>> > Example 1-3 to be exact
>> > the one with the classes
>> > using classes to split layer polygon into land and water
>> >
>> > when shp and dbf file is in filesystem it works fine
>> > But
>> > When I import shp file into postgres I get the following error
>> >
>> > After checking the error logs, my question is how do I get a class
>> > column? Do I have to insert the dbf file into schema? If so, how?
>> > Thanks
>> >
>> > *Error*:
>> > msDrawMap(): Image handling error. Failed to draw layer named
>> > 'states_poly'. msPostGISLayerWhichShapes(): Query error. Error
>> executing
>> > query. Check server logs
>> >
>> >
>>
>>
>> ------------------------------
>>
>> Subject: Digest Footer
>>
>> _______________________________________________
>> MapServer-users mailing list
>> MapServer-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
>>
>> ------------------------------
>>
>> End of MapServer-users Digest, Vol 183, Issue 13
>> ************************************************
>>
> _______________________________________________
> MapServer-users mailing list
> MapServer-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20230430/9277c5e2/attachment-0001.htm>