topic Re: Create Feature from a Related Table in Land Records and Valuation Questions

Create Feature from a Related Table

KennethBusby — Wed, 27 Nov 2019 16:35:17 GMT

I have a M-1 related table (Sales) and a Polygon feature (Parcels) I want to create a point feature for the sales. If I join to the Parcels I only get the first sale to join but I need all of them. Is there any way to do this? They are related by the PIN and they do not have addresses in either to geocode with.

I have taken the parcels and created a point feature, then used add X,Y to that and then joined that to the sales table and used display x,y data. Arcmap froze due to the size of the file.

Re: Create Feature from a Related Table

WilliamOstrander — Fri, 13 Dec 2019 19:45:47 GMT

Hi, Kenneth,

Maybe before displayng x,y data, subdivide your sales table into smaller tables -- by date range perhaps. Then display the x,y data for each subtable separately, export the event points to feature classes. You could then try appending those feature classes together to see if you can end up with a single feature class with all your sales data. If you can, it would be cool to look at the data with a time slider.

Bill Ostrander

Tioga County NY GIS