Tools for anesthetizing incident data

4163
2
09-18-2014 01:43 PM
CattyannCampbell
Occasional Contributor II

I have a bunch of incident data points that I would like to move off of private properties to the nearest road. I would also like to modify the addresses to the nearest block. There are a lot of points and I don't want to do this manually does anyone has have a set of scripts out there that they use to do this and is willing to share?

Tags (1)
0 Kudos
2 Replies
ToddZimmerman
New Contributor III

If your house number is in a separate field as a number, you can use the function below in the Calculate Field tool to round it to the 100 block:

=Int(HouseNumber / 100) * 100

I assume your original points are geocoded to an address point or some very specific address location. You can build another address locator just using your road centerlines and then gecode the addresses again to that locator using a side offset of 0 to get them all moved to the road.

Todd

CattyannCampbell
Occasional Contributor II

Ah sometimes you have to ask a question to see the answer staring you right in your face.
Turns out I already had the tools needed for this all along just needed someone to

wake me up. now I can throw it in the workflow and make it a 1 push effort.

Awesome thanks so much!

0 Kudos