Hi, I just wonder if the aim was to put every part of the list to their own lines
111. 222. 333. 44. 555 If it was, then the "add wrap character with SQL" is fine. If the aim was to keep the label on as few lines as possible and space admitting have 111.222.333.44.555 or 111.222.333. 44.555 then I fear that no workaround is usable and the real solution would be to change the code to support option "don't eat wrap characters" -Jukka Rahkonen- Jeff McKenna wrote: Great work Benjamin! (I was looking at that page but didn't think of using substring) Benjamin's solution works great (assuming your data is always in 111.222.333.44.555 Here is a working example: map output: http://pasteboard.co/25N6NcOV.png layer snippet: LAYER NAME "test" TYPE POINT STATUS ON CONNECTIONTYPE OGR CONNECTION "cities.shp" DATA "SELECT CONCAT(SUBSTR(PARCEL,1,3),'.+',SUBSTR(PARCEL,5,3),'.+',SUBSTR(PARCEL,9,3),'.+',SUBSTR(PARCEL,13,2),'.+',SUBSTR(PARCEL,16,4)) AS parcel_wrap from cities" LabelItem "parcel_wrap" CLASS NAME "mycities" LABEL COLOR 0 0 0 FONT sans TYPE truetype SIZE 8 POSITION AUTO PARTIALS FALSE OUTLINECOLOR 255 255 255 WRAP "+" END STYLE SYMBOL 7 SIZE 6 COLOR 0 0 0 END END END # Layer -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ On 2016-07-01 4:14 AM, Schepers, Benjamin wrote: > Hi Carrie, > > in my opinion the easiest way would be converting the data to > spatialite-DB (you get a lot of database-functions in a file based-DB > - no client-server-architecture, just a file; at best you use ogr2ogr > or QGIS for conversion) and then use replace function in your > SQL-QUERY > > i.e. to dynamically insert pipe "|" as wrap-character it should look like > that (fieldname is "parcel_no"): > SELECT *, replace(parcel_no, '.', '.|') AS parcel_no_wrap FROM > parcel_table > > If you have a shapefile and your parcel-no have a strict pattern (ie. > 2digits.3digits.4digits) then it should also be possible to use OGR generic > "concat" and "substring"-function, which were introduced with GDAL 1.8 > (according to documentation at > http://www.gdal.org/ogr_sql.html#ogr_sql_flist_ops and > http://www.gdal.org/ogr_sql.html#ogr_sql_functions): > > Example, also with pipe as wrap-character: > SELECT *, > CONCAT(SUBSTR(parcel_no,1,2),'.|',SUBSTR(parcel_no,4,3),'.|',SUBSTR(pa > rcel_no,8,4)) AS parcel_no_wrap FROM parcel_table > > In both examples the new virtual field "parcel_no_wrap" could be used for > displaying text with wrap character... > > Sincerely, > Benjamin Schepers > > > > Von: mapserver-users [mailto:[email protected]] > Im Auftrag von Mark Volz > Gesendet: Donnerstag, 30. Juni 2016 15:09 > An: [email protected] > Betreff: Re: [mapserver-users] Map file, Label WRAP Function in > mapbook removes character it > > Carrie, > > Our trick is to wrap on a character that you would otherwise not normally see > in the string. > > LAYER > .... > CLASS > TEXT ([LastName] * [PIN]) #overrides LABELITEM > ..... > LABEL > WRAP "*" > END #Parcel Label > END #Parcel Class > END #Parcel Layer > > > Sincerely, > Mark Volz, GISP > > -----Original Message----- > From: mapserver-users [mailto:[email protected]] > On Behalf Of [email protected] > Sent: Wednesday, June 29, 2016 11:04 AM > To: [email protected] > Subject: mapserver-users Digest, Vol 101, Issue 37 > > Send mapserver-users mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.osgeo.org/mailman/listinfo/mapserver-users > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific than "Re: > Contents of mapserver-users digest..." > > > Today's Topics: > > 1. Map file, Label WRAP Function in mapbook removes character it > is wrapping on. (Carrie Quast) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 29 Jun 2016 15:58:59 +0000 > From: Carrie Quast <[email protected]> > To: "'[email protected]'" > <[email protected]> > Subject: [mapserver-users] Map file, Label WRAP Function in mapbook > removes character it is wrapping on. > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf-8" > > Hello - I'm working on updating my .MAP Documents to Mapserver 7.0.1. > > I'm trying to get the labels in my Parcel Layer to wrap on the decimal point > (example 002.001.001.01.010) to make for a better a fit. I'm using the WRAP > function, which works wonderfully , except it removes the character I am > wrapping on. In this case, the point (.) In my parcel numbers. > > Each of the numbers should have a decimal between it. Any idea of how to > get the line to wrap on a character, but also keep it in the displayed label? > The MAXLENGTH works well too, but still removes all decimal points. > > I'm using Mapserver 7.0.1 with GeoMoose 2.9 > > Thank You - Carrie Quast, Brown County MN GIS Specialist > > [cid:[email protected]] > > > -------------- next part -------------- An HTML attachment was > scrubbed... > URL: > <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160629 > /8bda4b92/attachment.html> > -------------- next part -------------- A non-text attachment was > scrubbed... > Name: image001.png > Type: image/png > Size: 66665 bytes > Desc: image001.png > URL: > <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160629 > /8bda4b92/attachment.png> > -------------- next part -------------- A non-text attachment was > scrubbed... > Name: image002.png > Type: image/png > Size: 31355 bytes > Desc: image002.png > URL: > <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160629 > /8bda4b92/attachment-0001.png> > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > ------------------------------ > > End of mapserver-users Digest, Vol 101, Issue 37 > ************************************************ > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
