Latest Contributions by DavidPike

do you have a spatial index on the shape field? or possibly: select NAME1 from GTSOWNER.CM_BOUNDARY3_PG a  where sde.st_within (sde.st_point(45.576579,26.460792,32637), a.shape)=1; ... View more

you might try arcpy.RefreshActiveView() but i'll have  look at the code properly when I get the chance. ... View more

Can you give more info? Source of the data, what projection are the files you're comparing it to, what projections have you tried, what transformations used? ... View more

without delving into the rescale function I'd say it looks ok. Maybe pass the controlpoints as floats: e.g.  ControlPoint1 = float(arcpy.GetParameterAsText(3)) or just arcpy.GetParameter()  I'm no expert programmer, but I'd stop renaming variables for no reason, e.g. just call  minimum = arcpy.GetParameterAsText(4) and so on.  It seems needlessly confusing otherwise.   Is there a specific part it's falling over on?  Do you know how to assign the parameters in the script tool itself? ... View more

Is there a rationale behind making a tool from an existing tool (and perhaps limiting its functionality)? ... View more

Logically you would want to save the output file as a combination of the names of the rasters. I'd grab the names of the rasters before you multiple them, and create a path from that combination. ensure you import the os module (import os)   from arcpy import env from arcpy.sa import * import os arcpy.env.workspace = "C:/MSc_thesis/XrApor" idwlist = arcpy.ListRasters("*", "TIF") equallist = arcpy.ListRasters("*", "GRID") for eachidw in idwlist: for eachequal in equallist: out_name = eachidw.name + "_" + eachequal.name out_path = os.path.join(r"C:/MSc_thesis/products", out_name) outTimes = Times(eachidw,eachequal) outTimes.save(out_path)     ... View more

Seemed to work fine. 3dstack.png ... View more

I think you could quite easily iterate over each polyline (road) and jury-rig the stack profile tool https://desktop.arcgis.com/en/arcmap/latest/tools/3d-analyst-toolbox/stack-profile.htm then do some magic on the output table for each road.   ... View more

You want to count the number of IP's within 500m of each house? Looks like your join feature and target feature are the wrong way round. ... View more

I guess it's taking it in as assumed UTC (without specifying a timestamp it assumes 00:00:00 hrs) then converting to your local time  (UTC -5 hours a good guess?). That's strange, as the behaviour I observed on my enterprise when editing was that local times specified in edits were then posted as UTC to the enterprise gdb fc. appreciate there's no solution in my reply, just be warmed by the knowledge that I feel your pain. ... View more