field calculate in parcel fabric

162
2
Jump to solution
07-27-2020 06:53 AM
Labels (2)
BrettCase
New Contributor

I have hundreds of PIN numbers to change in the fabric from township PIN’s to City PIN’s.

I have a spreadsheet with a “new” PIN column and an “old” PIN column.

Do you know of a way to join the table based on the old pin column and then just calculate the joined pins to be new pins?

0 Kudos
1 Solution

Accepted Solutions
jcarlson
Regular Contributor II

Hey Brett!

There are lots of ways you might accomplish this sort of thing, depending on what you're comfortable with, how your data looks, and what program you're using. The process you describe is straightforward enough. Here's how.

Given a parcels layer and a newpins table (this can be any tabular dataset added to your workspace), use the Add Join GP tool to join the tabular data to your parcels by the appropriate field.

Verify that your data is joined in the way you intended. The attribute table should have the new pins correctly joined to your parcels now. In order to make that data permanent, but without creating a new layer or field, use the Calculate Field GP. Specify the existing PIN field, and simply set it equal to the joined newpin field.

After running, your PINs should be updated. Because the old PIN values were used in the join, the joined fields should now appear null. Feel free to run the Remove Join GP tool at this point, and you're done!

- Josh Carlson
Kendall County GIS

View solution in original post

2 Replies
jcarlson
Regular Contributor II

Hey Brett!

There are lots of ways you might accomplish this sort of thing, depending on what you're comfortable with, how your data looks, and what program you're using. The process you describe is straightforward enough. Here's how.

Given a parcels layer and a newpins table (this can be any tabular dataset added to your workspace), use the Add Join GP tool to join the tabular data to your parcels by the appropriate field.

Verify that your data is joined in the way you intended. The attribute table should have the new pins correctly joined to your parcels now. In order to make that data permanent, but without creating a new layer or field, use the Calculate Field GP. Specify the existing PIN field, and simply set it equal to the joined newpin field.

After running, your PINs should be updated. Because the old PIN values were used in the join, the joined fields should now appear null. Feel free to run the Remove Join GP tool at this point, and you're done!

- Josh Carlson
Kendall County GIS

View solution in original post

BrettCase
New Contributor

Thank you!  I did figure it out..the problem was that it was not working on the version of the parcel fabric in our enterprise database but it did work perfectly on the default.dbo.

 

Thanks

0 Kudos