Latest Contributions by Udaya_BhaskerCheerala

Hi All, Anyone found solutions for this? Thanks, Uday ... View more

Hello Vince, Thank you very much for the response. If I do not use spatial types -- GEOMETRY and GEOGRAPHY in my database, is this combination is fine or any other problems may araise? Thanks, Uday ... View more

Dear Vince, Thank you very much for the quick reply. Eventhough SQL Server is 2008, the SDE database Compatibility level is SQL Server 2000(80). And Iam able to edit the feature classes and save to database. Could you please let me know what spatial type support this combination does not support. Thanks, Uday ... View more

The format of the 'file=' file is documented with both 'shp2sde' and 'sde2shp', though it's unlikely the full range of features documented for 10.0 online were available at 9.1. You'll need to look in your local documentation for the features avaliable. Given that you are working with a view, it makes more sense to construct the view that will cause the least trouble at export (including limiting the column names to 10 characters). What does 'sdetable -o describe' report on your view? - V Hi Vince, Finally my problem is solved Iam able to export SDE feature class to shape using -a file option. Thank you very much for your support. Thanks, Uday ... View more

While not supported, the easiest way is to create empty templates of the tables in the current database, use 'sdetable -o create_view' to build the spatial view, and then edit the view definition to point to the other databases. If the table uses GEOMETRY/GEOGRAPHY, then just define the view yourself, and register the result with 'sdelayer -o register'. - V Hi Vince, Thank you very much for the response. Iam doing this task as you suggested (first create view and export it to shape file). Iam able to create view and Iam able to see point feature class in arc catalog. When I try to to export this view(feature class) to shape file Iam getting the following error C:\Documents and Settings\Administrator>sde2shp -o init -l Wells,shape -f E: \Wells.shp -t point -i 5151 -a all -u wysde -p wysde ArcSDE 9.1 SQL Server Build 2101 Thu Mar 3 18:55:48 PST 2005 Layer Features to Shape File Administration Utility ----------------------------------------------------- Truncating column FACILITYNAME to a width of 254 from 255. Unable to create shape attribute table, invalid dBASE column definition. Use "-a file=filename" option to modify the output definition. Shape Attribute Columns: 23 Name Type Width Decimal Places ------------ ---- ----- -------------- PRIORITYTI D 8 - PERMITSTAT C 50 - TOWNSHIP C 3 - TNS_SUFFIX C 1 - RANGE C 3 - RNG_SUFFIX C 1 - SECTION C 10 - QUARTER C 50 - QUARTERQUA C 50 - I did not find syntax help for sde2shp -a file=filename anywhere. Could you please help me how to rectify this error. Note: Spatial view having more than 4lac. records. Thanks, Uday ... View more

Hi Vince, Thank you very much for the reply. As you suggested I would like to go with 'sde2shp' command, combined with 'sdetable -o create_view' option. But how to join tables which are exist in another SQL Server database with the feature class exists in ArcSDE? Thanks, Uday ... View more