Using Python 2.7.8, I'm trying to use the default field mappings for all fields except for 2 (PIC_ID and Object ID). The two tables are essentially identical, the tinkering with the globalid is something I have to do in order to preserve the globalid part of an attachment relationship when syncing an AGOL feature service to an on-premise SDE, and not something I'm looking to change. The below snippet works when I'm just altering one field out of the mapping: target_layer = "C:/blah blah blah.sde/blah.DBO.blah" append_layer = renamefgdb + '\yada_yada_yada' fieldmappings = arcpy . FieldMappings ( ) fieldmappings . addTable ( target_layer ) fieldmappings . addTable ( append_layer ) field_to_map_index = fieldmappings . findFieldMapIndex ( "globalid" ) field_to_map = fieldmappings . getFieldMap ( field_to_map_index ) field_to_map . addInputField ( append_layer , "PIC_ID" ) fieldmappings . replaceFieldMap ( field_to_map_index , field_to_map ) arcpy . Append_management ( append_layer , target_layer , "NO_TEST" , fieldmappings , "" ) However I have an operational requirement to maintain the objectid during append: that is, the objectID's coming from the append source need to be the same when they go to the target layer. But when I do something like this, or many many many variations thereof, it fails. target_layer = "C:/blah blah blah.sde/blah.DBO.blah" append_layer = renamefgdb + '\yada_yada_yada' fieldmappings = arcpy . FieldMappings ( ) fieldmappings . addTable ( target_layer ) fieldmappings . addTable ( append_layer ) field_to_map_index = fieldmappings . findFieldMapIndex ( "globalid" ) field_to_map_index = fieldmappings . findFieldMapIndex ( "objectid" ) field_to_map = fieldmappings . getFieldMap ( field_to_map_index ) field_to_map . addInputField ( append_layer , "PIC_ID" ) field_to_map . addInputField ( append_layer , "OBJECTID" ) fieldmappings . replaceFieldMap ( field_to_map_index , field_to_map ) So is it possible to add ObjectID to a field mapping in python, and if so, how?

Instead of sidetracking the original discussion anymore, it might be worth spawning a new question using your last reply.

Original Content Removed Off topic discussion continued in new thread... https://community.esri.com/message/703697-query-max-objectid-from-base-and-adds-tables

Joshua Bixby you are correct, it returns the next ObjectID. You would therefore need to subtract 1 in order to get the last returned ObjectID. This returns the largest OID that has ever been used in the table. However, it doesn't guarantee that the OID is still present or has ever been used. If you want the largest currently in use, then simply sort your table by ObjectID. SELECT OBJECTID FROM owner . mytable ORDER BY OBJECTID DESC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY ;

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is it possible to append ObjectID using fieldmappings?

ThomasColson

Using Python 2.7.8, I'm trying to use the default field mappings for all fields except for 2 (PIC_ID and Object ID). The two tables are essentially identical, the tinkering with the globalid is something I have to do in order to preserve the globalid part of an attachment relationship when syncing an AGOL feature service to an on-premise SDE, and not something I'm looking to change. The below snippet works when I'm just altering one field out of the mapping:

target_layer <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:/blah blah blah.sde/blah.DBO.blah"</SPAN>
 append_layer <SPAN class="operator token">=</SPAN> renamefgdb<SPAN class="operator token">+</SPAN><SPAN class="string token">'\yada_yada_yada'</SPAN>
 fieldmappings <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FieldMappings<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
 
 fieldmappings<SPAN class="punctuation token">.</SPAN>addTable<SPAN class="punctuation token">(</SPAN>target_layer<SPAN class="punctuation token">)</SPAN>
 fieldmappings<SPAN class="punctuation token">.</SPAN>addTable<SPAN class="punctuation token">(</SPAN>append_layer<SPAN class="punctuation token">)</SPAN>
 
 field_to_map_index <SPAN class="operator token">=</SPAN> fieldmappings<SPAN class="punctuation token">.</SPAN>findFieldMapIndex<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"globalid"</SPAN><SPAN class="punctuation token">)</SPAN>
 
 field_to_map <SPAN class="operator token">=</SPAN> fieldmappings<SPAN class="punctuation token">.</SPAN>getFieldMap<SPAN class="punctuation token">(</SPAN>field_to_map_index<SPAN class="punctuation token">)</SPAN>
