[Geoserver-users] Hiding columns in layers

Hi List,
I want to publish a layer but don’t want all of the columns in the database to be visible in the WMS/WFS etc. Is there an easy way to “hide” columns with GeoServer?

(I know I can re-load the data or create a View in the database, but those are both high maintenance).

Cheers,
Jonathan

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

Jonathan,
you could create an SQL view directly into geoserver:
http://docs.geoserver.org/stable/en/user/data/database/sqlview.html

Cheers,
Carlo

···

2014-02-19 12:42 GMT+01:00 Jonathan Moules <jonathanmoules@anonymised.com>:

Hi List,
I want to publish a layer but don’t want all of the columns in the database to be visible in the WMS/WFS etc. Is there an easy way to “hide” columns with GeoServer?

(I know I can re-load the data or create a View in the database, but those are both high maintenance).

Cheers,
Jonathan

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk


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

==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

Dott. Carlo Cancellieri
@cancellieric
Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


Hi Carlo,
That had occurred to me but for some reason I never bothered testing it (I assumed it didn’t do columns).

That seems to have worked fine; many thanks!

Jonathan

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

···

On 19 February 2014 12:32, carlo cancellieri <carlo.cancellieri@anonymised.com> wrote:

Jonathan,
you could create an SQL view directly into geoserver:
http://docs.geoserver.org/stable/en/user/data/database/sqlview.html

Cheers,
Carlo

2014-02-19 12:42 GMT+01:00 Jonathan Moules <jonathanmoules@anonymised.com>:

Hi List,
I want to publish a layer but don’t want all of the columns in the database to be visible in the WMS/WFS etc. Is there an easy way to “hide” columns with GeoServer?

(I know I can re-load the data or create a View in the database, but those are both high maintenance).

Cheers,
Jonathan

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk


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

==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

Dott. Carlo Cancellieri
@cancellieric
Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


If you are worried about the columns showing up in the GetFeatureInfo call
(popup), you could use FTL
<http://docs.geoserver.org/stable/en/user/tutorials/GetFeatureInfo/index.html&gt;
to hide stuff.

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Hiding-columns-in-layers-tp5104684p5104942.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Interesting alternative solution, but probably doesn’t scale across to WFS (which I need). Useful to know about for the future though.
Thanks!

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

···

On 20 February 2014 16:43, maw269 <maw269@anonymised.com> wrote:

If you are worried about the columns showing up in the GetFeatureInfo call
(popup), you could use FTL
<http://docs.geoserver.org/stable/en/user/tutorials/GetFeatureInfo/index.html>
to hide stuff.


View this message in context: http://osgeo-org.1560.x6.nabble.com/Hiding-columns-in-layers-tp5104684p5104942.html
Sent from the GeoServer - User mailing list archive at Nabble.com.


Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk


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