Examples of expressions for query layers that use attributes and geometries?; Query layers responsive to user input

BrooksBreece

Good morning,

I am looking for examples of SQL expressions to use in Make Query Layer that have WHERE statements that include conditions based on attribute values and geometries.  The SDE from which I am pulling is an Oracle database.

Question 2: Who in a ModelBuilder tool or script tool asked an user to supply a geometry that is then used in a Query Layer SQL statement?

Thank you for your help.

JoshuaBixby

Talking in too abstract of terms is always difficult.  For your question 1, it would be helpful if you could provide a couple examples of what you are trying to achieve, e.g., I have three fields (field1 (str), field2 (dbl), field3 (date), field4 (geom)) where I want to select all rows where field1 = 'x' and field2 > 100. and area(field4) > 10 acres.

I don't think providing you with random examples relevant to my work will be useful for you in your work.