Hexagon Geospatial
MENU

Support ERDAS IMAGINE

Discuss and share topics of interest using ERDAS IMAGINE the world’s leading geospatial data authoring system.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Contributor
Posts: 59
Registered: ‎04-19-2016

Query feature attribute table and update attribute column

[ Edited ]

Hi,

 

How do I query an attribute table of a feature, for example:

 

Select row's of table where "Value >= 1 and Value < 10"

 

And then update the selected rows "Class" column in the attribute table with text:

 

"Class 1"

 

Please help!

 

 

Staff
Posts: 75
Registered: ‎07-04-2016

Re: Query feature attribute table and update attribute column

[ Edited ]

Hello Jens,

 

You can get some ideas from this model:

 

2016-08-25 11_36_07-Untitled_1 - ERDAS IMAGINE 2016.png

 

Here I am adding a new Category column, where value 1 will have polygons with MEAN less-then-or-equal-to 0.4 and value 2 will have polygons with MEAN more-then 0.4. 

 

The operators above for getting 2D CRS are needed to make the output shapefile editable. You can find the description here.

 

Hope this will help.

 

Kind Regards,

Marina Vardovska
Post-Sales Engineer Remote Sensing

Hexagon Geospatial Division

 

 

Kind Regards,
Marina Vardovska
Hexagon Geospatial Support
Staff
Posts: 75
Registered: ‎07-04-2016

Re: Query feature attribute table and update attribute column

If you want to set the range of values from... to..., so you can use Equal operator, like below:

 

2016-08-25 12_17_48-Untitled_1 - ERDAS IMAGINE 2016.png

 

Regards,

Marina

Kind Regards,
Marina Vardovska
Hexagon Geospatial Support
Contributor
Posts: 59
Registered: ‎04-19-2016

Re: Query feature attribute table and update attribute column

Thank you, I will give this a try!

Contributor
Posts: 59
Registered: ‎04-19-2016

Re: Query feature attribute table and update attribute column

Another quick question. 

 

Can the Either/Or operators return a string "Bare" instead of a Value "1" and add that as the class? Or would you suggest another part that changes the values in the table to strings...and if so, how would this be done?

 

Thanks!

Staff
Posts: 75
Registered: ‎07-04-2016

Re: Query feature attribute table and update attribute column

Jens,

 

Either/Or can return the table of strings. This can be done as you see below:

 

2016-09-01 11_16_57-Untitled_1 - ERDAS IMAGINE 2016.png

 

Just make sure that True/Otherwise ports of Either/Or operator consist strings, so there will be no conflict in output table format.

 

Regards,

Marina

Kind Regards,
Marina Vardovska
Hexagon Geospatial Support
Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.