9

I have an excel file with 2 attribute columns, 1-feature info 2-Number of color (RGB) that the current feature should be symbolize. This file file can be joined with the layer using the "feature info" field which is unique (join by attribute table). So i have as attribute the color number attribute for every polygon feature.

How can i use this this information to symbolize every feature with their attributed color already imported from the excel sheet?

  • This question is similar to the unanswered gis.stackexchange.com/q/37479/115 – PolyGeo Nov 26 '14 at 20:57
  • 1
    I've seen several variations of this question here. To my knowledge there is no way to symbolize a vector layer using pure RGB values. You'd have to first build it into a lyr file, feature template, or cartographic representation, and then use that. And I'm not aware of a way to automatically build/convert any sort of table of values into one of those. See also: gis.stackexchange.com/questions/114850 (no answer). – Chris W Nov 26 '14 at 21:12
  • 1
    You could do it in .net but I'm fairly sure that's the only way. It would be a HUGE UniqueValueRenderer for features or create graphics for each feature using the table colour... it just depends on what you want to do with it. – Michael Stimson Nov 26 '14 at 21:29
  • yes, its a big list already standardized from a previous person, i now need to follow that craziness. – Shefqet LULJA Nov 26 '14 at 21:42
2

As mentioned in comments, I am not aware of any out-of-the-box way for ArcMap to symbolize layers using RGB values stored in an attribute table, or using RGB values in Excel joined onto an attribute table.

However, there is an existing ArcGIS Idea to Set symbol color from RGB values in attribute table so I recommend that you add your vote to that.

Note that the above ArcGIS Idea only covers:

The ability to set the fill colour for a symbol from RGB values stored in the attribute table of a shapefile/feature class.

So if you are wanting to do this for points, polylines or outlines of polygons then you may want to submit additional or more comprehensive ArcGIS Ideas.


Alternatively, if you use ArcGIS Pro, you can use a few lines of ArcPy/Python to calculate a hexadecimal color field from your RGB values and then use attribute driven symbology.

For more details see Using RGB values stored in field of feature class to apply colour component for ArcGIS Pro symbology?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.