SQL Spatial features in ArcGIS-created Geodatabase

1124
5
09-19-2016 07:17 AM
AdrianaStanciu
New Contributor II

Hello ARCGIS experts,

What table within the ARCMAP-created geodatabase stores attributes like the fill colors of drawn polygons of a feature class?

I am looking to perform a SQL update command  on the feature class table created via ArcMap, and would like to change the color  of some entries based on the update criteria.

Thank you,

Adriana

0 Kudos
5 Replies
NeilAyres
MVP Alum

None.

Geodatabases contain the geometry of the features and its attributes (or meaning, school, police station, traffic pole etc etc).

Things like symbology, which is how you want the feature to be symbolised are maintained and set up inside an ArcMap session. This "look and feel" can be saved to a layer file (*.lyr) and loaded into new or other ArcMap docs so the symbols can be re-used again.

Style sheets can also be set up with each style named the same as your features, then when you apply your custon style, the features can be automagically symbolised.

NeilAyres
MVP Alum

This is basically the difference between a CAD representation of data which contains a lot about how the feature is supposed to look when it is plotted (line thicknesses, line types and so on), as opposed to its meaning, what the actual geometry represents in the real world.

0 Kudos
NeilAyres
MVP Alum

See some of the help docs...what-are-symbols-and-styles

AdrianaStanciu
New Contributor II

Thank you very much for the response Neil.

Can 'Style sheets' be used for dynamic map services?  I published the service as a map  and a feature class. I used the /Mapserver  rest URL in my application, and it updates automatically as polygons are added to the database.

I am wondering if i can implement the style sheets solution, in such a way that i would not have to republish the service after each change.

0 Kudos
NeilAyres
MVP Alum

The service is looking at the underlying mxd (or an image of it in memory somewhere). So, whether you use style sheets or not, the layer inside ArcMap would have to have all the possible types of polygon for instance. Say you had a whole bunch of building footprints, and they were classified into 4 "types" : House, Office, Restaurant; Commercial or something. If you only had actually 3 of these in your layer, they would draw, but there is no restuarant until someones edits and adds one. Then it would appear, without you having to re-publish. And add the extra type of feature into the toc.

If you add some category that is not in the TOC then you wont see it. That's what domains and so forth are about, controlling allowed entries. Then you can set everything up beforehand.