topic Attribute Assistant Intersecting Raster Method Not Working in State & Local Government Questions

Attribute Assistant Intersecting Raster Method Not Working

GregEpp — Mon, 06 Jan 2014 19:49:06 GMT

The Attribute Assistant tool has been an extremely valuable tool but I have not been able to get the 'Intersecting Raster' method to work on our enterprise SQL database. I am using version 2 of the attribute assistant. The following syntax worked on a file gdb but not on SDE:

Table Name: RMoN_San_Access_Chambers
Field Name: RIM_ELEVATION
Value Method: INTERSECTING_RASTER
Value Info: DEM_5M_2002|Pixel value

Does anyone know why this works in a file gdb but not on SDE?

Thanks.

Re: Attribute Assistant Intersecting Raster Method Not Working

MikeMillerGIS — Thu, 30 Jan 2014 15:09:10 GMT

Greg,
Can you activate the Attribute Assistant Log File and see what it says? You can turn this on by changing the config file.

Re: Attribute Assistant Intersecting Raster Method Not Working

GregEpp — Fri, 31 Jan 2014 13:18:34 GMT

Here is the log file:

      Field Name: RIM_ELEVATION was found at index: 44
                  Trying: INTERSECTING_RASTER
                  ERROR/WARING: No cell value or raster was found: DEM_5M_2002
                  Finished: INTERSECTING_RASTER

I have tried several values for the second parameter value, pixel value, and nothing but I am still getting a '0' value returned. Any ideas?

Re: Attribute Assistant Intersecting Raster Method Not Working

MikeMillerGIS — Fri, 31 Jan 2014 13:20:01 GMT

Can you verify the Rasters layers name? Is this a single band raster?

Re: Attribute Assistant Intersecting Raster Method Not Working

GregEpp — Fri, 31 Jan 2014 14:55:46 GMT

Can you verify the Rasters layers name? Is this a single band raster?

The raster layer name is correct but it is a single band raster.

Re: Attribute Assistant Intersecting Raster Method Not Working

MikeMillerGIS — Fri, 31 Jan 2014 14:57:22 GMT

Good, last question, does the spatial ref of the raster match the spatial reference of the data frame or data being edited?

Re: Attribute Assistant Intersecting Raster Method Not Working

GregEpp — Fri, 31 Jan 2014 15:15:27 GMT

Yes, the data frame and the raster both have a spatial reference of NAD_1983_UTM_Zone_17N. Should I be using a different field name for the SDE raster?

Re: Attribute Assistant Intersecting Raster Method Not Working

GregEpp — Fri, 31 Jan 2014 15:44:01 GMT

I think I found the problem. If I specify the database.owner.layer then the tool works. For example, instead of just giving the layer name in the dynamic value table, I needed to provide the following:

www_gis.GIS_ADMIN.DEM_5M_2002

Re: Attribute Assistant Intersecting Raster Method Not Working

MikeMillerGIS — Fri, 31 Jan 2014 15:49:18 GMT

That could be it. We tried hard to allow you to use the TOC name, or even the Dataset name minus the owner and table, but this one might have slipped through. If this resolves the issue, I can add a bug to the tools and get it resolved in next release.

Re: Attribute Assistant Intersecting Raster Method Not Working

GregEpp — Fri, 31 Jan 2014 16:04:13 GMT

It would be great if the next release fixes this issue. Will all updates be applied to the 10.2 version or will you update the Attribute Assistant tool for ArcGIS 10.0? I ask because we will be on 10.0 for some time yet.

Thanks.

Re: Attribute Assistant Intersecting Raster Method Not Working

MikeMillerGIS — Fri, 31 Jan 2014 16:05:50 GMT

Oh, then I bet it already fixed. We made a lot of those fixes at 10.1. We will not be updating 10.0. We are finalizing our 10.1 Quality Improvement Patch testing and should have it out shortly.