topic Re: Forming a field of type geometry in Geodatabase in ArcGIS API for Silverlight Questions

Forming a field of type geometry in Geodatabase

Anonymous User — Fri, 06 Dec 2013 08:06:11 GMT

Original User: aviabunin

Dear Gurus !
There is a table events with fields X, Y - containing the coordinates of points, which must be registered in the geodatabase. Created geodatabase cuks_gdb with standard tools of arcgis desktop 10.1. Table events copied in geodatabase :

select * into cuks_gdb.sde.events from cuks.dbo.events

3 . In the cloned table added field "shp" type geometry.

4 . Formed a field value by field values �??�??x, y:

update cuks_gdb.sde.events set Shp = geometry :: STGeomFromText ('Point (' + ltrim (STR (x, 99, 11 )) + '' + ltrim (STR (y, 99, 11) ) + ')' , 28406 );

All formed , error messages were not. But when I try to save changes in any field then I get an error message

The parameter type cuks_gdb.sys.geometry is invalid. Parameter name: value

How to fix ?

Re: Forming a field of type geometry in Geodatabase

Anonymous User — Sat, 07 Dec 2013 14:24:17 GMT

Original User: aviabunin

Any ideas?
1. Is there are any tool to form geometry field from x,y - fields?
2. Is there are any other way to form needed table in geodatabase from x,y-table in sql server?
3. The initial problem is , that service on the table with ObjectID and Shape fields not worked - data not saved in the example with EditorWidget. Only delete operation work well, and normally executes update operation , when I test feature service in arcgis,com.
4. Can I update and add features in geodatabase from arcgis desktop 10.1 and how I can do this?

Thanks in advance!

Re: Forming a field of type geometry in Geodatabase

AnatoliiTerentiev — Mon, 09 Dec 2013 09:50:58 GMT

Э�?о баг:
https://connect.microsoft.com/SQLServer/feedback/details/375067/ssms-edit-top-200-rows-fails-if-table-contains-geometry-or-geography-columns

Re: Forming a field of type geometry in Geodatabase

Anonymous User — Tue, 10 Dec 2013 06:33:46 GMT

Original User: dbroux

That doesn't seem to be a Silverlight question.

Concerning ArcGIS server you can look at Make XY event layer tool. But it's more likely a Microsoft SQL question.