Latest Contributions by EvanD

‎08-18-2019

I installed WireShark but it is well outside my area of expertise. I'm guessing I need to set up a capture filter and then try to run the sql in ArcMap, but that's as far as I got. I'll try some importing/exporting.

‎08-15-2019

I'm having trouble with ArcMap 10.4.1 hanging when performing select by location. I have point data stored in a sql server database table (Bores) with a geometry field, GeogLoc. I can do a select by location from a query layer based on the Bores table to get points within a polygon in a layer, Basin100, from a geodatabase. However, when I join the Bores table to my sql server WaterLevel table with a one-to-many PK to FK relationship, and then try to select the locations, ArcMap hangs. I have a clustered index on the PK, BoreID in the Bores table and a non-clustered index of the FK in the WaterLevel table. I have tried a spatial index on the GeogLoc field in the Bores table. I have tried both creating the join in the sql for the query layer and by creating a view in sql server. I tried indexing the view to make it a materialized view. None of that helps. It appears everything on the sql server side works properly and quickly. I have tried modifying the sql for the query layer so that fewer than 10 bore locations are returned and then the select by location is successful, but very slow. If I increase it to ~100 locations (< ~1000 records), the operation hangs. I would appreciate any advice on why this is not working and possible solutions or work-arounds.

‎01-03-2019

It says 10.4.2.5686.

‎01-01-2019

I am attempting to run a script that throws an error in a seemingly simple statement in bold below: for i in range(1,len(part)): cut=part[i-1:i+1] sides.append(arcpy.Polyline(cut,SR)) I ran the script up to where part is defined then entered: >>> part <Array [<Point (2524240.5113, 2562562.7555, #, #)>, <Point (2524240.8774, 2562712.7555, #, #)>, <Point (2524290.3774, 2562712.6347, #, #)>, <Point (2524290.0113, 2562562.6347, #, #)>, <Point (2524240.5113, 2562562.7555, #, #)>]> >>> c = part[0:2] Runtime error Traceback (most recent call last): File "<string>", line 1, in <module> File "c:\program files (x86)\arcgis\desktop10.4\arcpy\arcpy\arcobjects\mixins.py", line 161, in __getitem__ return convertArcObjectToPythonObject(self._arc_object.GetObject(index)) AttributeError: Array: Error in parsing arguments for GetObject I have tried on two computers, one with python 3 also installed and one without. The python directories returned by sys.path are all there (although the path also includes the non-existent 'C:\\WINDOWS\\SYSTEM32\\python27.zip'). Any ideas on how to troubleshoot this? Thanks.

‎03-16-2017

I think the devil is in the, "Now, after some quality control of adjustments and transformations, we can rectify this image and call it georeferenced!" part.

‎01-15-2015

Thanks for this. An approach that you might consider is to use rastertonumpyarray rather than looping through the extracts for each polygon. In my kludge to do something similar, actually wanted cumulative frequency curves, I extracted using rastertonumpyarray, flattened the array, sorted it ascending and then was working on calculating the percentiles when I said, "heck with it" and sent it all to Excel to finish. But the processing might be more efficient working in numpy.

‎07-25-2011

You should be able to do it using zonal statistics under the spatial analyst. If you are looking for any occurence of a particular value that won't necessarily be seen in the statistics (not min, max, etc.) then create a raster where the value is 1 where the value of the original raster is the one you are interested in and 0 everywhere else, then use max.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:24 AM

My Ideas

Latest Contributions by EvanD

Re: How to perform a spatial select against a Sql Server query layer (keeps crashing)

How to perform a spatial select against a Sql Server query layer (keeps crashing)

Re: slicing error in python in ArgGIS 10.4.1 for desktop

slicing error in python in ArgGIS 10.4.1 for desktop

Re: Explain Georeferencing To Me as If I Were a Five-Year-Old

Re: Zonal statistics - percentiles

Re: Raster: Select by location from vector?

Re: Explain Georeferencing To Me as If I Were a Fi...