[Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Ismail_Mark · March 27, 2014, 3:56pm

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

jive · March 28, 2014, 12:55am

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

···

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Russ · March 28, 2014, 8:53am

Looks like the path to the file is wrong as it includes C:` twice

I suspect GS is appending your path to the GEOSERVER_DATA_DIR folder, which looks like it is C:\GeoServer25\data_dir\styles\

I have used other SLDs from the OS with no problem, but I have not tried this one in particular.

Russ

···

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Ismail_Mark · March 28, 2014, 9:14am

Russ

Can you give me an example of one that you have used successfully from OS so I can test it ?

···

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 08:52
To: Jody Garnett
Cc: Ismail, Mark; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Looks like the path to the file is wrong as it includes C:` twice

I suspect GS is appending your path to the GEOSERVER_DATA_DIR folder, which looks like it is C:\GeoServer25\data_dir\styles\

I have used other SLDs from the OS with no problem, but I have not tried this one in particular.

Russ

On 28 Mar 2014, at 00:55, Jody Garnett <jody.garnett@anonymised.com> wrote:

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com40…> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Ismail_Mark · March 28, 2014, 9:28am

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>

The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

···

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com40…> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Russ · March 28, 2014, 9:36am

I just downloaded the SLDs from the OS and loaded the style called "OS MasterMap Topography (full colour style) - Topo Area.sld”.

It loaded, validated and submitted without problem. What version of GS are you using, though I don’t think that will be the problem?

I am running on Linux not Windows but that can’t make a difference.

Do you load them via the GS web admin pages i.e. Browse | Upload etc

Russ

On 28 Mar 2014, at 09:14, Ismail, Mark <mark.ismail@anonymised.com> wrote:

Russ

Can you give me an example of one that you have used successfully from OS so I can test it ?

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 08:52
To: Jody Garnett
Cc: Ismail, Mark; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Looks like the path to the file is wrong as it includes C:` twice

I suspect GS is appending your path to the GEOSERVER_DATA_DIR folder, which looks like it is C:\GeoServer25\data_dir\styles\

I have used other SLDs from the OS with no problem, but I have not tried this one in particular.

Russ

On 28 Mar 2014, at 00:55, Jody Garnett <jody.garnett@anonymised.com> wrote:

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark
This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

------------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Russ · March 28, 2014, 9:38am

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ServiceExceptionReport SYSTEM "http://localhost:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1"><ServiceException> The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA </ServiceException></ServiceExceptionReport>

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:
I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark
This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

------------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Ismail_Mark · March 28, 2014, 9:46am

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

···

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>

The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Russ · March 28, 2014, 9:54am

If you can I would change the database but I understand that is harder than changing the SLD.

So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round.

Russ

On 28 Mar 2014, at 09:46, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ServiceExceptionReport SYSTEM "http://localhost:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1"><ServiceException> The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA </ServiceException></ServiceExceptionReport>

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:
I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark
This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

------------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Ismail_Mark · March 28, 2014, 9:58am

I can try changing the SLD but just so I am clear

The sld is looking for a field in my database called os_cat ?

Eg :

Unclassified - 1:35 to 1:3,496 os_cat fillUnclassified 35 3496 #FFFF99

Because I don’t have a field called that

···

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:53
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

If you can I would change the database but I understand that is harder than changing the SLD.

So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round.

Russ

On 28 Mar 2014, at 09:46, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>

The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Russ · March 28, 2014, 10:05am

Correct.

Russ

On 28 Mar 2014, at 09:58, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I can try changing the SLD but just so I am clear

The sld is looking for a field in my database called os_cat ?

Eg :

 <FeatureTypeStyle>
 <Rule>
 <Name>Unclassified - 1:35 to 1:3,496</Name>
 <ogc:Filter>
 <ogc:PropertyIsEqualTo>
 <ogc:PropertyName>os_cat</ogc:PropertyName>
 <ogc:Literal>fillUnclassified</ogc:Literal>
 </ogc:PropertyIsEqualTo>
 </ogc:Filter>
 <MinScaleDenominator>35</MinScaleDenominator>
 <MaxScaleDenominator>3496</MaxScaleDenominator>
 <PolygonSymbolizer>
 <Fill>
 <CssParameter name="fill">#FFFF99</CssParameter>
 </Fill>
 </PolygonSymbolizer>
 </Rule>
 </FeatureTypeStyle>

Because I don’t have a field called that

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:53
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

If you can I would change the database but I understand that is harder than changing the SLD.

So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round.

Russ

On 28 Mar 2014, at 09:46, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ServiceExceptionReport SYSTEM "http://localhost:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1"><ServiceException> The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA </ServiceException></ServiceExceptionReport>

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:
I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark
This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

------------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Langford_Robert1 · March 28, 2014, 10:31am

Mark,

In the SLD you can download from the OS there should be a folder called “OS MasterMap Topography Layer SQL Scripts”, in there check out the Readme.txt:

The text files within this folder contain SQL scripts for Oracle databases loaded with OS MasterMap Topography Layer.

They look for various combinations of descriptiveTerm and descriptiveGroup values in the OS MasterMap Topography database and then create a new OS_CAT column which is populated with the required values that the OS MasterMap Topography Layer Style Layer Descriptor’s (SLD’s) will use so that the the relevant symbol for that feature is displayed.

Also, you will need the folder of SVG symbols on the server as well.

Hope this helps.

Rob

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 10:06
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Correct.

Russ

On 28 Mar 2014, at 09:58, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I can try changing the SLD but just so I am clear

The sld is looking for a field in my database called os_cat ?

Eg :

Unclassified - 1:35 to 1:3,496 os_cat fillUnclassified 35 3496 #FFFF99

Because I don’t have a field called that

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:53
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

If you can I would change the database but I understand that is harder than changing the SLD.

So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round.

Russ

On 28 Mar 2014, at 09:46, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>

The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@anonymised.comceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@anonymised.comceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from Robert.Langford@anonymised.com..5490... sent on Fri Mar 28 10:31:57 2014 is confidential. It is intended solely for the addressee(s) mark.ismail@anonymised.com;geoserver-users@anonymised.comurceforge.net<br><br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act.<br>Please immediately contact the sender, Robert.Langford@anonymised.com if you have received this message in error.<br><br>For the full disclaimer please access http://www.salford.gov.uk/e-mail.  Thank you.<br>

Ismail_Mark · March 28, 2014, 1:12pm

You were right I hadn’t run the scripts

I have the field in the database now and I have changed the sld to make os_cat upper case

I now get a new error

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

The requested Style can not be used with this layer. The style specifies an attribute of make and the layer is: Geostore:TOPOGRAPHICAREA

Any ideas ?

···

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 10:31
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

In the SLD you can download from the OS there should be a folder called “OS MasterMap Topography Layer SQL Scripts”, in there check out the Readme.txt:

The text files within this folder contain SQL scripts for Oracle databases loaded with OS MasterMap Topography Layer.

They look for various combinations of descriptiveTerm and descriptiveGroup values in the OS MasterMap Topography database and then create a new OS_CAT column which is populated with the required values that the OS MasterMap Topography Layer Style Layer Descriptor’s (SLD’s) will use so that the the relevant symbol for that feature is displayed.

Also, you will need the folder of SVG symbols on the server as well.

Hope this helps.

Rob

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 10:06
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Correct.

Russ

On 28 Mar 2014, at 09:58, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I can try changing the SLD but just so I am clear

The sld is looking for a field in my database called os_cat ?

Eg :

Unclassified - 1:35 to 1:3,496 os_cat fillUnclassified 35 3496 #FFFF99

Because I don’t have a field called that

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:53
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

If you can I would change the database but I understand that is harder than changing the SLD.

So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round.

Russ

On 28 Mar 2014, at 09:46, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>

The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 10:31:57 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com...;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

Langford_Robert1 · March 28, 2014, 1:19pm

Again,

Looks like you’re missing the column “MAKE”.

Should have values like:

· Natural

· Multiple

· Manmade

· Unclassified

· Unknown

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 13:13
To: Langford, Robert
Cc: geoserver-users@anonymised.comnet
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

You were right I hadn’t run the scripts

I have the field in the database now and I have changed the sld to make os_cat upper case

I now get a new error

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

The requested Style can not be used with this layer. The style specifies an attribute of make and the layer is: Geostore:TOPOGRAPHICAREA

Any ideas ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 10:31
To: Ismail, Mark
Cc: geoserver-users@anonymised.comorge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

In the SLD you can download from the OS there should be a folder called “OS MasterMap Topography Layer SQL Scripts”, in there check out the Readme.txt:

The text files within this folder contain SQL scripts for Oracle databases loaded with OS MasterMap Topography Layer.

They look for various combinations of descriptiveTerm and descriptiveGroup values in the OS MasterMap Topography database and then create a new OS_CAT column which is populated with the required values that the OS MasterMap Topography Layer Style Layer Descriptor’s (SLD’s) will use so that the the relevant symbol for that feature is displayed.

Also, you will need the folder of SVG symbols on the server as well.

Hope this helps.

Rob

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 10:06
To: Ismail, Mark
Cc: geoserver-users@anonymised.comorge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Correct.

Russ

On 28 Mar 2014, at 09:58, Ismail, Mark <mark.ismail@anonymised.com.> wrote:

I can try changing the SLD but just so I am clear

The sld is looking for a field in my database called os_cat ?

Eg :

Unclassified - 1:35 to 1:3,496 os_cat fillUnclassified 35 3496 #FFFF99

Because I don’t have a field called that

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com690…]
Sent: 28 March 2014 09:53
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

If you can I would change the database but I understand that is harder than changing the SLD.

So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round.

Russ

On 28 Mar 2014, at 09:46, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>

The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com…> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 10:31:57 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com..;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from Robert.Langford@anonymised.com..5490... sent on Fri Mar 28 13:19:13 2014 is confidential. It is intended solely for the addressee(s) mark.ismail@anonymised.com;geoserver-users@anonymised.comurceforge.net<br><br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act.<br>Please immediately contact the sender, Robert.Langford@anonymised.com if you have received this message in error.<br><br>For the full disclaimer please access http://www.salford.gov.uk/e-mail.  Thank you.<br>

Langford_Robert1 · March 28, 2014, 3:30pm

Mark,

We’ve lost the list – cc’d back in.

I think we’d need more info, are you just viewing in the layer preview, what style is it set to?

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 15:26
To: Langford, Robert
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Right again!

The field make was in the wrong case

Ive got it working now – thanks for all your help

New problem though

My one and only overlay I have which is a point table of bus stops has an opaque qhite background – and I haven’t a clue why – and no its not set to opaque

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 13:21
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Again,

Looks like you’re missing the column “MAKE”.

Should have values like:

· Natural

· Multiple

· Manmade

· Unclassified

· Unknown

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 13:13
To: Langford, Robert
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

You were right I hadn’t run the scripts

I have the field in the database now and I have changed the sld to make os_cat upper case

I now get a new error

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

The requested Style can not be used with this layer. The style specifies an attribute of make and the layer is: Geostore:TOPOGRAPHICAREA

Any ideas ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 10:31
To: Ismail, Mark
Cc: geoserver-users@anonymised.comforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

In the SLD you can download from the OS there should be a folder called “OS MasterMap Topography Layer SQL Scripts”, in there check out the Readme.txt:

The text files within this folder contain SQL scripts for Oracle databases loaded with OS MasterMap Topography Layer.

They look for various combinations of descriptiveTerm and descriptiveGroup values in the OS MasterMap Topography database and then create a new OS_CAT column which is populated with the required values that the OS MasterMap Topography Layer Style Layer Descriptor’s (SLD’s) will use so that the the relevant symbol for that feature is displayed.

Also, you will need the folder of SVG symbols on the server as well.

Hope this helps.

Rob

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 10:06
To: Ismail, Mark
Cc: geoserver-users@anonymised.comorge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Correct.

Russ

On 28 Mar 2014, at 09:58, Ismail, Mark <mark.ismail@anonymised.com.> wrote:

I can try changing the SLD but just so I am clear

The sld is looking for a field in my database called os_cat ?

Eg :

Unclassified - 1:35 to 1:3,496 os_cat fillUnclassified 35 3496 #FFFF99

Because I don’t have a field called that

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com690…]
Sent: 28 March 2014 09:53
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

If you can I would change the database but I understand that is harder than changing the SLD.

So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round.

Russ

On 28 Mar 2014, at 09:46, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>

The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com84…]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com...](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 10:31:57 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com;geoserver-users@anonymised.com.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com90...](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com..5490...) sent on Fri Mar 28 13:19:13 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from Robert.Langford@anonymised.com..5490... sent on Fri Mar 28 15:30:20 2014 is confidential. It is intended solely for the addressee(s) mark.ismail@anonymised.com;geoserver-users@anonymised.comurceforge.net<br><br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act.<br>Please immediately contact the sender, Robert.Langford@anonymised.com if you have received this message in error.<br><br>For the full disclaimer please access http://www.salford.gov.uk/e-mail.  Thank you.<br>

Ismail_Mark · March 28, 2014, 3:31pm

Its set to the default red square

And it’s the same in layer preview or my test solution

···

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 15:29
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

We’ve lost the list – cc’d back in.

I think we’d need more info, are you just viewing in the layer preview, what style is it set to?

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 15:26
To: Langford, Robert
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Right again!

The field make was in the wrong case

Ive got it working now – thanks for all your help

New problem though

My one and only overlay I have which is a point table of bus stops has an opaque qhite background – and I haven’t a clue why – and no its not set to opaque

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 13:21
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Again,

Looks like you’re missing the column “MAKE”.

Should have values like:

· Natural

· Multiple

· Manmade

· Unclassified

· Unknown

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 13:13
To: Langford, Robert
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

You were right I hadn’t run the scripts

I have the field in the database now and I have changed the sld to make os_cat upper case

I now get a new error

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

The requested Style can not be used with this layer. The style specifies an attribute of make and the layer is: Geostore:TOPOGRAPHICAREA

Any ideas ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 10:31
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

In the SLD you can download from the OS there should be a folder called “OS MasterMap Topography Layer SQL Scripts”, in there check out the Readme.txt:

The text files within this folder contain SQL scripts for Oracle databases loaded with OS MasterMap Topography Layer.

They look for various combinations of descriptiveTerm and descriptiveGroup values in the OS MasterMap Topography database and then create a new OS_CAT column which is populated with the required values that the OS MasterMap Topography Layer Style Layer Descriptor’s (SLD’s) will use so that the the relevant symbol for that feature is displayed.

Also, you will need the folder of SVG symbols on the server as well.

Hope this helps.

Rob

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 10:06
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Correct.

Russ

On 28 Mar 2014, at 09:58, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I can try changing the SLD but just so I am clear

The sld is looking for a field in my database called os_cat ?

Eg :

Unclassified - 1:35 to 1:3,496 os_cat fillUnclassified 35 3496 #FFFF99

Because I don’t have a field called that

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:53
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

If you can I would change the database but I understand that is harder than changing the SLD.

So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round.

Russ

On 28 Mar 2014, at 09:46, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>

The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 10:31:57 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com...;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 13:19:13 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com...;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 15:30:20 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com...;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

Langford_Robert1 · March 28, 2014, 3:37pm

Mark,

Are you only requesting that one layer? If not, what should be visible “behind” it?

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 15:31
To: Langford, Robert
Cc: geoserver-users@anonymised.coms.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Its set to the default red square

And it’s the same in layer preview or my test solution

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 15:29
To: Ismail, Mark
Cc: geoserver-users@anonymised.comurceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

We’ve lost the list – cc’d back in.

I think we’d need more info, are you just viewing in the layer preview, what style is it set to?

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 15:26
To: Langford, Robert
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Right again!

The field make was in the wrong case

Ive got it working now – thanks for all your help

New problem though

My one and only overlay I have which is a point table of bus stops has an opaque qhite background – and I haven’t a clue why – and no its not set to opaque

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com0…]
Sent: 28 March 2014 13:21
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Again,

Looks like you’re missing the column “MAKE”.

Should have values like:

· Natural

· Multiple

· Manmade

· Unclassified

· Unknown

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 13:13
To: Langford, Robert
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

You were right I hadn’t run the scripts

I have the field in the database now and I have changed the sld to make os_cat upper case

I now get a new error

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

The requested Style can not be used with this layer. The style specifies an attribute of make and the layer is: Geostore:TOPOGRAPHICAREA

Any ideas ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 10:31
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

In the SLD you can download from the OS there should be a folder called “OS MasterMap Topography Layer SQL Scripts”, in there check out the Readme.txt:

The text files within this folder contain SQL scripts for Oracle databases loaded with OS MasterMap Topography Layer.

They look for various combinations of descriptiveTerm and descriptiveGroup values in the OS MasterMap Topography database and then create a new OS_CAT column which is populated with the required values that the OS MasterMap Topography Layer Style Layer Descriptor’s (SLD’s) will use so that the the relevant symbol for that feature is displayed.

Also, you will need the folder of SVG symbols on the server as well.

Hope this helps.

Rob

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 10:06
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Correct.

Russ

On 28 Mar 2014, at 09:58, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I can try changing the SLD but just so I am clear

The sld is looking for a field in my database called os_cat ?

Eg :

Unclassified - 1:35 to 1:3,496 os_cat fillUnclassified 35 3496 #FFFF99

Because I don’t have a field called that

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:53
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@anonymised.comceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

If you can I would change the database but I understand that is harder than changing the SLD.

So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round.

Russ

On 28 Mar 2014, at 09:46, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>

The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@anonymised.comourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@anonymised.comceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 10:31:57 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@anonymised.com.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 13:19:13 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 15:30:20 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from Robert.Langford@anonymised.com..5490... sent on Fri Mar 28 15:37:16 2014 is confidential. It is intended solely for the addressee(s) mark.ismail@anonymised.com;geoserver-users@anonymised.comurceforge.net<br><br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act.<br>Please immediately contact the sender, Robert.Langford@anonymised.com if you have received this message in error.<br><br>For the full disclaimer please access http://www.salford.gov.uk/e-mail.  Thank you.<br>

Ismail_Mark · March 28, 2014, 3:59pm

Im the only user at the moment

Its the os mastermap topo layer that is set as base layer and the bus stops as the overlay

···

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 15:36
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

Are you only requesting that one layer? If not, what should be visible “behind” it?

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 15:31
To: Langford, Robert
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Its set to the default red square

And it’s the same in layer preview or my test solution

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 15:29
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

We’ve lost the list – cc’d back in.

I think we’d need more info, are you just viewing in the layer preview, what style is it set to?

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 15:26
To: Langford, Robert
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Right again!

The field make was in the wrong case

Ive got it working now – thanks for all your help

New problem though

My one and only overlay I have which is a point table of bus stops has an opaque qhite background – and I haven’t a clue why – and no its not set to opaque

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 13:21
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Again,

Looks like you’re missing the column “MAKE”.

Should have values like:

· Natural

· Multiple

· Manmade

· Unclassified

· Unknown

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 13:13
To: Langford, Robert
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

You were right I hadn’t run the scripts

I have the field in the database now and I have changed the sld to make os_cat upper case

I now get a new error

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

The requested Style can not be used with this layer. The style specifies an attribute of make and the layer is: Geostore:TOPOGRAPHICAREA

Any ideas ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 10:31
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

In the SLD you can download from the OS there should be a folder called “OS MasterMap Topography Layer SQL Scripts”, in there check out the Readme.txt:

The text files within this folder contain SQL scripts for Oracle databases loaded with OS MasterMap Topography Layer.

They look for various combinations of descriptiveTerm and descriptiveGroup values in the OS MasterMap Topography database and then create a new OS_CAT column which is populated with the required values that the OS MasterMap Topography Layer Style Layer Descriptor’s (SLD’s) will use so that the the relevant symbol for that feature is displayed.

Also, you will need the folder of SVG symbols on the server as well.

Hope this helps.

Rob

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 10:06
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Correct.

Russ

On 28 Mar 2014, at 09:58, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I can try changing the SLD but just so I am clear

The sld is looking for a field in my database called os_cat ?

Eg :

Unclassified - 1:35 to 1:3,496 os_cat fillUnclassified 35 3496 #FFFF99

Because I don’t have a field called that

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:53
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

If you can I would change the database but I understand that is harder than changing the SLD.

So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round.

Russ

On 28 Mar 2014, at 09:46, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>

The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 10:31:57 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com...;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 13:19:13 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com...;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 15:30:20 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com...;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 15:37:16 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com...;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

Langford_Robert1 · March 28, 2014, 4:09pm

Mark,

Not sure how you’d be doing that in Geoserver’s layer preview, can you provide the URL you’re trying view?

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 15:59
To: Langford, Robert
Cc: ‘geoserver-users@lists.sourceforge.net’
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Im the only user at the moment

Its the os mastermap topo layer that is set as base layer and the bus stops as the overlay

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 15:36
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

Are you only requesting that one layer? If not, what should be visible “behind” it?

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 15:31
To: Langford, Robert
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Its set to the default red square

And it’s the same in layer preview or my test solution

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 15:29
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

We’ve lost the list – cc’d back in.

I think we’d need more info, are you just viewing in the layer preview, what style is it set to?

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 15:26
To: Langford, Robert
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Right again!

The field make was in the wrong case

Ive got it working now – thanks for all your help

New problem though

My one and only overlay I have which is a point table of bus stops has an opaque qhite background – and I haven’t a clue why – and no its not set to opaque

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 13:21
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Again,

Looks like you’re missing the column “MAKE”.

Should have values like:

· Natural

· Multiple

· Manmade

· Unclassified

· Unknown

Rob

From: Ismail, Mark [mailto:mark.ismail@anonymised.com]
Sent: 28 March 2014 13:13
To: Langford, Robert
Cc: geoserver-users@anonymised.comrceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

You were right I hadn’t run the scripts

I have the field in the database now and I have changed the sld to make os_cat upper case

I now get a new error

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

The requested Style can not be used with this layer. The style specifies an attribute of make and the layer is: Geostore:TOPOGRAPHICAREA

Any ideas ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Langford, Robert [mailto:Robert.Langford@anonymised.com]
Sent: 28 March 2014 10:31
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Mark,

In the SLD you can download from the OS there should be a folder called “OS MasterMap Topography Layer SQL Scripts”, in there check out the Readme.txt:

The text files within this folder contain SQL scripts for Oracle databases loaded with OS MasterMap Topography Layer.

They look for various combinations of descriptiveTerm and descriptiveGroup values in the OS MasterMap Topography database and then create a new OS_CAT column which is populated with the required values that the OS MasterMap Topography Layer Style Layer Descriptor’s (SLD’s) will use so that the the relevant symbol for that feature is displayed.

Also, you will need the folder of SVG symbols on the server as well.

Hope this helps.

Rob

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 10:06
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Correct.

Russ

On 28 Mar 2014, at 09:58, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I can try changing the SLD but just so I am clear

The sld is looking for a field in my database called os_cat ?

Eg :

Unclassified - 1:35 to 1:3,496 os_cat fillUnclassified 35 3496 #FFFF99

Because I don’t have a field called that

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:53
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

If you can I would change the database but I understand that is harder than changing the SLD.

So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round.

Russ

On 28 Mar 2014, at 09:46, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I am loading the data direct from an Oracle database – created by a piece of software from PBBI called geostore

All the database fields are in upper case though – is there any way to fix it ? I cant really change the database, maybe I can change the sld ?

I did notice there was a folder called osmmsymbolsfull of svg files that came with the download from os which didn’t get copied to geoserver

Is that significant

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Russell Hore [mailto:russ@anonymised.com]
Sent: 28 March 2014 09:37
To: Ismail, Mark
Cc: Jody Garnett; geoserver-users@anonymised.comts.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

Are you loading the data from Postgres? If so I suspect it is the field names in the database are upper case and the SLD is expecting lower case. (I have been there myself)

Russ

On 28 Mar 2014, at 09:28, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I tried what you suggested and it did submit but its not very happy

<?xml version="1.0" encoding="UTF-8"?>

The requested Style can not be used with this layer. The style specifies an attribute of os_cat and the layer is: Geostore:TOPOGRAPHICAREA

I am new to this and haven’t a clue what that means – can anyone suggest why it isn’t happy ?

Mark Ismail

Principal IT Officer

Tel: 0151 443 3021

Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL

Save time – use the IT Service Desk Self Serve Application

From: Jody Garnett [mailto:jody.garnett@anonymised.com]
Sent: 28 March 2014 00:54
To: Ismail, Mark
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance survey with geoserver?

That does look like the filename is incorrect. I have not seen TopoArea.sld so I do not know if it compatible. Try copying and pasting the content into a new style and see how you go?

Jody Garnett

On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <mark.ismail@anonymised.com> wrote:

I have tried to upload the sld provided by uk ordnance survey but although they validate I get the following error when I click submit

org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld (The filename, directory name, or volume label syntax is incorrect

Mark

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com...) sent on Fri Mar 28 10:31:57 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com440...;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com90...) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 13:19:13 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com;geoserver-users@anonymised.comnet](mailto:mark.ismail@anonymised.com;geoserver-users@anonymised.com.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 15:30:20 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) sent on Fri Mar 28 15:37:16 2014 is confidential. It is intended solely for the addressee(s) [mark.ismail@anonymised.com;geoserver-users@lists.sourceforge.net](mailto:mark.ismail@anonymised.com;geoserver-users@anonymised.comeforge.net)<br>

 

<br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>

<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. <br>

<br>Please immediately contact the sender, [Robert.Langford@anonymised.com](mailto:Robert.Langford@anonymised.com) if you have received this message in error. <br>

 

<br>For the full disclaimer please access [http://www.salford.gov.uk/e-mail](http://www.salford.gov.uk/e-mail).  Thank you.<br>

This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

<br>DISCLAIMER: The information contained in this communication/message from Robert.Langford@anonymised.com..5490... sent on Fri Mar 28 16:09:27 2014 is confidential. It is intended solely for the addressee(s) mark.ismail@anonymised.com;geoserver-users@anonymised.comurceforge.net<br><br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act.<br>Please immediately contact the sender, Robert.Langford@anonymised.com if you have received this message in error.<br><br>For the full disclaimer please access http://www.salford.gov.uk/e-mail.  Thank you.<br>