[mapserver-users] Map file, Label WRAP Function in mapbook removes character it
Jeff McKenna
jmckenna at gatewaygeomatics.com
Fri Jul 1 04:27:30 PDT 2016
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(parcel_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:mapserver-users-bounces at lists.osgeo.org] Im Auftrag von Mark Volz
> Gesendet: Donnerstag, 30. Juni 2016 15:09
> An: mapserver-users at lists.osgeo.org
> 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:mapserver-users-bounces at lists.osgeo.org] On Behalf Of mapserver-users-request at lists.osgeo.org
> Sent: Wednesday, June 29, 2016 11:04 AM
> To: mapserver-users at lists.osgeo.org
> Subject: mapserver-users Digest, Vol 101, Issue 37
>
> Send mapserver-users mailing list submissions to
> mapserver-users at lists.osgeo.org
>
> 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
> 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. 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 <Carrie.Quast at co.brown.mn.us>
> To: "'mapserver-users at lists.osgeo.org'"
> <mapserver-users at lists.osgeo.org>
> Subject: [mapserver-users] Map file, Label WRAP Function in mapbook
> removes character it is wrapping on.
> Message-ID: <77b9eefcc9264bddb77bd9a85bd037e1 at MSEXCHANGE1.bc.local>
> 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:image002.png at 01D1D1F5.3D5294F0]
>
>
> -------------- 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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
> ------------------------------
>
> End of mapserver-users Digest, Vol 101, Issue 37
> ************************************************
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
More information about the MapServer-users
mailing list