I have to transformate data and change the coordinate system but have troubles to set it correct programmatically.
I have: ArcGIS 10.2 / MS SQL-Server 10.0.5520 / sde 10.2.2
My steps:
1) Some feature classes are stored in a dataset. Everything looks correct. When I look to SDE_layers the srid is 13 which links to auth_srid 21781.
2) I drag and drop all feature classes out of the dataset. Everything looks correct also in SDE.
3) I do transform data with FME. The situation in SDE is still the same. Setting the projection in FME with EsriReprojector does not change anything.
4) I create a new dataset with the new Projection System (2056) and the same resolution and tolerance like the original data.
5) I use the geoprocessing-tool set_projection (DefineProjection_management) and set the projection in batch-mode to 2056. I also set the environment parameter (precision, ...) correct. Now the situation looks confusing. In ArcCatalog looks all fine. Every layer has the correct projection (2056). When I look into the database (MS_SQL) then I see that I have a new spatial_reference with srid 14. But in the table SDE_layers there are confusing data in it. 4 of 6 layers are linking still to srid 3. When I look into SDE_spatial_references then I see that that srtext changed correct but auth_srid is still the old value and also the tolerance are default and not mine. One empty layer is linking to srid 13 like in the original-data and one layer (also empty) is linking to the correct srid 14.
6) I move (drag and drop) all layers into a dataset with the new projection. I assume that all layers should have the same srid in the same dataset. But with the move into the dataset nothing has changed.
I bet, there is a better way for my workflow. But anyway - I think the SDE does not make the correct logic. Does anyone had similar problems?
What is the best way to set the projection correct in a dataset. I cannot use the build-in transformation because I do a special transformation on the data.
أكثر...
I have: ArcGIS 10.2 / MS SQL-Server 10.0.5520 / sde 10.2.2
My steps:
1) Some feature classes are stored in a dataset. Everything looks correct. When I look to SDE_layers the srid is 13 which links to auth_srid 21781.
2) I drag and drop all feature classes out of the dataset. Everything looks correct also in SDE.
3) I do transform data with FME. The situation in SDE is still the same. Setting the projection in FME with EsriReprojector does not change anything.
4) I create a new dataset with the new Projection System (2056) and the same resolution and tolerance like the original data.
5) I use the geoprocessing-tool set_projection (DefineProjection_management) and set the projection in batch-mode to 2056. I also set the environment parameter (precision, ...) correct. Now the situation looks confusing. In ArcCatalog looks all fine. Every layer has the correct projection (2056). When I look into the database (MS_SQL) then I see that I have a new spatial_reference with srid 14. But in the table SDE_layers there are confusing data in it. 4 of 6 layers are linking still to srid 3. When I look into SDE_spatial_references then I see that that srtext changed correct but auth_srid is still the old value and also the tolerance are default and not mine. One empty layer is linking to srid 13 like in the original-data and one layer (also empty) is linking to the correct srid 14.
6) I move (drag and drop) all layers into a dataset with the new projection. I assume that all layers should have the same srid in the same dataset. But with the move into the dataset nothing has changed.
I bet, there is a better way for my workflow. But anyway - I think the SDE does not make the correct logic. Does anyone had similar problems?
What is the best way to set the projection correct in a dataset. I cannot use the build-in transformation because I do a special transformation on the data.
أكثر...