topic Re: Feature Datasets, SDE, and Spatial References Do Not Match Error in Data Management Questions

Feature Datasets, SDE, and Spatial References Do Not Match Error

TimHayes — Sat, 29 Jun 2013 14:06:27 GMT

I have an SDE Geodatabase running with SQL Server 2008 R2.

I created my Feature Classes, now I have decided it a good idea to include some Feature Datasets to group like Feature Classes into.

1) I created a Feature Dataset, set it's coordinate system to the same of the Feature Classes.

2) I load the Feature Classes into the Feature Dataset and I get the message "Spatial References Do Not Match", none of my data gets loaded. I also tried Copy/Paste, no luck.

Any idea how to resolve this?

Re: Feature Datasets, SDE, and Spatial References Do Not Match Error

JoeBorgione — Mon, 01 Jul 2013 18:45:12 GMT

I have an SDE Geodatabase running with SQL Server 2008 R2.

I created my Feature Classes, now I have decided it a good idea to include some Feature Datasets to group like Feature Classes into.

1) I created a Feature Dataset, set it's coordinate system to the same of the Feature Classes.

2) I load the Feature Classes into the Feature Dataset and I get the message "Spatial References Do Not Match", none of my data gets loaded. I also tried Copy/Paste, no luck.

Any idea how to resolve this?

Are you specifically referencing the feature class using the import button? That's how I prefer to set the coordinate system.

However, I'm not a big fan of feature datasets used as organizational tools, especially in an SDE database, and urge you to reconsider this approach. See this discussion.

Re: Feature Datasets, SDE, and Spatial References Do Not Match Error

GISDev1 — Mon, 01 Jul 2013 20:06:53 GMT

Check the XY Resolution and XY Tolerance. See if they match between the SDE Feature Dataset and the File GDB Feature Class. Just having the same WKID isn't enough in this case. I learned this the hard way a few months ago.

Re: Feature Datasets, SDE, and Spatial References Do Not Match Error

JoeBorgione — Mon, 01 Jul 2013 20:29:24 GMT

Check the XY Resolution and XY Tolerance. See if they match between the SDE Feature Dataset and the File GDB Feature Class. Just having the same WKID isn't enough in this case.

Which is exactly why using the import feature is the way to go...

Re: Feature Datasets, SDE, and Spatial References Do Not Match Error

GISDev1 — Mon, 01 Jul 2013 20:40:28 GMT

Which is exactly why using the import feature is the way to go...

Import Feature from the Right Click menu? That didn't work for me.
I never tried the Toolbox route though, maybe that works?

Edit: Oh, I think you mean when you set the Coord. system of the Feature Dataset in SDE. Good idea. In my case, the Feature Dataset was already existing.

Re: Feature Datasets, SDE, and Spatial References Do Not Match Error

JoeBorgione — Mon, 01 Jul 2013 21:32:22 GMT

Import Feature from the Right Click menu? That didn't work for me.
I never tried the Toolbox route though, maybe that works?

Edit: Oh, I think you mean when you set the Coord. system of the Feature Dataset in SDE. Good idea. In my case, the Feature Dataset was already existing.

Sorry, poor choice of words. Use the import button in the New Feature Dataset dialog. (See attached image.) If you have an existing feature dataset and you are unsure of it's spatial characteristics, you can Export the feature class of your choice from ArcMap to the feature dataset. It will take care of the projection for you.