field_to_map<SPAN class="punctuation token">.</SPAN>addInputField<SPAN class="punctuation token">(</SPAN>append_layer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PIC_ID"</SPAN><SPAN class="punctuation token">)</SPAN>
 
 fieldmappings<SPAN class="punctuation token">.</SPAN>replaceFieldMap<SPAN class="punctuation token">(</SPAN>field_to_map_index<SPAN class="punctuation token">,</SPAN> field_to_map<SPAN class="punctuation token">)</SPAN>
 
 arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN>append_layer<SPAN class="punctuation token">,</SPAN> target_layer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_TEST"</SPAN><SPAN class="punctuation token">,</SPAN> fieldmappings<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

However I have an operational requirement to maintain the objectid during append: that is, the objectID's coming from the append source need to be the same when they go to the target layer.

But when I do something like this, or many many many variations thereof, it fails.

target_layer <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:/blah blah blah.sde/blah.DBO.blah"</SPAN>
 append_layer <SPAN class="operator token">=</SPAN> renamefgdb<SPAN class="operator token">+</SPAN><SPAN class="string token">'\yada_yada_yada'</SPAN>
 fieldmappings <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FieldMappings<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
 
 fieldmappings<SPAN class="punctuation token">.</SPAN>addTable<SPAN class="punctuation token">(</SPAN>target_layer<SPAN class="punctuation token">)</SPAN>
 fieldmappings<SPAN class="punctuation token">.</SPAN>addTable<SPAN class="punctuation token">(</SPAN>append_layer<SPAN class="punctuation token">)</SPAN>
 
 field_to_map_index <SPAN class="operator token">=</SPAN> fieldmappings<SPAN class="punctuation token">.</SPAN>findFieldMapIndex<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"globalid"</SPAN><SPAN class="punctuation token">)</SPAN>
 field_to_map_index <SPAN class="operator token">=</SPAN> fieldmappings<SPAN class="punctuation token">.</SPAN>findFieldMapIndex<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"objectid"</SPAN><SPAN class="punctuation token">)</SPAN>
 
 field_to_map <SPAN class="operator token">=</SPAN> fieldmappings<SPAN class="punctuation token">.</SPAN>getFieldMap<SPAN class="punctuation token">(</SPAN>field_to_map_index<SPAN class="punctuation token">)</SPAN>
