Latest Contributions by DavidPike

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

I think your input needs to be a table view for your getCount function, rather than the feature class. ... View more

absolutely, Generate Tessellation—Data Management toolbox | Documentation  this may not be available on your version of arcmap if its quite old however. The fishnet tool would be useful if not. ... View more

Ah ok, those raster density outputs aren't really designed for attribution in a tabular form. I'd highly recommend making that grid of hexagons (play about with the size you want) then do a spatial join based on those points. ... View more

Hi Chad, you may want to search for Point Density and Kernel Density, they are similar but there are important differences between them. If you want to use an aggregation method, I personally like to generate a grid of spatial bins, then count how many points are within each bin using the Spatial Join tool. Generate Tesselation is a great tool which can also produce a hexagonal grid of bins (Hexagons are the most complex regular shape that can be tessellated, and have equidistant centres to all their neighbours!). ... View more