Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
SQL help please! I've tried searching, but can't find the help I need.
This is for ArcGIS Advanced 10.2.
I have a parcel layer with all kinds of info that the general public shouldn't be able to access. What I want to do is use a definition query to hide entire columns of data, but still display the parcel with some non-sensitive information. I'd like to avoid deleting the columns if I can.
A definition query cannot hide columns of data. It is used to filter out rows of your data. For what you want to do I would either create a view of your feature class that doesn't include the columns you want to hide or if you are publishing this as a map service you can turn those columns off within the map document.
Within ArcMap right click the layer and choose Properties. Then click on the Fields tab. Uncheck the fields that you do not want published to the service. If you are only working with a MXD turning the fields off isn't a real secure option, because anyone could go in and turn them back on. But if you are publishing this as a service it will prevent those fields from being published.
A query layer pointing to the original DB of features would allow you to generate a limited version of your dataset.
A query layer uses full SQL, rather than the limited SQL available in a definition query. Your select statement should only include the desired fields instead of the default "Select *."
http://resources.arcgis.com/en/help/main/10.2/index.html#//00s500000027000000
