|
POST
|
Here's a simple Python field calculator example: !fieldnamehere!.replace(' ST', ' STREET') Longer example for addressing multiple changes. Use your fieldname instead of FacilityAddress. def StreetSuffix(FacilityAddress):
list = FacilityAddress.split()
for item in range(len(list)):
if list[item] == 'STREET':
list[item] = list[item].replace("STREET", "ST")
if list[item] == 'STREET,':
list[item] = list[item].replace("STREET,", "ST")
if list[item] == 'STR.':
list[item] = list[item].replace("STR.", "ST")
if list[item] == 'STR,':
list[item] = list[item].replace("STR,", "ST")
if list[item] == 'ST.':
list[item] = list[item].replace("ST.", "ST")
if list[item] == 'ST,':
list[item] = list[item].replace("ST,", "ST")
if list[item] == 'WAY':
list[item] = list[item].replace("WAY", "WY")
if list[item] == 'WAY,':
list[item] = list[item].replace("WAY,", "WY")
if list[item] == 'WY.':
list[item] = list[item].replace("WY.", "WY")
if list[item] == 'WY,':
list[item] = list[item].replace("WY,", "WY")
return " ".join(list) Credit to Darren Wiens and several others knowledgeable in Python for coming up with this, which I gratefully stole borrowed. Chris Donohue, GISP
... View more
01-04-2016
01:37 PM
|
2
|
3
|
3445
|
|
POST
|
Yes, this can be done in Python. The Python code can be placed in the field calculator, or a pure Python run can be done. Chris Donohue, GISP
... View more
01-04-2016
01:12 PM
|
2
|
0
|
3445
|
|
BLOG
|
Another chance to try to keep up with the experts. Chris Donohue, GISP
... View more
12-31-2015
05:37 PM
|
1
|
0
|
757
|
|
POST
|
Thanks Bill. I'll see if Operation System Authorization is an option when I get back into work after the holiday. That will certainly make life easier, if it is feasible given our City's configuration. Chris Donohue, GISP
... View more
12-24-2015
01:27 PM
|
0
|
0
|
3403
|
|
POST
|
In Modelbuilder one way to do this would be to use an Iterator to loop through the Feature Dataset, then have a function to create a new geodatabase as it loops each time. The name could be transferred across from the iteration to your new geodatabases through the use of a in-line variable substitution. Iterator examples ArcGIS Desktop In-line variable substitution ArcGIS Help (10.2, 10.2.1, and 10.2.2) Chris Donohue, GISP
... View more
12-24-2015
08:41 AM
|
2
|
1
|
3479
|
|
POST
|
I believe it is Database Authentication. At least that is what is shown in the Layer Properties, Source Tab, under "Authentication Type" when I look at a feature class in a Version I made. Chris Donohue, GISP
... View more
12-23-2015
01:33 PM
|
0
|
2
|
3403
|
|
POST
|
Some more questions to add on the above - if your organization does testing of candidates, can you also elaborate on: Does your organization do written tests? Are these tests emailed to the candidate or taken at the workplace? Do you have your candidates do a practical test - i.e. the candidate gets on a computer and works on a task in GIS? I thinks folks will be interested to hear the management side of GIS hiring, which offers a whole set of challenges people may not realize. Chris Donohue, GISP
... View more
12-21-2015
08:25 AM
|
3
|
4
|
6459
|
|
POST
|
Given the interest and controversy in the recent topic Does GISP make a difference for GIS analysts? , it may be beneficial to hear specifically from the folks who are involved in the hiring of GIS professionals as to what they and their organizations value when choosing to hire. Hiring is not a cut and dried science. Pragmatically, as a hiring manager, you have a limited amount of time to evaluate potential candidates. You are tasked to fill a need and there are usually many candidates to choose from for each position. So how do you test/vet GIS candidates? Specifically, how do you figure out the best candidate for your organizations needs? Is a degree important? If so, what level, and does it have to be in GIS? Experience? Certification(s)? Candidates portfolio? How the candidate interviews? How the candidate performs on a test you give them? Their recommendations from other professionals/professors? None of the above? All of the above? What factors into your organizations decision? And overall, does the process yield good results, or are there other methods you think might be better? Obviously this will vary by organization and position requirements, but it will educational for all if we get a cross-section of replies so folks can get a better understanding of the ways it is done. So if you are a manager hiring for a GIS position, how do you do it? Chris Donohue, GISP
... View more
12-18-2015
06:07 PM
|
3
|
15
|
24692
|
|
POST
|
You may want to contact ESRI Support. If the installation didn't come with a specific contact number for Support, you can always try the Main ESRI Support number. It is (909) 793-3774 (United States number). Chris Donohue, GISP
... View more
12-18-2015
03:38 PM
|
0
|
0
|
3574
|
|
POST
|
One question that arises is why? If you are using Census data, why would you want to essentially "move" it to the new city spatial data? Where do you want to go with this? I ask this not as a criticism, but as the reason why could very much affect the outcome. For example, Census data is created with certain assumptions and constraints (including spatial). I'm not an expert on Census data, but I suspect changing the spatial part may invalidate some of it, so it would be best to know where this is going so as to be able to evaluate whether the outcome will still be valid. Chris Donohue, GISP
... View more
12-18-2015
07:41 AM
|
0
|
0
|
3399
|
|
POST
|
I gave it a quick try and it seems to work, though I will need to test it further just to be sure. Thanks for the suggestion. Sometimes it is the obvious stuff that trips one up..... Chris Donohue, GISP
... View more
12-17-2015
04:03 PM
|
0
|
0
|
3403
|
|
POST
|
No problem. One caution - it can sometimes take a few tries to find the right combination of settings that achieve what is desired with a Spatial Join, so I would run some tests first and carefully check the output. Play around with the Spatial Join and if you get stuck post what you tried and what doesn't seem to be working. Chris Donohue, GISP
... View more
12-17-2015
09:01 AM
|
0
|
0
|
1011
|
|
POST
|
You may want to look at doing a Spatial Join Spatial Join—Help | ArcGIS for Desktop GIS Tutorial: How to perform a spatial join in ArcMap - YouTube A Spatial Join can be performed with either the Tool in ArcToolbox Spatial Join (Analysis) or by performing a Join to one of the feature classes while accessing the Layer Properties from the Table of Contents in ArcMap. Chris Donohue, GISP
... View more
12-17-2015
08:40 AM
|
1
|
2
|
1011
|
|
POST
|
I agree with Matt Sheehan - it is important to show what you can do over having a degree or certification. I say this as many employers don't know what value the certification brings (unfortunately) or even what it is, be it ESRI's certification, GISP, or others. If you have a specific field in mind, I would try to network with GIS professionals in that field to see if a degree or certification is desired. Note that GIS is broad, so this can vary depending on which specific field you are in. For example, in the Public Sector, many mid-level and above jobs require a degree in GIS as a prerequisite (which is not the case typically in the Private Sector). Chris Donohue, GISP
... View more
12-17-2015
08:17 AM
|
0
|
0
|
1618
|
|
POST
|
I looked at the images that were posted and I'm not seeing a unique ID field that provides a means to tie the data together, nor coordinates in the table that could be used to create points. The bottom table does have an Address column, but it only has the street name, not more detailed information. The Account Number column looked promising at first glance, but then one sees they all have the same account number. So it looks like it will be a challenge to figure out how the data is associated. Is there any other data sources, metadata, or other information sources available to help relate the data? It may even entail consulting with the town's employees who have been around for a while to find out the scoop on this data and what the backstory is. Chris Donohue, GISP
... View more
12-17-2015
08:02 AM
|
0
|
0
|
5848
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-18-2015 12:04 PM | |
| 1 | 09-29-2015 12:41 PM | |
| 1 | 11-29-2018 07:51 AM | |
| 1 | 05-08-2018 02:07 PM | |
| 1 | 07-26-2016 07:53 AM |
| Online Status |
Offline
|
| Date Last Visited |
08-03-2022
01:39 PM
|