Flip between different query layer SQL definitions (for rapid spatial SQL development)

513
0
04-11-2023 09:38 PM
Status: Open
Labels (1)
Bud
by
Notable Contributor

ArcGIS Pro 2.6.8; Oracle 18c 10.7.1 EGDB

I have multiple query layers in the Contents pane of my map. I want to quickly navigate between the SQL definitions of the different query layers -- all within a single pane.

Reason: I want to do rapid spatial SQL development. Similar to what we can do in non-spatial SQL clients, except seamlessly visualize the spatial results in the map.

For example:

  1. Make a change to the sidewalks query layer's SQL definition. Hit run.
  2. In the same pane, quickly switch to the roads query layer SQL definition. Make a change and hit run.
  3. Switch to a different query layer's SQL definition. Make a change. And so on.

Bud_0-1681274319882.png

 

Possible ideas:

  • Add a dropdown parameter to the Make Query Layer GP tool that lets me choose a different query layer and edit it. The rest of the parameters would get automatically populated from the existing query layer.
  • Or, create a new GP tool called Edit Query Layer. It would have a similar dropdown parameter to the one described above.
  • Or, create a new kind of pane called the Query Layer pane. Flip between different query layers and edit them.
  • Or, the new pane could be used for any kind of feature layer: query layers, feature layers, or standalone tables. The pane could either edit the definition query of regular layers, or edit the SQL definition of query layers (whatever applies). The pane could be called the SQL Query Pane, or the SQL Definition Pane, etc.
  • Or something better.


Would something like that be possible?

I'm aware of the Query Layer properties —> Edit Query Layer dialog. But I don't think that helps me since it can only be used to modify the one query layer.