Sorry I don't have much time, but below is a query that will get the CommLocal from the vegmap, and match it to the ID from the transect. This could be wrapped in an update statement so it updates automatically, but I didn't have time to fiddle with that. I originally tried to use a contains join on the lines, but there must be some precision issues going on there, because not all lines were being selected, and this could be why the spatial overlay is not reliable. Because you have already split the lines with each vegmap, i used centroidInner, then did a contains query. THIS WILL NOT WORK IF THE TRANECTS ARE NOT SPLIT WITH THE VEGMAP AREAS. A query could be written to do all splitting and updating no worries to take out that extra step, but again, I had no time. Hope this helps select [Vegmap] .[CommLocal], t1.Id from [Transects] t1 INNER JOIN [Vegmap] on contains([Vegmap].[Geom (I)], CentroidInner(t1.[Geom (I)]))
James Kelly http://www.locationsolve.com |