Latest Contributions by DavidPike

Hi, I don't understand the process fully, why was there a need to export to excel after running the zonal stats? The tool has a sum method? The OID issue is always a pain, I find adding a new field and copying the OIDs across works well to retain a relationship. ... View more

I'm not sure I fully understand, after re-reading several times I'm guessing you want to emulate the inclination of the panels which would go onto flat roofs in your DSM? It seems a bit backward to me as you would have to do burn some pseudo heights onto your DSM to then re-run the slope calculation, which would get very involved considering the orientation of the buildings. I'd recommend burning your calculated slope values (proposed panel orientations for flat roofed buildings) onto your original slope calculation using Raster Calculator.  ... View more

Is this in Pro? ArcMap may not have the same limitation. Candidate facilities Facilities to find Number of potential solutions 10 5 252 30 15 155,177,520 50 25 126,410,606,437,752 100 50 1.009 x 10 29 500 250 1.167 x 10 149 ... View more

How are you rotating it? Have you tried changing the rotation in the properties for the text symbol? ... View more

I started typing before you replied Joe, honest! ... View more

What an interesting question, I was trying to wrap my head around that! Can you just work out which domains contain 'Overhead'? eg if overhead appears in coded value 2,4,9 and 10: "[SUBTYPECD]" IN (2, 4 ,9, 10) I also believe the query should be passed as a string in itself, ie: query = ' "[SUBTYPECD]" IN (2, 4 ,9, 10) ' arcpy.SelectLayerByAttribute_management ("OHlyr3", "NEW_SELECTION", query )  hope this helps ... View more

Stupid question but did you allow it to run (top of your screenshot)? ... View more

I thought .shx was a mandatory file? ... View more

You may have to persist the join by saving into into memory or scratch, if it was me I would save it as an output for the moment and inspect it manually to see what it looks like. ... View more

A few print statements will give you a better idea. has that DATA column got any missing values or nulls? that would throw an exception.  If so use a bit of logic such as if type(attachment)… do this or a try Except block with a continue. ... View more

I've checked this in pro (don't use it much) and the column names have no quotation now, i'd try that ... View more

What is the query for? is it a select by attribute, definition query etc? is the APN a number or string? if it's a number get rid of the quotes. you could also use the IN operator for efficiency: "APN" IN (12344, 123124, 142442) ... View more

My first advice would be to ensure that your search radius and cell sizes are all the same, and you set a snap raster (look it up!) When it comes to raster calculator, the tool is very easy to get along with. any rasters in your TOC will appear in the window and you can enter your expression with the keypad. it would look something like: ("PointDensityRaster.tif" + "LineDensityRaster.tif") / 2.0 psb documentation which will explain it much better than me. Raster Calculator—Help | ArcGIS for Desktop  ... View more

You could use Generate Points Along Lines—Help | ArcGIS Desktop to create points along your lines with a specified interval. another method might be to use point density or kernel density on your points, then another density for your lines then add the results in Raster Calculator. ... View more

Of course,  I've looked at the documentation you sent a link for, that code sample applies to the use of a script in immediate mode i.e. the python window in an mxd, where you have the feature classes represented a layer in your TOC. I'd suggest adding a line of code in your second for loop to turn each of those feature classes into feature layers, which may work the same as a table view. ... View more