Creating a 1:M Parcel File buy joining

MicahWarnock1

In ArcMap I can join our parcel polygon file to our CAMA Assessors database by our GISID.  This gives me a 1:1 match.  If I right click and export the joined parcel polygon file the results are a 1:M stacked parcel export.  I use this tool to create a searchable parcel layer on our WebGIS.  Over the past week, I have tried to automate this through the model builder process with no success.  What I am looking for is how to perform a quick export(right click export in arcmap) in the model building process or a tool that functions the same.

MichaelDumais

Hi Micah,

How long does it take to export your parcel-join? 

I'm asuming you would be expecting a record count that would closely match the record count in your Assessor table.

It sounds like your Assessor table has a foreign key field that relates to geometry in your parcel layer to get the stacked parcels you describe, which are your multi-family units (Apartments & Condo scenario) that share the same geometry.    I too have a similar scenario where that stacked unit layer is important for our permiting software to return the correct tax roll parcel-id.

I've tried creating a view in the hopes of exporting a nightly layer with no success.  When I try to export the join of our parcel layer to tax roll table, I get a ridiculous amount of resulting polygons.

If you have performance issues with ArcMap, try using ArcPro, which is a 64 bit app.  It will use the internal memory of your work-station better than ArcDesktop apps.  I've noticed a difference using ArcPro vs ArcMap when exporting these type of joined scenarios.

Did you find a work-around for your scenario?

Cheers, Mike