Parcel attribute updates

2791
3
09-04-2015 07:03 AM
Labels (1)
ChadArmstrong
New Contributor

two related problems:

I am sure this is something easy, but I just began a new city job.

We have land parcel attributes on a parcel layer that must be updated each month: new owners, tax info, land value, etc.

I get the new data collected buy the county in excel with the same fields.

What is the method of a fast way to replace attribute data in mass with an excel file?

However, my boss requested me to get, from the county data assessors, for additional parcels along the outside boundary of the city.

The file has more rows than the map documents parcel data for parcels within the city.

First, I need a method to simply update the attributes for the parcels in the existing layer attributes.

Second, how would I create new rows with polygons for parcel data outside the border of the city?

I think, I would need to request a shape file from the county with those polygons. Right?

0 Kudos
3 Replies
WesMiller
Regular Contributor III

I would check with your county and see if the data already exists with the associated data, it may as the information you mentioned is useful on many levels. If you have to do the update yourself you'll need a field to join the data, usually a tax map number. I would think that since you'll need to do it frequently you'll want to look into model builder.

JeffWard
Occasional Contributor III

Can you make an arrangement to get the parcel data from the county monthly?  Archiving the old parcel layer and replacing it with the new one using the same path and file name of the old one so all of your map links will work.

If that won't work then Wes Miller​'s recommendation to create a model works great.  I have several models I run monthly to update various layers.  Some tools that I use frequently is the Make Table Query tool, Truncate Table tool (to wipe out the old table after backing it up to a separate fgdb) Join and Append.

Jeff Ward
Summit County, Utah
ChadArmstrong
New Contributor

Thank you, I will be getting regular updates about every month, almost due for another.

I found that there were parcels in our city layer that were not represented in the county data,

not sure why. I cannot just replace it without missing parcels,

so I had to figure out a very complex join and append method to get a new layer with all parcels.

We have just released a newly developed city maps website with a web platform developed through outsourcing,

which was contracted prior to my taking the job, and we are testing through the bugs, extensively.

The uploaded layer seems to work now, yet occasionally I get a can't have null value error from a parcel search.

I will explore your suggestions further. Thank you much.

Chad Armstrong

GIS Specialist Technician

Engineering Department

City of Bartlesville

401 S. Johnstone Ave.

Bartlesville, OK 74003

918-338-4258 office

918-338-4259 fax

0 Kudos