GISOBJID for Hexagon EAM

[rami_shah]

Hello experts,

I am integrating GIS with EAM (enterprise asset mgmt). I need to match unique identifier aka GISID. Does Esri have built in option to keep track of new and existing GISID.

1. I want to ensure it is not duplicated

2. group 1 doesn't overlap with group 2 and vice versa

Note: GISID is a field in gis database with long integer type. thanks in advance for your help!

R

[CodyPatterson]

Hey @rami_shah 

If possible, you may have better luck using the GLOBALID instead of the OBJECTID or GISOBJID you're mentioning. The reason is because the OBJECTID at least is a start at 0 and increment by 1 unique value, which will 100% have duplicates between layers. The GLOBALID is a GUID which is a 128 bit text string that is randomized, the chances of duplicates are astronomically low, and with around 200 million features we have not had a duplicate. These would then not overlap as there is such a low chance of one being reused, so this issue would inherently be out of worry.

I would personally use that, but if you're required to use OBJECTID or similar long integer types, then ESRI has safeguards into stopping duplication by using unique keys on a single table, to prevent overlap, you may want to assign ranges, like 1-100000 and 200000-300000 for the IDs for example, so they don't have a chance to overlap, so start at 1 and start at 200000, so on, but the GLOBALID method will solve itself!

Cody