field_to_map<SPAN class="punctuation token">.</SPAN>addInputField<SPAN class="punctuation token">(</SPAN>append_layer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PIC_ID"</SPAN><SPAN class="punctuation token">)</SPAN>
 field_to_map<SPAN class="punctuation token">.</SPAN>addInputField<SPAN class="punctuation token">(</SPAN>append_layer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">)</SPAN>
 
 fieldmappings<SPAN class="punctuation token">.</SPAN>replaceFieldMap<SPAN class="punctuation token">(</SPAN>field_to_map_index<SPAN class="punctuation token">,</SPAN> field_to_map<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

So is it possible to add ObjectID to a field mapping in python, and if so, how?

Find more posts tagged with

Accepted answers

All comments

JoshuaBixby

I guess it depends on what blake.terhune‌ means by "current RowID." Doesn't the base_id field in the SQL above represent the next value that will be returned by calling next_rowid? At least that is how it works when I test it on my system. Although last_id seems temping to use, the fact is that the last ID issued might not be the highest objectID in use since records can be deleted.

Blake, why do you want "current RowID"? Or, are you after the highest/largest ObjectID in use?

DavidBlanchard

There's no simple stored procedure to call. But essentially, the last OID is stored in a lookup table that uses the tables registration id (e.g. data_owner.i10). The following code can be used in SQL Server with SDE 10.4 to retrieve the last ObjectID:

<SPAN class="keyword token">DECLARE</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="variable token">@owner</SPAN> nvarchar<SPAN class="punctuation token">(</SPAN><SPAN class="number token">128</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'data_owner'</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="variable token">@table</SPAN> nvarchar<SPAN class="punctuation token">(</SPAN><SPAN class="number token">128</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'MyTable'</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">DECLARE</SPAN> <SPAN class="variable token">@regid</SPAN> <SPAN class="keyword token">int</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">SELECT</SPAN> <SPAN class="variable token">@regid</SPAN> <SPAN class="operator token">=</SPAN> registration_id
<SPAN class="keyword token">FROM</SPAN> sde<SPAN class="punctuation token">.</SPAN>SDE_table_registry
<SPAN class="keyword token">WHERE</SPAN> owner <SPAN class="operator token">=</SPAN> <SPAN class="variable token">@owner</SPAN> <SPAN class="operator token">AND</SPAN> table_name <SPAN class="operator token">=</SPAN> <SPAN class="variable token">@table</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">DECLARE</SPAN> <SPAN class="variable token">@sql</SPAN> nvarchar<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1024</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">SET</SPAN> <SPAN class="variable token">@sql</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SELECT base_id FROM '</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="variable token">@owner</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'.i'</SPAN> <SPAN class="operator token">+</SPAN>cast <SPAN class="punctuation token">(</SPAN><SPAN class="variable token">@regid</SPAN> <SPAN class="keyword token">AS</SPAN> <SPAN class="keyword token">VARCHAR</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">' WHERE id_type = 2'</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">EXECUTE</SPAN> sp_executesql <SPAN class="variable token">@sql</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

blake.terhune

Sorry to go off topic, but is there a way to get the current RowID without incrementing it by calling Next_RowID? Like calling CURRVAL instead of NEXTVAL?

DavidBlanchard

As the OBJECTID field is used by ArcGIS as an internal unique primary key field, it is protected from manual editing and is instead automatically assigned by internal processes within ArcGIS (see What is an ObjectID?—Help | ArcGIS Desktop).

This field is meant to be unique within the table in question, and copying the OID across tables would make it possible for duplicates to exist. Therefore, this isn't possible.

Even when editing directly within a database engine (outside ArcGIS), one must use the correct procedures to generate unique OIDs (see Next_RowID—Help | ArcGIS Desktop ).

ThomasColson

Per this, https://community.esri.com/thread/185431-append-tool-and-field-mapping-help-examples?q=field%20mapping , I tried this:

target_layer <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:/blah blah blah.sde/blah.DBO.blah"</SPAN>
 append_layer <SPAN class="operator token">=</SPAN> renamefgdb<SPAN class="operator token">+</SPAN><SPAN class="string token">'\yada_yada_yada'</SPAN>
 fieldmappings <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FieldMappings<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
 
 fieldmappings<SPAN class="punctuation token">.</SPAN>addTable<SPAN class="punctuation token">(</SPAN>target_layer<SPAN class="punctuation token">)</SPAN>
 fieldmappings<SPAN class="punctuation token">.</SPAN>addTable<SPAN class="punctuation token">(</SPAN>append_layer<SPAN class="punctuation token">)</SPAN>
 list_of_fields_we_will_map <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
 list_of_fields_we_will_map<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'PIC_ID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'globalid'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
 list_of_fields_we_will_map<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'objectid'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'objectid'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="keyword token">for</SPAN> field_map <SPAN class="keyword token">in</SPAN> list_of_fields_we_will_map<SPAN class="punctuation token">:</SPAN>
 field_to_map_index <SPAN class="operator token">=</SPAN> fieldmappings<SPAN class="punctuation token">.</SPAN>findFieldMapIndex<SPAN class="punctuation token">(</SPAN>field_map<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> 
 field_to_map <SPAN class="operator token">=</SPAN> fieldmappings<SPAN class="punctuation token">.</SPAN>getFieldMap<SPAN class="punctuation token">(</SPAN>field_to_map_index<SPAN class="punctuation token">)</SPAN>
 field_to_map<SPAN class="punctuation token">.</SPAN>addInputField<SPAN class="punctuation token">(</SPAN>append_layer<SPAN class="punctuation token">,</SPAN> field_map<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
 fieldmappings<SPAN class="punctuation token">.</SPAN>replaceFieldMap<SPAN class="punctuation token">(</SPAN>field_to_map_index<SPAN class="punctuation token">,</SPAN> field_to_map<SPAN class="punctuation token">)</SPAN>
 
 <SPAN class="comment token">#field_to_map_index = fieldmappings.findFieldMapIndex("globalid")</SPAN>
 <SPAN class="comment token">#field_to_map = fieldmappings.getFieldMap(field_to_map_index)</SPAN>
 <SPAN class="comment token">#field_to_map.addInputField(append_layer, "PIC_ID")</SPAN>
 
 
 arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN>append_layer<SPAN class="punctuation token">,</SPAN> target_layer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_TEST"</SPAN><SPAN class="punctuation token">,</SPAN> fieldmappings<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

and it fails with

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 File <SPAN class="string token">"C:/PRODUCTION/GRSM_VEG_AA_SRV_LOAD/ARCHIVE_AA_S123_TEST.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">67</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
 field_to_map <SPAN class="operator token">=</SPAN> fieldmappings<SPAN class="punctuation token">.</SPAN>getFieldMap<SPAN class="punctuation token">(</SPAN>field_to_map_index<SPAN class="punctuation token">)</SPAN>
 File <SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\arcobjects\arcobjects.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">328</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> getFieldMap
 <SPAN class="keyword token">return</SPAN> convertArcObjectToPythonObject<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">.</SPAN>_arc_object<SPAN class="punctuation token">.</SPAN>GetFieldMap<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN>gp_fixargs<SPAN class="punctuation token">(</SPAN>args<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
RuntimeError<SPAN class="punctuation token">:</SPAN> FieldMappings<SPAN class="punctuation token">:</SPAN> Error <SPAN class="keyword token">in</SPAN> getting field map <SPAN class="keyword token">from</SPAN> field mapping <SPAN class="keyword token">for</SPAN> GetFieldMap<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I've already worked around the globalid's changing....my destination table has a field called "globalid", but it is not a "globalid" field, so the source globalid writes nicely into it, and doesn't change. "GIS_ID" is defined as the "globalid" in the destination schema.

Really need to get the source OID to write into the destination OID without changing.....

RebeccaStrauch__GISP

I'm working on a really similar issues right now, so will be interested to hear other's thoughts too. I am using other GP tools, but the results are similar.

Just FYI - Once thing I discovered is that GlobalIDs will not copy/join, and of course ObjectIDs can change.

What I recommend is old-school...create a new uniqueID field and populate is with the ObjectID. The new and ObjectID field will most likely get out of sync fairly fast, but at least you have a static ID.

What I am testing is trying to get a trigger/notification is the global or ObjectID changes do to a polygon splitting etc. I just started testing so still working on it.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.