topic Re: Exporting globalID and objectID to shp using geoprocessing tools - possible? in Geoprocessing Questions

Exporting globalID and objectID to shp using geoprocessing tools - possible?

yonatanrubinstein — Sun, 10 Apr 2011 12:54:45 GMT

Hello,

I'm trying to export files from SDE to shp(shapefile). When I do it manually (Data>Export data), the globalID (GID) and ObjectID (OID) fields are exported to the shapefile. In contrast, when I use geoprocessing tools (such as Select or CopyFeatures) all fields are exported except the GID and OID.

Is there any way I can use the Geoprocessing tools (and\or Python) to export ALL fields including GID and OID???

(I'm using ArcGIS 9.3.1, and the manual way isn't good enough as I want to export a large amount of layers).

Re: Exporting globalID and objectID to shp using geoprocessing tools - possible?

IdrisPeiren — Tue, 29 Nov 2011 07:18:40 GMT

Hi,

This problem is a known issue for years now and I'm still searching for a solution. I've tried every tool that involves exporting but none of them keeps the Objectid.
Have you been able to fix this problem yet?

Kind regards,

Idris Peiren

Re: Exporting globalID and objectID to shp using geoprocessing tools - possible?

yonatanrubinstein — Tue, 29 Nov 2011 07:37:24 GMT

Hi,

This problem is a known issue for years now and I'm still searching for a solution. I've tried every tool that involves exporting but none of them keeps the Objectid.
Have you been able to fix this problem yet?

Kind regards,

Idris Peiren

Idris,

I did not find a solution - I just put it aside, as there is no solution as far as I know.

Re: Exporting globalID and objectID to shp using geoprocessing tools - possible?

MeghanKulkarni — Thu, 23 Aug 2018 17:56:07 GMT

It's too late to respond reason I'm relatively new to GIS. I have found one workaround.

If we create a new attribute with data type as GUID instead of GlobalID and copy over the same data, it works.

It does not work in earlier case because GlobalID is Unicode Data Type in ArcGIS however in Enterprise GDB, SQL Server, for instance, it does not know to map from Unicode into the string (I guess ArcPy should internally convert GlobalID data type into nvarchar for say). Maybe something to look into with ArcPy's internal mapping code.

I hope this helps,

My Best,

Re: Exporting globalID and objectID to shp using geoprocessing tools - possible?

MeghanKulkarni — Thu, 23 Aug 2018 17:56:40 GMT

It's too late to respond reason I'm relatively new to GIS. I have found one workaround.

If we create a new attribute with data type as GUID instead of GlobalID and copy over the same data, it works.

I hope this helps,

My Best,