AnsweredAssumed Answered

how to reproject (or copy) a spatial view

Question asked by tedrakel on Jun 6, 2013
Latest reply on Jun 10, 2013 by mdenil
I need to reproject data from sde into a file geodatabase.  I use the arc toolbox 'data management tools'->'projections and transformations'->'project' tool to reproject the feature classes and that works fine.  There are some spatial views in sde that I need to get into the file geodatabase.  I was told to use the same toolbox tool to reproject the spatial views.  Whenever I run the 'project' tool on a spatial view, I get an the following error messages.  The 'row with this OID already exists' message seems important.

I'm wondering if I really do need to use the 'project' tool to reproject the spatial view in the first place.  The feature class that the spatial view makes use of has already been reprojected, so maybe I should use a different tool from arc toolbox to move the spatial view into the file geodatabase.

Does anyone have any ideas on how to best get a spatial view from sde into a file geodatabase?


Here's the error message I get from trying to reproject a  spatial view:

Messages
Executing: Project "Database Connections\Connection to orcs.apollo namcis.sde\NAMCIS.SV_115KV_LINES" "C:\ArcFM\Sample Data\svTest.gdb\svTarget" PROJCS['WGS_1984_Web_Mercator_Auxiliary_Sphere',GEOGCS['GCS_WGS_1984',DATUM['D_WGS_1984',SPHEROID['WGS_1984',6378137.0,298.257223563]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Mercator_Auxiliary_Sphere'],PARAMETER['False_Easting',0.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',0.0],PARAMETER['Standard_Parallel_1',0.0],PARAMETER['Auxiliary_Sphere_Type',0.0],UNIT['Meter',1.0]] WGS_1984_(ITRF00)_To_NAD_1983 PROJCS['Hydro One Lambert Conformal Conic',GEOGCS['GCS_North_American_1983',DATUM['D_North_American_1983',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Lambert_Conformal_Conic'],PARAMETER['False_Easting',930000.0],PARAMETER['False_Northing',6430000.0],PARAMETER['Central_Meridian',-85.0],PARAMETER['Standard_Parallel_1',44.5],PARAMETER['Standard_Parallel_2',53.5],PARAMETER['Scale_Factor',1.0],PARAMETER['Latitude_Of_Origin',0.0],UNIT['Meter',1.0]]
Start Time: Thu Jun 06 16:05:40 2013
ERROR 000210: Cannot create output C:\ArcFM\Sample Data\svTest.gdb\svTarget
A row with this OID already exists.
Failed to execute (Project).
Failed at Thu Jun 06 16:05:48 2013 (Elapsed Time: 8.00 seconds)

Outcomes