Latest Contributions by ChrisDonohue__GISP

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 Polygon:  Residential 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. Thanks in advance, Chris Donohue, GISP ... View more

Is there a way to run an automated check to see if all features in one layer have have had the relationship established through the Relationship Class to their matching feature in another layer? Here's the specific example: In this case we are entering a new subdivision into the City's landbase layers.  One of the tasks is creating the relationship between each Parcel Polygon and its Address Point (and its linked Address Annotation).  In the example here, as seen in the Attribute Window, the relationship has been established for this parcel and its address point.  What I was wondering is if there was a way to automatically check all the parcels in this subdivision after the relationships have all been updated to ensure that each parcel does have at least one address point related to it, in order to catch omissions, as our business rule is that each parcel must have an address point.  I'm hoping there is an alternative way to check the work besides clicking on each parcel and drilling down the Attributes tree to see if the data has been related to that address point.  To clarify, checking to see that an address point is spatially located on each parcel is not the issue in this case; instead we're looking for a way to check to see if they all have been related through the Relationship Class. I've not done much with Relationship Classes before, so I suspect I am missing something obvious.  We are using ArcGIS 10.2.1. and the data resides in SDE 10.2.1/SQL Server 2008 R2. Thanks in advance, Chris Donohue, GISP ... View more