Latest Contributions by AdrianWelsh

Sounds like Margaret Maher​ might need to chime in on this talk!  She is the ultimate expert in coordinate systems. ... View more

For 'newer' versions of MS Access (using the .accdb extension instead of the .mdb), you might need to establish an Ole DB connection. There is an esri article on it: 32976 - Connect to Microsoft Access 2007 / 2010 (ACCDB) files in ArcGIS ... View more

Thanks for all the replies. PyScripter seems pretty useful! I will definitely be checking it out! ... View more

I was using Pythonwin since I liked its interactive window. Though, I now use PyCharm . I find it's helpful with drop down intellisense like menus. Both of these are free so that is another plus. And yes, Dan, I have seen this blog post: IDE's for Python It's a great comprehensive list, though I would like to hear other's opinions on this board  ... View more

Could you perform a spatial join? This may help what you are doing Spatial Join—Help | ArcGIS for Desktop ... View more

I don't see your screen shot of your TOC. In any case, you could add a US States layer. There are various ways of obtaining this. You could search in ArcGIS Online (in the Add Data button, drop down to Add Data from ArcGIS Online). Here is one I have used before: https://services.arcgis.com/P3ePLMYs2RVChkJx/arcgis/rest/services/USA_States_Generalized/FeatureServer Or you could search in the Template data that comes when you install ArcGIS. Usually found in a similar place to here: C:\Program Files (x86)\ArcGIS\Desktop10.3\TemplateData ... View more

If you are in ArcMap, you can right click on the layer, go to Properties and then click on the Definition Query tab. Here write a query (the syntax will depend on your naming conventions and such) that will look similar to STATE_NAME = 'Georgia' ... View more

Sometimes there is a glitch when publishing certain services and I do not fully know why. I have found that it helps when I open my MXD from ArcCatalog and publish it from there, as opposed to opening the MXD from Windows Explorer. Also, the server name of my folder connection in ArcCatalog has to be named a certain way to match the server itself (which I also do not fully understand). So, I am not sure that this helps... ... View more

No problem! If this helped answer your question then please mark this answer as "Correct". ... View more

This is a great question. I found where someone asked this on Stack Exchange and there is a 'suitable' answer there. Not sure if this works for you or not. Besides the obvious, the ArcMap interface really isn't suitable for so many fields. Even three fields is pretty cumbersome. A workaround is to recode your five fields into a single, master symbology field. Then you can use the regular unique values symbology for this. Here's an example with some made-up data: By recoding the fields into the Master field, you can create a set of unique symbologies as needed. You could even concatenate values so that the master field had a value of USA, New York, Buffalo, Type 1, Active in the first row. ... View more

Ok, it was the bottom part.... I needed to make it say: makestr(!Layer!) ...sheesh... Thanks James! Again, you're the best! ... View more

James, that makes sense and I ran the codeblock in Field Calculator with your code, but it didn't return anything. There were no errors though. Is there something I am doing wrong? The field that I am grabbing the values from is called "Layer" and I am putting the values into "Parcel_Numb". def makestr(Layer):       numlist = []        for s in Layer:           if s.isdigit():               numlist.append(s)       retlist = ''.join(numlist)        if any(char.isdigit() for char in retlist):           return retlist and for the bottom part: makestr(!Pacel_Numb!) Is it a syntax issue? ... View more