Latest Contributions by DevinUnderwood2

‎01-31-2018

Thanks, this works by confirming the calculation of date difference. timedelta is definitely the key. I will now work on incorporating Joshua's example to use a cursor. import arcpy import datetime from datetime import timedelta # Set Date Variables today = datetime.date.today() daysAgo30 = today - timedelta(days=30) print "Today is: " + " " + str(today) print "30 days ago is:" + " " + str(daysAgo30)‍‍‍‍‍‍‍‍‍

‎01-30-2018

Thanks for the advice. SYSDATE - Is this from the import sys module ? I tried this but with an error using SYSDATE

‎01-30-2018

Oracle sde features

‎01-30-2018

I am trying to use a search cursor to look up a date field to only return LastUpdates within the last 30 days. today = datetime.date.today() I want to use the datetime and date field types which are in different formats and is why I can't calculate the difference. How can I format them the same to accomplish this ?

‎12-20-2017

ArcMap doesn't have override settings.

‎12-20-2017

Great advice, I don't have access to Pro yet. Would have been real easy to use this setting. I have looked at the correlated documentation and have not come across a solution. This Optimized Hot Spot Analysis is convenient also since it gives me counts per polygon . My alternative requires several steps. Point density (raster) Change raster (float to integer) Raster to polygon Spatial Join to get counts (Requires cleaning up or ensuring all point density output have 100 foot squares.

‎12-20-2017

I keep getting a cell size of 57 feet which is automatically set. I want to manually set the cell size of the generated fishnet polygons around the points. I tried the environment settings XY Resolution Tolerance but the tool ignores my input. How can I get this to work or is there another way ? Thank you

‎12-19-2017

Thanks, I used the Raster Calculator syntax helper to double click the Int option to correctly complete the expression.

‎12-18-2017

Perfect, that is what I needed. It works now . Thank you.

‎12-18-2017

I am using the Raster Calculator Tool to change my raster from a float to a integer so I can eventually change run Raster to Polygon (need to integer raster input) I ran the tool several times using the following expression)but my result is still a float. "pointden100ft" * 1000000000 The expression is very easy as I consulted the following ESRI tips https://support.esri.com/en/technical-article/000012554 Any ideas what is causing the issue ?

‎11-09-2017

I changed it up trying to get it to work and used while instead for loop. I noticed that all the records all selected then all records unselected so the cursor is not working like I want it to. One by one import arcpy, time mxd = arcpy.mapping.MapDocument ('CURRENT') df = arcpy.mapping.ListDataFrames(mxd,"Layers")[0] field = "OBJECTID" # y = input("Type Layer Name :") fc = r'Orders_High_RD' lyr = arcpy.mapping.ListLayers(mxd, fc, df)[0] ##df.extent = lyr.getSelectedExtent() df.scale = 1000 # we set the scale to 1000 ##arcpy.RefreshActiveView() cursor = arcpy.SearchCursor(fc) row = cursor.next() while row: row = cursor.next() ## print (row.getValue(field)) ## time.sleep(5) arcpy.SelectLayerByAttribute_management(fc,"NEW_SELECTION") time.sleep(5) df.extent = lyr.getSelectedExtent() arcpy.RefreshActiveView() ## df.zoomToSelectedFeatures() ## arcpy.RefreshTOC()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎11-09-2017

great advice, I will work with this, and it seems I would not want the DF.zoomToSelectedFeatures()

‎11-09-2017

This makes sense, where exactly would I put it, as I know I want to pause after each selected record. What is the difference between using df.zoomToSelectedFeatures() & df.extent = lyr.getSelectedExtent()

‎11-08-2017

I know I almost have this right but it selects all records and doesn't zoom to each record - one by one import arcpy mxd = arcpy.mapping.MapDocument ('CURRENT') df = arcpy.mapping.ListDataFrames(mxd,"Layers")[0] # y = input("Type Layer Nmae :") fc = r'Orders_High_RD' lyr = arcpy.mapping.ListLayers(mxd, fc, df)[0] #df.extent = lyr.getSelectedExtent() df.scale = 1000 # we set the scale to 1000 #arcpy.RefreshActiveView() with arcpy.da.SearchCursor(fc, "OBJECTID") as cursor: row = cursor.next() for row in cursor: df.extent = lyr.getSelectedExtent() arcpy.SelectLayerByAttribute_management(fc,"NEW_SELECTION") #df.zoomToSelectedFeatures() arcpy.RefreshTOC() arcpy.RefreshActiveView()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎10-16-2017

I would like to post it after I modify the code some more to use ListFields rather than manually hardcode the field names. Also, one last section of tying in the max() value to the auto increment () function, which I haven't had a chance to test yet, but soon.

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

My Ideas

Latest Contributions by DevinUnderwood2

Re: Calculate Number of Days from Current Date

Re: Calculate Number of Days from Current Date

Re: Calculate Number of Days from Current Date

Calculate Number of Days from Current Date

Re: Optimized Hot Spot Analysis

Re: Optimized Hot Spot Analysis

Optimized Hot Spot Analysis

Re: Convert a floating type raster to Integer

Re: Convert a floating type raster to Integer

Convert a floating type raster to Integer

Re: Zoom To Each Record Search Cursor

Re: Zoom To Each Record Search Cursor

Re: Zoom To Each Record Search Cursor

Zoom To Each Record Search Cursor

Re: Update Fields by Matching Fields

Re: Arcmap Python Label Expression Function "Null"

Re: How do I loop a folder of mxds

Python Tool - User input then Select by Attribute

csv.reader to updateCursor

Re: Display Table XY Dayta