POST
|
02-05-2018
03:28 PM
|
0
|
0
|
721
|
POST
|
Another error. I attached my data to a previous comment if that would help. Have I mentioned I am eternally grateful?
... View more
02-05-2018
03:06 PM
|
0
|
2
|
721
|
POST
|
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
02-05-2018
02:24 PM
|
0
|
4
|
721
|
POST
|
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
02-05-2018
01:24 PM
|
0
|
0
|
554
|
POST
|
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
02-05-2018
12:37 PM
|
0
|
0
|
554
|
POST
|
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
02-05-2018
10:59 AM
|
0
|
0
|
530
|
POST
|
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
02-05-2018
10:45 AM
|
0
|
6
|
530
|
POST
|
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
02-05-2018
08:05 AM
|
0
|
8
|
530
|
POST
|
In my last job I had an advanced license. So having to figure out things without my awesome tools, I loved. Lol
... View more
02-01-2018
05:58 PM
|
0
|
1
|
554
|
POST
|
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
02-01-2018
03:07 PM
|
0
|
1
|
530
|
POST
|
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
02-01-2018
02:08 PM
|
0
|
13
|
1420
|
POST
|
02-01-2018
01:11 PM
|
0
|
1
|
1420
|
POST
|
02-01-2018
01:09 PM
|
0
|
0
|
1420
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:25 AM
|