AnsweredAssumed Answered

Creating a dynamic spatial view to be displayed on ArcMAp and published on ArcGIS Server

Question asked by EgbuleI on Aug 7, 2017

Hi All

I have some datasets: Parks, Park facilities and ParkTrails. These have many-to-many relationship; i.e a park can have multiple facilities and there may be multiple park trails on a single park

I would like to publish this data to ArcGIS Server, and issue queries on it, so that I can get a single result for a single Park. Currently, when mapping  say a pack I get all other parks and facilities as well as Park line and this is somehow confusing and a lot of information to digest at a time when the result is drawn by a text search.

Please does anyone have an idea how I can create a spatial view that will generate a unique Object ID field for repeated geometries to enable me publish a park layer with say uniquely identified facilities and park lines.

I am using MSSQL Database server 2012 and ArcGIS 10.4. I would also not want to tamper with my data storage type.

I have tried creating the view from my MSSQL interface but  on bringing it across to ArcCatalog or ArcMap, I keep getting the OID error (ObjectID)and some other errors as shown in the screenshot attached here.

Also at some point, the feature displays on ArcMap to show just  one feature either polygon data or the Line data but when I try to view the attribute table it gives me another error screenshot 2

error meaasageScreenshot 2 error that shows when i tried to open the attribute tables of the view that were created on MSSQL

 

 

Outcomes