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

760
1
06-23-2017 06:42 AM
BrooksBreece
New Contributor III

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.

Tags (3)
0 Kudos
1 Reply
JoshuaBixby
MVP Esteemed Contributor

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.