[GIS] Definition Query to hide attribute data

arcgis-10.2arcgis-desktopdefinition-querysql

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.

Best Answer

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.

Related Solutions

[GIS] spatial query tool for laymen

In ArcMap, If you look up Search in Polygon in ArcMap, you'll find this:

"Select By Location to select those features from the points layer that intersect the polygon layer"

That's found by "Selection>Select by Location" on the menu bar and it will ask for a Target layer then a Source layer and a selection method.

So the Target layer is your point layer, the Source layer the polygon layer and 'Target layer are within source layer as your spatial selection method.

Then save the output

[GIS] Definition Query / SQL problem in ArcGIS

The reason they don't add up is that in query 1, you have a condition Query 1: (this) AND NOT (that).

Queries 2 and three have only one condition Query 2: (this) Query 3: (that)

You undoubtedly have some records where (this) is true AND (that) is true and also where they are both false.

Try modifying query 1 (take out NOT)

(railway NOT IN (Null,'') AND osmSupportingElement = 'no') AND (railway IN ('platform') AND (osm_level LIKE ('%-%') OR osm_layer LIKE ('%-%') OR osm_location IN ('underground','underwater')))

and see what you get. Also try breaking the queries into smaller pieces and you may come by the answer on your own (see my comment).

Best Answer

Related Solutions

[GIS] spatial query tool for laymen

[GIS] Definition Query / SQL problem in ArcGIS

Related Question