arcgis-servermap-servicemsd
I'm trying to publish a map service using simple xy data from a table in SDE; however, whenever I try to create the MSD, I'm told "no can do" by ArcMap.
I would like to be able to simply add xy coordinates in SQL and have them update in real-time in the map service.
I've experimented with model builder, but nothing's worked yet.
Any advice?
try exporting the event layer formed by add XY process to shape file it will work
You need to have previously registered the PostGIS table with the Geodatabase in ArcCatalog.
Image from right-click menu in Catalog Tree on table.
Be sure that, when you reach the "Fields" tab during registration, you have your "objectid" field recognized as having "Object ID" type, as the GID field in following image.
Next, you shouldn't use a sequence of your own to populate the objectid values. You should use a ON INSERT trigger that calls a SDE database function named "sde.next_rowid". Please refer to these ArcGIS Help items ArcGIS Help - Editing geodatabase data using SQL.
Perhaps you should get some additional background information, like the one you can get in ESRI presentations (as this for ArcGIS 9.3)
Best Answer
@jswise is correct, in ArcGIS Server v.10 you cannot create an .msd containing an XY event layer - you can create a service from an .mxd though. Support for XY event layers in .msd's has been added in the next version (10.1) according to this comment:
http://blogs.esri.com/esri/arcgis/2010/08/19/what-are-the-deprecation-plans-for-arcgis-10-and-the-upcoming-release-of-arcgis-10-1/#comment-90