Latest Contributions by DavidPike

‎04-03-2020

I'm thinking you should have compressed the database before the upgrade, I'm guessing the delta tables are stored differently? Far from an expert answer. I would definitely seek Esri guidance.

‎04-01-2020

'Double' is the data type you need.

‎03-31-2020

I believe !Version! in field calculator would represent each entry, calculating the max of that would only return itself. by "that if the field is 0, it will find the max for the field and add 1 to it. " i'm assuming you mean: that if an entry in the field is 0, it will find the max for the field and add 1 to it. ? find the max for the field first then run the calculate field

‎03-31-2020

Hi Benas, I've tried multiple syntax but no avail. I've been able to apply definition queries to feature classes using your code, but not a MD. wrt the raster catalog footprints, it seems this is correct for a mosaic dataset (I think the MD is a repackaged raster catalog rolled in glitter) Look forward to someone solving this.

‎03-31-2020

I'll try it on a dummy mosaic and get the syntax right for you. The data type on your screenshot is FGdb Raster Catalog not Mosaic Dataset?

‎03-31-2020

field = "Date" values = "1950" query = '"' + field + " = " + values + '"'‍‍‍ Is it Sacle_1250 or Scale_1250 maybe?

‎03-31-2020

As Steve says, Reclassify would be my go-to option. If you do need/want to cast it into memory: sloperasterpath = r"c:\myraster.tif" sloperasterobject = arcpy.Raster(rasterpath) then do a Con(….) using map algebra syntax. A useful part of the Reclassify tool is that if you change the symbology in the TOC to your desired classes, dragging that layer into the tool keeps those classified ranges.

‎03-29-2020

The join remains static from the time the join was created. You would have to remove and add the join each time, or use a relate, which will be dynamic.

‎03-29-2020

The land use tiff should be classified by coded values, e.g 1 = cropland, 2 = forest and therefore not interrogable by a text query such as 'if LU.tif == 'forest'... then..) I think it should be pretty easy in raster calculator with a Con statement: Con(InRas1 condition and InRas2 condition, True, False) my syntax might be a bit off, ive not tested it, if not try if "LU.tif" in (1,2) instead. Con( ("LU.tif" == 1 or "LU.tif" == 2 and "mndwi.tif" >= 0.4), "mndwi.tif", "LU.tif") my syntax might be a bit off, ive not tested it, if not try if "LU.tif" in (1,2) instead.

‎03-29-2020

I've not studies the code thoroughly but i'm guessing it's updating the values as expected? I may be misinterpreting, but you're aware that the visible attribute table has nothing to do with the actual positions of the points? You would need to update the geometry object ("SHAPE@" token in a cursor) or use the update fields to create a new feature through a tool like add xy data.

‎03-27-2020

You could do this with a search cursor. 1. Create a dictionary of OID keys and values of [SHAPE@, Intensity, Field] 2.Iterate through each OID to find matching SHAPE@ and Intensity and append them to a list. 3.you should have a list of all OIDs classed as identical by position and Intensity. Iterate through that list using the initial dictionary to find where field is N or Y

‎03-27-2020

Perhaps copy the connection file to the server with a full path, have you set up setparameter etc as derived output? On publishing you should be able to specify the level of error messaging.

‎03-25-2020

This script makes no sense, can you be clear what you exactly want to achieve.

‎03-23-2020

I don't see anything wrong with the statement, as it's in Raster Calculator not map algebra, the quotes are needed. I would troubleshoot by performing some simple expressions on each raster to see if the rasters themselves are the issue.

‎03-22-2020

A useful workflow for me is to write the expression first in the 'Select by attribute' window and see if it returns the expected results, then enclose the expression in quotations. for example a simple selection "Id" = 0 becomes '"id" = 0'

Online Status	Offline
Date Last Visited	‎01-14-2026 12:10 PM

My Ideas

Latest Contributions by DavidPike

Re: Enterprise Geodatabase (or .sde?) Anatomy

Re: How to add a parameter to a Toolbox GUI to provide a floating numeric value to a script?

Re: Finding the max of a field and adding 1

Re: Create a new layer of mosaic dataset with definition query in ArcMap.

Re: Create a new layer of mosaic dataset with definition query in ArcMap.

Re: Create a new layer of mosaic dataset with definition query in ArcMap.

Re: Generalize a Slope Surface

Re: How do I make a joined features layer automatically update?

Re: How to re-classify certain raster values based on another raster (land use classification)?

Re: Update fields and redraw points based on updated fields

Re: python(DeleteIdentical)

Re: Publish python script

Re: For Loop and Python String format()

Re: Raster calculator

Re: Making more Complex SQL Queries with Arcpy SearchCursor

Re: Define Projection crack-down

Re: Generate polygons that represent historic air ...

Re: Enterprise geodatabase connection slow - machi...

Re: Discrepancy between measure tool and expected ...

Re: Why does the geographic transformation involvi...

GIS Jobs