topic Re: How to select a raster from raster catalog by a selected point with a field that contains the raster name in ModelBuilder Questions

How to select a raster from raster catalog by a selected point with a field that contains the raster name

RolandGliba — Tue, 31 May 2016 09:40:03 GMT

Hy!

I have a managed raster catalog and its raster's names are contained in a field in a point feature class. I use the select layer by location tool with an in memory point to get the point and then I need something to get this value to the select layer by attribute tool. Can anyone help me? thank you

Roland

Re: How to select a raster from raster catalog by a selected point with a field that contains the raster name

FC_Basson — Tue, 31 May 2016 10:35:17 GMT

You can set the Expression value in the Select Layer By Attribute tool by using the field value of the previous process with an inline variable:

MYFIELD = '%Value%'

Also make the Get Field Value result a precondition for your final select by attribute process.

Re: How to select a raster from raster catalog by a selected point with a field that contains the raster name

RolandGliba — Tue, 31 May 2016 13:46:17 GMT

I did it, get field value is made as a precondition to the select layer by attributes, the model is running without any result so the problem is, either with the get field value process or with the expression.

Re: How to select a raster from raster catalog by a selected point with a field that contains the raster name

FC_Basson — Wed, 01 Jun 2016 05:38:56 GMT

This is where you need to break your model down in parts and see what each process required inputs and results are.

Re: How to select a raster from raster catalog by a selected point with a field that contains the raster name

curtvprice — Thu, 09 Jun 2016 05:41:05 GMT

You aren't seeing any thing in the message dialog that gives you a clue?

One approach you may want to try is to use the Calculate Value tool to compose your SQL expression from the output of Get Field Value. Value would be a precondition to Calculate Value, which would use the expression: r"MYFIELD = '%Value%'" with the datatype set to SQL expression. The SQL expression would then connect into your Select Layer By Attribute tool.