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 <jason2017...@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-requ...@lists.osgeo.org> > wrote: > >> Send MapServer-users mailing list submissions to >> mapserver-users@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-requ...@lists.osgeo.org >> >> You can reach the person managing the list at >> mapserver-users-ow...@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 <jason2017...@gmail.com> >> To: Jason Snyder <mapserver-users@lists.osgeo.org> >> Subject: [MapServer-users] Database problem when using CLASSITEM >> Message-ID: >> <CAKjBGf+iN=mw+F9= >> fodixgr6rynaskbpv9wxrnaf_-m2-pb...@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 <jmcke...@gatewaygeomatics.com> >> To: mapserver-users@lists.osgeo.org >> Subject: Re: [MapServer-users] Database problem when using CLASSITEM >> Message-ID: >> <8e6a0d0c-34aa-fe09-698a-6c815d9b3...@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@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@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ MapServer-users mailing list MapServer-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users