10-18-2017 07:17 AM
With the Schema Manager I'm able to create PickLists (via Define PickList..). But how can I apply these picklists to an existing attribute?
Thanks for your hints.
10-27-2017 11:50 AM - edited 04-27-2018 03:23 PM
Here are the steps to add a picklist to a feature class via the ‘Schema Manager’ dialog. These steps assume that you have already created the PickList as per the description in the original post.
03-02-2018 05:51 AM
I've got a question to your description:
If I do all of this, I get a feature class with the picklists added, but without any geometry. Before adding a picklist via the schema remodeler, my feature class does have a geometry (a point). After replacing the existing feature with the one with the picklist, the geometry (point) gets lost. How can I avoid this? At the end, I need a feature (point) with my picklists added.
Or is this not possible with Geomedia? Maybe I just can do this before I set a point to my feature class and not after this.
Thanks for your help.
04-27-2018 03:20 PM
The purpose of Schema Manager is to create schema templates for the creation of the new databases, so it is not designed or intended to add picklists to attributes of existing feature classes that are already populated with features. For existing feature classes it would be better to add a picklist of type GPickLists which can be done using the unsupported 'GeoMedia Picklist Manager' tool. This tool works for a limited set of read-write warehouse types (i.e. Access, Oracle Object Model, and SQL Server). For other read-write warehouses, picklist of type GPickLists can be manually defined.
A knowledge base article with the subject 'How to add a picklist to an attribute for an existing feature class' is available at this link:
This article has the 'GeoMedia Picklist Manager' tool attached and includes a brief description of the limitations and usage of the tool. I've also attached the 'GeoMedia Picklist Manager' tool to this reply. Note that there is no Help available for the tool, but it is fairly intuitive and the linked knowledge base article should help get you started.