Latest Contributions by LukeWebb

Hello,  Most of your issues seem to be 'basic' python issues that can be resolved with a little experience and have mostly been answered. e.g. -there seem to be problems with converting/using characters which don't fit into ASCII - i couldn't figure out how to ask properly if Field 5 is Null - I could not properly translate the "AND" and the "OR" from Excel to Python (for example: If Field 4 is Null AND Field 5 is Null AND Field 1 is 612, Field 6 = ...) When it comes to this point, I feel your excel formulaes, or whatever other method you use will require the same amount of code / a big formulae. Do you see this differently?  - the code will become huge (I have more fields and values to compare) Anyways, to come from a different angle, answers to date seem to be focused on a more functional programming style. I like to try and break down my problem, and write as much code in more descriptive 'english' as I can, Ill provide a sample code showing what I mean by this but as its hard to work out what your doing it might come across badly! I tested this in ArcMap and it works great. You do need to add logic for the "Uncaught text" def compare(code_field, date_field1, date_field2, text_field1, text_field2):     # -*- coding: latin-1 -*- or # -*- coding: utf-8 -*-     def get_date_text():         if code_field == '617':             return str(date_field2)         else:             return str(date_field1)     def get_sometext_string():         if text_field1 == 'ABC' and text_field2 is None:             return "Sometext"         elif text_field1 == 'ABC' and text_field2:             return "Someothertext"         else:             return "UNCAUGHT_TEXT"     def get_otherfield_data():         if text_field1 == 'ABC' and text_field2 is not None:             return text_field2.encode("UTF-8")         else:             return ""     #First I will work out each of the "Parts" that I need to represent in the output text and make a variable for these     #(This bit isnt really needed, but helps us picture what we are going to do in our head)     date_text = ""     divider = ' | '     string_about_sometext = ""     other_field_data = ""     #Now I know what I need to populate, I can write a function thinknig about each bit seperately, then put it all together later.     date_text = get_date_text()     string_about_sometext = get_sometext_string()     other_field_data = get_otherfield_data()     #Now I should have everything, ready to combine into an answer     #(I would normally write this code using other string functions, but to keep it simpler am just combining all the strings and making sure each function returns a string)     final_text = date_text + divider + string_about_sometext + other_field_data     return final_text #Expression compare( !Field1! , !Field2! , !Field3! , !Field4! , !Field5! ) ... View more

Dan posted the solution, ill rewrite it more explicitly for your question.  You can pass as many values/fields to a function as you like so that you can then return their values. def compare(class1, class2, class3):    if class1 in (612, 611):        return class2    elif class1 == 617:        return class3    else:        return class1 # Expression below compare(!some_field!, !another_field!, !another_field2!) ... View more

The issue is if I write in the python window:       data = [] for row in some_fc:      data.append(row stuff) I now have this in memory,. Clearing the screen is good, but I can still do : print data to get back my stuff, so memory is used. How to release this? ... View more

It depends where you chose when you installed ArcGIS.   For me its this file here: C:\Program Files\ArcGIS\Pro\bin\Python\python.exe ... View more

When in the "Data Driven Page Setup" window where you selected the layer to be used as the data driven index, you are able to select a 'Name Field'. Subsequently, when exporting map, choose the 'Pages' tab, and select the option to export all maps, using a 'name'. When you enter a name into the GUI for your maps, it will then add the name attribute to the end. For example you enter "Maps_" and it will export "Maps_Map1Name.pdf", Maps_Map2Name.pdf" etc. ... View more

Hi Mark, For us, our license server is in the USA, whereas we work in the UK.  We notice that the script above can on a good day, run in approx 5 seconds. But when our LAN is slow, it can take 30-45 seconds, which when your changing 1 charecter in a script can be frustrating.  Checking out (borrowing) the license using Adminstrator may help, havent actually tried it! (Dont do much python at the moment sadly) ... View more

