Latest Contributions by HannahSmith3

THANK YOU SOOOOOOOO MUCH!!!!!! You are amazing! ... View more

Another error. I attached my data to a previous comment if that would help. Have I mentioned I am eternally grateful? ... View more

There is 6. You forgot the 'Street Name' field in the bottom. I ran it and it worked on the ones that just have an empty cell. But not on the ones that have <Null>. I think I will select the ones that have <Null> and convert that to "" and run it again and see if that will work. ... View more

This is the error I got back. ... View more

So it should look like this: def strip( !HOUSE_NUMB!, !PREFIX_DIR!, !PREFIX_TYP!, !STREET_TYP!, !SUFFIX_DIR!): """ provide the 6 fields to strip and concatenate python parser""" flds = [i.strip() for i in [ !HOUSE_NUMB!, !PREFIX_DIR!, !PREFIX_TYP!, !STREET_NAM!, !STREET_TYP!, !SUFFIX_DIR!]] result = "{} {} {} {} {} {}".format(*flds) return result a = 'A ' b = ' B ' c = 'C ' d = ' D' e = 'e E ' f = ' F' strip(a, b, c, d, e, f) 'A B C D e E F' ... View more

The issue is that the spaces are not within the fields I am concatenating, but the spaces I am using to make it readable. The spaces are an issue when it runs into a field that is null/blank. [HOUSE_NUB]&" "& [PREFIX_DIR]&" "&[PREFIX_TYPE]&" "&[STREET_NAM]&" "&[STREET_TYP]&" "&[SUFFIX_DIR]. If I do not put in the " " command the whole string runs together. I hope I am making sense.  ... View more

Not going to lie but that looks like jibberish to me. Would you mind making it more simple for me? I am sorry to ask you to do my job for me but I am just confused. ... View more

I realized my issue was the fact that when I made the new field for the full address. It left spaces when there was nothing in that field. Such as  How do I do the concatenate so that there is not a space in the way screwing up the data? Thank you for all of your help. You have been a life saver!  ... View more

Okay so I have done the spatial joins for the Old addressing and the parcel. How do I select based on the differences between the two addresses? ... View more

In my last job I had an advanced license. So having to figure out things without my awesome tools, I loved. Lol ... View more

Yes exactly.  Your whole last paragraph is correct. That is exactly what/why. I just know some of these addresses (the house numbers) have been changed and I want to make sure that is represented as well. I am doing this for 911 dispatch. I came to this city a month ago and it turns out they did not have anyone doing GIS for over 4 years. So I received the new addresses from the county from the parcel data. Looking back 4 years to what had previously been done. So a lot of updates. But I do not want to loose the majority of those who have been placed over the building. Thank you for your assistance. I will try these out tomorrow! I will let you know how it goes! ... View more

The newer version of the address points was created from the parcel data. So once I do a spatial join what should I do? ... View more