[Geoserver-users] Hiding columns in layers

GeoServer GeoServer User
1

Hi,

It is also possible to manipulate the “featuretype.xml” file. For example, open the schema file of top:states from

\geoserver-2.5-RC1\data_dir\workspaces\topp\states_shapefile\states\featuretype.xml

Cut some attribute elements, save the file, restart Geoserver – do

http://localhost:8080/geoserver/wfs?service=wfs&version=1.0.0&request=describefeaturetype&typename=topp:states

and see what you get.

-Jukka Rahkonen-

···

Jonathan Moules wrote:

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

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

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.

2

Hi Jukka,
I have to admit, this method has a certain appeal. But it’s not “fail-safe”; what’ll happen is that I’ll end up forgetting about the manual tweaking (or someone else won’t know about/understand it) and the layer will be re-loaded with no followup-change.
Useful to know about though, 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 25 February 2014 12:28, Rahkonen Jukka (Tike) <jukka.rahkonen@anonymised.com> wrote:

Hi,

It is also possible to manipulate the “featuretype.xml” file. For example, open the schema file of top:states from

\geoserver-2.5-RC1\data_dir\workspaces\topp\states_shapefile\states\featuretype.xml

Cut some attribute elements, save the file, restart Geoserver – do

http://localhost:8080/geoserver/wfs?service=wfs&version=1.0.0&request=describefeaturetype&typename=topp:states

and see what you get.

-Jukka Rahkonen-

Jonathan Moules wrote:

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

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.4942…>:

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

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.

Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk

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

3

Hi,

As an Oracle user it may be good for you to know that by hand-editing the schema you can also make Geoserver to advertise a fixed geometry type even if the Oracle spatial index is created without the layer_gtype parameter.

-Jukka Rahkonen-

···

On 25 February 2014 12:28, Rahkonen Jukka (Tike) <jukka.rahkonen@anonymised.com> wrote:

Hi,

It is also possible to manipulate the “featuretype.xml” file. For example, open the schema file of top:states from

\geoserver-2.5-RC1\data_dir\workspaces\topp\states_shapefile\states\featuretype.xml

Cut some attribute elements, save the file, restart Geoserver – do

http://localhost:8080/geoserver/wfs?service=wfs&version=1.0.0&request=describefeaturetype&typename=topp:states

and see what you get.

-Jukka Rahkonen-

Jonathan Moules wrote:

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

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

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.

Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk

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