Theres an indentation issue causing the script to overwrite the mxd for each line in the CSV. Not sure if copy paste issue or actual problem! #     set up blank lists for data oldP,newF,newL = [],[],[] #     read data from file and store in lists with open(r"C:\hardcode_to_Path\dsListTEST.csv", "rb") as dsList:      r= csv.reader(dsList,delimiter=",")      for i,row in enumerate(r):           if i>0:                  #skip the header                oldP.append(str(row[0]))                newF.append(str(row[1]))                newL.append(str(row[2])) # replace the existing datasource with the new path, feature class name and layer name. mxd = arcpy.mapping.MapDocument(r"hardcode_to_testMap.mxd") for lyr in arcpy.mapping.ListLayers(mxd):     if lyr.supports("DATASOURCE"):          if lyr.dataSource == oldP:               lyr.replaceDataSource(r"Hardcode_to_new_location","None",newF, True)               lyr.name = newL               print lyr.dataSource mxd.saveACopy(r"hardcode_to_Copy_testMap.mxd") del mxd dsList.close()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Im not sure I understand the question!   If you are copying FROM the database into a FC, any copy rows / featureclass to featureclass should work, as objectID is managed by the shapefile / FileGDB without problems. I understand why you may be having difficulty storing data inside the database as I have had similar issues, but your workflow is the opposite way round no? Anyways, I only ever manged to insert data into SQL via SQL queries 1 row at a time in a loop, using the functions described here to get the next objectID: Next_RowID—Help | ArcGIS Desktop  ... View more

The API terms state: 50 requests per second, calculated as the sum of client-side and server-side queries. Your code does: time.sleep(.1)  So I am not sure why you hit these issues. However, there help file has an example script that demonstrates how to work around this issue: url = "MAPS_API_WEBSERVICE_URL" attempts = 0 success = False while success != True and attempts < 3:   raw_result = urllib.urlopen(url).read()   attempts += 1   # The GetStatus function parses the answer and returns the status code   # This function is out of the scope of this example (you can use a SDK).   status = GetStatus(raw_result)   if status == "OVER_QUERY_LIMIT":     time.sleep(2)     # retry     continue   success = True if attempts == 3:   # send an alert as this means that the daily limit has been reached   print "Daily limit has been reached" ... View more

How do you connect to it inside ArcMAP...using normal techniques?  (Does it work as a standard 'add database connection', or do you require to connect via OLE DB methods?) (I work in a Microsoft SQL Server shop) ... View more

Im interested in what you are trying to achieve with the code here: new_layer = arcpy.mapping.Layer(new_layer_name)‍‍‍‍‍‍‍‍‍ As you are simply passing it a string, no paths to any data or anything. dataset_to_process = r'FULL_PATH_TO_A_FEATURE_CLASS_IN_A_GEODATABASE'  #e.g.  C:\temp\a.gdb\layername         new_layer_name = os.path.basename(dataset_to_process)     #e.g.    layername     ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The layer that did get added to your map, came from MakeFeatureLayer_management due to the default arcmap setting. The second bunch of code (arcpy.Mapping.Addlayer etc) should (and does on my pc) have crashed as the layer we make in the above fashion cannot be correct. However I feel it may somehow be making a ghost layer, that has no selections applied for obvious reasons. (e.g. a bug in ESRI, that wont manifest if you use the software as intended) ... View more

As Joshua mentions its likely a config issue within pyscripter. Your PC can have as many versions of Python installed as you would like. ArcGIS installs a version, so does ArcGIS pro, so does other software, you may even have just installed one yourself. Only the version of Python that ArcGIS installed itself can use ArcPy.  Your pyscripter is likely set to use one of the other versions of python that exist on your computer.  This setting is called the "Interpreter", look to change that. I can see in your "Environment Settings" attachment, that the python version 36 does not appear to be one of the ArcGIS python installs. ... View more

Concerns you will need to ensure that each polygon initially has extraneous vertices removed (Generalize, removing points on the perimeter that aren't part of a direction change. To add to this, a shape you see as a 'rectangle', may actually be composed of smaller edges that look like 4 edges when you zoom out far enough inside the GIS.  (e.g. the computer sees it as a 18 sided polygon, not a rectangle!) The generalise tool can help simplify the shape, but you need to enter tolerances that make sense with your particular data. Simple example: Actual Coords (5 sided shape to the computer): 1,1      1,2     2,2     2,1      2.02, 1.02 Human interpreted coords (Shape looks like a rectangle to me as the final vertex added nothing): 1,1      1,2     2,2     2,1  In this example, if I generalise the input data with a 0.05m tolerance, it would clean out the node thats not required as the 0.02 metre deviation has less effect on the shape of the polygon than the 0.05 tolerance.. and is therefore not required. ... View more