nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Display results/layers in Spyder Jupyter Notebook

ZacharyHart

Is there a way to visualize query results (like a Query Table or layer) in either of these IDE's? I know you can leverage the arcgis module in Jupyter, but here you're beholden to a web GIS. What if you're just running queries against an SQL instance? I really like both of these IDE's but at least if you're using the ArcGIS Python window (Dan Patterson‌ don't shoot me!) you see your results displayed directly (as a table or layer).

Any thoughts? Maybe I'm missing something really obvious here.

Thanks!

Trouver plus de publications taguées avec

Accepted answers

All comments

DanPatterson_Retired

<SPAN class="keyword token">import</SPAN> arcpy

f <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Git_Dan\JupyterNoteBooks\Data\Shapefiles\test.shp"</SPAN>

a <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>TableToNumPyArray<SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">)</SPAN>

sub <SPAN class="operator token">=</SPAN> a<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'FID'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">&</SPAN> <SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token"><</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>

frmt_rec<SPAN class="punctuation token">(</SPAN>sub<SPAN class="punctuation token">)</SPAN>

<SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN>n<SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN> FID&nbsp;&nbsp;&nbsp;&nbsp; Shape&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; E&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; G&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; H&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; J&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; K&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; L
<SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN>
 <SPAN class="number token">000</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">3</SPAN>&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="number token">9</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.62</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">8.94</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">8.25</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">0.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">4.47</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">3.16</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">2.24</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.83</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">8.54</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.28</SPAN>
 <SPAN class="number token">001</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">4</SPAN>&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">8.60</SPAN>&nbsp;&nbsp; <SPAN class="number token">10.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6.32</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">4.47</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">0.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">1.41</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.62</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6.08</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.39</SPAN>
 <SPAN class="number token">002</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5</SPAN>&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">8.49</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">9.90</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.07</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">3.16</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">1.41</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">0.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">4.12</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.21</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6.08</SPAN>
 <SPAN class="number token">003</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6</SPAN>&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.39</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6.71</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6.71</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">2.24</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">4.12</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">0.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">3.61</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.21</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.83</SPAN>
 <SPAN class="number token">004</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7</SPAN>&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">2.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">3.16</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.83</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.83</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.62</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.21</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">3.61</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">0.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6.71</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.39</SPAN>
 <SPAN class="number token">005</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">8</SPAN>&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6.08</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">1.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">8.54</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6.08</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.21</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6.71</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">0.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">1.41</SPAN>
 <SPAN class="number token">006</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">9</SPAN>&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6.08</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">1.00</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">7.28</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.39</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">6.08</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.83</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">5.39</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">1.41</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">0.00</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

You can always query the results and convert the table to a numpy array using.

If you are nice I will even share my fancy formatting function

Done in Spyder

https://community.esri.com/ideas/15429

ZacharyHart

Dan,

that makes good sense and is very helpful!

Maybe for a bit of context, as a novice python user, I hack my way towards creating things I need to get done. Even with all the shortcomings of the python window in ArcGIS, I'll often use that to bash away at various tools and I'll have an immediate idea (a visualization of the output) if they're gonna work or not. If one was to say try to figure out SelectLayerByLocation_management, you could do so and see your results right away and then build that into a tool/script/function.

I'm loving Jupyter & Spyder, (especially given my envy every time a colleague shows me what they're doing in R-Studio [but let's not start the Rodeo debate, right?]). I know I can't get the visualization end of things in Jupyter using our web GIS, but that's not what I'm trying to achieve here.

Maybe I'm just having a Goldilocks moment and want the perfect thing? Anyway, hopefully the background is helpful, but maybe what i'm looking for just doesn't exist outside ArcGIS.

Thanks!

DanPatterson_Retired

I just use the code snippets in the help file, if needed.

This just saves the expression which is pretty useless...

Now the selection works

so you go here

and copy the python command and … voila!

arcpy.management.SelectLayerByAttribute("a_1_pnts", "NEW_SELECTION", "OBJECTID < 8 And grid_code = 2", None)

ZacharyHart

Thanks Dan. I have used python snippets in the past as a learning tool.

Let me try to explain a little further. One of the redeeming qualities of using the python window in ArcGIS is that you are able to see your results, and therefore know that the command you executed works. Instant feedback.

KyleGonterwitz

Try importing pandas and using df = pd.DataFrame.from_records(data=arcpy.da.SearchCursor(fc,fields),columns=fields)

where fc is your GIS feature class layer and fields are a list of fields in fc you define

format the data frame and print tables, display tables, or display(HTML(table.to_html())) for larger outputs

try using group by with .sum or .apply and lambda functions for fast results printed in the jupyter output window

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.