Latest Contributions by JacquelinePursell

The function is acting the same as a view which is a permanent query that runs every time the table is viewed or loaded. I gather data from many non spatial databases in Oracle and SQL Server and plot them and truncate and append my SDE on a regular basis.  Making a query such as this function or a view makes it possible for me to do this quickly and easily. ... View more

I am not asking why it takes forever, I'm asking if there is a better way to interact with a function in ArcGIS because I am not finding it.  The function itself takes only a second or 2 to load.  The issue is making a view out of the function in order for me to interact with it in GIS.  Because the view is made from a function, the view is essentially running the query twice, hence the 12 seconds.  I was able to create a feature class out of the view in ArcCatalog but I cannot view the records until after the feature class is created. Views show up in the table list when I connect in ArcGIS but Functions do not.  I want to know how to use a function in ArcGIS without shoving it through a view and making it extremely slow. ... View more

Thanks! ... View more

Yes I know that.  We have software we are using to collect data but I want to know if ArcMap can even do that.  My users many many times ask me to load ArcMap on their tablets and tell me it's a backup option but I don't even know if it's possible.  That's what I'm asking. ... View more

I want an example too.  I'm giving up and using the GlobalID's because it's too easy but if I had something to go on maybe I could accomplish this. ... View more

If I could create my own unique index that could do multiple offline devices then I would not feel the need to worry about altering a global ID.  I do not have the skills and we don't have the money to hire anyone out for it.  I would be more than fine using a user created ID too but we are shifting towards using more contractors to collect data and relying on random people to stay unique isn't possible.  Using the GlobalID feels like I'm giving up because it's just too easy to use.  At least the scenario I outlined earlier about cold swapping out features is a rare event and it will never be me picking out some random ID, it will always be reusing the old ID to keep the relationships intact.  At least the ESRI GlobalID trigger only occurs upon an insert of a new record and I am just updating a record so there is no conflicts there either. But if you or anyone else has an actual stored procedure built that does what I need, please share it!  Even if it was not for SQL Server, it can be easily modified. ... View more

Yes, I do know that.   This is not for some random day when I want to change the IDs for fun.  This is for when I want to do a cold swap of a feature but keep the attribute table and the relationships intact.  There are so many times in my career when I have had to replace hundreds or thousands of bad shapes for better shapes and because all the databases I've ever encountered had a  straightforward user created ID, I was able to preserve this information and swap them out seamlessly.  The usage of the GlobalID for a relationship worried me on being able to do this, just like if I used the ObjectID. Unfortunately I need to edit offline with this database and there will be 2+ users at a time in the field and some of them contractors. The GlobalID is so easy to use when editing offline because of the random nature and no user prompt but I really did not want to use it.  If I didn't use a Global ID then I would have to create a very intense and complicated stored procedure/trigger that would create the sequential ID I want offline.  I don't have the skills for that and we don't have enough money for it either to send it out. I'm not sure what kind of "warranty" you are implying...  If the GlobalID was untouched and it made a hideous error and destroyed all the data in my database, do you really think ESRI would guarantee to restore it?  no, I don't think so.  I'm not altering their stored procedures. Also, in ESRI's own help documents is all kinds of backend manipulation of the GlobalID:   Inserting a value into a global ID or GUID column in SQL Server using SQL—Help | ArcGIS for Desktop  and... Next_GlobalID—Help | ArcGIS for Desktop  ... View more

My database guy got me access to a sandbox I can play in.  I created a feature class and added a globalID on it and then I ran a very simple update statement to the globalID in SQL Server Management Studio.  Voila!  As long as the GlobalID isn't NULL you can change it to any ID you want!  Even the one you used to have in the database like the old feature!  I swapped these all around a few times with no issue! UPDATE Parent SET GLOBALID='DE00A00E-A060-0AC4-B555-2DE5B6AF04D4' WHERE OBJECTID=2; So even though the front end of ArcGIS is extremely prohibitive and makes the GUID/UUID looks scary, you can easily manipulate this value.  ... View more

Very interesting...  That makes sense that it should be a GlobalID but it's just like an OID in that you can't overwrite it or preserve it if you needed to swap out the feature itself. ... View more

I am running into a design issue with a database we will be using for offline editing.  Contractors want to use a GlobalID and I have put my foot down on not using it.   However, after in-depth discussions with my database guys, to create an auto-generated and sequential sequence to use as an ID, it could take forever with all the loops on all the related tables to insert it in and a beast to write.  Plus with it being offline, we aren't sure if the stored procedures gets copied over as well and then with 2 or more people collecting data, we will have ID conflicts.  If we would always be online editing, I would have no issues with triggers and stored procedures but offline ESRI tends to take the reins and I'm not sure how it will handle it. I would love to never use the GlobalID as the relationship key but how can I achieve the custom ID offline without conflicts?   ... View more

I don't want to make a python script.  That's not what I want to do here in this situation at this time.  I only have a few editors and the posting is rare so I have no problems doing it manually right now. And yes it does forget the version I pointed to and quite often.  It has happened to me my entire career with using ESRI (10 years plus school) and also currently on 10.2.2.  For every single person, ESRI has randomly forgotten the settings on everything from connection files pointing to a version to their normal.mxt reverting back to default randomly.  My published map services also once in a blue moon like to decide they don't like the query on attributes that have not changed or that a layer that has not been touched sometimes will be a broken link.  These don't happen often, but it happens.  No one goes in there and touches any of these things I mention.  And it has nothing to do with our environment because it has happened everywhere I have ever worked and in all kinds of set ups.  It's a fact of life.  Digital files age, I get it.  I am only trying to see if there is a way I can make my editor's lives easier so they don't have to triple check everything is sourced right.  But I guess not. ... View more