Customer Service | Training | Contact Us
You are here: Home > User Forums > arcgis server forums > Thread Replies

ArcGIS Server Forums

ArcGIS Server: Publishing and using GIS Services forum

Map service that supports one to many joins...   Susan Mordy Nov 06, 2009
Re: Map service that supports one to many j...   vipul soni Nov 09, 2009
Re: Map service that supports one to many j...   Susan Mordy Nov 10, 2009
Report Inappropriate Content • Top • Print • Reply    
Subject Map service that supports one to many joins? 
Author Susan Mordy 
Date Nov 06, 2009 
Message How is everyone dealing with not be able to create a map service that supports one to many joins?

Just wondering if anyone has created a work around solution as I can't be the only person with spatial data that requires a one to many relationship to display all of it's attributes.

For example, say I have a point feature class. At each point location there can be more than one service. For example, at Point 'A' there is a library, a gym, and a community centre.

I want the user of my Flex application to be able to know what services are available at a single location, using the identify tool, mouseover or query builder results table.

Either I could have 3 separate point feature classes (which doesn't make alot of sense and wouldn't be very user friendly), or have one point feature class that links to a table.

I realize ArcMap joins don't produce one to many relationships and a MSD doesn't recognize relates.

This seems to be a reasonable thing to want to do, but I am stumped as to how to make such a simple thing happen. 
   
Report Inappropriate Content • Top • Print • Reply    
Subject Re: Map service that supports one to many joins? 
Author vipul soni 
Date Nov 09, 2009 
Message Hi,

ill tell you what i did for this issue, infact since arcims days and in argis server also ,the issue of carrying your joins and relates in arcmap mxd to armcap services in web based environment was an issue...

create a view in arcsde ...a spatial view which has the relate query defined in it ...thus when a new service is setup with the gis resource as the spatial view from arcsde you will have the identify tool showing you the data from both the datasets,spatial and non spatial. 
  Vipul Soni

INDIA 
   
Report Inappropriate Content • Top • Print • Reply    
Subject Re: Map service that supports one to many joins? 
Author Susan Mordy 
Date Nov 10, 2009 
Message Thanks Vipul.

I am not using ArcSDE, just a personal database.
Any suggestions on how to do this using a personal database?