One of the updates I have to perform frequently is identify parcels and the village they are in.
My difficulty is when a parcel boundary aligns with a village boundary. Using the JOIN feature will omit those. To compensate, I've expanded my village outlines so that this does not occur. But this means that I have overlapping village boundaries, which visually isn't the greatest, but it at least lets me put parcels in the correct village.
I thought that if I could join the center of the parcel instead it would eliminate this problem and allow me to have cleaner village boundaries. However, I don't see any way to accomplish this with the JOIN command and I wouldn't know where to begin to modify the code that is generated (pasted below.)
I'd love to be able to simplify this process and clean up my output.
t.[mfd_id] AS tkey0,
t.[Village] AS t0,
FROM [Sumter] AS t LEFT JOIN (
[s_mfd_id] AS skey0,
FirstNonNull([o_Village]) AS s0
FROM CALL GeomOverlayContainingPar([Sumter], [VillageOutlines], 0, ThreadConfig(SystemCpuCount()))
GROUP BY [s_mfd_id]
) AS s ON t.[mfd_id] = s.skey0
t0 = s0;