Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 6 down vote favorite
1

I'm currently creating an ArcSDE DB on an SQL Server. It is designed to complete species survey, with information from the field.

In order to help themselves, they asked me to implement a particular yet logical behavior: in a first field Order, they want a list of related taxa. In a second field, a list of Genera (Genus) related to their Order choice. In a third field Species the list related to their Genus choice.

Basically, it is the subtype/domain behavior, but here, the field Genus should be a subtype and a domain at the same time and it's not possible.

So, I thought about implementing this behavior in SQL Server but is it possible? Moreover, will this behavior work directly in ArcMap when working in a editing session on the DB?

Other ideas? Thanks, Merlin

share|improve this question
I think your "gender" field may be genus or genera. I would refer to this as hierarchical fields. – PolyGeo May 16 at 21:45
There is an ArcGIS Idea which relates I think to part of your requirement. Another part of the requirement can be met with Tool Validation but the last part (as I see it) which I don't yet have an idea for is how to enforce the hierarchy during Attribute editing. – PolyGeo May 18 at 5:32

1 Answer

up vote 0 down vote

I don't think there is a really good answer to this but ...

  1. This is an existing ArcGIS Idea that I would encourage you to vote for because it sounds like your question.
  2. Hierarchical field behaviour can be programmed into Geoprocessing tool dialogs using Tool Validation.
  3. There is another ArcGIS Idea (mine) related to this for Validation of Hierarchical Fields.
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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