I thought this would be relatively simple thing to do, create my own
ObjectID when writing to a feature class, i.e. pass an attribute to the
ObjectID, as long as it is a unique integer (no null values)??

Drew,

There are a couple tricks to this. First you need to ensure the objectid is
registered as a different column than the geometry - older versions of
ArcSDE allow you to use a binary geometry column for double duty. Secondly,
the object id should be a *positive* unique integer; you'll likely also
need a unique constraint of the column (required for Oracle). Note you can
only have one unique constraint when doing the registration of the layer
... so this may mean you can't have a PK until after the layer has been
registered with SDE. The Counter transformer works well for populating the
object id into a physical layer.

Probably don't have to worry about this - but try to make the objectid
values are as consistent as posible between runs. You don't need to sweat
this too much if the value is stored in a table in your database, but the
object id does need to be consistent for the life of the feature in the
layer. This means you shouldn't use something like rownum in a view
definition or materialized view (ArcMap can return inconsistent identify
values).
Cheers
David

I'd be quite careful with this - and would ask why you want it. If the
geodatabase layer is registered "normally" by ArcCatalog the objected
will be linked to a sequence (oracle) or identity table (sql server) so
if you want to supply your own object ids and then you use esri tools to
add more records the object ids generated by esri will be too low unless
you modify the sequence as well.

If you only ever want to apply your own object ids you need to alter the
registration of the table using the sde  command sdetable -o alter_reg
and tell it that it has a user maintained object id. However having done
this you ALWAYS need to supply objectid values which makes things like
editing in ArcMap interesting!

Rob

Rob McPherson | GIS Consultant | esri (UK)

From: fmetalk@googlegroups.com [mailto:fmetalk@googlegroups.com] On
Behalf Of Drew
Sent: 04 May 2012 02:52
To: fmetalk@googlegroups.com
Subject: [fme] ESRI Geodatabase Writing ObjectID

I thought this would be relatively simple thing to do, create my own
ObjectID when writing to a feature class, i.e. pass an attribute to the
ObjectID, as long as it is a unique integer (no null values)??

--
Get all the FME resources you need at http://www.FMEpedia.com
Sign up to attend an FME World Tour event at http://www.safe.com/wt2012

You received this message because you are subscribed to the Google
Groups "FME Talk" group.

To post to this group, send email to fmetalk@googlegroups.com
To unsubscribe from this group, send email to
fmetalk-unsubscribe@googlegroups.com

Click here
<https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
jhVkSLOomriC8CHUl3K9VqbidIdI6snfiskNWyQ1f1p+mg==>  to report this email
as spam.

Disclaimer and Corporate Information This e-mail and any attachments are confidential, may be privileged and are intended solely for the use of the intended recipient/s. If you are not an intended recipient, please (a) notify the sender immediately; and (b) delete the original e-mail and your reply from your system. Unauthorized copying, forwarding, disclosure or usage of this e-mail is prohibited. No liability is accepted for damage caused by the presence of any virus.  The contents of this e-mail are provided "subject to contract". Views or opinions in this e-mail are those of the author and not necessarily those of the company. The company may intercept, copy or monitor e-mails from or to anyone using its facilities in accordance with the law.  ESRI (UK) Ltd, registered in England under company number 01288342. Registered office: Millennium House, 65 Walton Street, Aylesbury, Buckinghamshire HP21 7QG.  Environmental Systems Research Institute Ireland Ltd, registered in Ireland under company number 353903. Registered office: Riverside One, Sir John Rogersons Quay, Dublin 2.

image003.jpg 3K Download