Monday, March 7, 2011

ArcSDE error: Cannot insert duplicate key row in object

I am at my wits' end on this error message.

-I am trying to update a ‘NAME’ field in ‘CONTENT_POINTS’ SDE Feature Class

-I’ve used Attribute Creator to create a fme_db_operation = UPDATE

-Update Key Fields in Feature Type Properties>Parameters is set to NAME

-ArcSDE Mode Of Operation is UPDATE

Error:

Error while executing stream update operation for table 'PROFILING.CONTENT_POINTS'.:SDE_ERROR_CODE(-51) Underlying DBMS error. SDE_EXT_ERROR(2601) SDE_ERROR_MSG1(Microsoft SQL Native Client: Cannot insert duplicate key row in object 'PROFILING.CONTENT_POINTS' with unique index 'CID'.) SDE_EXT_ERROR_MSG2()

If I understand this correctly it is saying that I am trying to insert a duplicate key row in the CONTENT_POINTS featureclass.

‘CID’ is the unique ID

I am trying to update, not insert, and so of course there will be the same ‘CID’ because that is the unique ID I am using to update the NAME field with the new NAME form the source file.

I have tried what feels like a million different things to do what should be simple, something I have done many times before.

Any suggestions or help would be greatly appreciated.

Thanks

Sunday, March 7, 2010

Spatial Views and SDE - Versioning

Recently, I've been looking into versioning an SDE database. The issue I have is that in my workflow, I need to have spatial views. In the past, we have been told from ESRI that spatial views will not work with a versioned database.

It seems that the real truth to this matter is that spatial views WILL work with a versioned database BUT the spatial view will only read the base tables (not the delta tables that have not been reconciled with the database).

I think this will work for my needs. Once I have implemented a workflow that works, I will be happy to share the details of my experience.

I also recently attended an ESRI training on Multiuser Geodatabases. I wish the course had more information on versioning because this is the next project that I'm excited about. I think there is another Multiuser Geodatabase course offered that goes into more detail about versioning. I'm looking forward to the upcoming challenges.

If you have successfully implemented a versioned database with spatial views, please contact me!

Tuesday, July 28, 2009

GIS Careers

I just came back from doing a delightful presentation on GIS and Careers, what to watch for, how to develop a career, etc. to an enthusiatic group of interns. I've uploaded the presentation below so be sure to take a look at it. It has a lot of information that would be useful for both new GIS professionals and for those that have been in the field for longer.

Wednesday, July 22, 2009

Career Development - GIS

I was asked to do a presentation on GIS and careers, etc. for a group of interns. Having never done this type of a presentation before, I wanted to make sure not to bore them to death and to include content that would allow them to know what's happening in the industry. I've decided to focus more on the GIS industry, who to follow, what to read and how to keep skills updated instead of "how to find a job" or "what's required in a GIS job".

I look forward to posting how this disucssion goes. I've compiled a list of slides that I'll post next week after the presentation.

Friday, July 10, 2009

I'm still here - slowly down for the summer

The summer months have triggered my extreme laziness. I will try to keep updating as regularly as possible but I hope to get back into full force in September.

Thanks for dropping by!

Saturday, May 30, 2009

ESRI Spatial Statistics - Six tests to perform on OLS results

I've been quite busy lately - so I haven't had time to post. I hope that this review of spatial statistics will make up for my recent absenteeism!

Earlier this week, I attended a Spatial Statistics seminar hosted by ESRI. What I expected to be a veiled attempt to get users to buy more ESRI extensions was really a review of functions already readily available in ArcView. I was pleasantly surprised and felt that the seminar was worthwhile.

Dr. Lauren Scott was the speaker. She works for ESRI Redlands and has a passion for spatial statistics. It's always refreshing to hear a speaker who has a passion for what she does.

The core spatial tools that were presented were the standard deviation ellipse, hot spot analysis and regression. Most of the seminar focused on spatial regression including ordinary least square (OLS) and geographical weighted regression.

Dr. Scott went over the six quick tests to perform to know if your OLS model is complete; that is, if the model is explaining the dependant variable in the most effective way possible. Once you perform OLS on a variable, these are the six things to examine.

a) coefficients have the correct sign. If the relationship between the explanatory variable and the dependant variable is positive, the coefficient for that explanatory variable should be positive in the final results table. If it is not, the results should be checked.

b) all variables are statistically significant (both probability and robust probability). If the variables are not statistically significant, they should be removed from the analysis because they are not working to explain the dependant variable. The Koenker (BP) test should be significant - this will mean that geographically weighted regression can be performed on the data.

c) the VIF should be below 7.5. If VIF is above 7.5, this means that some of the explanatory variables are redundant and there could be variables that are being double counted in the analysis. The lower the VIF, the better.

d) the adjusted R2 should be high (the closer to one the better), the AIC should be low (the AIC allows multiple models that have the same dependent variable to be compared to one another - if you have two models that for the same dependent variable, the one with the lower AIC is the better model).

e) Jarques-Bera test should NOT be statistically significant. If this value is statistically significant, you are missing an explanatory variable in the analysis.

f) the residuals from the regression should have a random distribution. The more clustered these variables, the poorer the model. Clustered residuals point to explanatory variables that are missing in the analysis.

Wednesday, May 27, 2009

ESRI Spatial Statistic (Toronto)

Lauren from Redland ESRI has done a great job today by providing easy to understand presentation with the hardest thing to explain in the world. Highly recommend to view the spatial statistic tool that they implement for 9.3 (ArcGIS 9.3 Online help)

GIS can widely use by other field such as Crime (Pocket Men Analysis - to see the pattern of the criminal and provide general area where they will commit the crime), and Health(Try to find out the pattern of disease that spread in the study area) and much more other fields that I would like to explore to. Demonstration in the presentation has open my mind to others in the GIS field how they use the tool smartly :) Can't wait to view the presentation video again!