Create Feature from a Related Table

695
1
11-27-2019 08:35 AM
KennethBusby
Occasional Contributor

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. 

Tags (2)
0 Kudos
1 Reply
WilliamOstrander
New Contributor

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

0 Kudos