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:[email protected]] Sent: 28 March 2014 10:06 To: Ismail, Mark Cc: [email protected] 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 <[email protected]<mailto:[email protected]>> 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<http://kmbcselfservice/> Application From: Russell Hore [mailto:[email protected]] Sent: 28 March 2014 09:53 To: Ismail, Mark Cc: Jody Garnett; [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> 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<http://kmbcselfservice/> Application From: Russell Hore [mailto:[email protected]] Sent: 28 March 2014 09:37 To: Ismail, Mark Cc: Jody Garnett; [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> 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"><file:///C:\Users\ismailm\AppData\Local\Microsoft\Windows\Temporary%20Internet%20Files\Content.IE5\6DSNU31E\wms><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<http://kmbcselfservice/> Application From: Jody Garnett [mailto:[email protected]] Sent: 28 March 2014 00:54 To: Ismail, Mark Cc: [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]> 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 [email protected]<mailto:[email protected]> 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. DISCLAIMER: The information contained in this communication/message from [email protected] sent on Fri Mar 28 10:31:57 2014 is confidential. It is intended solely for the addressee(s) [email protected];[email protected] 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. 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. Please immediately contact the sender, [email protected] if you have received this message in error. For the full disclaimer please access http://www.salford.gov.uk/e-mail. Thank you.
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
