Screenshot instructions:
Windows
Mac
Red Hat Linux
Ubuntu
Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)
From: Andy Berry <Andy.Berry@wr...> - 2011-10-28 12:26:02
Attachments:
Message as HTML
|
I am trying to display lines with specific attributes contained in a field The field (from Mapinfo) contains for example Pen(4, 2, 16711935) I will need to convert the 3rd number to a hex colour and the first to the line thickness So far I have <LineSymbolizer> <Stroke> <CssParameter name="stroke"> #FF0000 </CssParameter> <CssParameter name="stroke-width"> <ogc:Function name="strSubstring"> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> <ogc:Literal>5</ogc:Literal> <ogc:Function name="strIndexOf"> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> <ogc:Literal>,</ogc:Literal> </ogc:Function> </ogc:Function> </CssParameter> </Stroke> </LineSymbolizer> The difficulty is working out how to convert the number 1671168 to the hex colour, in this case #FF0000. Has anyone done this before? Take a look - you can pay, report, request, have your say and find information online at http://www.wrexham.gov.uk. Save paper - think before you print! This e-mail message and any attachments are intended solely for the individual or organisation to whom it is addressed. For full conditions in relation to content and use of this e-mail message and any attachments, please refer to http://www.wrexham.gov.uk/top_navigation/disclaimers.htm. Mae'r neges e-bost hon ac unrhyw atodiadau wedi eu bwriadu ar gyfer yr unigolyn neu?r sefydliad y?i cyfeirir atynt yn unig. Am yr amodau llawn ynglyn a chynnwys a defnyddio?r neges e-bost hon ac unrhyw atodiadau, cyfeiriwch at http://www.wrecsam.gov.uk/top_navigation/disclaimersw.htm. |
From: Andrea Aime <andrea.aime@ge...> - 2011-10-30 10:38:32
|
On Fri, Oct 28, 2011 at 2:12 PM, Andy Berry <Andy.Berry@...> wrote: > I am trying to display lines with specific attributes contained in a field > > The field (from Mapinfo) contains for example Pen(4, 2, 16711935) > > I will need to convert the 3rd number to a hex colour and the first to the > line thickness > > So far I have > > <LineSymbolizer> > > <Stroke> > > <CssParameter name="stroke"> > > #FF0000 > > </CssParameter> > > <CssParameter name="stroke-width"> > > <ogc:Function name="strSubstring"> > > > <ogc:PropertyName>MI_STYLE</ogc:PropertyName> > > > <ogc:Literal>5</ogc:Literal> > > > <ogc:Function name="strIndexOf"> > > > <ogc:PropertyName>MI_STYLE</ogc:PropertyName> > > > <ogc:Literal>,</ogc:Literal> > > > </ogc:Function> > > </ogc:Function> > > </CssParameter> > > </Stroke> > > </LineSymbolizer> > > The difficulty is working out how to convert the number 1671168 to the hex > colour, in this case #FF0000. Has anyone done this before? I can't think of a good way to do that with the current toolset. I guess one would need some new filter functions that can do the parsing you need, that at the moment requires some java programming (we have been talking about having some scripting ability for a while, but so far nothing is evolved enough to ship with GeoServer, even if just as an extension) Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- |
From: Milo van der Linden <milo@do...> - 2011-10-30 11:12:13
|
The MapInfo color coding scheme is documented here: http://georezo.net/jparis/MI_Enviro/Colors/color_models.htm#6-1%20R,G,B%20%3C%3E%20RGB RGB = (65536 * R) + (256 * G) + B With this formula, you should be able to get the R, G and B and transform them to hex. 2011/10/30 Andrea Aime <andrea.aime@...>: > On Fri, Oct 28, 2011 at 2:12 PM, Andy Berry <Andy.Berry@...> wrote: >> I am trying to display lines with specific attributes contained in a field >> >> The field (from Mapinfo) contains for example Pen(4, 2, 16711935) >> >> I will need to convert the 3rd number to a hex colour and the first to the >> line thickness >> >> So far I have >> >> <LineSymbolizer> >> >> <Stroke> >> >> <CssParameter name="stroke"> >> >> #FF0000 >> >> </CssParameter> >> >> <CssParameter name="stroke-width"> >> >> <ogc:Function name="strSubstring"> >> >> >> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> >> >> >> <ogc:Literal>5</ogc:Literal> >> >> >> <ogc:Function name="strIndexOf"> >> >> >> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> >> >> >> <ogc:Literal>,</ogc:Literal> >> >> >> </ogc:Function> >> >> </ogc:Function> >> >> </CssParameter> >> >> </Stroke> >> >> </LineSymbolizer> >> >> The difficulty is working out how to convert the number 1671168 to the hex >> colour, in this case #FF0000. Has anyone done this before? > > I can't think of a good way to do that with the current toolset. > I guess one would need some new filter functions that can do the parsing you > need, that at the moment requires some java programming (we have been talking > about having some scripting ability for a while, but so far nothing is > evolved enough > to ship with GeoServer, even if just as an extension) > > Cheers > Andrea > > -- > ------------------------------------------------------- > Ing. Andrea Aime > GeoSolutions S.A.S. > Tech lead > > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > > phone: +39 0584 962313 > fax: +39 0584 962313 > > http://www.geo-solutions.it > http://geo-solutions.blogspot.com/ > http://www.youtube.com/user/GeoSolutionsIT > http://www.linkedin.com/in/andreaaime > http://twitter.com/geowolf > > ------------------------------------------------------- > > ------------------------------------------------------------------------------ > Get your Android app more play: Bring it to the BlackBerry PlayBook > in minutes. BlackBerry App World™ now supports Android™ Apps > for the BlackBerry® PlayBook™. Discover just how easy and simple > it is! http://p.sf.net/sfu/android-dev2dev > _______________________________________________ > Geoserver-users mailing list > Geoserver-users@... > https://lists.sourceforge.net/lists/listinfo/geoserver-users > |
From: Andy Berry <Andy.Berry@wr...> - 2011-10-31 10:06:21
|
Solution was to remove the # from the colour and present as the original decimal provided by mapinfo easyloader. I have listed the whole style for any one who wants it. Thanks for your help <?xml version="1.0" encoding="ISO-8859-1"?> <StyledLayerDescriptor version="1.0.0" xmlns="http://www.opengis.net/sld"; xmlns:ogc="http://www.opengis.net/ogc"; xmlns:xlink="http://www.w3.org/1999/xlink"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://www.opengis.net/sld http://schemas.opengis.net/sld/1.0.0/StyledLayerDescriptor.xsd"> <NamedLayer> <Name>Mapinfo Line Colour setting</Name> <UserStyle> <Title>Colour settings</Title> <Abstract>Read pen and colour from MI_STYLE uploaded from mapinfo using Easyloader to postgis</Abstract> <FeatureTypeStyle> <Rule> <Name>Set Line Colour Thickness</Name> <ogc:Filter> <ogc:PropertyIsEqualTo> <ogc:Function name="strSubstring"> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> <ogc:Literal>0</ogc:Literal> <ogc:Literal>3</ogc:Literal> </ogc:Function> <ogc:Literal>Pen</ogc:Literal> </ogc:PropertyIsEqualTo> </ogc:Filter> <LineSymbolizer> <Stroke> <CssParameter name="stroke"> <ogc:Function name="parseInt"> <ogc:Function name="strSubstring"> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> <ogc:Add> <ogc:Function name="strLastIndexOf"> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> <ogc:Literal>,</ogc:Literal> </ogc:Function> <ogc:Literal>2</ogc:Literal> </ogc:Add> <ogc:Function name="strLastIndexOf"> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> <ogc:Literal>)</ogc:Literal> </ogc:Function> </ogc:Function> </ogc:Function> </CssParameter> <CssParameter name="stroke-width"> <ogc:Function name="parseInt"> <ogc:Function name="strSubstring"> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> <ogc:Literal>5</ogc:Literal> <ogc:Function name="strIndexOf"> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> <ogc:Literal>,</ogc:Literal> </ogc:Function> </ogc:Function> </ogc:Function> </CssParameter> </Stroke> </LineSymbolizer> </Rule> <Rule> <Name>Default Colour Thickness</Name> <ogc:Filter> <ogc:PropertyIsNotEqualTo> <ogc:Function name="strSubstring"> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> <ogc:Literal>0</ogc:Literal> <ogc:Literal>3</ogc:Literal> </ogc:Function> <ogc:Literal>Pen</ogc:Literal> </ogc:PropertyIsNotEqualTo> </ogc:Filter> <LineSymbolizer> <Stroke> <CssParameter name="stroke">#000000</CssParameter> <CssParameter name="stroke-width">1</CssParameter> </Stroke> </LineSymbolizer> </Rule> </FeatureTypeStyle> </UserStyle> </NamedLayer> </StyledLayerDescriptor> -----Original Message----- From: Milo van der Linden [mailto:milo@...] Sent: 30 October 2011 10:43 To: Andrea Aime Cc: Andy Berry; geoserver-users@... Subject: Re: [Geoserver-users] SLD files The MapInfo color coding scheme is documented here: http://georezo.net/jparis/MI_Enviro/Colors/color_models.htm#6-1%20R,G,B%20%3C%3E%20RGB RGB = (65536 * R) + (256 * G) + B With this formula, you should be able to get the R, G and B and transform them to hex. 2011/10/30 Andrea Aime <andrea.aime@...>: > On Fri, Oct 28, 2011 at 2:12 PM, Andy Berry <Andy.Berry@...> wrote: >> I am trying to display lines with specific attributes contained in a field >> >> The field (from Mapinfo) contains for example Pen(4, 2, 16711935) >> >> I will need to convert the 3rd number to a hex colour and the first to the >> line thickness >> >> So far I have >> >> <LineSymbolizer> >> >> <Stroke> >> >> <CssParameter name="stroke"> >> >> #FF0000 >> >> </CssParameter> >> >> <CssParameter name="stroke-width"> >> >> <ogc:Function name="strSubstring"> >> >> >> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> >> >> >> <ogc:Literal>5</ogc:Literal> >> >> >> <ogc:Function name="strIndexOf"> >> >> >> <ogc:PropertyName>MI_STYLE</ogc:PropertyName> >> >> >> <ogc:Literal>,</ogc:Literal> >> >> >> </ogc:Function> >> >> </ogc:Function> >> >> </CssParameter> >> >> </Stroke> >> >> </LineSymbolizer> >> >> The difficulty is working out how to convert the number 1671168 to the hex >> colour, in this case #FF0000. Has anyone done this before? > > I can't think of a good way to do that with the current toolset. > I guess one would need some new filter functions that can do the parsing you > need, that at the moment requires some java programming (we have been talking > about having some scripting ability for a while, but so far nothing is > evolved enough > to ship with GeoServer, even if just as an extension) > > Cheers > Andrea > > -- > ------------------------------------------------------- > Ing. Andrea Aime > GeoSolutions S.A.S. > Tech lead > > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > > phone: +39 0584 962313 > fax: +39 0584 962313 > > http://www.geo-solutions.it > http://geo-solutions.blogspot.com/ > http://www.youtube.com/user/GeoSolutionsIT > http://www.linkedin.com/in/andreaaime > http://twitter.com/geowolf > > ------------------------------------------------------- > > ------------------------------------------------------------------------------ > Get your Android app more play: Bring it to the BlackBerry PlayBook > in minutes. BlackBerry App World™ now supports Android™ Apps > for the BlackBerry® PlayBook™. Discover just how easy and simple > it is! http://p.sf.net/sfu/android-dev2dev > _______________________________________________ > Geoserver-users mailing list > Geoserver-users@... > https://lists.sourceforge.net/lists/listinfo/geoserver-users > Take a look - you can pay, report, request, have your say and find information online at http://www.wrexham.gov.uk. Save paper - think before you print! This e-mail message and any attachments are intended solely for the individual or organisation to whom it is addressed. For full conditions in relation to content and use of this e-mail message and any attachments, please refer to http://www.wrexham.gov.uk/top_navigation/disclaimers.htm. Mae'r neges e-bost hon ac unrhyw atodiadau wedi eu bwriadu ar gyfer yr unigolyn neu’r sefydliad y’i cyfeirir atynt yn unig. Am yr amodau llawn ynglyn a chynnwys a defnyddio’r neges e-bost hon ac unrhyw atodiadau, cyfeiriwch at http://www.wrecsam.gov.uk/top_navigation/disclaimersw.htm. |