We are in the process of cleaning up our asset database which contains day 20 of layers generally in file geodatabase format and includes point, line and polygon types and some non spatial tables.
Is there a method or data format to create a unique integer ID for each record across all the layers? Ideally it would auto populate when entering new records to avoid gaps or duplication. A method that can be accessed by multiple software types would be advantageous. I am locked into ESRI software, but personally am more comfortable with QGIS. It would also be advantageous for the data to be created in AutoCAD and Microsoft Excel.
The purpose of the ID is to allow interaction with other closed database systems used by my employer, and to allow for including attribute connectivity in the layers (eg upstream and downstream manholes ID on sewer main).
I was planning to adopt a strategy of giving each layer a number and then each record a decimal manually (eg 19.00007) but thought this could be limiting and prone to error