Latest Contributions by MikeSweetman

Hi My environment started out using version 10.0 but is now using 10.3. I've written an oracle PL/SQL package that interrogates the SDE schema to create a trigger that will determine when a feature in a versioned/or non versioned feature class is being deleted, and copy it to an other feature class. This way, we can see current, and deleted features. In my instance I am working with a versioned feature class, and so the trigger sits on the Dnnn table and determine if the Dnnn record being added means the feature is being deleted (it could be being superceded by a Annn row(. Due the the implementation we have I need to copy records in Annn, Fmmm and Smmm and place them in FC_DELETED, Fppp and Sppp. Everything looks ok, but, when I use arcMap features created this way are not displayed; only when I select them does their position get revealed. As far as I can tell the spatial index is fine. I think the problem I have is that there is a table in the SDE schema that I have not appended a record to to indicate that my newly created FC_DELETED feature exists in the current timeline (not the right word but the right concept). I have found that directly creating features in FC_DELETED via ArcMap does work. For now, I am going to try and perform regular feature creations andd see where records in SDE appear, and try and deduce the issue from there. Any help really appreciated ... View more

I have a funny - if I create a feature class via import XML workspace document the alias is just the feature class name eg COUNTY, but if I create it using arcpy.CreateFeatureclass_management the alias is schema name '.' feature class name eg GISLOADER.COUNTY. I have not found a means to set the alias when the feature class is created, and as much as I read that 10.1 will have arcpy.AlterAliasName I'm at 10.0. Any pointers in sorting this out, using ArcCatalog or arcpy ? cheers Mike ... View more

I have a model, and am supplied with data for that model. The model contains relationship classes based on numeric ID and FK_ID fields. I have a requirement to convert all the primary key ID fields to GLOBALID fields. I initially misunderstood the requirement and created fields called GLOBALID and FK_ID_GLOBALID that were GUIDs, as this was all I saw in the drop down on ArcCatalog. I had something that was great, but it required the application developed on top of this data to get and set the GLOBALID field when a new row was added. What was actually wanted was the GLOBALID fields to get their own GUID value automatically. With GLOBALIDs the generation of the fields value is performed automatically. Now, my problem. From what I've read I need to use AddGlobalIDs_management to create and set the GLOBALID field/values. I then believed I needed to create my FK_ID_GLOBALID foreign key fields as GUIDs, and with some coding rework the data so the FK_ID_GLOBALID value was using the correct GLOBALID value. When I then tried to create a relationship class between two feature classes I received the error     arcpy.CreateRelationshipClass_management(                                              sdeFilePath + "PARENT",                                              sdeFilePath + "CHILD",                                                                sdeFilePath + "DATASET_A\PARENT_TO_CHILD",                                              "SIMPLE",                                              "PARENT_TO_CHILD",                                              "CHILD_TO_PARENT",                                              "NONE",                                              "ONE_TO_ONE",                                               "NONE",                                              "GLOBALID",                                               "PARENT_ID_GLOBALID" ) Error Info: <class 'arcgisscripting.ExecuteError'>: Failed to execute. Parameters are not valid. ERROR 000800: The value is not a member of GLOBALID. Failed to execute (CreateRelationshipClass). GP ERRORS: Failed to execute. Parameters are not valid. ERROR 000800: The value is not a member of GLOBALID. Failed to execute (CreateRelationshipClass). ##End## This worked fine when all fields were GUIDs. This would have me believe that I need to create the foreign key fields as GLOBALIDs too, but the AddGlobalIDs_management routine only creates a GLOBALID field, and would not create fields with names I want, for use in a relationship class. Where have I gone wrong ? Thanks ... View more