AnsweredAssumed Answered

Automated way to create table relationships based on location?

Question asked by cdspatial Champion on Nov 23, 2015
Latest reply on Nov 23, 2015 by wwmiller68

My department has recently inherited several of the City's landbase layers and as we work through the processes to update them we are realizing that some tasks are very manual.  For example, as part of adding a new subdivision to the City's landbase, we need to create a table relationship between each parcel and their respective address point(s).  The current manual process goes like this (see also image below):

 

1.  A Version is created, then preliminary steps completed, including updating the parcel polygons, address points, and several other landbase layers. 

2.  Then we start the table relationship process by selecting both a parcel polygon and its address point(s).

3.  In the editing Attributes Window, we drill down the tree below Parcel PolygonResidential Potential, Address Point.

4.  We right-click on Address Point - has Address and click "Add Selected" from the menu that appears.  This creates the relationship.

 

So here's what I was wondering.  This process is very manual.  Is there a way to automatically create the table relationships based on location?  Sort of like a Spatial Join?  What would this process be called? 

 

In other words, can we create all relationships at once instead of doing each parcel polygon and its address point(s) one at a time.  This would save quite a bit of effort, as this subdivision has 90+ parcels and we have several more subdivisions to do (and more in the works).

 

All of the address points are spatially located in their respective parcel polygons.

 

Note - though I have been doing GIS for many years, I'm not an SDE (or SQL Server) expert, so may need some background explanation if it gets technical fast on that side of things.

 

We are using ArcGIS 10.2.1, ArcSDE 10.2.1, SQLServer 2008 R2.  We are not using a Parcel Fabric nor the Local Government Information Model.

 

Westpark_relationship_drilldown.jpg

 

Thanks in advance,

 

 

Chris Donohue, GISP

Outcomes